private void Saveclick() { if (MessageBox.Show("ต้องการสร้าง List สำหรับเช็ค Stock ?", "สร้าง List", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { using (DataClasses1DataContext db = new DataClasses1DataContext()) { tb_CheckStock cl = db.tb_CheckStocks.Where(c => !c.Status.Equals("Completed")).FirstOrDefault(); if (cl != null) { MessageBox.Show("เลขเช็คสต๊อค เก่ายังไม่ได้ ปิดสถานะ!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { tb_CheckStock list1 = new tb_CheckStock(); list1.CheckNo = dbClss.GetSeriesNo(1, 2); list1.CreateBy = dbClss.UserID; list1.CheckDate = DateTime.Now; list1.Status = "Waiting Upload"; db.tb_CheckStocks.InsertOnSubmit(list1); db.SubmitChanges(); LoadDefault(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void radButtonElement4_Click(object sender, EventArgs e) { try { if (row >= 0) { if (MessageBox.Show("คุณต้องการ [Finish] หรือไม่ ?", "Finish รายการ", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { string ckNo = dgvData.Rows[row].Cells["CheckNo"].Value.ToString(); using (DataClasses1DataContext db = new DataClasses1DataContext()) { tb_CheckStock ck = db.tb_CheckStocks.Where(t => t.CheckNo == ckNo && t.Status == "Waiting Check").FirstOrDefault(); if (ck != null) { ck.Status = "Completed"; db.SubmitChanges(); db.sp_E_004_CompletedStock(ckNo); MessageBox.Show("Update Completed."); LoadDefault(); } else { MessageBox.Show("เลขที่เอกสารนี้ ไม่สามารถลบได้!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } } } catch { } }
private bool DeleteUnit() { bool ck = false; this.Cursor = Cursors.WaitCursor; int C = 0; try { if (row >= 0) { string CheckNo = Convert.ToString(dgvData.Rows[row].Cells["CheckNo"].Value); // string CodeTemp = Convert.ToString(radGridView1.Rows[row].Cells["dgvCodeTemp"].Value); dgvData.EndEdit(); if (MessageBox.Show("ต้องการลบรายการ ( " + CheckNo + " ) หรือไม่ ?", "ลบรายการ", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { using (DataClasses1DataContext db = new DataClasses1DataContext()) { tb_CheckStock cd = db.tb_CheckStocks.Where(c => c.CheckNo == CheckNo && !c.Status.Equals("Completed")).FirstOrDefault(); if (cd != null) { db.tb_CheckStocks.DeleteOnSubmit(cd); var DeleteStockList = db.tb_CheckStockLists.Where(s => s.CheckNo == CheckNo).ToList(); // db.tb_CheckStockLists.DeleteAllOnSubmit(DeleteStockList); foreach (var rd in DeleteStockList) { db.tb_CheckStockLists.DeleteOnSubmit(rd); //db.SubmitChanges(); } db.SubmitChanges(); C = 1; dbClss.AddHistory(this.Name, "ลบรายการ", "Delete Check No [" + CheckNo + "]", ""); } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); dbClss.AddError("DeleteUnit", ex.Message, this.Name); } if (C > 0) { row = row - 1; MessageBox.Show("ลบรายการ สำเร็จ!"); } this.Cursor = Cursors.Default; return(ck); }
private void btnExport_Click(object sender, EventArgs e) { //Upload try { // tb_CheckStockList <= Insert to this table //Update Status tb_CheckStock to "Waiting Check" //สามารถอัพโหลดใหม่ได้ โดยการ ให้ลบ ข้อมูลเก่าทั้งหมดออกก่อน // string DKUBU, ItemCode, ItemDescription, Type //, Revision, ExclusionClass, StorageWorkCenter, StorageWorkCenterName //, CurrentInventory, InventoryValue, StockBeforeInventory, PhysicalInventoryValue //, UnitOfMeasure = ""; int C = 0; this.Cursor = Cursors.WaitCursor; using (DataClasses1DataContext db = new DataClasses1DataContext()) { tb_CheckStock tc = db.tb_CheckStocks.Where(c => c.CheckNo == txtCheckNo.Text && c.Status != "Completed").FirstOrDefault(); if (tc != null) { progressBar1.Minimum = 0; progressBar1.Maximum = dt_d.Rows.Count + 1; progressBar1.Visible = true; progressBar1.Step = 1; var Dl = db.tb_CheckStockLists.Where(w => w.CheckNo == txtCheckNo.Text).ToList(); db.tb_CheckStockLists.DeleteAllOnSubmit(Dl); db.SubmitChanges(); foreach (DataRow dr in dt_d.Rows) { //DKUBU = ""; ItemCode = ""; ItemDescription = ""; Type = ""; //Revision = ""; ExclusionClass = ""; StorageWorkCenter = ""; StorageWorkCenterName = ""; //CurrentInventory = ""; InventoryValue = ""; StockBeforeInventory = ""; PhysicalInventoryValue = ""; //UnitOfMeasure = ""; //d = dr["DATE"].ToString(); if (dbClss.TSt(dr["StorageWorkCenter"]).Equals("WH01")) { //tb_CheckStockList ck = db.tb_CheckStockLists.Where(cp => cp.CheckNo == txtCheckNo.Text).FirstOrDefault(); //if (ck != null) //{ //} //else //{ tb_CheckStockList u = new tb_CheckStockList(); u.CheckNo = txtCheckNo.Text.Trim(); u.Status = "Waiting"; u.Code = dbClss.TSt(dr["ItemCode"]); u.PartName = dbClss.TSt(dr["ItemDescription"]); u.Type = dbClss.TSt(dr["Type"]); u.Location = dbClss.TSt(dr["StorageWorkCenter"]); u.Revision = dbClss.TInt(dr["Revision"]); u.ExclusionClass = dbClss.TInt(dr["ExclusionClass"]); u.StorageWorkCenter = dbClss.TSt(dr["StorageWorkCenter"]); u.StorageWorkCenterName = dbClss.TSt(dr["StorageWorkCenterName"]); u.CurrentInventory = dbClss.TDe(dr["CurrentInventory"]); u.InventoryValue = dbClss.TDe(dr["InventoryValue"]); u.StockBeforeInventory = dbClss.TDe(dr["StockBeforeInventory"]); u.PhysicalInventoryValue = 0; //dbClss.TDe(dr["PhysicalInventoryValue"]); u.UnitOfMeasure = dbClss.TSt(dr["UnitOfMeasure"]); u.Quantity = dbClss.TDe(dr["CurrentInventory"]); u.Plant = db.getPlanTIDTPICS(dbClss.TSt(dr["ItemCode"])); u.InputQty = 0; u.Remark = ""; u.Diff = 0; db.tb_CheckStockLists.InsertOnSubmit(u); db.SubmitChanges(); //} C += 1; } progressBar1.Value = C; progressBar1.PerformStep(); } if (C > 0) { var h = (from ix in db.tb_CheckStocks where ix.CheckNo == txtCheckNo.Text.Trim() select ix).ToList(); if (h.Count > 0) { var hh = (from ix in db.tb_CheckStocks where ix.CheckNo == txtCheckNo.Text.Trim() select ix).First(); //unit1.Status = ""; hh.CheckDate = Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US")); hh.CreateBy = dbClss.UserID; hh.Status = "Waiting Check"; db.SubmitChanges(); dbClss.AddHistory(this.Name, "แก้ไข", "Import CheckStock [" + hh.CheckNo + "]", ""); } MessageBox.Show("Import data Complete."); } else { MessageBox.Show("ไม่พบข้อมูล!"); } //radProgressBarElement1.Visibility = Telerik.WinControls.ElementVisibility.Collapsed; } else { MessageBox.Show("เอกสารเสร็จสิ้นแล้ว แก้ไขไฟล์ไม่ได้!"); } } lblSS.Visible = false; txtFileName.Text = ""; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { this.Cursor = Cursors.Default; } }
private void Caculate() { try { this.Cursor = Cursors.WaitCursor; using (DataClasses1DataContext db = new DataClasses1DataContext()) { // db.sp_E_003_Calculate(txtCheckNo.Text); tb_CheckStock chk = db.tb_CheckStocks.Where(t => t.CheckNo == txtCheckNo.Text && !t.Status.Equals("Completed")).FirstOrDefault(); if (chk != null) { var Listx = db.tb_CheckStockPDALists.Where(p => p.CheckNo == txtCheckNo.Text).ToList(); if (Listx.Count > 0) { int SNP = 0; decimal Qty = 0; foreach (var rd in Listx) { tb_CheckStockTempCheck tc = db.tb_CheckStockTempChecks.Where(t => t.CheckNo == txtCheckNo.Text && t.PKTAG == rd.PKTAG).FirstOrDefault(); if (tc != null) { db.tb_CheckStockTempChecks.DeleteOnSubmit(tc); db.SubmitChanges(); } ////////// string[] Data = rd.PKTAG.Split(','); if (Data.Length > 2) { SNP = 0; Qty = 0; int.TryParse(rd.SNP.ToString(), out SNP); decimal.TryParse(rd.Qty.ToString(), out Qty); tb_CheckStockTempCheck ci = new tb_CheckStockTempCheck(); ci.RefNo = Data[1]; ci.Code = rd.PartNo.ToString(); ci.ItemName = db.getItemNoTPICS(rd.PartNo); ci.PKTAG = rd.PKTAG; ci.ofTAG = rd.OfTAG; ci.LotNo = rd.LotNo; ci.Location = rd.LW; ci.CheckMachine = "PDA"; ci.CreateBy = rd.UserID; ci.CreateDate = rd.CreateDate; ci.CheckBy = rd.UserID; ci.CheckNo = rd.CheckNo; ci.SNP = SNP; ci.Quantity = Qty; ci.Remark = ""; ci.Package = ""; ci.Status = "Waiting"; ci.SP = Data[0]; ci.Type = db.getTypeTPICS(rd.PartNo); db.tb_CheckStockTempChecks.InsertOnSubmit(ci); db.SubmitChanges(); tb_CheckStockPDAList pl = db.tb_CheckStockPDALists.Where(p => p.PKTAG == rd.PKTAG).FirstOrDefault(); if (pl != null) { db.tb_CheckStockPDALists.DeleteOnSubmit(pl); db.SubmitChanges(); } } /////// } } //Update Qty// db.sp_E_003_Calculate(txtCheckNo.Text); MessageBox.Show("Calculate Completed."); } else { MessageBox.Show("สถานะ Completed. แล้ว!"); } } this.Cursor = Cursors.Default; } catch (Exception ex) { this.Cursor = Cursors.Default; MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { this.Cursor = Cursors.Default; } }