frmareamanage.cs

客户关系管理系统

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

namespace CRM.DataManage
{
    public partial class frmAreaManage : Form
    {
        CRM.BaseClass.BaseOperate boperate = new CRM.BaseClass.BaseOperate();
        CRM.BaseClass.OperateAndValidate opAndvalidate = new CRM.BaseClass.OperateAndValidate();
        protected string M_str_sql = "select AreaID as 区域编号,AreaName as 区域名称,AreaType as 区域类型 from tb_Area";
        protected string M_str_table = "tb_Area";
        protected int M_int_judge;
        public frmAreaManage()
        {
            InitializeComponent();
        }

        private void frmAreaManage_Load(object sender, EventArgs e)
        {
            DataSet myds = boperate.getds(M_str_sql, M_str_table);
            dgvAreaInfo.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 AreaID from tb_Area", "tb_Area", "AreaID", "QY", "1000001",txtAreaCode);
            tsbtnSave.Enabled = true;
            txtAreaName.Text = "";
            M_int_judge = 0;
        }

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

        private void tsbtnSave_Click(object sender, EventArgs e)
        {
            SqlDataReader sqlread=boperate.getread("select AreaName from tb_Area where AreaName='"+txtAreaName.Text.Trim()+"'");
            sqlread.Read();
            if (M_int_judge == 0)
            {
                if (txtAreaName.Text == "")
                {
                    MessageBox.Show("区域名称不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else if(sqlread.HasRows)
                {
                    MessageBox.Show("该区域已经存在！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    txtAreaName.Text = "";
                    txtAreaName.Focus();
                }
                else
                {
                    boperate.getcom("insert into tb_Area(AreaID,AreaName,AreaType) values('"
                        +txtAreaCode.Text.Trim()+"','"+txtAreaName.Text.Trim()+"','"+cboxAreaType.Text.Trim()+"')");
                    frmAreaManage_Load(sender,e);
                    MessageBox.Show("区域信息添加成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    tsbtnSave.Enabled = false;
                }
            }
            sqlread.Close();
            if (M_int_judge == 1)
            {
                if (txtAreaName.Text == "")
                {
                    MessageBox.Show("区域名称不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    boperate.getcom("update tb_Area set AreaName='" + txtAreaName.Text.Trim() 
                        + "',AreaType='" + cboxAreaType.Text.Trim() + "' where AreaID='" + txtAreaCode.Text.Trim() + "'");
                    frmAreaManage_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_Area where AreaID='" + Convert.ToString(dgvAreaInfo[0, dgvAreaInfo.CurrentCell.RowIndex].Value).Trim() + "'");
                    frmAreaManage_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 == "")
                {
                    frmAreaManage_Load(sender, e);
                }
                if (tscboxCondition.Text.Trim() == "区域编号")
                {
                    DataSet myds = boperate.getds(M_str_sql + " where AreaID like '%" + tstxtKeyWord.Text.Trim() + "%'", M_str_table);
                    if (myds.Tables[0].Rows.Count > 0)
                        dgvAreaInfo.DataSource = myds.Tables[0];
                    else
                        MessageBox.Show("没有要查找的相关记录！");
                }
                if (tscboxCondition.Text.Trim() == "区域名称")
                {
                    DataSet myds = boperate.getds(M_str_sql + " where AreaName like '%" + tstxtKeyWord.Text.Trim() + "%'", M_str_table);
                    if (myds.Tables[0].Rows.Count > 0)
                        dgvAreaInfo.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 dgvAreaInfo_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            txtAreaCode.Text = Convert.ToString(dgvAreaInfo[0, dgvAreaInfo.CurrentCell.RowIndex].Value).Trim();
            txtAreaName.Text = Convert.ToString(dgvAreaInfo[1, dgvAreaInfo.CurrentCell.RowIndex].Value).Trim();
            cboxAreaType.Text = Convert.ToString(dgvAreaInfo[2, dgvAreaInfo.CurrentCell.RowIndex].Value).Trim();
        }
    }
}