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; }
}
