private void btn_Select_Click(object sender, EventArgs e) { Frm_TranferPayBill frm = new Frm_TranferPayBill(); if (frm.ShowDialog() == DialogResult.OK) { List <Stock_TranferArInvoice> Item_temp = Item_Tran; Item_Tran = new List <Stock_TranferArInvoice>(); IEnumerable <BCARINVOICESUB> Ireturn = frm.Item_Return; foreach (var itemadd in Ireturn) { Stock_TranferArInvoice Item = new Stock_TranferArInvoice(); Item.DocNo = itemadd.DocNo; Item.DocDate = itemadd.DocDate; Item.ItemCode = itemadd.ItemCode; Item.ItemName = itemadd.ItemName; Item.ArCode = itemadd.ArCode; Item.SaleCode = itemadd.SaleCode; Item.MyDescription = itemadd.MyDescription; Item.WHCode = itemadd.WHCode; Item.ShelfCode = itemadd.ShelfCode; Item.Qty = itemadd.Qty; Item.QtyActual = itemadd.Qty; Item.Price = itemadd.Price; Item.Amount = itemadd.Amount; Item.UnitCode = itemadd.UnitCode; Item.LineNumber = itemadd.LineNumber; //Item_Tran.Add(Item); Item_temp.Add(Item); } Item_Tran = Item_temp.GroupBy(c => new { c.DocNo, c.ItemCode, c.LineNumber }).Select(g => g.First()).ToList(); Fn_LoadToGrid(); } }
public void Update(Stock_TranferArInvoice Items) { var ItemEdit = this.GetFind(Items.ROWORDER); if (ItemEdit != null) { ItemEdit.Tran_DocNo = Items.Tran_DocNo; ItemEdit.DocDate = Items.DocDate; ItemEdit.DocNo = Items.DocNo; ItemEdit.ItemCode = Items.ItemCode; ItemEdit.DocDate = Items.DocDate; ItemEdit.ArCode = Items.ArCode; ItemEdit.SaleCode = Items.SaleCode; ItemEdit.MyDescription = Items.MyDescription; ItemEdit.ItemName = Items.ItemName; ItemEdit.WHCode = Items.WHCode; ItemEdit.ShelfCode = Items.ShelfCode; ItemEdit.Qty = Items.Qty; ItemEdit.QtyActual = Items.QtyActual; ItemEdit.QtyRemain = Items.QtyRemain; ItemEdit.Price = Items.Price; ItemEdit.Amount = Items.Amount; ItemEdit.UnitCode = Items.UnitCode; ItemEdit.LineNumber = Items.LineNumber; ItemEdit.Tran_StatusClear = Items.Tran_StatusClear; ItemEdit.Tran_Attribute01 = Items.Tran_Attribute01; ItemEdit.Tran_Attribute02 = Items.Tran_Attribute02; ItemEdit.Tran_Attribute03 = Items.Tran_Attribute03; ItemEdit.Tran_Attribute04 = Items.Tran_Attribute04; ItemEdit.Tran_Attribute05 = Items.Tran_Attribute05; ItemEdit.Status = Items.Status; ItemEdit.Tran_CreateBy = Items.Tran_CreateBy; ItemEdit.Tran_CreateDate = Items.Tran_CreateDate; ItemEdit.Tran_UpdateBy = Items.Tran_UpdateBy; ItemEdit.Tran_UpdateDate = Items.Tran_UpdateDate; } }
private void simpleButton1_Click(object sender, EventArgs e) { if (Utility.MessageQuestion("คุณต้องการ [ยกเลิกข้อมูลการโอน] หรือไม่...กด Yes เพื่อทำการยกเลิก") == DialogResult.No) { return; } using (var srv = new StockTranferArInvoiceService(Utility.ConnSDB)) { List <Stock_TranferArInvoice> ItemAdd = new List <Stock_TranferArInvoice>(); List <Stock_TranferAccrual> ItemLog = new List <Stock_TranferAccrual>(); Stock_TranferArInvoice Iupdate = srv.GetFind(this._Code); if (Iupdate != null) { string Remark = txt_Tran_Attribute01.Text.Trim(); Iupdate.Tran_Attribute01 = Remark; Iupdate.Status = 2;//0 : โอนสำเร็จ 1 : ค้างโอน 2 : ยกเลิก Iupdate.Tran_UpdateDate = DateTime.Now; Iupdate.Tran_UpdateBy = Utility._UserDB; ItemAdd.Add(Iupdate); Stock_TranferAccrual ILog = new Stock_TranferAccrual(); ILog.TranferAccrual_Date = DateTime.Now; ILog.Tran_DocNo = Iupdate.Tran_DocNo; ILog.Tran_DocDate = Iupdate.Tran_DocDate; ILog.DocNo = Iupdate.DocNo; ILog.ItemCode = Iupdate.ItemCode; ILog.DocDate = Iupdate.DocDate; ILog.ArCode = Iupdate.ArCode; ILog.SaleCode = Iupdate.SaleCode; ILog.MyDescription = Iupdate.MyDescription; ILog.ItemName = Iupdate.ItemName; ILog.WHCode = Iupdate.WHCode; ILog.ShelfCode = Iupdate.ShelfCode; ILog.Qty = Iupdate.Qty; ILog.QtyActual = Iupdate.QtyActual; ILog.QtyRemain = Iupdate.QtyRemain; ILog.Price = Iupdate.Price; ILog.Amount = Iupdate.Amount; ILog.UnitCode = Iupdate.UnitCode; ILog.LineNumber = Iupdate.LineNumber; ILog.Tran_StatusClear = Iupdate.Tran_StatusClear; ILog.Tran_Attribute01 = Iupdate.Tran_Attribute01; ILog.Tran_Attribute02 = Iupdate.Tran_Attribute02; ILog.Tran_Attribute03 = Iupdate.Tran_Attribute03; ILog.Tran_Attribute04 = Iupdate.Tran_Attribute04; ILog.Tran_Attribute05 = Iupdate.Tran_Attribute05; ILog.Status = Iupdate.Status; ILog.Tran_CreateBy = Iupdate.Tran_CreateBy; ILog.Tran_CreateDate = Iupdate.Tran_CreateDate; ILog.Tran_UpdateBy = Iupdate.Tran_UpdateBy; ILog.Tran_UpdateDate = Iupdate.Tran_UpdateDate; ItemLog.Add(ILog); } using (var srv2 = new StockTranferAccrualService(Utility.ConnSDB)) { if (srv.Update(ItemAdd) && srv2.Insert(ItemLog)) { Utility.MessageInformation("บันทึกข้อมูลสำเร็จ..."); DialogResult = DialogResult.Yes; this.Close(); } else { if (srv.ErrorMessage != "") { Utility.MessageError("ไม่สามารถบันทึกได้ เนื่องจาก : " + srv.ErrorMessage); } if (srv2.ErrorMessage != "") { Utility.MessageError("ไม่สามารถบันทึกได้ เนื่องจาก : " + srv2.ErrorMessage); } } } } }
public void Delete(Stock_TranferArInvoice Items) { db.Stock_TranferArInvoice.Remove(Items); }
public void Insert(Stock_TranferArInvoice Items) { db.Stock_TranferArInvoice.Add(Items); }
private void btn_Cancel_Click(object sender, EventArgs e) { if (gridView1.SelectedRowsCount > 0) { if (Utility.MessageQuestion("คุณต้องการ [ยกเลิกข้อมูลการโอน] ที่เลือกหรือไม่...กด Yes เพื่อทำการยกเลิก") == DialogResult.No) { return; } int[] rows = gridView1.GetSelectedRows(); using (var srv = new StockTranferArInvoiceService(Utility.ConnSDB)) { List <Stock_TranferArInvoice> ItemAdd = new List <Stock_TranferArInvoice>(); List <Stock_TranferAccrual> ItemLog = new List <Stock_TranferAccrual>(); for (int i = 0; i < gridView1.SelectedRowsCount; i++) { Stock_TranferArInvoice IReture = (Stock_TranferArInvoice)gridView1.GetRow(rows[i]); Stock_TranferArInvoice Iupdate = srv.GetFind(IReture.ROWORDER); if (Iupdate != null) { //---เดิม //Iupdate.QtyActual = Iupdate.QtyActual + IReture.QtyActual; // บวกการเบิกของใหม่กับเดิมไป //---ใหม่ แก้ตรงข้ามกับอันเดิม 27-12-2559 Iupdate.QtyActual = Iupdate.QtyActual - IReture.QtyActual; // บวกการเบิกของใหม่กับเดิมไป Iupdate.QtyRemain = Iupdate.Qty - Iupdate.QtyActual; // คำนวณยอดคงเหลือ Iupdate.Tran_StatusClear = 1; //0 : รายการปกติ ยอดคงค้างใช้คำนวณ 1 : รายการที่ถูกยกเลิก ยอดคงค้างจะไม่คำนวณ Iupdate.Status = 2; //0 : โอนสำเร็จ 1 : ค้างโอน 2 : ยกเลิก Iupdate.Tran_UpdateDate = DateTime.Now; Iupdate.Tran_UpdateBy = Utility._UserDB; ItemAdd.Add(Iupdate); Stock_TranferAccrual ILog = new Stock_TranferAccrual(); ILog.TranferAccrual_Date = DateTime.Now; ILog.Tran_DocNo = Iupdate.Tran_DocNo; ILog.Tran_DocDate = Iupdate.Tran_DocDate; ILog.DocNo = Iupdate.DocNo; ILog.ItemCode = Iupdate.ItemCode; ILog.DocDate = Iupdate.DocDate; ILog.ArCode = Iupdate.ArCode; ILog.SaleCode = Iupdate.SaleCode; ILog.MyDescription = Iupdate.MyDescription; ILog.ItemName = Iupdate.ItemName; ILog.WHCode = Iupdate.WHCode; ILog.ShelfCode = Iupdate.ShelfCode; ILog.Qty = Iupdate.Qty; ILog.QtyActual = Iupdate.QtyActual; ILog.QtyRemain = Iupdate.QtyRemain; ILog.Price = Iupdate.Price; ILog.Amount = Iupdate.Amount; ILog.UnitCode = Iupdate.UnitCode; ILog.LineNumber = Iupdate.LineNumber; ILog.Tran_StatusClear = Iupdate.Tran_StatusClear; ILog.Tran_Attribute01 = Iupdate.Tran_Attribute01; ILog.Tran_Attribute02 = Iupdate.Tran_Attribute02; ILog.Tran_Attribute03 = Iupdate.Tran_Attribute03; ILog.Tran_Attribute04 = Iupdate.Tran_Attribute04; ILog.Tran_Attribute05 = Iupdate.Tran_Attribute05; ILog.Status = Iupdate.Status; ILog.Tran_CreateBy = Iupdate.Tran_CreateBy; ILog.Tran_CreateDate = Iupdate.Tran_CreateDate; ILog.Tran_UpdateBy = Iupdate.Tran_UpdateBy; ILog.Tran_UpdateDate = Iupdate.Tran_UpdateDate; ItemLog.Add(ILog); } } //foreach (Stock_TranferArInvoice Iset in ItemAdd) //{ // Stock_TranferAccrual ILog = new Stock_TranferAccrual(); // ILog.TranferAccrual_Date = DateTime.Now; // ILog.Tran_DocNo = Iset.Tran_DocNo; // ILog.Tran_DocDate = Iset.Tran_DocDate; // ILog.DocNo = Iset.DocNo; // ILog.ItemCode = Iset.ItemCode; // ILog.DocDate = Iset.DocDate; // ILog.ArCode = Iset.ArCode; // ILog.SaleCode = Iset.SaleCode; // ILog.MyDescription = Iset.MyDescription; // ILog.ItemName = Iset.ItemName; // ILog.WHCode = Iset.WHCode; // ILog.ShelfCode = Iset.ShelfCode; // ILog.Qty = Iset.Qty; // ILog.QtyActual = Iset.QtyActual; // ILog.QtyRemain = Iset.QtyRemain; // ILog.Price = Iset.Price; // ILog.Amount = Iset.Amount; // ILog.UnitCode = Iset.UnitCode; // ILog.LineNumber = Iset.LineNumber; // ILog.Tran_StatusClear = Iset.Tran_StatusClear; // ILog.Tran_Attribute01 = Iset.Tran_Attribute01; // ILog.Tran_Attribute02 = Iset.Tran_Attribute02; // ILog.Tran_Attribute03 = Iset.Tran_Attribute03; // ILog.Tran_Attribute04 = Iset.Tran_Attribute04; // ILog.Tran_Attribute05 = Iset.Tran_Attribute05; // ILog.Status = Iset.Status; // ILog.Tran_CreateBy = Iset.Tran_CreateBy; // ILog.Tran_CreateDate = Iset.Tran_CreateDate; // ILog.Tran_UpdateBy = Iset.Tran_UpdateBy; // ILog.Tran_UpdateDate = Iset.Tran_UpdateDate; // ItemLog.Add(ILog); //} using (var srv2 = new StockTranferAccrualService(Utility.ConnSDB)) { if (srv.Update(ItemAdd) && srv2.Insert(ItemLog)) { Utility.MessageInformation("บันทึกข้อมูลสำเร็จ..."); backgroundWorker_Remain.RunWorkerAsync(); } else { if (srv.ErrorMessage != "") { Utility.MessageError("ไม่สามารถบันทึกได้ เนื่องจาก : " + srv.ErrorMessage); } if (srv2.ErrorMessage != "") { Utility.MessageError("ไม่สามารถบันทึกได้ เนื่องจาก : " + srv2.ErrorMessage); } } } } //List<Stock_TranferArInvoice> ItemAdd = new List<Stock_TranferArInvoice>(); //for (int i = 0; i < gridView1.SelectedRowsCount; i++) //{ // Stock_TranferArInvoice IReture = (Stock_TranferArInvoice)gridView1.GetRow(rows[i]); // IReture.QtyRemain = IReture.Qty - IReture.QtyActual; // [Qty] - [QtyActual] // IReture.Tran_StatusClear = 1;//0 : รายการปกติ ยอดคงค้างใช้คำนวณ 1 : รายการที่ถูกยกเลิก ยอดคงค้างจะไม่คำนวณ // ItemAdd.Add(IReture); //} //using (var srv = new StockTranferArInvoiceService(Utility.ConnSDB)) //{ // if (srv.Update(ItemAdd)) // { // Utility.MessageInformation("บันทึกข้อมูลสำเร็จ..."); // backgroundWorker_Remain.RunWorkerAsync(); // } // else // Utility.MessageError("ไม่สามารถบันทึกได้ เนื่องจาก : " + srv.ErrorMessage); //} } }