private void ChckStockPC_Load(object sender, EventArgs e)
{
try
{
if (!PKTAG.Equals(""))
{
string[] Data = PKTAG.Split(',');
// แบบ 1 // PD,WO17001112,2,4,AA2,3of3,41217058036N1
if (Data.Length > 2)
{
txtPKTAG.Text = PKTAG;
txtRef.Text = Data[1];
txtType.Text = Data[0];
txtQty.Text = Data[2];
txtSNP.Text = Data[3];
txtLotNo.Text = Data[4];
txtOfTAG.Text = Data[5];
txtPartNo.Text = Data[6];
}
else
{
// แบบ 1 // PD,WO17001112,2,4,AA2,3of3,41217058036N1
txtPKTAG.Text = PKTAG;
txtPartNo.Text = PKTAG;
//txtRef.Text = Data[1];
txtType.Text = "Code";
// Data[0];
// txtQty.Text = "0";
txtLotNo.ReadOnly = false;
//txtLotNo.Text = Data[4];
// txtOfTAG.Text = Data[5];
// txtPartNo.Text = PKTAG;
}
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
tb_CheckStockList im = db.tb_CheckStockLists.Where(i => i.CheckNo == CheckNo && i.Code == txtPartNo.Text).FirstOrDefault();
if (im != null)
{
var part = db.sp_001_TPIC_SelectItem(txtPartNo.Text).FirstOrDefault();
if (part != null)
{
txtPartName.Text = part.NAME.ToString(); //db.getItemNoTPICS(txtPartNo.Text).ToString();
txtTypeF.Text = part.Detail; //db.getTypeTPICS(txtPartNo.Text).ToString();
if (Data.Length < 2)
{
txtSNP.Text = part.LotSize.ToString();
txtQty.Text = part.CurrentStock.ToString();
}
}
else
{
// MessageBox.Show("ไม่พบไอเท็มนี้ ในรายการเช็คสินค้า !", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
// this.Close();
}
}
else
{
MessageBox.Show("ไม่พบไอเท็มนี้ ในรายการเช็คสินค้า !", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
}
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); }
txtQtyR.Text = "";
txtQtyR.Focus();
}
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())
{
//radProgressBarElement1.Visibility = Telerik.WinControls.ElementVisibility.Visible;
//radProgressBarElement1.Minimum = 0;
//radProgressBarElement1.Maximum = dt_d.Rows.Count;
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 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.InputQty = 0;
u.Remark = "";
u.Diff = 0;
db.tb_CheckStockLists.InsertOnSubmit(u);
db.SubmitChanges();
C += 1;
}
}
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;
}
lblSS.Visible = false;
txtFileName.Text = "";
}
catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); }
finally { this.Cursor = Cursors.Default; }
}
