protected void btn_Search_Click(object sender, EventArgs e) { try { bool isAudit = false; var selectType = int.Parse(DDL_Type.SelectedValue); //門市/福袋、瑕疵退廠調出查詢 var shipDa = new POS_Library.ShopPos.ShipOutDA(); var posTickets = shipDa.PosTickets(selectType, _areaId); int si = 1; var temp = posTickets.OrderByDescending(x => x.TicketDate).Select(x => new { 序號 = si++, 傳票ID = x.TicketId, 出貨日期 = x.TicketDate.ToString("yyyy-MM-dd"), 印單日期 = x.VerifyDate == null ? "" : x.VerifyDate.Value.ToString("yyyy-MM-dd"), 驗貨日期 = x.AuditDate == null ? "" : x.AuditDate.Value.ToString("yyyy-MM-dd"), 驗貨者 = x.AuditAccount, 功能 = "", }).ToList(); gv_List.DataSource = temp; gv_List.DataBind(); lbl_Count.Text = "總筆數:" + gv_List.Rows.Count; } catch (Exception ex) { lbl_Message.Text = ex.Message; } }
public void Search() { try { var temp = new List <POS_Library.ShopPos.DataModel.ImportClass.TicketDetailModel>(); if (!string.IsNullOrEmpty(box)) { var shipDa = new POS_Library.ShopPos.ShipInDA(); temp = shipDa.GetPosBoxDetail(box, areaId); } else if (ticketId != 0) { var shipDa = new POS_Library.ShopPos.ShipOutDA(); temp = shipDa.GetTicketDetail(ticketId, areaId, false, true); } int x = 1; var temp2 = (from i in temp select new { 序號 = x++, 傳票ID = i.TicketId, 產品編號 = i.ProductId, 數量 = i.Quantity }).ToList(); gv_List.DataSource = temp2; gv_List.DataBind(); var 總筆數 = temp2.Count; var 傳票數 = temp2.Select(y => y.傳票ID).Distinct().Count(); var 總件數 = temp2.Sum(y => y.數量); lbl_Count.Text = "總筆數: " + 總筆數 + ", 傳票數: " + 傳票數 + ", 總件數: " + 總件數; } catch (Exception ex) { lbl_Count.Text = ex.Message; } }
public void ShipOutDetail(int pickType, int num, string productid, int store) { try { var ticketShelfTempList = new List <POS_Library.ShopPos.DataModel.TicketShelfTemp>(); var shipDa = new POS_Library.ShopPos.ShipOutDA(); ticketShelfTempList = shipDa.PickDetailCk(num, pickType, store); if (!string.IsNullOrEmpty(productid)) { ticketShelfTempList = ticketShelfTempList.Where(x => x.ProductId == productid).ToList(); } ticketShelfTempList = ticketShelfTempList.Select(x => new POS_Library.ShopPos.DataModel.TicketShelfTemp { Ticket = x.Ticket, ShipId = x.ShipId, Account = x.Account, ShipNo = x.ShipNo, ProductId = x.ProductId, Quantity = x.Quantity, Repository = x.Repository, Division = x.Division, Floor = x.Floor, GuestId = x.GuestId, NowQuantity = x.NowQuantity, LackQuantity = x.LackQuantity }).ToList(); //產生無貨表供勾選 if (ticketShelfTempList.Count > 0) { int x = 1; var result = (from i in ticketShelfTempList orderby i.Division select new { 序號 = x++, 傳票號碼 = i.Ticket, 訂單編號 = i.GuestId, 商品編號 = i.ProductId, 別 = i.Repository, 儲位名稱 = i.Division, 應有數量 = i.NowQuantity, 現有數量 = i.NowQuantity, 短缺數量 = i.LackQuantity, 樓層 = i.Floor, GuestId = i.GuestId, 出貨序號 = i.ShipId, 貨運單號 = i.ShipNo, 帳號 = i.Account, }).ToList(); if (result.Count == 0) { lbl_Message.Text = "此無貨撿貨單已全部處理完成!請重新列印撿貨單!!"; } gv_List.DataSource = result; gv_List.DataBind(); } else { lbl_Message.Text = "無資料!"; } } catch (Exception ex) { Response.Write("系統發生錯誤 " + ex.Message); } }