frmdataclear.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.SysManage
{
    public partial class frmDataClear : Form
    {
        CRM.BaseClass.BaseOperate boperate = new CRM.BaseClass.BaseOperate();
        public frmDataClear()
        {
            InitializeComponent();
        }

        private void btnClear_Click(object sender, EventArgs e)
        {
            if (chkCInfo.Checked)
                boperate.getcom("delete from tb_CInfo");
            if(chkClientInfo.Checked)
                boperate.getcom("delete from tb_ClientInfo");
            if(chkOppInfo.Checked)
                boperate.getcom("delete from tb_Opponent");
            if(chkEmployeeInfo.Checked)
                boperate.getcom("delete from tb_Employee");
            if(chkGoodsInfo.Checked)
                boperate.getcom("delete from tb_GoodsInfo");
            if(chkEventInfo.Checked)
                boperate.getcom("delete from tb_Event");
            if(chkAreaInfo.Checked)
                boperate.getcom("delete from tb_Area");
            MessageBox.Show("数据清理成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }

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