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