private void DgBind() { string strCardID = txtCardID.Text.Trim(); string strEmpName = txtEmpName.Text.Trim(); string strDeptID = cmbDept.Text.Trim(); string strPhone = txtPhone.Text.Trim(); if (strDeptID == "全部") { strDeptID = ""; } else { strDeptID = this.GetColEn(strDeptID, "MD"); } Hashtable htpara = new Hashtable(); htpara.Add("cardid", strCardID); htpara.Add("empname", strEmpName); htpara.Add("deptid", strDeptID); htpara.Add("phone", strPhone); Exception err = null; DataTable dt = new DataTable(); dt = ca.GetEmpInfo(htpara, out err); if (err != null) { MessageBox.Show("查询错误,请重试!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); clog.WriteLine(err); return; } if (dt.Rows.Count >= 0) { this.DataTableConvert(dt, "vcDegree", "DE", "vcCommCode", "vcCommName"); this.DataTableConvert(dt, "vcFlag", "ES", "vcCommCode", "vcCommName"); this.DataTableConvert(dt, "vcOfficer", "OF", "vcCommCode", "vcCommName"); this.DataTableConvert(dt, "vcDeptID", "MD", "vcCommCode", "vcCommName"); } if (dt != null) { this.dataGrid1.SetDataBinding(dt, ""); this.EnToCh("员工卡号,员工姓名,性别,证件号码,入职时间,学历,联系电话,地址,职务,门店,员工状态,备注,操作时间", "60,100,60,100,80,100,100,100,90,60", dt, this.dataGrid1); } else { MessageBox.Show("查询错误,请重试!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); } }