void gridView1_DoubleClick(object sender, EventArgs e) { int rowCount = gridView1.SelectedRowsCount; if (rowCount != 1) { return; } Dictionary <string, string> paramenters = new Dictionary <string, string>(); DataRow row = gridView1.GetDataRow(gridView1.GetSelectedRows()[0]); foreach (DataColumn c in row.Table.Columns) { paramenters.Add(c.ColumnName, row[c.ColumnName] == null ? "" : row[c.ColumnName].ToString()); } if (eventShowDetails != null) { GetPlan = new DOCPlan { VoucherID = paramenters["VoucherID"], SampleName = paramenters["SampleName"], //Purpose = paramenters["Purpose"], ProdDate = Convert.ToDateTime(paramenters["ProdDate"]), SampleID = paramenters["SampleID"], LOT_NO = paramenters["LOT_NO"], LINE = paramenters["LINE"], //CompanyOffer = paramenters["CompanyOfferSample"] , //CompanyProd = paramenters["CompanyProduce"] }; eventShowDetails(sender, e); } }
public bool InsertPlan(DOCPlan doc, ref string VoucherID, out string msg) { Console.WriteLine("DOCPlanDAL-InsertPlan():" + DateTime.Now.ToString()); VoucherID = string.Empty; msg = string.Empty; try { //1. VoucherID By SampleName and ProdDate VoucherID = CreateVoucherID(doc.SampleName, doc.ProdDate); //3.Create VoucherID doc.VoucherID = VoucherID; doc.State = "1"; //得到等级的版本 成品一定要有等级规格 string versionID = string.Empty; msg = CheckGradeVersion(doc.SampleName, doc.LOT_NO, out versionID); if (!string.IsNullOrEmpty(msg)) { return(false); } Console.WriteLine(versionID); doc.GradeVersion = versionID; doc.UserID = Shawoo.GenuineChannels.GenuineUtility.CurrentSession["UID"].ToString(); return(db.Insert(doc)); } catch (Exception e) { log.Error(e); throw new Exception(e.Message); } }
private void AddPOLYSSP(string sampleName, string materialNo, bool isSampleId) { AddPOLYSSP _AddPOLYSSP = new AddPOLYSSP(sampleName, materialNo, isSampleId); _AddPOLYSSP.LineList = GetLines(sampleName); _AddPOLYSSP.CreateTypeLoad = GetPlanType(); CultureLanuage.ApplyResourcesFrom(_AddPOLYSSP, "QC21", "AddPOLYSSP"); _AddPOLYSSP.ShowDialog(); if (_AddPOLYSSP.rValue) { string msg = _AddPOLYSSP.ReadyWork; if (string.IsNullOrEmpty(msg)) { DOCPlan _DOC = _AddPOLYSSP.GetDocPlan; string VoucherID = ""; if (biz.InsertPlan(_DOC, ref VoucherID, out msg)) { WriteTips(5, "Add VoucherID DOC :successful!"); _QC21View.dtGrid = GetPlan(); } else { WriteTips(5, msg, false); } } else { WriteTips(5, msg); } } }
public bool InsertPlanByAdd(DOCPlan doc, int addID, out string voucherID) { Console.WriteLine("PlanAddService--InsertPlanByAdd " + DateTime.Now.ToString()); bool result = false; string labAddr = ""; string LabAddCommand = @"SELECT LabID FROM Samples where SampleName = @SampleName"; try { labAddr = acQC.SelectScalar <string>(LabAddCommand, new object[] { doc.SampleName }); voucherID = "P" + labAddr + DateTime.Now.ToString("yyMMdd"); } catch { voucherID = ""; return(false); } // string planCount = "SELECT ISNULL(Max(substring(VoucherID,9,4))+1,1) FROM PLANS WHERE SUBSTRING(VoucherID,1,8) = @PRE"; try { voucherID += (acQC.SelectScalar <int>(planCount, new object[] { voucherID })).ToString().PadLeft(4, '0'); Console.WriteLine("VoucherID:" + voucherID); // doc.createType = 1; doc.VoucherID = voucherID; doc.PlanAddID = addID; doc.HasChart = "1"; Console.WriteLine(JsonConvert.SerializeObject(doc)); if (db.Insert(doc)) { acQC.DbHelper.ExecuteNonQuery("UPDATE PlanAdd SET State = '2' WHERE VoucherID = @VoucherID", new object[] { addID }); return(true); } return(false); } catch (Exception ex) { log.Error(ex); throw new Exception(ex.Message); } }
void btAccept_Click(object sender, EventArgs e) { if (PlanAddID == -1) { WriteTips(8, "NO SELECT ROW", false); return; } Console.WriteLine("btAccept_Click"); Console.WriteLine(PlanAddID.ToString() + "|" + SampleName + "|" + LOT_NO + "|" + LINE + "|" + ProdDate.ToString() + "|" + SampleID); string voucherid = ""; DOCPlan panAdd = new DOCPlan(); panAdd.SampleName = SampleName; panAdd.LOT_NO = LOT_NO; panAdd.LINE = LINE; panAdd.ProdDate = ProdDate; panAdd.SheetDate = SheetDate; panAdd.State = "1"; panAdd.Grade = "A"; panAdd.SampleID = SampleID; panAdd.createType = CreateType; panAdd.companyProd = CompanyProd; panAdd.companyOffer = CompanyOffer; panAdd.GradeVersion = GradeVersion; if (_planAddBiz.InsertPlanByAdd(panAdd, PlanAddID, out voucherid)) { QueryAddPlan(); WriteTips(8, "add VoucherID:" + voucherid, true); } else { WriteTips(8, "Receipt of test documents failed", false); } }
public List <DOCPlan> GetMultipleSelectionProducts() { List <DOCPlan> dOCPlans = new List <DOCPlan>(); // Add the selected rows to the list. Int32[] selectedRowHandles = gridView1.GetSelectedRows(); for (int i = 0; i < selectedRowHandles.Length; i++) { int selectedRowHandle = selectedRowHandles[i]; if (selectedRowHandle >= 0) { var currentDoc = gridView1.GetDataRow(selectedRowHandle); DOCPlan doc = new DOCPlan(); doc.SampleName = SampleName; doc.LOT_NO = LotNO; doc.LINE = currentDoc["Line"].ToString(); doc.Grade = "A"; doc.grades = currentDoc["Grades"].ToString(); doc.SampleID = currentDoc["BarCode"].ToString(); dOCPlans.Add(doc); } } return(dOCPlans); }
public bool InsertPlanByAdd(DOCPlan DOC, int AddID, out string VoucherID) { return(proxy.InsertPlanByAdd(DOC, AddID, out VoucherID)); }
public void EditPlanADD(DOCPlan PlanADD) { _QA23Dialog.Plan = PlanADD; _QA23Dialog.ShowDialog(); }
public bool InsertPlan(DOCPlan doc, ref string VoucherID, out string msg) { return(proxy.InsertPlan(doc, ref VoucherID, out msg)); }