/// <summary> /// Binds the purchase list. /// </summary> private void BindPurchaseList() { DataTable dt = new DataTable(); dt.Columns.Add("OrderHeaderId"); dt.Columns.Add("Records"); dt.Columns.Add("PONumber"); dt.Columns.Add("Type"); int iCount = 1; string objPOnumber = (this.txtPONumber.Text.Trim() == "*") ? string.Empty : PurchasingUtils.GenSafeChars(this.txtPONumber.Text.Trim()); string objType = (this.txtType.Text.Trim() == "*") ? string.Empty : PurchasingUtils.GenSafeChars(this.txtType.Text.Trim()); string sql = "Status = 1 AND PostedBy <> '" + System.Guid.Empty + "' AND OrderNumber LIKE '%" + objPOnumber + "%' AND OrderType LIKE '%" + objType + "%'"; string[] objOrderBy = { "OrderNumber" }; PurchaseOrderHeaderCollection objHeaders = PurchaseOrderHeader.LoadCollection(sql, objOrderBy, true); foreach (PurchaseOrderHeader objHeader in objHeaders) { string orderType = string.Empty; switch (objHeader.OrderType) { case 0: orderType = DAL.Common.Enums.POType.FPO.ToString(); break; case 1: orderType = DAL.Common.Enums.POType.LPO.ToString(); break; case 2: orderType = DAL.Common.Enums.POType.OPO.ToString(); break; } DataRow row = dt.NewRow(); row["OrderHeaderId"] = objHeader.OrderHeaderId.ToString(); //// OrderHeaderId row["Records"] = iCount.ToString(); //// Line Number row["PONumber"] = objHeader.OrderNumber; row["Type"] = orderType; dt.Rows.Add(row); iCount++; } dgvReceivingFindList.DataSource = dt; }
/// <summary> /// Binds the purchase list. /// </summary> private void BindPurchaseList() { this.lisReceivingFindList.Items.Clear(); ////清除lisPurchaseOrderList控件中的数据 int iCount = 1; string objPOnumber = (this.txtPONumber.Text.Trim() == "*") ? string.Empty : PurchasingUtils.GenSafeChars(this.txtPONumber.Text.Trim()); string objType = (this.txtType.Text.Trim() == "*") ? string.Empty : PurchasingUtils.GenSafeChars(this.txtType.Text.Trim()); string sql = "Status = 1 AND PostedBy <> '" + Guid.Empty + "' AND OrderNumber LIKE '%" + objPOnumber + "%' AND OrderType LIKE '%" + objType + "%'"; string orderBy = "OrderNumber"; using (var ctx = new EF6.RT2020Entities()) { var objHeaders = ctx.PurchaseOrderHeader.SqlQuery( string.Format("Select * from PurchaseOrderHeader Where {0} Order By {1}", sql, orderBy)) .AsNoTracking() .ToList(); foreach (var objHeader in objHeaders) { string orderType = string.Empty; switch (objHeader.OrderType) { case 0: orderType = EnumHelper.POType.FPO.ToString(); break; case 1: orderType = EnumHelper.POType.LPO.ToString(); break; case 2: orderType = EnumHelper.POType.OPO.ToString(); break; } ListViewItem objItem = this.lisReceivingFindList.Items.Add(objHeader.OrderHeaderId.ToString()); //// OrderHeaderId objItem.SubItems.Add(iCount.ToString()); //// Line Number objItem.SubItems.Add(objHeader.OrderNumber); objItem.SubItems.Add(orderType); iCount++; } } }