public string GetGradeVersion(string lot_no, string sampleName) { string _GradeVersion = ""; string msg = ""; DataTable dt = rep.Reporting("MMJY_GetVersionID", new string[] { "LotNo", "SampleName" }, new object[] { lot_no, sampleName }).Tables[0]; if (dt.Rows.Count > 0) { msg = dt.Rows[0]["MSG"].ToString(); Console.WriteLine(msg); if (string.IsNullOrEmpty(msg)) { _GradeVersion = dt.Rows[0]["VersionID"].ToString(); } else { WriteTips(5, msg, false); } } return(_GradeVersion); }
void gridView1_Click(object sender, EventArgs e) { int rowCount = gridView1.SelectedRowsCount; if (rowCount != 1) { return; } DataRow row = gridView1.GetDataRow(gridView1.GetSelectedRows()[0]); VoucherID = row["VoucherID"].ToString(); SampleName = row["SampleName"].ToString(); GradeVersion = row["GradeVersion"].ToString(); txtRemark.Text = row["Remark"].ToString(); //Items SearchPlansItem(); //Remark //DataTable tableVoucher = new DataTable(); //tableVoucher = rep.Reporting("QC04_QueryDocByVoucherId", new string[] { "voucherId", "Lang" }, new object[] { VoucherID,MyLanguage.Language }).Tables[0]; //if (tableVoucher.Rows.Count > 0) //{ // DataRow rowVoucher = tableVoucher.Rows[0]; // txtRemark.Text = rowVoucher["Remark"].ToString(); //} //else //{ // txtRemark.Text = ""; //} //Grade this.cmbGrade.DataSource = rep.Reporting("QC05_Query_SampleGradesList", new string[] { "SampleName" }, new object[] { SampleName }).Tables[0]; this.cmbGrade.DisplayMember = "Grade"; this.cmbGrade.ValueMember = "Grade"; txtSysGrade.Text = GetAutoGrade(VoucherID); cmbGrade.Text = txtSysGrade.Text; }
void QueryAddPlan() { tableDraftList = reports.Reporting("QC03_QueryAddPlan", new string[] { }, new object[] { }).Tables[0]; }
/// <summary> /// 根据委托单号或样品单号查询委托单 /// </summary> /// <param name="draftid">委托单号</param> /// <param name="voucherid">样品单号</param> void QueryDraftPlan(string draftid, string voucherid) { tableDraftList = reports.Reporting("QC03_QueryDraftPlan", new string[] { "DraftID", "VoucherID", "DateForm", "DateTo" }, new object[] { draftid, voucherid, B, E }).Tables[0]; }