private void CampaignFullyQtyAndSaleForm_Load(object sender, EventArgs e)
        {
            dateTimePickerStart.MinDate = DateTime.Now;
            SingletonProduct.Instance();
            SingletonPriority1.Instance();
            using (SSLsEntities db = new SSLsEntities())
            {
                int currentYear  = DateTime.Now.Year;
                int currentMonth = DateTime.Now.Month;
                var pro          = db.PriceSchedule.Where(w => w.CreateDate.Year == currentYear && w.CreateDate.Month == currentMonth).Count() + 1;

                string proCodeGen = SingletonThisBudgetYear.Instance().ThisYear.CodeYear + DateTime.Now.ToString("MM") + Library.GenerateCodeFormCount(pro, 3);
                textBoxProCode.Text = proCodeGen;
            }
        }
 /// <summary>
 /// ตกลง ต่อเวลา
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void button2_Click(object sender, EventArgs e)
 {
     using (SSLsEntities db = new SSLsEntities())
     {
         priceSchedule                 = db.PriceSchedule.SingleOrDefault(w => w.Id == priceSchedule.Id);
         priceSchedule.StartDate       = dateTimePickerStart.Value;
         priceSchedule.EndDate         = dateTimePickerEnd.Value;
         priceSchedule.UpdateDate      = DateTime.Now;
         priceSchedule.UpdateBy        = Singleton.SingletonAuthen.Instance().Id;
         db.Entry(priceSchedule).State = EntityState.Modified;
         db.SaveChanges();
         this.searchEditPromotionForm.Reload();
         this.Dispose();
     }
 }
        private void ResetForm()
        {
            string code = "";

            using (SSLsEntities db = new SSLsEntities())
            {
                int        currentYear  = DateTime.Now.Year;
                int        currentMonth = DateTime.Now.Month;
                var        iss          = db.ISS2Front.Where(w => w.CreateDate.Year == currentYear && w.CreateDate.Month == currentMonth).Count() + 1;
                BudgetYear budget       = Singleton.SingletonThisBudgetYear.Instance().ThisYear;
                //Branch branch = Singleton.SingletonP
                code             = MyConstant.PrefixForGenerateCode.StoreFrontAdd + "" + budget.CodeYear + DateTime.Now.ToString("MM") + Library.GenerateCodeFormCount(iss, 4);
                textBoxCode.Text = code;
            }
        }
 public void setProductGroup(ComboBox cb)
 {
     using (SSLsEntities db = new SSLsEntities())
     {
         var       pgp          = db.ProductGroups.Where(w => w.Enable == true).ToList();
         var       locationtype = pgp.Select(w => new { w.Id, w.Name }).ToList();
         DataTable dt_summary   = new DataTable();
         dt_summary = Library.ConvertToDataTable(locationtype);
         dt_summary.Rows.Add(0, "ทั้งหมด");
         cb.DataSource    = dt_summary;
         cb.DisplayMember = "Name";
         cb.ValueMember   = "Id";
         cb.SelectedIndex = dt_summary.Rows.Count - 1;
     }
 }
 private void Recount()
 {
     using (SSLsEntities db = new SSLsEntities())
     {
         string barcodescan       = textBoxScanner.Text.Trim();
         var    getProductDetails = Singleton.SingletonProduct.Instance().ProductDetails.FirstOrDefault(w => w.Enable == true && w.Code == barcodescan);
         var    checkFKPro        = db.CheckStockDetails.FirstOrDefault(w => w.Enable == true && w.FKProductDetails == getProductDetails.Id);
         checkFKPro.Enable          = false;
         checkFKPro.UpdateDate      = DateTime.Now;
         checkFKPro.UpdateBy        = _UserId;
         db.Entry(checkFKPro).State = EntityState.Modified;
         db.SaveChanges();
     }
     ResetNew();
 }
        private void RefreshGrid()
        {
            using (SSLsEntities db = new SSLsEntities())
            {
                dataGridView1.Rows.Clear();
                dataGridView1.Refresh();
                DateTime dateS = dateTimePickerStart.Value;
                DateTime dateE = dateTimePickerEnd.Value;
                List <CheckStockDetails> list = new List <CheckStockDetails>();
                if (_UserId == null)
                {
                    list = db.CheckStockDetails.Where(w => w.Enable == true &&
                                                      DbFunctions.TruncateTime(w.CreateDate) >= DbFunctions.TruncateTime(dateS) &&
                                                      DbFunctions.TruncateTime(w.CreateDate) <= DbFunctions.TruncateTime(dateE)).OrderBy(w => w.CreateDate).ToList();
                }
                else
                {
                    list = db.CheckStockDetails.Where(w => w.Enable == true && w.CreateBy == _UserId &&
                                                      DbFunctions.TruncateTime(w.CreateDate) >= DbFunctions.TruncateTime(dateS) &&
                                                      DbFunctions.TruncateTime(w.CreateDate) <= DbFunctions.TruncateTime(dateE)).OrderBy(w => w.CreateDate).ToList();
                }

                foreach (var item in list)
                {
                    string stat = "ตรวจนับ";
                    if (item.ConfirmDate != null)
                    {
                        stat = "ยืนยัน";
                    }
                    decimal total = (item.QtyUnitCheck - item.QtyUnitOnHand) * item.ProductDetails.CostAndVat;
                    dataGridView1.Rows.Add
                    (
                        item.Id,
                        Library.ConvertDateToThaiDate(item.CreateDate),
                        Library.GetFullNameUserById(item.CreateBy),
                        item.ProductDetails.Code,
                        item.ProductDetails.Products.ThaiName,
                        item.ProductDetails.ProductUnit.Name,
                        Library.ConvertDecimalToStringForm(item.QtyUnitOnHand),
                        Library.ConvertDecimalToStringForm(item.QtyUnitCheck),
                        Library.ConvertDecimalToStringForm(item.QtyUnitCheck - item.QtyUnitOnHand),
                        Library.ConvertDecimalToStringForm(item.ProductDetails.CostAndVat),
                        Library.ConvertDecimalToStringForm(total),
                        stat
                    );
                }
            }
        }
        /// <summary>
        /// ยืนยันบันทึก disable ชุดเดิมทิ้งทั้งหมด
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button3_Click(object sender, EventArgs e)
        {
            List <int> ids = new List <int>();

            for (int i = 0; i < dataGridView2.Rows.Count; i++)
            {
                //Console.WriteLine();
                int id = int.Parse(dataGridView2.Rows[i].Cells[0].Value.ToString());
                ids.Add(id);
            }
            DialogResult dr = MessageBox.Show("คุณต้องการบันทึกข้อมูล ใช่หรือไม่ ?",
                                              "คำเตือนจากระบบ", MessageBoxButtons.YesNo);

            switch (dr)
            {
            case DialogResult.Yes:
                using (SSLsEntities db = new SSLsEntities())
                {
                    var menuAc = db.MenuAccess.Where(w => w.Enable == true && w.FKRole == _idRole);
                    foreach (var item in menuAc)
                    {
                        item.Enable          = false;
                        item.UpdateDate      = DateTime.Now;
                        item.UpdateBy        = Singleton.SingletonAuthen.Instance().Id;
                        db.Entry(item).State = EntityState.Modified;
                    }
                    // add new ids
                    foreach (var item in ids)
                    {
                        MenuAccess ac = new MenuAccess();
                        ac.CreateBy   = Singleton.SingletonAuthen.Instance().Id;
                        ac.CreateDate = DateTime.Now;
                        ac.FKRole     = _idRole;
                        ac.FKMenu     = item;
                        ac.UpdateDate = DateTime.Now;
                        ac.UpdateBy   = Singleton.SingletonAuthen.Instance().Id;
                        ac.Enable     = true;
                        db.MenuAccess.Add(ac);
                    }
                    db.SaveChanges();
                    ReloaGrid1();
                }
                break;

            case DialogResult.No:
                break;
            }
        }
        public void ReloadGrid()
        {
            using (SSLsEntities db = new SSLsEntities())
            {
                dataGridView1.Rows.Clear();
                dataGridView1.Refresh();
                DateTime dateS = dateTimePickerStart.Value;
                DateTime dateE = dateTimePickerEnd.Value;
                List <StoreFrontTransferOut> list = new List <StoreFrontTransferOut>();
                list = db.StoreFrontTransferOut.Where(w =>
                                                      DbFunctions.TruncateTime(w.CreateDate) >= DbFunctions.TruncateTime(dateS) &&
                                                      DbFunctions.TruncateTime(w.CreateDate) <= DbFunctions.TruncateTime(dateE)).OrderBy(w => w.CreateDate).ToList();

                decimal total = 0;
                foreach (var item in list)
                {
                    string status = "";
                    if (item.Enable == false)
                    {
                        status = "ยกเลิกใบโอน";
                    }
                    else if (item.ConfirmDate != null)
                    {
                        status = "ยืนยันใบโอน";
                    }
                    else
                    {
                        status = "สร้างใบโอน";
                    }

                    dataGridView1.Rows.Add(
                        false,
                        Library.ConvertDateToThaiDate(item.CreateDate),
                        Library.GetFullNameUserById(item.CreateBy),
                        item.Code,
                        item.StoreFrontTransferOutDtl.Where(w => w.Enable == true).ToList().Count(),
                        Library.ConvertDecimalToStringForm(item.TotalQtyUnit),
                        Library.ConvertDecimalToStringForm(item.TotalBalance),
                        status,
                        item.Branch.Name + " " + item.Branch.BranchNo,
                        item.Remark
                        );
                    total += item.TotalBalance;
                }
                textBoxQtyList.Text      = list.Count() + "";
                textBoxTotalBalance.Text = Library.ConvertDecimalToStringForm(total);
            }
        }
        private void SaveCommit()
        {
            using (SSLsEntities db = new SSLsEntities())
            {
                string username = Singleton.SingletonAuthen.Instance().Id;
                var    data     = db.Users.SingleOrDefault(w => w.Id == username);

                data.UpdateBy        = Singleton.SingletonAuthen.Instance().Id;
                data.UpdateDate      = DateTime.Now;
                data.Name            = textBoxFullName.Text;
                data.Description     = textBoxDesc.Text;
                db.Entry(data).State = EntityState.Modified;
                db.SaveChanges();
                this.Dispose();
            }
        }
 private void PopupProductBaseForm_Load(object sender, EventArgs e)
 {
     using (SSLsEntities db = new SSLsEntities())
     {
         var prod        = db.ProductDetails.SingleOrDefault(w => w.Id == idProDtl);
         var prodDtlList = db.ProductDetails.Where(w => w.FKProduct == prod.FKProduct && w.Enable == true);
         foreach (var item in prodDtlList)
         {
             dataGridView1.Rows.Add(item.Id,
                                    item.Code,
                                    item.PackSize,
                                    item.ProductUnit.Name,
                                    Library.ConvertDecimalToStringForm(item.CostOnly));
         }
     }
 }
Example #11
0
        private void WmsTransferBranchForm_Load(object sender, EventArgs e)
        {
            string code = "";

            using (SSLsEntities db = new SSLsEntities())
            {
                int        currentYear  = DateTime.Now.Year;
                int        currentMonth = DateTime.Now.Month;
                var        wto          = db.WmsTransferOut.Where(w => w.CreateDate.Year == currentYear && w.CreateDate.Month == currentMonth).Count() + 1;
                BudgetYear budget       = Singleton.SingletonThisBudgetYear.Instance().ThisYear;
                //Branch branch = Singleton.SingletonP
                code               = MyConstant.PrefixForGenerateCode.WmsTransferOut + "" + budget.CodeYear + DateTime.Now.ToString("MM") + Library.GenerateCodeFormCount(wto, 4);
                textBoxCode.Text   = code;
                textBoxTODate.Text = Library.ConvertDateToThaiDate(DateTime.Now);
            }
        }
        private void WastManageDetailForm_Load(object sender, EventArgs e)
        {
            using (SSLsEntities db = new SSLsEntities())
            {
                var data = db.StoreFrontTransferWasteDtl.Where(w => w.Enable == true && w.FKStoreFrontTransferWaste == code).ToList();

                foreach (var item in data)
                {
                    dataGridView1.Rows.Add(item.Id, item.ProductDetails.Code,
                                           item.ProductDetails.Products.ThaiName, item.ProductDetails.PackSize,
                                           item.Qty, Library.ConvertDecimalToStringForm(item.CostPerUnit), item.Description);
                }
                textBox1.Text = code;
                textBox2.Text = Library.ConvertDateToThaiDate(data.FirstOrDefault().CreateDate);
            }
        }
        private void SendAutoMapper(POHeader item)
        {
            using (SSLsEntities db = new SSLsEntities())
            {
                POHeader po = new POHeader();

                po.ApproveBy       = null;
                po.ApproveDate     = null;
                po.UnApproveDate   = null;
                po.UpApproveBy     = null;
                po.UpApproveRemark = null;
                po.Enable          = true;
                db.POHeader.Add(po);
                db.SaveChanges();
            }
        }
Example #14
0
        private void GoodsAutoReturnWmsForm_Load(object sender, EventArgs e)
        {
            textBoxDate.Text = Library.ConvertDateToThaiDate(DateTime.Now);
            string code = "";

            using (SSLsEntities db = new SSLsEntities())
            {
                int        currentYear  = DateTime.Now.Year;
                int        currentMonth = DateTime.Now.Month;
                var        cnw          = db.CNWarehouse.Where(w => w.CreateDate.Year == currentYear && w.CreateDate.Month == currentMonth).Count() + 1;
                BudgetYear budget       = Singleton.SingletonThisBudgetYear.Instance().ThisYear;
                //Branch branch = Singleton.SingletonP
                code             = MyConstant.PrefixForGenerateCode.GoodsReturnCN + "" + budget.CodeYear + DateTime.Now.ToString("MM") + Library.GenerateCodeFormCount(cnw, 4);
                textBoxCode.Text = code;
            }
        }
        /// <summary>
        /// ปริ้นออเดอร์
        /// </summary>
        /// <param name="codeSelected"></param>
        private void PrintOrderOrder(IEnumerable<string> codeSelected)
        {

            using (SSLsEntities db = new SSLsEntities())
            {
                List<string> invs = new List<string>();
                foreach (var item in codeSelected)
                {
                    var data = db.SaleOrderWarehouse.FirstOrDefault(w => w.Enable == true && w.Code == item);
                    invs.Add(data.InvoiceNo);
                }
                _Inv = invs;
            }

            Thread print = new Thread(ThreadPrint);
            print.Start();
        }
 private void CancelOrder(IEnumerable<string> stackDocNo)
 {
     using (SSLsEntities db = new SSLsEntities())
     {
         foreach (var item in stackDocNo)
         {
             var order = db.SaleOrderWarehouse.SingleOrDefault(w => w.Code == item);
             order.UpdateDate = DateTime.Now;
             order.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
             order.Enable = false;
             order.FKSaleOrderWarehouseStatus = MyConstant.SaleOrderWarehouseStatus.CancelOrder;
             db.Entry(order).State = EntityState.Modified;
         }
         db.SaveChanges();
         LoadGrid();
     }
 }
 void AddStockHD(int id)
 {
     using (SSLsEntities db = new SSLsEntities())
     {
         StoreFrontStock hd = new StoreFrontStock();
         hd.Description = "-";
         hd.CreateDate  = DateTime.Now;
         hd.CreateBy    = Singleton.SingletonAuthen.Instance().Id;
         hd.UpdateDate  = DateTime.Now;
         hd.UpdateBy    = Singleton.SingletonAuthen.Instance().Id;
         hd.Enable      = true;
         hd.CurrentQty  = 0;
         hd.FKProduct   = id;
         db.StoreFrontStock.Add(hd);
         db.SaveChanges();
     }
 }
        /// <summary>
        /// product id dtl
        /// </summary>
        /// <param name="id"></param>
        public void BinddingProductDtChoose(int id)
        {
            using (SSLsEntities db = new SSLsEntities())
            {
                var getNewProduct = db.ProductDetails.SingleOrDefault(w => w.Id == id);
                int row           = dataGridView1.CurrentRow.Index;
                //int idpo = int.Parse(dataGridView1.Rows[row].Cells[colIdPo].Value.ToString());
                //int idProd = int.Parse(dataGridView1.Rows[row].Cells[colIdProd].Value.ToString());
                dataGridView1.Rows[row].Cells[colIdProd].Value = id;
                //int number = int.Parse(dataGridView1.Rows[row].Cells[colNumber].Value.ToString());
                //string code = dataGridView1.Rows[row].Cells[colCode].Value.ToString();
                dataGridView1.Rows[row].Cells[colCode].Value = getNewProduct.Code;
                decimal pz               = decimal.Parse(dataGridView1.Rows[row].Cells[colPz].Value.ToString());
                decimal rcvComplete      = decimal.Parse(dataGridView1.Rows[row].Cells[colRcvComplete].Value.ToString());
                decimal pieceRcvComplete = rcvComplete * pz;
                dataGridView1.Rows[row].Cells[colRcvComplete].Value = Library.ConvertDecimalToStringForm(pieceRcvComplete / getNewProduct.PackSize);

                decimal qty   = decimal.Parse(dataGridView1.Rows[row].Cells[colQty].Value.ToString());
                decimal piece = qty * pz;

                dataGridView1.Rows[row].Cells[colPz].Value = getNewProduct.PackSize;
                //string unit = dataGridView1.Rows[row].Cells[colUnit].Value.ToString();
                dataGridView1.Rows[row].Cells[colUnit].Value = getNewProduct.ProductUnit.Name;

                dataGridView1.Rows[row].Cells[colQty].Value = Library.ConvertDecimalToStringForm(piece / getNewProduct.PackSize);

                decimal gift = decimal.Parse(dataGridView1.Rows[row].Cells[colGift].Value.ToString());

                dataGridView1.Rows[row].Cells[colGift].Value = Library.ConvertDecimalToStringForm((gift * pz) / getNewProduct.PackSize);

                decimal rcvQty = decimal.Parse(dataGridView1.Rows[row].Cells[colRcvQty].Value.ToString());
                dataGridView1.Rows[row].Cells[colRcvQty].Value = Library.ConvertDecimalToStringForm(0);

                decimal rcvGift = decimal.Parse(dataGridView1.Rows[row].Cells[colRcvGift].Value.ToString());
                dataGridView1.Rows[row].Cells[colRcvGift].Value = Library.ConvertDecimalToStringForm(0);

                //decimal price = decimal.Parse(dataGridView1.Rows[row].Cells[colPrice].Value.ToString());
                dataGridView1.Rows[row].Cells[colPrice].Value = Library.ConvertDecimalToStringForm(0);

                //decimal total = decimal.Parse(dataGridView1.Rows[row].Cells[colTotal].Value.ToString());
                qty = decimal.Parse(dataGridView1.Rows[row].Cells[colQty].Value.ToString());
                dataGridView1.Rows[row].Cells[colTotal].Value = Library.ConvertDecimalToStringForm(0);

                int poDtlId = int.Parse(dataGridView1.Rows[row].Cells[colPODtlId].Value.ToString());
            }
        }
        /// <summary>
        /// ปุ่มค้นหา
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button3_Click(object sender, EventArgs e)
        {
            using (SSLsEntities db = new SSLsEntities())
            {
                dataGridView1.Rows.Clear();
                dataGridView1.Refresh();
                DateTime dateS       = dateTimePickerStart.Value;
                DateTime dateE       = dateTimePickerEnd.Value;
                bool     checkNotRcv = checkBoxNotRcv.Checked;
                bool     checkRcv    = checkBoxRcv.Checked;
                //var data = _poList.Where(w =>
                //DbFunctions.TruncateTime(w.CreateDate) >= DbFunctions.TruncateTime(dateS) &&
                //DbFunctions.TruncateTime(w.CreateDate) <= DbFunctions.TruncateTime(dateE)
                //).ToList();
                var data = _poList.Where(w =>
                                         int.Parse(w.CreateDate.ToString("yyyyMMdd")) >= int.Parse(dateS.ToString("yyyyMMdd")) &&
                                         int.Parse(w.CreateDate.ToString("yyyyMMdd")) <= int.Parse(dateE.ToString("yyyyMMdd"))
                                         ).ToList();
                if (checkNotRcv == true && checkRcv == true)
                {
                }
                else if (checkNotRcv == true && checkRcv == false) // เอาเฉพาะ ไม่เคยรับเข้า
                {
                    data = data.Where(w => w.FKPOStatus == MyConstant.POStatus.NotRCV).ToList();
                }
                else if (checkNotRcv == false && checkRcv == true) // เอาเฉพาะ เคยรับเข้าแล้ว
                {
                    data = data.Where(w => w.FKPOStatus == MyConstant.POStatus.RCVNotEnd).ToList();
                }
                else
                {
                    //data = data.Where(w => w.FKPOStatus == MyConstant.POStatus.RCVNotEnd).ToList();
                    MessageBox.Show("เงื่อนไขค้นหาไม่ถูกต้อง");
                    return;
                }
                foreach (var item in data)
                {
                    // จำนวนหน่วยทั้งหมดของ PO ไม่นับของแถม
                    decimal getQtyInPO    = item.PODetail.Where(w => w.Enable == true).ToList().Sum(w => (w.Qty + w.GiftQty));
                    decimal getRcvQtyInPO = item.PODetail.Where(w => w.Enable == true).ToList().Sum(w => (w.RcvQty + w.RcvGiftQty));

                    decimal percent = Library.GetPercentFromValue(getRcvQtyInPO, getQtyInPO);
                    dataGridView1.Rows.Add(item.Id, Library.ConvertDateToThaiDate(item.CreateDate), item.PONo, Library.ConvertDateToThaiDate(item.POExpire), item.POStatus.Name, item.Vendor.Name, Library.ConvertDecimalToStringForm(percent) + " %");
                }
            }
        }
        public static List <string> GetAllDocId(string Code_S, string Code_E)
        {
            using (SSLsEntities db = new SSLsEntities())
            {
                List <string> fkProHd = new List <string>();
                try
                {
                    var allDoc = db.StoreFrontValueDoc.Where(w => w.Enable == true).OrderBy(w => w.DocNo);

                    if (Code_S == "")
                    {
                        fkProHd.AddRange(allDoc.Select(w => w.DocNo).Distinct().ToList <string>());
                        return(fkProHd);
                    }
                    else if (Code_S == Code_E)
                    {
                        fkProHd.Add(Code_S);
                        return(fkProHd);
                    }
                    bool found = false;
                    foreach (var item in allDoc)
                    {
                        if (found == true && item.DocNo != Code_E)
                        {
                            fkProHd.Add(item.DocNo);
                        }
                        else if (item.DocNo == Code_S)
                        {
                            found = true;
                            fkProHd.Add(item.DocNo);
                        }
                        else if (item.DocNo == Code_E)
                        {
                            fkProHd.Add(item.DocNo);
                            break;
                        }
                    }
                    return(fkProHd.Distinct().ToList <string>());;
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.ToString());
                    return(fkProHd);
                }
            }
        }
        private void Reload()
        {
            dataGridView1.Rows.Clear();
            dataGridView1.Refresh();
            dataGridView2.Rows.Clear();
            dataGridView2.Refresh();
            using (SSLsEntities db = new SSLsEntities())
            {
                var data    = db.PriceSchedule.SingleOrDefault(w => w.Id == id);
                var selling = data.SellingPrice.Where(w => w.Enable == true).ToList();
                foreach (var item in selling)
                {
                    dataGridView1.Rows.Add(item.Id, item.ProductDetails.Code, item.ProductDetails.Products.ThaiName, item.ProductDetails.ProductUnit.Name, Library.ConvertDecimalToStringForm(item.ProductDetails.SellPrice), item.Description);
                }
                textBoxProAmount.Text = Library.ConvertDecimalToStringForm(data.FullQty);
                foreach (SellingPriceDetails item in data.SellingPrice.FirstOrDefault().SellingPriceDetails.Where(w => w.Enable == true).ToList())
                {
                    dataGridView2.Rows.Add(item.Id, item.ProductDetails.Code, item.ProductDetails.Products.ThaiName, item.ProductDetails.ProductUnit.Name, Library.ConvertDecimalToStringForm(item.ProductDetails.SellPrice), Library.ConvertDecimalToStringForm(item.SpecialPrice), item.Description, item.FKProduct);
                }
                /// check หมดเขต หรือ disable
                if (data.Enable == false)
                {
                    // ยกเลิกแล้ว
                    button3.Enabled = false;
                    label1.Text     = "* ยกเลิกแล้ว";
                    label1.Visible  = true;

                    button2.Enabled = false;
                    label2.Text     = "* ยกเลิกแล้ว";
                    label2.Visible  = true;
                }
                else if (data.IsStop == true)
                {
                    // หมดเขตแล้ว
                    button3.Enabled = false;
                    label1.Text     = "* หมดเขตแล้ว";
                    label1.Visible  = true;

                    button2.Enabled = false;
                    label2.Text     = "* หมดเขตแล้ว";
                    label2.Visible  = true;
                }
            }
            RowColor();
            RowColor(2);
        }
Example #22
0
        /// <summary>
        /// ยอดยกไป
        /// </summary>
        /// <param name="fkProHD"></param>
        /// <param name="startdDate"></param>
        /// <param name="endDate"></param>
        /// <returns></returns>
        public decimal GetBalance(int fkProHD, DateTime startdDate, DateTime endDate)
        {
            decimal resultForProDtl = GetResult(fkProHD, startdDate);

            try
            {
                using (SSLsEntities db = new SSLsEntities())
                {
                    List <StoreFrontStockDetails> details = db.StoreFrontStock.FirstOrDefault(w => w.FKProduct == fkProHD && w.Enable == true)
                                                            .StoreFrontStockDetails.Where(w => w.Enable == true &&
                                                                                          int.Parse(w.CreateDate.ToString("yyyyMMdd")) >= int.Parse(startdDate.ToString("yyyyMMdd")) &&
                                                                                          int.Parse(w.CreateDate.ToString("yyyyMMdd")) <= int.Parse(endDate.ToString("yyyyMMdd"))
                                                                                          ).OrderBy(w => w.CreateDate).ToList();

                    if (details.Count() == 0)
                    {
                        return(0);
                    }
                    else
                    {
                        foreach (var trans in details)
                        {
                            decimal plus  = 0;
                            decimal minus = 0;

                            if (trans.TransactionType.IsPlus == true)
                            {
                                plus            = trans.ActionQty;
                                resultForProDtl = resultForProDtl + plus;
                            }
                            else
                            {
                                minus           = trans.ActionQty;
                                resultForProDtl = resultForProDtl - minus;
                            }
                        }
                    }
                    return(resultForProDtl);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "แจ้งเตือนจากระบบ!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                throw;
            }
        }
Example #23
0
        private void button2_Click(object sender, EventArgs e)
        {
            using (SSLsEntities db = new SSLsEntities())
            {
                if (_Id == 0)
                {
                    // add new
                    ProductGroups obj = new ProductGroups();
                    obj.Code        = textBoxCode.Text;
                    obj.Name        = textBoxName.Text;
                    obj.Description = textBoxDesc.Text;
                    obj.CreateDate  = DateTime.Now;
                    obj.CreateBy    = Singleton.SingletonAuthen.Instance().Id;
                    obj.Enable      = true;
                    obj.UpdateBy    = Singleton.SingletonAuthen.Instance().Id;
                    obj.UpdateDate  = DateTime.Now;
                    db.ProductGroups.Add(obj);
                }
                else
                {
                    // edit
                    var obj = db.ProductGroups.SingleOrDefault(w => w.Id == _Id);
                    obj.UpdateDate  = DateTime.Now;
                    obj.UpdateBy    = Singleton.SingletonAuthen.Instance().Id;
                    obj.Code        = textBoxCode.Text;
                    obj.Name        = textBoxName.Text;
                    obj.Description = textBoxDesc.Text;
                    if (radioButton1.Checked)
                    {
                        obj.Enable = true;
                    }
                    else
                    {
                        obj.Enable = false;
                    }
                    db.Entry(obj).State = EntityState.Modified;
                }
                db.SaveChanges();
                Singleton.SingletonPriority1.SetInstance();
                //Singleton.SingletonPriority1.Instance();

                dataGrid();
                //this.Dispose();
                //_Id = 0;
            }
        }
        /// <summary>
        /// ค้นหาทั้งหมด
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button4_Click(object sender, EventArgs e)
        {
            dataGridView1.Rows.Clear();
            dataGridView1.Refresh();

            /// Get สินค้าห้องของเสีย
            IEnumerable <int> allProductInVendor = Singleton.SingletonProduct.Instance().Products.Where(w => w.Enable == true).Select(w => w.Id).Distinct().ToList <int>();

            using (SSLsEntities db = new SSLsEntities())
            {
                var waste = db.WasteWarehouse.Where(w => w.Enable == true && allProductInVendor.Contains(w.FKProduct) && w.QtyUnit > 0).ToList();
                /// ตรวจพบสินค้า vendor ในห้องของเสีย
                foreach (var item in waste)
                {
                    IEnumerable <int> fkProductDtls = item.WasteWarehouseDetails.Where(w => w.Enable == true && w.LastResultUnit > 0).Select(w => w.FKProductDetails).Distinct().ToList <int>();
                    /// Bindding Data Grid
                    foreach (var last in fkProductDtls)
                    {
                        var getLast = item.WasteWarehouseDetails.Where(w => w.Enable == true && w.FKProductDetails == last).OrderByDescending(w => w.CreateDate).FirstOrDefault();
                        // get ค่าจากใบทำคืนที่ ยังไม่คอนเฟิม
                        decimal qtyCNNotComplete = 0;
                        var     cnData           = db.CNWarehouseDetails.Where(w => w.Enable == true && w.FKProductDetails == getLast.FKProductDetails && w.CNWarehouse.ConfirmCNDate == null && w.CNWarehouse.Enable == true).ToList();
                        if (cnData != null)
                        {
                            qtyCNNotComplete = cnData.Sum(w => w.Qty);
                        }
                        /// from ห้องของเสีย
                        dataGridView1.Rows.Add
                        (
                            getLast.FKProductDetails,
                            getLast.ProductDetails.Code,
                            getLast.ProductDetails.Products.ThaiName,
                            getLast.ProductDetails.ProductUnit.Name,
                            Library.ConvertDecimalToStringForm(getLast.LastResultUnit),
                            Library.ConvertDecimalToStringForm(qtyCNNotComplete),// ยอดที่รอการคอนเฟิม หลังจากส่งคืน
                            getLast.Packsize,
                            Library.ConvertDecimalToStringForm(getLast.ProductDetails.CostOnly),
                            Library.ConvertDecimalToStringForm(getLast.ProductDetails.CostOnly * getLast.QtyUnit),
                            "-"
                        );
                    }
                }
                TotalSummary();
            }
        }
        /// <summary>
        /// คำนวน Order ใหม่
        /// </summary>
        /// <param name="code"></param>
        private void Recal(string code)
        {
            using (SSLsEntities db = new SSLsEntities())
            {
                var data = db.SaleOrderWarehouse.SingleOrDefault(w => w.Code == code);
                decimal totalHasVat = 0; // ยอดสินค้ามีภาษี
                decimal totalUnVat = 0; // ยอดสินค้ายกเว้นภาษี
                decimal totalDisInList = 0;
                foreach (var item in data.SaleOrderWarehouseDtl.Where(w => w.Enable == true).ToList())
                {
                    if (item.QtyAllow < item.Qty)
                    {
                        // ได้ยอดไม่ตามเป้า
                        item.QtyOriginal = item.Qty;
                        item.Qty = item.QtyAllow;
                        // clear ส่วนลด
                        item.PercentDiscount = 0;
                        item.BathDiscount = 0;
                        item.TotalPrice = item.QtyAllow * item.PricePerUnit;
                        db.Entry(item).State = EntityState.Modified;

                    }
                    if (item.ProductDetails.Products.ProductVatType.Id == MyConstant.ProductVatType.HasVat)
                    {
                        totalHasVat += item.TotalPrice;
                    }
                    else
                    {
                        totalUnVat += item.TotalPrice;
                    }
                    totalDisInList += item.BathDiscount;

                }
                decimal total = totalHasVat + totalUnVat; // ยอดรวมก่อนหักลด
                decimal totalBalance = total - data.TotalDiscount;

                data.TotalVat = totalHasVat * MyConstant.MyVat.Vat / MyConstant.MyVat.VatRemove;
                data.TotaNoVat = totalUnVat;
                data.TotalBeforeVat = totalHasVat - data.TotalVat;
                data.Total = total;
                data.TotalDiscountInList = totalDisInList;
                data.TotalBalance = totalBalance;
                db.SaveChanges();
            }
        }
Example #26
0
        private void ReportStockCard_Load(object sender, EventArgs e)
        {
            button3.Enabled         = false;
            button4.Enabled         = false;
            checkBoxProduct.Checked = true;
            lb_msg.Visible          = false;

            var getPdtl = Singleton.SingletonProduct.Instance().ProductDetails.Where(w => w.Enable == true).ToList();
            AutoCompleteStringCollection colPdtl = new AutoCompleteStringCollection();

            foreach (var item in getPdtl)
            {
                colPdtl.Add(item.Code);
            }
            textBox1.AutoCompleteCustomSource = colPdtl;

            var getPdg = Singleton.SingletonProduct.Instance().ProductDetails.Where(w => w.Enable == true).ToList();
            AutoCompleteStringCollection colPdg = new AutoCompleteStringCollection();

            foreach (var item in getPdg)
            {
                colPdg.Add(item.Code);
            }
            textBox2.AutoCompleteCustomSource = colPdg;

            SSLsEntities db    = new SSLsEntities();
            var          combo = db.ProductGroups.Where(w => w.Enable == true).Select(s => new { s.Id, s.Name }).OrderBy(o => o.Id).ToList();

            DataTable dt_summary  = new DataTable();
            DataTable dt_summary2 = new DataTable();

            dt_summary  = CodeFileDLL.ConvertToDataTable(combo);
            dt_summary2 = CodeFileDLL.ConvertToDataTable(combo);
            dt_summary.Rows.Add(0, "ทั้งหมด");
            comboBox1.DataSource    = dt_summary;
            comboBox1.DisplayMember = "Name";
            comboBox1.ValueMember   = "Id";
            comboBox1.SelectedIndex = dt_summary.Rows.Count - 1;

            dt_summary2.Rows.Add(0, "ทั้งหมด");
            comboBox2.DataSource    = dt_summary2;
            comboBox2.DisplayMember = "Name";
            comboBox2.ValueMember   = "Id";
            comboBox2.SelectedIndex = dt_summary2.Rows.Count - 1;
        }
 /// <summary>
 /// ตรวจสอบ Promotion หยุดทำงาน
 /// </summary>
 private void CheckPromorionstop()
 {
     using (SSLsEntities db = new SSLsEntities())
     {
         var      dateQuery  = db.Database.SqlQuery <DateTime>("SELECT getdate()");
         DateTime serverDate = dateQuery.AsEnumerable().First();
         var      dateCheck  = db.PriceScheduleCheck.FirstOrDefault(w => DbFunctions.TruncateTime(w.DateCheck) == DbFunctions.TruncateTime(serverDate));
         if (dateCheck.IsCheck == false)
         {
             // ถ้าวันนี้ ยังไม่เชค ก็เชค
             dateCheck.IsCheck         = true;
             dateCheck.CheckDate       = serverDate;
             dateCheck.CheckBy         = SingletonAuthen.Instance().Id;
             db.Entry(dateCheck).State = EntityState.Modified;
             var priceSchedule = db.PriceSchedule.Where(w => w.Enable == true && w.IsStop == false);
             foreach (var item in priceSchedule)
             {
                 if (serverDate > item.EndDate)
                 {
                     // ถ้าวันนี้ มากกว่า วันสิ้นสุด
                     // โปรโมชั่น ควร Stop ลง
                     item.IsStop          = true;
                     item.StopReason      = "Stop By Code";
                     item.UpdateDate      = DateTime.Now;
                     item.UpdateBy        = SingletonAuthen.Instance().Id;
                     db.Entry(item).State = EntityState.Modified;
                 }
             }
             db.SaveChanges();
         }
         else
         {
             // ถ้าวันนี้ เชคแล้ว ปล่อยผ่าน
         }
         //int days = 1000;
         //for (int i = 0; i < days; i++)
         //{
         //    PriceScheduleCheck f = new PriceScheduleCheck();
         //    f.DateCheck = DateTime.Now.AddDays(i + 1);
         //    f.IsCheck = false;
         //    db.PriceScheduleCheck.Add(f);
         //}
         //db.SaveChanges();
     }
 }
Example #28
0
 private List <ยกมาของเสย> Getยกมา()
 {
     using (SSLsEntities db = new SSLsEntities())
     {
         string date  = dateTimePickerStart.Value.ToString("yyyyMMdd");
         string query = @"SELECT        TOP (100) PERCENT wms.WasteWarehouseDetails.CreateDate, CONVERT(varchar, wms.WasteWarehouseDetails.CreateDate, 112) AS DateStr, wms.WasteWarehouseDetails.CreateBy, wms.ProductDetails.FKProduct, 
                  wms.WasteWarehouseDetails.FKProductDetails, wms.WasteWarehouseDetails.QtyPiece, wms.WasteWarehouseDetails.IsInOrOut, wms.Products.FKVender
                 FROM            wms.WasteWarehouseDetails INNER JOIN
                                             wms.ProductDetails ON wms.WasteWarehouseDetails.FKProductDetails = wms.ProductDetails.Id INNER JOIN
                                             wms.Products ON wms.ProductDetails.FKProduct = wms.Products.Id
                 WHERE        (wms.WasteWarehouseDetails.Enable = 1) AND (wms.ProductDetails.Enable = 1) AND (CONVERT(varchar, wms.WasteWarehouseDetails.CreateDate, 112) < '{0}') AND (wms.Products.Enable = 1) AND 
                                             (wms.Products.FKVender = {1})
                 ORDER BY wms.WasteWarehouseDetails.CreateDate DESC";
         String s     = String.Format(query, date, _VId);
         var    data  = db.Database.ExecuteEntities <ยกมาของเสย>(s).ToList();
         return(data);
     }
 }
        private void POListNotCompleteForm_Load(object sender, EventArgs e)
        {
            _poList = new List <POHeader>();
            using (SSLsEntities db = new SSLsEntities())
            {
                _poList = db.POHeader.Include("PaymentType").Include("POStatus").Include("PODetail.ProductDetails.Products").Include("PODetail.ProductDetails.ProductUnit").Include("Vendor.POCostType").Include("PORcv.PORcvDetails").Include("PORcv.PORcvDetails")
                          .Where(w => w.Enable == true && w.ApproveDate != null && (w.FKPOStatus == MyConstant.POStatus.NotRCV || w.FKPOStatus == MyConstant.POStatus.RCVNotEnd)).ToList();
            }
            foreach (var item in _poList)
            {
                // จำนวนหน่วยทั้งหมดของ PO ไม่นับของแถม
                decimal getQtyInPO    = item.PODetail.Where(w => w.Enable == true).ToList().Sum(w => (w.Qty + w.GiftQty));
                decimal getRcvQtyInPO = item.PODetail.Where(w => w.Enable == true).ToList().Sum(w => (w.RcvQty + w.RcvGiftQty));

                decimal percent = Library.GetPercentFromValue(getRcvQtyInPO, getQtyInPO);
                dataGridView1.Rows.Add(item.Id, Library.ConvertDateToThaiDate(item.CreateDate), item.PONo, Library.ConvertDateToThaiDate(item.POExpire), item.POStatus.Name, item.Vendor.Name, Library.ConvertDecimalToStringForm(percent) + " %");
            }
        }
        private void PrintConfirm()
        {
            int seq = int.Parse(textBoxKeyValue.Text.Trim());

            if (seq > v)
            {
                MessageBox.Show("ไม่ถูกต้อง");
            }
            else
            {
                using (SSLsEntities db = new SSLsEntities())
                {
                    var data            = db.POHeader.SingleOrDefault(w => w.SequenceEdit == seq && w.PONo == _code);
                    MainReportViewer mr = new MainReportViewer(data.Id);
                    mr.ShowDialog();
                }
            }
        }