private void LoadDataDefault() { try { using (DataClasses1DataContext db = new DataClasses1DataContext()) { tb_Path ph = db.tb_Paths.Where(p => p.PathCode == "Image").FirstOrDefault(); if (ph != null) { PathFile = ph.PathFile; } } } catch { } }
private void Saveclick() { if (!txtItemNo.Text.Equals("") && !txtPathImage.Text.Equals("")) { if (MessageBox.Show("ต้องการบันทึก ?", "บันทึก", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { string Path = ""; using (DataClasses1DataContext db = new DataClasses1DataContext()) { tb_Path ph = db.tb_Paths.Where(p => p.PathCode == "Image").FirstOrDefault(); if (ph != null) { Path = ph.PathFile; } tb_ItemList uck = db.tb_ItemLists.Where(u => u.CodeNo == txtItemNo.Text).FirstOrDefault(); if (uck != null) { //un.UserID = txtUserID.Text; UploadImage(Path); uck.PathImage = txtImage.Text; db.SubmitChanges(); dbClss.AddHistory("ListItem", "แก้ไขรูป", "แก้ไขรายละเอียด [" + txtItemNo.Text + "] ", "จากเครื่อง " + System.Environment.MachineName); } else { UploadImage(Path); tb_ItemList im = new tb_ItemList(); im.CodeNo = txtItemNo.Text; im.PathImage = txtImage.Text; db.tb_ItemLists.InsertOnSubmit(im); db.SubmitChanges(); dbClss.AddHistory("ListItem", "เพิ่มรูป", "ทำการเพิ่มรายการชื่อ [" + txtItemNo.Text + "] เข้าระบบ", "จากเครื่อง " + System.Environment.MachineName); } MessageBox.Show("Save Completed!"); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { MessageBox.Show("Path Image is Empty!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnExport_Click(object sender, EventArgs e) { //Print TAG// try { this.Cursor = Cursors.WaitCursor; int Qty = 0; int snp = 1; int TAG = 0; int a = 0; double ap = 0; int Remain = 0; int.TryParse(txtQty.Text, out Qty); int.TryParse(txtsNP.Text, out snp); string OfTAG = ""; string QrCode = ""; if (Qty > 0) { // string TMNo = dbClss.GetSeriesNo(2, 2); if (Qty != 0 && snp != 0) { a = 0; ap = (Qty % snp); if (ap > 0) { a = 1; } TAG = Convert.ToInt32(Math.Floor((Convert.ToDouble(Qty) / Convert.ToDouble(snp)) + a));//.ToString("###"); //txtOftag.Text = Math.Ceiling((double)1.7 / 10).ToString("###"); Remain = Qty; } int C = 0; string ImagePath = ""; string ImageName = ""; using (DataClasses1DataContext db = new DataClasses1DataContext()) { tb_Path ph = db.tb_Paths.Where(p => p.PathCode == "Image").First(); if (ph != null) { ImagePath = ph.PathFile; } tb_ItemList il = db.tb_ItemLists.Where(i => i.CodeNo == txtPartNo.Text).FirstOrDefault(); if (il != null) { ImageName = il.PathImage; } var tm = db.tb_ProductTAGs.Where(t => t.UserID.ToLower() == dbClss.UserID.ToLower()).ToList(); if (tm.Count > 0) { db.tb_ProductTAGs.DeleteAllOnSubmit(tm); db.SubmitChanges(); } for (int i = 1; i <= TAG; i++) { OfTAG = ""; QrCode = ""; if (Remain > snp) { Qty = snp; Remain = Remain - snp; } else { Qty = Remain; Remain = 0; } OfTAG = i + "of" + TAG; QrCode = ""; QrCode = "PD," + txtBomNo.Text + "," + Qty + "," + snp + "," + txtLotNo.Text + "," + OfTAG + "," + txtPartNo.Text; //MessageBox.Show(QrCode); byte[] barcode = dbClss.SaveQRCode2D(QrCode); /////////////////////////////// tb_ProductTAG ts = new tb_ProductTAG(); ts.UserID = dbClss.UserID; ts.BOMNo = txtBomNo.Text; ts.LotNo = txtLotNo.Text; // ts. = dtDate1.Value.ToString("dd/MM/yyyy"); ts.QRCode = barcode; ts.PartName = txtPartName.Text; ts.PartNo = txtPartNo.Text; ts.Machine = Environment.MachineName; ts.OFTAG = i + "/" + TAG; if (!ImageName.Equals("")) { ts.PathPic = ImagePath + ImageName; } else { ts.PathPic = ""; } ts.Qty = Qty; ts.Seq = i; ts.CSTMShot = txtCustomerShortName.Text; ts.CustomerName = txtCustomerName.Text; ts.CSTMItem = txtCustItemNo.Text; ts.CustItem2 = txtCustItemName.Text; //ts.s = snp; // ts.Company = "Nabtesco Autmotive Corporation"; //ts.Quantity = Qty; // ts.OfTAG = i + " / " + TAG; /////////////////////////////////////////////// db.tb_ProductTAGs.InsertOnSubmit(ts); db.SubmitChanges(); C += 1; } } if (txtAC.Text == "") { txtAC.Text = "1"; } Report.Reportx1.WReport = "PDTAG"; Report.Reportx1.Value = new string[3]; Report.Reportx1.Value[0] = txtBomNo.Text; Report.Reportx1.Value[1] = dbClss.UserID; // Report.Reportx1.Value[2] = txtAC.Text; Report.Reportx1 op = new Report.Reportx1("FG_TAG.rpt"); op.Show(); } else { MessageBox.Show("Qty invalid!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } this.Cursor = Cursors.Default; }