frmimportantevent.cs

企业客户资源管理系统 企业客户资源管理系统

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace CRM.PInfoManage
{
    public partial class frmImportantEvent : Form
    {
        CRM.BaseClass.BaseOperate boperate = new CRM.BaseClass.BaseOperate();
        CRM.BaseClass.OperateAndValidate opAndvalidate = new CRM.BaseClass.OperateAndValidate();
        protected string M_str_sql = "select EventID as 事件编号,ETitle as 事件标题,EDate as 发生时间,EContent as 事件内容 from tb_Event";
        protected string M_str_table = "tb_Event";
        protected int M_int_judge;
        public frmImportantEvent()
        {
            InitializeComponent();
        }

        private void frmImportantEvent_Load(object sender, EventArgs e)
        {
            DataSet myds = boperate.getds(M_str_sql, M_str_table);
            dgvEventInfo.DataSource = myds.Tables[0];
            if (myds.Tables[0].Rows.Count > 0)
                tsbtnDel.Enabled = true;
            else
                tsbtnDel.Enabled = false;
        }

        private void tsbtnAdd_Click(object sender, EventArgs e)
        {
            opAndvalidate.autoNum("select EventID from tb_Event", "tb_Event", "EventID", "SJ", "1000001", txtEventID);
            tsbtnSave.Enabled = true;
            M_int_judge = 0;
            txtEventTitle.Text = "";
            txtEContent.Text = "";
        }

        private void tsbtnEdit_Click(object sender, EventArgs e)
        {
            tsbtnSave.Enabled = true;
            M_int_judge = 1;
        }

        private void tsbtnSave_Click(object sender, EventArgs e)
        {
            if (M_int_judge == 0)
            {
                if (txtEventTitle.Text == "")
                {
                    MessageBox.Show("事件标题不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    boperate.getcom("insert into tb_Event(EventID,ETitle,EDate,EContent) values('" + txtEventID.Text.Trim()
                        + "','" + txtEventTitle.Text.Trim() + "','" + dtpEDate.Text.Trim() + "','" + txtEContent.Text.Trim() + "')");
                    frmImportantEvent_Load(sender, e);
                    MessageBox.Show("历史事件信息添加成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    tsbtnSave.Enabled = false;
                }
            }
            if (M_int_judge == 1)
            {
                if (txtEventTitle.Text == "")
                {
                    MessageBox.Show("事件标题不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    boperate.getcom("update tb_Event set ETitle='" + txtEventTitle.Text.Trim() + "',EDate='" + dtpEDate.Text.Trim()
                        + "',EContent='" + txtEContent.Text.Trim() + "' where EventID='" + txtEventID.Text.Trim() + "'");
                    frmImportantEvent_Load(sender, e);
                    MessageBox.Show("历史事件信息修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    tsbtnSave.Enabled = false;
                }
            }
        }

        private void tsbtnDel_Click(object sender, EventArgs e)
        {
            try
            {
                if (MessageBox.Show("确定要删除该事件信息吗？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
                {
                    boperate.getcom("delete from tb_Event where EventID='" + Convert.ToString(dgvEventInfo[0, dgvEventInfo.CurrentCell.RowIndex].Value).Trim() + "'");
                    frmImportantEvent_Load(sender, e);
                    MessageBox.Show("删除数据成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
            }
        }

        private void tsbtnLook_Click(object sender, EventArgs e)
        {
            try
            {
                if (tstxtKeyWord.Text == "")
                {
                    frmImportantEvent_Load(sender, e);
                }
                if (tscboxCondition.Text.Trim() == "事件编号")
                {
                    DataSet myds = boperate.getds(M_str_sql + " where EventID like '%" + tstxtKeyWord.Text.Trim() + "%'", M_str_table);
                    if (myds.Tables[0].Rows.Count > 0)
                        dgvEventInfo.DataSource = myds.Tables[0];
                    else
                        MessageBox.Show("没有要查找的相关记录！");
                }
                if (tscboxCondition.Text.Trim() == "事件标题")
                {
                    DataSet myds = boperate.getds(M_str_sql + " where ETitle like '%" + tstxtKeyWord.Text.Trim() + "%'", M_str_table);
                    if (myds.Tables[0].Rows.Count > 0)
                        dgvEventInfo.DataSource = myds.Tables[0];
                    else
                        MessageBox.Show("没有要查找的相关记录！");
                }
                if (tscboxCondition.Text.Trim() == "发生时间")
                {
                    DataSet myds = boperate.getds(M_str_sql + " where EDate like '%" + tstxtKeyWord.Text.Trim() + "%'", M_str_table);
                    if (myds.Tables[0].Rows.Count > 0)
                        dgvEventInfo.DataSource = myds.Tables[0];
                    else
                        MessageBox.Show("没有要查找的相关记录！");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }

        private void tsbtnExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void dgvEventInfo_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            txtEventID.Text = Convert.ToString(dgvEventInfo[0, dgvEventInfo.CurrentCell.RowIndex].Value).Trim();
            txtEventTitle.Text = Convert.ToString(dgvEventInfo[1, dgvEventInfo.CurrentCell.RowIndex].Value).Trim();
            dtpEDate.Text = Convert.ToString(dgvEventInfo[2, dgvEventInfo.CurrentCell.RowIndex].Value).Trim();
            txtEContent.Text = Convert.ToString(dgvEventInfo[3, dgvEventInfo.CurrentCell.RowIndex].Value).Trim();
        }
    }
}