Ejemplo n.º 1
0
        private void btnQuery_Click(object sender, System.EventArgs e)
        {
            Session.Remove("Query");
            strBeginDate = Request.Form["txtBegin"].ToString();
            strEndDate   = Request.Form["txtEnd"].ToString();
            if (strBeginDate == "" || strEndDate == "" || strBeginDate == null || strEndDate == null)
            {
                this.SetErrorMsgPageBydir("时间不能为空,请重新选择时间!");
                return;
            }

            string strDeptID = this.ddlReceiveDept.SelectedValue;

            if (strDeptID == "")
            {
                this.SetErrorMsgPageBydir("领用单位不能为空!");
                return;
            }
//			string strGroup=this.ddlGroup.SelectedValue;
//			if(strGroup=="")
//			{
//				this.SetErrorMsgPageBydir("生产组不能为空!");
//				return;
//			}

            Hashtable htPara = new Hashtable();

            htPara.Add("strDeptID", strDeptID);
//			htPara.Add("strGroup",strGroup);
            htPara.Add("strBeginDate", strBeginDate);
            htPara.Add("strEndDate", strEndDate);
            htPara.Add("strOrderState", this.ddlOrderState.SelectedValue);

            Hashtable htapp   = (Hashtable)Application["appconf"];
            string    strcons = (string)htapp["cons"];

            StoBusi = new BusiComm.StorageBusi(strcons);
            try
            {
                DataTable dtout = StoBusi.GetBillOfReceive(htPara);
                if (dtout == null)
                {
                    this.SetErrorMsgPageBydir("查询出错,请重试!");
                    return;
                }
                else
                {
                    this.TableConvert(dtout, "cnvcReceiveDeptID", "NewDept");
                    this.TableConvert(dtout, "cnvcGroup", "tbNameCodeToStorage", "vcCommSign='GROUP'");
                    this.TableConvert(dtout, "cnvcBillState", "tbNameCodeToStorage", "vcCommSign='RECEIVE_OS'");
                    dtout.TableName = "领料单";
                }

                Session["Query"]          = dtout;
                this.DataGrid1.DataSource = dtout;
                this.DataGrid1.DataBind();
            }
            catch (Exception er)
            {
                this.clog.WriteLine(er);
                this.SetErrorMsgPageBydir("查询错误,请重试!");
                return;
            }
        }