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