예제 #1
0
 /// <summary> 在线用户
 /// </summary>
 void UCOnLineUser_ExportEvent(object sender, EventArgs e)
 {
     try
     {
         string fileName = "在线用户" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
         ExcelHandler.ExportExcel(fileName, dgvUser);
     }
     catch (Exception ex)
     {
         GlobalStaticObj_Server.GlobalLogService.WriteLog("在线用户", ex);
         MessageBoxEx.ShowWarning("程序异常");
     }
 }
예제 #2
0
 //导出
 private void btnOutput_Click(object sender, EventArgs e)
 {
     try
     {
         string fileName = "组织管理" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
         ExcelHandler.ExportExcel(fileName, dgvRecord);
     }
     catch (Exception ex)
     {
         GlobalStaticObj_Server.GlobalLogService.WriteLog("组织管理", ex);
         MessageBoxEx.ShowWarning("程序异常");
     }
 }
예제 #3
0
 /// <summary>
 /// 导出事件
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 void UCSupplierManager_ExportEvent(object sender, EventArgs e)
 {
     try
     {
         string fileName = "供应商档案" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
         ExcelHandler.ExportExcel(fileName, dgvSupplierList);
     }
     catch (Exception ex)
     {
         Utility.Log.Log.writeLineToLog("【供应商档案】" + ex.Message, "server");
         MessageBoxEx.ShowWarning("导出失败!");
     }
 }
 /// <summary>
 /// 导出事件
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 void UC_ExportEvent(object sender, EventArgs e)
 {
     if (this.dgvRData.Rows.Count == 0)
     {
         return;
     }
     try
     {
         string fileName = "维修结算单" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
         ExcelHandler.ExportExcel(fileName, dgvRData);
     }
     catch (Exception ex)
     {
         Utility.Log.Log.writeLineToLog("【维修结算单】" + ex.Message, "server");
         MessageBoxEx.ShowWarning("导出失败!");
     }
 }
예제 #5
0
 /// <summary> 导出
 /// </summary>
 void UCDictionaryManager_ExportEvent(object sender, EventArgs e)
 {
     try
     {
         //获取数据表
         DataTable dt = DBHelper.GetTable("查询码表", "v_dictionaries", "*", where, "", "order by dic_code");
         //根据datagridview列制定datatable导出列及列名称
         dt = ExcelHandler.HandleDataTableForExcel(dt, dgvDicList);
         string fileName = "字典码表" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
         ExcelHandler.ExportExcel(fileName, dt);
     }
     catch (Exception ex)
     {
         Utility.Log.Log.writeLineToLog("【字典码表】" + ex.Message, "client");
         MessageBoxEx.ShowWarning("导出失败!");
     }
 }
예제 #6
0
 private void ExportToxls(DataGridViewEx dgv, string strMsg)
 {
     if (dgv.Rows.Count == 0)
     {
         return;
     }
     try
     {
         string fileName = strMsg + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
         ExcelHandler.ExportExcel(fileName, dgv);
     }
     catch (Exception ex)
     {
         Utility.Log.Log.writeLineToLog("【" + strMsg + "】" + ex.Message, "server");
         MessageBoxEx.ShowWarning("导出失败!");
     }
 }
예제 #7
0
 //导出
 void UCPersonnelManager_ExportEvent(object sender, EventArgs e)
 {
     if (this.dgvUser.Rows.Count == 0)
     {
         return;
     }
     try
     {
         string fileName = "人员管理" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
         ExcelHandler.ExportExcel(fileName, ExcelHandler.HandleDataTableForExcel(dgvUser.GetBoundData(), dgvUser));
     }
     catch (Exception ex)
     {
         Utility.Log.Log.writeLineToLog("人员管理" + ex.Message, "client");
         MessageBoxEx.ShowWarning("导出失败!");
     }
 }
예제 #8
0
 void UCSalePlanManagerSearch_ExportEvent(object sender, EventArgs e)
 {
     if (this.gvSalePlanList.Rows.Count == 0)
     {
         return;
     }
     try
     {
         string fileName = "销售计划单查询" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
         ExcelHandler.ExportExcel(fileName, gvSalePlanList);
     }
     catch (Exception ex)
     {
         Utility.Log.Log.writeLineToLog("【销售计划单查询】" + ex.Message, "server");
         MessageBoxEx.ShowWarning("导出失败!");
     }
 }
예제 #9
0
        BusinessPrint businessPrint;//业务打印功能
        #endregion

        #region Method -- 方法
        //初始化
        private void Init()
        {
            dgvQData.MultiSelect = false;    //不允许多选操作

            SetUCBaseFuncationVisible();

            #region 初始化时间控件值
            dtpCBSTime.Value = DateTime.Now.AddMonths(-1);
            dtpCBETime.Value = DateTime.Now.AddDays(+1);
            #endregion

            #region 初始化下拉框数据绑定
            CommonCtrl.BindComboBoxByDictionarr(cboCBType, "sys_callback_type", true);    //绑定反馈类型
            CommonCtrl.BindComboBoxByDictionarr(cboCBMode, "sys_callback_mode", true);    //绑定反馈方式
            #endregion

            #region 注册功能按钮事件
            #region 清除查询条件
            btnClear.Click += delegate
            {
                txtCBTitle.Caption      = String.Empty;
                cboCBType.SelectedValue = String.Empty;
                cboCBMode.SelectedValue = String.Empty;
                dtpCBSTime.Value        = DateTime.Now.AddMonths(-1);
                dtpCBETime.Value        = DateTime.Now.AddDays(+1);
                txtCustomerName.Text    = String.Empty;
                txtCBPerson.Text        = String.Empty;
            };
            #endregion

            #region 导出事件
            btnExport.Click += delegate
            {
                if (this.dgvQData.Rows.Count == 0)
                {
                    return;
                }
                try
                {
                    string fileName = "信息反馈" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
                    ExcelHandler.ExportExcel(fileName, dgvQData);
                }
                catch (Exception ex)
                {
                    Utility.Log.Log.writeLineToLog("【信息反馈】" + ex.Message, "server");
                    MessageBoxEx.ShowWarning("导出失败!");
                }
            };
            #endregion

            #region 预览事件
            btnView.Click += delegate
            {
                businessPrint.Preview(dgvQData.GetBoundData());
            };
            #endregion

            #region 打印事件
            btnPrint.Click += delegate
            {
                businessPrint.Print(dgvQData.GetBoundData());
            };
            #endregion

            #region 设置事件
            btnSet.Click += delegate
            {
                businessPrint.PrintSet(dgvQData);
            };
            #endregion

            #region 查询
            btnQuery.Click += delegate
            {
                BindPageData();
            };
            #endregion

            #region  择客户信息
            txtCustomerName.ChooserClick += delegate
            {
                var frmCustomer = new frmCustomerInfo();
                var result      = frmCustomer.ShowDialog();
                if (result == DialogResult.OK)
                {
                    txtCustomerName.Text = frmCustomer.strCustomerName;
                    txtCustomerName.Tag  = frmCustomer.strCustomerId;
                }
            };
            #endregion

            #region  择反馈人
            txtCBPerson.ChooserClick += delegate
            {
                var frmContacts = new frmContacts();
                var result      = frmContacts.ShowDialog();
                if (result == DialogResult.OK)
                {
                    txtCBPerson.Text = frmContacts.contName;
                    txtCBPerson.Tag  = frmContacts.contID;
                }
            };
            #endregion

            #region 数据翻页
            pageQ.PageIndexChanged += delegate
            {
                BindPageData();
            };
            #endregion

            #region 数据表数据选择
            dgvQData.CellDoubleClick += delegate
            {
                if (dgvQData.SelectedRows.Count > 0)
                {
                    var uc = new UCFeedbackAddOrEdit();
                    uc.windowStatus      = WindowStatus.View;
                    uc.UCFeedbakcManager = this;
                    var selectedData = dgvQData.SelectedRows[0];
                    uc.FeedbackId = selectedData.Cells["drtxt_Feedback_id"].Value.ToString();
                    var callbackInfo = DBHelper.GetTable("查询反馈信息", "tb_CustomerSer_Feedback", "*",
                                                         "Feedback_id = '" + uc.FeedbackId + "'", "",
                                                         "");
                    if (callbackInfo != null && callbackInfo.DefaultView.Count != 0)
                    {
                        uc.CustId   = callbackInfo.DefaultView[0]["corp_id"].ToString();
                        uc.ContId   = callbackInfo.DefaultView[0]["Feedback_by"].ToString();
                        uc.HandleId = callbackInfo.DefaultView[0]["handle_name"].ToString();
                    }
                    uc.addUserControl(uc, "信息反馈-详细", "UCFeedbackView", Tag.ToString(), Name);
                }
            };
            #endregion

            #region 数据表格数据格式化
            dgvQData.CellFormatting += delegate(object sender, DataGridViewCellFormattingEventArgs args)
            {
                UIAssistants.DgvCellDataConvert2Table(dgvQData, args, "Feedback_by", "tb_contacts", "cont_id", "cont_name");
                UIAssistants.DgvCellDataConvert2Table(dgvQData, args, "handle_name", "sys_user", "user_id", "user_name");
                UIAssistants.DgvCellDataConvert2Table(dgvQData, args, "corp_id", "tb_customer", "cust_id", "cust_name");
                UIAssistants.DgvCellDataConvert2Datetime(dgvQData, args, "Feedback_time");
                UIAssistants.DgvCellDataConvert2DicData(dgvQData, args, "Feedback_type");    //反馈类型
                UIAssistants.DgvCellDataConvert2DicData(dgvQData, args, "Feedback_mode");    //反馈形式
            };
            #endregion

            #region 新增数据
            AddEvent += delegate
            {
                var uc = new UCFeedbackAddOrEdit();
                uc.UCFeedbakcManager = this;
                uc.windowStatus      = WindowStatus.Add;
                uc.addUserControl(uc, "信息反馈-新增", "UCFeedbackAdd", Tag.ToString(), Name);
            };
            #endregion

            #region 编辑数据
            EditEvent += delegate
            {
                if (dgvQData.SelectedRows.Count > 0)
                {
                    var uc = new UCFeedbackAddOrEdit();
                    uc.windowStatus      = WindowStatus.Edit;
                    uc.UCFeedbakcManager = this;
                    var dataView  = GetSelectedRowData();
                    var listField = GetCheckRows();
                    if (dataView != null && listField.Count > 0)
                    {
                        var selectedData = dataView[0];
                        uc.FeedbackId = CommonCtrl.IsNullToString(selectedData["Feedback_id"]);
                        var callbackInfo = DBHelper.GetTable("查询反馈信息", "tb_CustomerSer_Feedback", "*",
                                                             "Feedback_id = '" + uc.FeedbackId + "'", "",
                                                             "");
                        if (callbackInfo != null && callbackInfo.DefaultView.Count != 0)
                        {
                            uc.CustId   = callbackInfo.DefaultView[0]["corp_id"].ToString();
                            uc.ContId   = callbackInfo.DefaultView[0]["Feedback_by"].ToString();
                            uc.HandleId = callbackInfo.DefaultView[0]["handle_name"].ToString();
                        }
                        uc.addUserControl(uc, "信息反馈-编辑", "UCFeedbackEdit", Tag.ToString(), Name);
                    }
                }
                BindPageData("1=1");
            };
            #endregion

            #region  除数据
            DeleteEvent += delegate
            {
                try
                {
                    if (dgvQData.SelectedRows.Count == 0)
                    {
                        MessageBoxEx.Show("请选择删除记录!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        return;
                    }
                    var result = MessageBoxEx.Show("此操作将永久删除选定信息。\n若要继续,请单击“确定”。", "您确认要删除此条信息吗?", MessageBoxButtons.OKCancel,
                                                   MessageBoxIcon.Warning);
                    if (result == DialogResult.OK)
                    {
                        var dataView  = GetSelectedRowData();
                        var listField = GetCheckRows();
                        if (dataView != null && listField.Count > 0)
                        {
                            var selectedData = dataView[0];
                            var id           = CommonCtrl.IsNullToString(selectedData["Feedback_id"]);
                            var flag         = DBHelper.DeleteDataByID("删除反馈信息", "tb_CustomerSer_Feedback", "Feedback_id",
                                                                       id);
                            if (flag)
                            {
                                BindPageData();
                                MessageBoxEx.Show("删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                                BindPageData();
                            }
                            else
                            {
                                MessageBoxEx.Show("删除失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                            }
                        }
                    }
                }
                catch (Exception ex)
                {
                    MessageBoxEx.Show("删除失败!" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
                BindPageData("1=1");
            };
            #endregion

            #region 根据选择的数据判断功能按钮的显示状态
            dgvQData.CellMouseUp += delegate
            {
                var dataView  = GetSelectedRowData();
                var listField = GetCheckRows();
                btnStatus.Enabled = false;
                btnEdit.Enabled   = false;
                btnDelete.Enabled = false;
                if (dataView == null || listField.Count == 0)
                {
                }
                else
                {
                    #region 编辑
                    if (listField.Count == 1)
                    {
                        btnEdit.Enabled   = true;
                        btnDelete.Enabled = true;
                    }
                    #endregion
                }
            };
            #endregion

            #endregion

            BindPageData();
        }
예제 #10
0
        private void FuncationRegiste() //事件注册
        {
            #region 数据表数据选择
            //单元格数据转换
            dgv_table.CellFormatting += (sender, args) => ConvertDataGridColumnsData(args);
            //数据行双击事件
            dgv_table.CellDoubleClick += delegate(object sender, DataGridViewCellEventArgs e)
            {
                try
                {
                    if (e.RowIndex < 0)
                    {
                        return;
                    }
                    var value = dgv_table.Rows[e.RowIndex].Cells[cust_id.Name].Value;
                    if (value == null)
                    {
                        return;
                    }
                    var id             = value.ToString();
                    var ucCustomerView = new UCCustomerViews
                    {
                        Id = id,
                        UCCustomerManager = this
                    };
                    addUserControl(ucCustomerView, "客户详细信息", "UCCustomerViews" + id, Tag.ToString(), Name);
                }
                catch (Exception ex)
                {
                    LogService4Customer.WriteLog(1, ex);
                }
            };
            //ViewEvent += delegate
            //{
            //    try
            //    {
            //        if (dgv_table.SelectedRows.Count != 1) return;
            //        var value =  dgv_table.SelectedRows[0].Cells[cust_id.Name].Value;
            //        if (value == null) return;
            //        var id = value.ToString();
            //        var ucCustomerView = new UCCustomerViews
            //        {
            //            Id = id,
            //            UCCustomerManager = this
            //        };
            //        addUserControl(ucCustomerView, "客户详细信息", "UCCustomerViews" + id, Tag.ToString(), Name);
            //    }
            //    catch (Exception ex)
            //    {
            //        LogService4Customer.WriteLog(1, ex);
            //    }
            //};
            #endregion

            #region 数据翻页
            pageQ.PageIndexChanged += delegate
            {
                BindPageData();
            };
            #endregion

            #region 清除按钮事件
            btn_clear.Click += delegate
            {
                try
                {
                    UIAssistants.ClearQueryControlValue(pnl_query);
                }
                catch (Exception ex)
                {
                    LogService4Customer.WriteLog(1, ex);
                }
            };
            #endregion

            #region 查询
            btn_query.Click += (sender, args) =>
            {
                pageQ.PageIndex   = 1;
                pageQ.RecordCount = 0;
                BindPageData();
            };
            #endregion

            #region 预览事件
            btnView.Click += delegate
            {
                businessPrint.Preview(dgv_table.GetBoundData());
            }
            ;
            #endregion

            #region 打印事件
            btnPrint.Click += delegate
            {
                businessPrint.Print(dgv_table.GetBoundData());
            };
            #endregion

            #region 设置事件
            btnSet.Click += delegate
            {
                businessPrint.PrintSet(dgv_table);
            }
            ;
            #endregion

            #region 导出事件
            btnExport.Click += delegate
            {
                if (this.dgv_table.Rows.Count == 0)
                {
                    return;
                }
                try
                {
                    string fileName = "客户档案" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
                    ExcelHandler.ExportExcel(fileName, dgv_table);
                }
                catch (Exception ex)
                {
                    Utility.Log.Log.writeLineToLog("【客户档案】" + ex.Message, "server");
                    MessageBoxEx.ShowWarning("导出失败!");
                }
            };
            #endregion

            #region 新增
            btnAdd.Click += delegate
            {
                try
                {
                    var ucCustomerAddOrEdit = new UCCustomerAddOrEdit {
                        UCCustomerManager = this, windowStatus = WindowStatus.Add
                    };
                    addUserControl(ucCustomerAddOrEdit, "客户信息新增", "UCCustomerAddOrEdit-Add", Tag.ToString(), Name);
                }
                catch (Exception ex)
                {
                    LogService4Customer.WriteLog(1, ex);
                }
            };
            #endregion

            #region  制
            btnCopy.Click += delegate
            {
                try
                {
                    var id       = "";
                    var dataView = UIAssistants.GetDataGridCheckRows(dgv_table, colCheck, cust_id, TableName);
                    if (dataView == null)
                    {
                        return;
                    }
                    foreach (DataRowView rowView in dataView)
                    {
                        id = rowView["cust_id"].ToString();
                        break;
                    }
                    var ucCustomerAddOrEdit = new UCCustomerAddOrEdit
                    {
                        UCCustomerManager = this,
                        windowStatus      = WindowStatus.Copy,
                        Id = id
                    };
                    addUserControl(ucCustomerAddOrEdit, "客户信息拷贝", "UCCustomerAddOrEdit-Copy" + ucCustomerAddOrEdit.Id, Tag.ToString(), Name);
                }
                catch (Exception ex)
                {
                    LogService4Customer.WriteLog(1, ex);
                }
            };
            #endregion

            #region 编辑
            btnEdit.Click += delegate
            {
                try
                {
                    var id       = "";
                    var dataView = UIAssistants.GetDataGridCheckRows(dgv_table, colCheck, cust_id, TableName);
                    if (dataView == null)
                    {
                        return;
                    }
                    foreach (DataRowView rowView in dataView)
                    {
                        id = rowView["cust_id"].ToString();
                        break;
                    }
                    var ucCustomerAddOrEdit = new UCCustomerAddOrEdit
                    {
                        UCCustomerManager = this,
                        windowStatus      = WindowStatus.Edit,
                        Id = id
                    };
                    addUserControl(ucCustomerAddOrEdit, "客户信息编辑", "UCCustomerAddOrEdit-Edit" + ucCustomerAddOrEdit.Id, Tag.ToString(), Name);
                }
                catch (Exception ex)
                {
                    LogService4Customer.WriteLog(1, ex);
                }
            };
            #endregion

            #region  除
            btnDelete.Click += delegate
            {
                try
                {
                    var selectedRows = UIAssistants.GetDataGridCheckRows(dgv_table, colCheck, cust_id);
                    if (selectedRows.Count == 0)
                    {
                        MessageBoxEx.Show("请选择删除记录!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        return;
                    }
                    if (MessageBoxEx.Show("确认要删除吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
                    {
                        return;
                    }
                    //var comField = new Dictionary<string, string> { { "enable_flag", "0" } };
                    //flag = DBHelper.BatchUpdateDataByIn("删除三包服务单", TableName, comField, "tg_id", selectedRows.ToArray());
                    var comField = new Dictionary <string, string> {
                        { "enable_flag", "0" }
                    };
                    var flag = DBHelper.BatchUpdateDataByIn("批量删除客户档案", "tb_customer", comField, "cust_id", selectedRows.ToArray());
                    foreach (var selectedRow in selectedRows)
                    {
                        var crmIdDt = DBHelper.GetTable("查询客户档案信息", "tb_customer", "cust_crm_guid",
                                                        String.Format("cust_id = '{0}'", selectedRow), "", "");
                        if (crmIdDt != null && crmIdDt.Rows.Count == 1)
                        {
                            BeginInvoke(new MethodInvoker(delegate()
                            {
                                DBHelper.WebServHandler("删除客户档案", EnumWebServFunName.UpLoadCustomer,
                                                        new tb_customer
                                {
                                    cust_crm_guid        = CommonCtrl.IsNullToString(crmIdDt.Rows[0][0]),
                                    status               = "1",
                                    accessories_discount = 0,
                                    agency               = "",
                                    bank_account         = "",
                                    bank_account_person  = "",
                                    billing_account      = "",
                                    billing_address      = "",
                                    billing_name         = "",
                                    business_scope       = "",
                                    city                   = "",
                                    com_constitution       = "",
                                    country                = "",
                                    county                 = "",
                                    create_by              = "",
                                    create_time            = 0,
                                    credit_account_period  = 0,
                                    credit_line            = 0,
                                    credit_rating          = "",
                                    cust_address           = "",
                                    cust_code              = "",
                                    cust_email             = "",
                                    cust_fax               = "",
                                    cust_id                = "",
                                    cust_name              = "",
                                    cust_phone             = "",
                                    cust_quick_code        = "",
                                    cust_relation          = "",
                                    cust_remark            = "",
                                    cust_short_name        = "",
                                    cust_tel               = "",
                                    cust_type              = "",
                                    cust_website           = "",
                                    data_source            = "",
                                    enable_flag            = "",
                                    ent_qualification      = "",
                                    enterprise_nature      = "",
                                    indepen_legalperson    = "",
                                    institution_code       = "",
                                    is_member              = "",
                                    legal_person           = "",
                                    market_segment         = "",
                                    member_class           = "",
                                    member_number          = "",
                                    member_period_validity = 0,
                                    open_bank              = "",
                                    price_type             = "",
                                    province               = "",
                                    registered_capital     = "",
                                    sap_code               = "",
                                    tax_num                = "",
                                    update_by              = "",
                                    update_time            = 0,
                                    vehicle_structure      = "",
                                    workhours_discount     = 0,
                                    yt_customer_manager    = "",
                                    yt_sap_code            = "",
                                    zip_code               = ""
                                });
                            }));
                        }
                    }
                    if (flag)
                    {
                        BindPageData();
                        if (dgv_table.Rows.Count > 0)
                        {
                            dgv_table.CurrentCell = dgv_table.Rows[0].Cells[0];
                        }
                        MessageBoxEx.Show("删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    else
                    {
                        MessageBoxEx.Show("删除失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                }
                catch (Exception ex)
                {
                    LogService4Customer.WriteLog(1, ex);
                    MessageBoxEx.Show("删除失败!" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            };
            #endregion

            #region 省市区联动
            cboprovince.SelectedIndexChanged += delegate
            {
                try
                {
                    if (!string.IsNullOrEmpty(cboprovince.SelectedValue.ToString()))
                    {
                        CommonFuncCall.BindCityComBox(cbocity, cboprovince.SelectedValue.ToString(), "市");
                        CommonFuncCall.BindCountryComBox(cbocounty, cbocity.SelectedValue.ToString(), "区/县");
                    }
                    else
                    {
                        CommonFuncCall.BindCityComBox(cbocity, "", "市");
                        CommonFuncCall.BindCountryComBox(cbocounty, "", "区/县");
                    }
                }
                catch (Exception ex)
                {
                    LogService4Customer.WriteLog(1, ex);
                }
            };
            cbocity.SelectedIndexChanged += delegate
            {
                try
                {
                    if (!string.IsNullOrEmpty(cbocity.SelectedValue.ToString()))
                    {
                        CommonFuncCall.BindCountryComBox(cbocounty, cbocity.SelectedValue.ToString(), "区/县");
                    }
                    else
                    {
                        CommonFuncCall.BindCountryComBox(cbocounty, "", "区/县");
                    }
                }
                catch (Exception ex)
                {
                    LogService4Customer.WriteLog(1, ex);
                }
            };
            #endregion

            #region 启用停用事件
            StatusEvent += delegate
            {
                try
                {
                    var          listSql   = new List <SQLObj>();
                    const string opName    = "修改客户档案状态";
                    var          strStatus = Convert.ToInt16(_eStatus).ToString(CultureInfo.InvariantCulture);
                    string       msg;
                    if (_eStatus == DataSources.EnumStatus.Start) //启用
                    {
                        StatusSql(listSql, _tiList, strStatus);   //停用的ti_list改为启用
                        msg = "启用";
                    }
                    else//停用
                    {
                        StatusSql(listSql, _qiList, strStatus);//启用的qi_list 改为停用
                        msg = "停用";
                    }
                    if (MessageBoxEx.Show("确认要" + msg + "吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
                    {
                        return;
                    }
                    if (DBHelper.BatchExeSQLMultiByTrans(opName, listSql))
                    {
                        btnStatus.Enabled = false;
                        BindPageData();
                        MessageBoxEx.Show(msg + "成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    else
                    {
                        MessageBoxEx.Show(msg + "失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
                catch (Exception ex)
                {
                    LogService4Customer.WriteLog(1, ex);
                }
            };
            #endregion

            #region 数据表格事件
            dgv_table.CellContentClick += delegate(object sender, DataGridViewCellEventArgs e)
            {
                try
                {
                    if (e.ColumnIndex != 0)
                    {
                        return;
                    }
                    _qiList.Clear();
                    _tiList.Clear();
                    _eStatus = new DataSources.EnumStatus();
                    foreach (DataGridViewRow row in dgv_table.Rows)
                    {
                        if (!Convert.ToBoolean(row.Cells[0].EditedFormattedValue))
                        {
                            continue;
                        }
                        if (row.Cells["status"].EditedFormattedValue.ToString() == DataSources.EnumStatus.Start.GetDescription()) //表格中是启用
                        {
                            _qiList.Add(row.Cells["cust_id"].EditedFormattedValue.ToString());
                        }
                        else//表格中是停用
                        {
                            _tiList.Add(row.Cells["cust_id"].EditedFormattedValue.ToString());
                        }
                    }
                    BtnStatus(_qiList, _tiList);
                }
                catch (Exception ex)
                {
                    LogService4Customer.WriteLog(1, ex);
                }
            };
            dgv_table.HeadCheckChanged += delegate
            {
                try
                {
                    _qiList.Clear();
                    _tiList.Clear();
                    _eStatus = new DataSources.EnumStatus();
                    foreach (DataGridViewRow row in dgv_table.Rows)
                    {
                        if (Convert.ToBoolean(row.Cells[0].Value))
                        {
                            if (row.Cells["status"].Value.ToString() == DataSources.EnumStatus.Start.GetDescription())//表格中是启用
                            {
                                _qiList.Add(row.Cells["cust_id"].Value.ToString());
                            }
                            else//表格中是停用
                            {
                                _tiList.Add(row.Cells["cust_id"].Value.ToString());
                            }
                        }
                    }
                    BtnStatus(_qiList, _tiList);
                }
                catch (Exception ex)
                {
                    LogService4Customer.WriteLog(1, ex);
                }
            };
            #endregion

            #region 根据选择的数据判断功能按钮的显示状态
            dgv_table.CellMouseUp += delegate
            {
                try
                {
                    var dataView = UIAssistants.GetDataGridCheckRows(dgv_table, colCheck, cust_id, TableName);
                    if (dataView == null)
                    {
                        btnCopy.Enabled   = false;
                        btnEdit.Enabled   = false;
                        btnDelete.Enabled = false;
                        return;
                    }
                    var isYt      = dataView.Cast <DataRowView>().Any(rowView => CommonCtrl.IsNullToString(rowView["data_source"]) == "2");
                    var listField = UIAssistants.GetDataGridCheckRows(dgv_table, colCheck, cust_id);
                    if (listField.Count == 0)
                    {
                        btnCopy.Enabled   = false;
                        btnEdit.Enabled   = false;
                        btnDelete.Enabled = false;
                    }
                    else
                    {
                        btnCopy.Enabled   = true;
                        btnEdit.Enabled   = true;
                        btnDelete.Enabled = true;
                    }
                    if (isYt)
                    {
                        btnEdit.Enabled   = false;
                        btnDelete.Enabled = false;
                    }
                }
                catch (Exception ex)
                {
                    LogService4Customer.WriteLog(1, ex);
                }
            };
            #endregion
        }