private void DgBind() { Hashtable htPara = new Hashtable(); string strBesFlag = cmbFlag.Text.Trim(); if (cmbFlag.Text == "全部" || cmbFlag.Text.Trim() == "") { strBesFlag = ""; } else if (cmbFlag.Text == "已下订") { strBesFlag = "0"; } else if (cmbFlag.Text == "已完成") { strBesFlag = "2"; } else if (cmbFlag.Text == "已取消") { strBesFlag = "1"; } // else // { // strBesFlag=this.GetColEn(strBesFlag,"BF"); // } htPara.Add("strBesFlag", strBesFlag); string strBegin = dtpBegin.Value.ToShortDateString() + " 00:00:00"; htPara.Add("strBegin", strBegin); string strEnd = dtpEnd.Value.ToShortDateString() + " 23:59:59"; htPara.Add("strEnd", strEnd); Exception err = null; DataTable dt = new DataTable(); dt = cs.GetBespeaksQuery(htPara, out err); if (dt != null && dt.Rows.Count >= 0) { this.DataTableConvert(dt, "vcDeptID", "MD", "vcCommCode", "vcCommName"); this.dataGrid1.CaptionText = "订购日志"; this.dataGrid1.SetDataBinding(dt, ""); this.EnToCh("流水号,会员卡号,订购人,联系电话,订购内容,数量,下订日期,送货日期,操作员,操作员门店,订购状态,完成日期", "50,50,80,100,150,50,80,80,80,80,80,80", dt, this.dataGrid1); if (dt.Rows.Count > 0) { this.sbtnExcel.Enabled = true; } else { this.sbtnExcel.Enabled = false; } } else { MessageBox.Show("查询出错,请重试!", "系统提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); if (err != null) { clog.WriteLine(err); } } }