private void radButtonElement4_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("คุณต้องการลบหรือไม่ ?", "ลบรายการ", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int id = 0;
int.TryParse(dgvData.Rows[row].Cells["id"].Value.ToString(), out id);
if (!CodeNo.Equals("") && !id.Equals(0))
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
tb_CheckStockTempCheck td = db.tb_CheckStockTempChecks.Where(t => t.id == id).FirstOrDefault();
if (td != null)
{
db.tb_CheckStockTempChecks.DeleteOnSubmit(td);
db.SubmitChanges();
LoadData(CodeNo);
}
}
}
}
}
catch { }
}
private void SaveData()
{
try
{
if (!PKTAG.Equals(""))
{
decimal QtyR = 0;
decimal.TryParse(txtQtyR.Text, out QtyR);
int SNP = 0;
int.TryParse(txtSNP.Text, out SNP);
int ZoneNo = 0;
if (QtyR > 0)
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
tb_CheckStockTempCheck ck = db.tb_CheckStockTempChecks.Where(t => t.PKTAG == PKTAG && t.CheckNo == CheckNo).FirstOrDefault();
if (ck != null && !txtType.Text.Equals("Code"))
{
MessageBox.Show("ข้อมูลซ้ำกับที่ยงเข้าไปแล้ว! Qty [ " + ck.Quantity.ToString() + " ]", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
}
else
{
ZoneNo = Convert.ToInt32(db.getMaxZone(CheckNo, LW)) + 1;
tb_CheckStockTempCheck ci = new tb_CheckStockTempCheck();
ci.RefNo = txtRef.Text;
ci.Code = txtPartNo.Text;
ci.ItemName = txtPartName.Text;
ci.PKTAG = txtPKTAG.Text;
ci.ofTAG = txtOfTAG.Text;
ci.LotNo = txtLotNo.Text;
ci.Location = LW;
ci.CheckMachine = Environment.MachineName;
ci.CreateBy = dbClss.UserID;
ci.CreateDate = DateTime.Now;
ci.CheckBy = UserCK;
ci.CheckNo = CheckNo;
ci.SNP = SNP;
ci.Quantity = QtyR;
ci.Remark = "";
ci.Package = "";
ci.Status = "Waiting";
ci.SP = txtType.Text;
ci.Type = txtTypeF.Text;
ci.ZoneNo = ZoneNo;
ci.TY = 0;
db.tb_CheckStockTempChecks.InsertOnSubmit(ci);
db.SubmitChanges();
this.Close();
}
}
}
else
{
MessageBox.Show("โปรดระบุจำนวน..");
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); }
}
private void InsertData(string CheckNo, string Code, string ItemName, string PONo, string SP, decimal Quantity, int SPN, string LotNo, string TAGof, string Type)
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
var g = (from ix in db.tb_CheckStockTempChecks
where ix.CheckNo.Trim() == CheckNo &&
ix.Status != "Cancel"
//&& ix.Status != "Completed"
&& ix.Code == Code
select ix).ToList();
if (g.Count > 0) //มีรายการในระบบ
{
var g1 = (from ix in db.tb_CheckStockTempChecks
where ix.CheckNo.Trim() == CheckNo &&
ix.Status != "Cancel" &&
ix.Status != "Completed" &&
ix.Code == Code
select ix).ToList();
if (g1.Count > 0)
{
var gg = (from ix in db.tb_CheckStockTempChecks
where ix.CheckNo.Trim() == CheckNo &&
ix.Status != "Cancel" &&
ix.Status != "Completed" &&
ix.Code == Code &&
ix.id == Convert.ToInt16(g1.FirstOrDefault().id)
select ix).First();
gg.CreateBy = dbClss.UserID;
gg.CreateDate = Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"));
gg.CheckMachine = "";
gg.Location = ddlLocation.Text;
gg.CheckBy = txtCheckBy.Text;
gg.Code = Code;
gg.ItemName = ItemName;
gg.Quantity = Quantity;
gg.Status = "Waiting";
gg.Remark = "";
gg.Package = "";
gg.Type = Type;
gg.LotNo = LotNo;
gg.SNP = SPN;
gg.ofTAG = TAGof;
gg.RefNo = PONo;
gg.SP = SP;
db.SubmitChanges();
}
}
else
{
tb_CheckStockTempCheck u = new tb_CheckStockTempCheck();
u.CheckNo = CheckNo;
u.CreateBy = dbClss.UserID;
u.CreateDate = Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"));
u.CheckMachine = "";
u.Location = ddlLocation.Text;
u.CheckBy = txtCheckBy.Text;
u.Code = Code;
u.ItemName = ItemName;
u.Quantity = Quantity;
u.Status = "Waiting";
u.Remark = "";
u.Package = "";
u.Type = Type;
u.LotNo = LotNo;
u.SNP = SPN;
u.ofTAG = TAGof;
u.RefNo = PONo;
u.SP = SP;
db.tb_CheckStockTempChecks.InsertOnSubmit(u);
db.SubmitChanges();
}
}
}
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; }
}
