private void DBbind() { Session.Remove("oldEnterCount"); Session.Remove("EnterForMod"); strBeginDate = Request.Form["txtBegin"].ToString(); strEndDate = Request.Form["txtEnd"].ToString(); if (strBeginDate == "" || strEndDate == "" || strBeginDate == null || strEndDate == null) { this.SetErrorMsgPageBydir("时间不能为空,请重新选择时间!"); return; } Session.Remove("QUERY"); Hashtable htapp = (Hashtable)Application["appconf"]; string strcons = (string)htapp["cons"]; msb1 = new MaterialSBusi(strcons); string strMaterialCode = txtMaterialCode.Text.Trim(); string strMaterialName = txtMaterialName.Text.Trim(); string strMaterialType = ddlMaterialType.SelectedValue; string strEnterSerial = txtEnterSerial.Text.Trim(); Hashtable htpara = new Hashtable(); htpara.Add("strMaterialCode", strMaterialCode); htpara.Add("strMaterialName", strMaterialName); htpara.Add("strMaterialType", strMaterialType); htpara.Add("strEnterSerial", strEnterSerial); htpara.Add("strBeginDate", strBeginDate); htpara.Add("strEndDate", strEndDate); htpara.Add("strBatchNo", this.txtBatchNo.Text.Trim()); htpara.Add("strDeptID", this.ddlDept.SelectedValue); try { DataTable dtout = msb1.GetMaterialEnterForMod(htpara); if (dtout == null) { this.SetErrorMsgPageBydir("查询出错,请重试!"); return; } else { dtout.TableName = "原材料入库查询"; Session["EnterForMod"] = dtout; this.DataGrid1.EditItemIndex = -1; this.DataGrid1.Columns[16].Visible = true; CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"]; if (ls1.strDeptID == "CEN00" || ls1.strNewDeptID == "") { this.DataGrid1.Columns[15].Visible = false; this.DataGrid1.Columns[16].Visible = false; } this.DataGrid1.DataSource = dtout; this.DataGrid1.DataBind(); } this.DataGrid1.DataSource = dtout; this.DataGrid1.DataBind(); } catch (Exception er) { this.clog.WriteLine(er); this.SetErrorMsgPageBydir("查询错误,请重试!"); return; } }