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();
            }
        }
Ejemplo n.º 2
0
        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;
            }
        }
Ejemplo n.º 3
0
        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);
                        }
                    }
                }
            }
        }
Ejemplo n.º 4
0
 public void Delete(Stock_TranferArInvoice Items)
 {
     db.Stock_TranferArInvoice.Remove(Items);
 }
Ejemplo n.º 5
0
 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);
                //}
            }
        }