//查询数据 private void QueryData(out OrderInfoInvoke orderInfoInvokeObj, out List <PurchaseOrder> lstPurchaseOrder) { string warehouse = string.Empty;// //从配置文件读取默认的仓库--地王26库 if (System.Configuration.ConfigurationManager.AppSettings.AllKeys.Contains("DefaultWHCode")) { warehouse = System.Configuration.ConfigurationManager.AppSettings["DefaultWHCode"].ToString(); } else { warehouse = "20101"; } string billType = "PurchaseOrder"; //单据类型 string startTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", System.DateTime.Now); //开始时间 if (txtStartTime.Text.Trim() != string.Empty) { DateTime dateEnd = Convert.ToDateTime(txtStartTime.Text.Trim()); DateTime endT = new DateTime(dateEnd.Year, dateEnd.Month, dateEnd.Day, 00, 00, 00);//获取开始时间,精确到秒 startTime = endT.ToString(); } string endTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", System.DateTime.Now);//结束时间 if (txtEndTime.Text.Trim() != string.Empty) { DateTime dateEnd = Convert.ToDateTime(txtEndTime.Text.Trim()); //DateTime endT = new DateTime(dateEnd.Year, dateEnd.Month, dateEnd.Day, System.DateTime.Now.Hour, System.DateTime.Now.Minute,System.DateTime.Now.Second);//获取截止时间,精确到秒 DateTime endT = new DateTime(dateEnd.Year, dateEnd.Month, dateEnd.Day, 23, 59, 59);//获取截止时间,精确到秒 endTime = endT.ToString(); } int maxCount = 500;//最大查询条数 //是否已导入 string isAlreadyStatus = string.Empty; if (ddlisAlreadyStatus.SelectedIndex != 0) { isAlreadyStatus = ddlisAlreadyStatus.SelectedValue; } string queryMsg = ""; orderInfoInvokeObj = OrderInfoInvokeFactory.CreateInstance(warehouse, billType, startTime, endTime, maxCount, isAlreadyStatus); if (orderInfoInvokeObj.GetNCDataJoinRFID(out lstPurchaseOrder, out queryMsg) == false) { ShowMessageBox("查询用友系统采购订单信息失败!详细信息:" + queryMsg); return; } ViewState["lstPurchaseOrder"] = lstPurchaseOrder; }
//提交 protected void btnSubmit_Click(object sender, EventArgs e) { string saveMsg = ""; List <PurchaseOrder> lstPurchaseOrder = new List <PurchaseOrder>(); //所有的采购订单 List <PurchaseOrder> lstSelectPurchase = new List <PurchaseOrder>(); //被选中的采购订单行项目 bool isChecked = false; OrderInfoInvoke orderInfoInvokeObj = new OrderInfoInvoke(); QueryData(out orderInfoInvokeObj, out lstPurchaseOrder); if (ViewState["lstPurchaseOrder"] != null) { lstPurchaseOrder = (List <PurchaseOrder>)ViewState["lstPurchaseOrder"]; } //获取选中的行项目 foreach (GridViewRow grow in GridView1.Rows) { CheckBox chkSelect = grow.Cells[0].Controls[1] as CheckBox; if (chkSelect.Checked) { isChecked = true; string ncCode = grow.Cells[1].Text; foreach (PurchaseOrder purchaseOrder in lstPurchaseOrder) { if (purchaseOrder.NCOrderCode == ncCode) { lstSelectPurchase.Add(purchaseOrder); } } } } if (!isChecked || lstSelectPurchase.Count == 0) { ShowMessageBox("请选择需要导入的订单!"); return; } bool result = orderInfoInvokeObj.SaveToRFID(lstSelectPurchase, out saveMsg); if (result) { btnReturn.Visible = true; btnSubmit.Enabled = false; } ShowMessageBox(result == true ? "数据导入成功!" : "数据导入失败!", new Exception(saveMsg)); }
//列表排序 protected void GridView1_Sorting(object sender, GridViewSortEventArgs e) { ////保存sortExpression和sortDirection。 string sortExpression = e.SortExpression; string sortDirection = "ASC"; if (sortExpression.Equals(GridView1.Attributes["sortExpression"]) && "ASC".Equals(GridView1.Attributes["sortDirection"])) { sortDirection = "DESC"; } GridView1.Attributes.Add("sortExpression", sortExpression); GridView1.Attributes.Add("sortDirection", sortDirection); //GridView1.DataBind(); List <PurchaseOrder> lstPurchaseOrder = null; if (ViewState["lstPurchaseOrder"] != null) { lstPurchaseOrder = (List <PurchaseOrder>)ViewState["lstPurchaseOrder"]; } else { OrderInfoInvoke orderInfoInvokeObj = new OrderInfoInvoke(); QueryData(out orderInfoInvokeObj, out lstPurchaseOrder); } if (lstPurchaseOrder != null) { //string sortExpression = e.SortExpression; SortDirection sortDirection1 = GridView1.Attributes["sortDirection"] == "ASC" ? SortDirection.Ascending : SortDirection.Descending; if (sortDirection1 == SortDirection.Ascending) { lstPurchaseOrder = lstPurchaseOrder.OrderBy(r => r.GetType().GetProperty(sortExpression).GetValue(r, null)).ToList(); } else { lstPurchaseOrder = lstPurchaseOrder.OrderByDescending(r => r.GetType().GetProperty(sortExpression).GetValue(r, null)).ToList(); } //绑定数据到界面的Gridview GridView1.DataSource = lstPurchaseOrder; GridView1.DataBind(); ViewState["lstPurchaseOrder"] = lstPurchaseOrder; } }
//页面加载事件 protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //设置开始时间和结束时间的默认值 txtStartTime.Text = System.DateTime.Now.ToShortDateString(); txtEndTime.Text = System.DateTime.Now.ToShortDateString(); List <PurchaseOrder> lstPurchaseOrder = null; OrderInfoInvoke orderInfoInvokeObj = new OrderInfoInvoke(); QueryData(out orderInfoInvokeObj, out lstPurchaseOrder); if (lstPurchaseOrder != null) { //绑定数据到界面的Gridview GridView1.DataSource = lstPurchaseOrder; GridView1.DataBind(); } } //这里要注意,一定要放在if (!this.IsPostBack)之外 DisplayFixHeader(this.GridView1);//生成固定表头 }
//查询按钮 protected void btnQuery_Click(object sender, EventArgs e) { try { //清空界面数据 GridView1.DataSource = null; GridView1.DataBind(); List <PurchaseOrder> lstPurchaseOrder = null; OrderInfoInvoke orderInfoInvokeObj = new OrderInfoInvoke(); QueryData(out orderInfoInvokeObj, out lstPurchaseOrder); if (lstPurchaseOrder != null) { //绑定数据到界面的Gridview GridView1.DataSource = lstPurchaseOrder; GridView1.DataBind(); } } catch (Exception ex) { ShowMessageBox("数据导入失败!", ex); } }