/// <summary>
/// 根据AQL参数获取样本和允收标准
/// </summary>
/// <param name="SQCID"></param>
/// <param name="cyfs"></param>
/// <param name="jcsp"></param>
/// <param name="jybz"></param>
private void selectAQL_Info(string SQCID, string cyfs, string jcsp, string jybz)
{
SendQCReport sqcr = new SendQCReport();
DataTable dt = sqcr.selectAQLInfo(SQCID, cyfs, jcsp, jybz);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
string result, RetMsg = "";
result = dr["RetValue"].ToString();
RetMsg = dr["RetMsg"].ToString();
if (result == "0")
{
//AQLSampleSizeQty,@ACQty AS ACQty,@ReQty AS ReQty
StringBuilder sb = new StringBuilder();
sb.Append("{\"result\":0,\"msg\":\"获取成功\",\"data\":[");
string json = "{" + String.Format("\"SampleQty\":\"{0}\" ,\"ACQty\":\"{1}\",\"ReQty\":\"{2}\"",
dr["AQLSampleSizeQty"].ToString(), Convert.ToInt32(dr["ACQty"]).ToString(), dr["ReQty"]) + "}]}";
sb.Append(json);
Response.Write(sb.ToString());
string str = sb.ToString();
return;
}
else
{
Response.Write("{\"result\":1,\"msg\":\"" + RetMsg + "\"}");
}
}
else
{
Response.Write("{\"result\":-1,\"msg\":\"获取AQL信息失败\"}");
}
}
protected void Page_Load(object sender, EventArgs e)
{
int pageCount, recCount;
SendQCReport SQ = new SendQCReport();
result.RetStr = SQ.getSendQCReportList("", "", 20, curPage, out pageCount, out recCount, out outDataSet);
if (result.Code == 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("{\"result\":0,\"msg\":\"获取成功\",\"data\":[");
for (int i = 0; i < outDataSet.Tables[0].Rows.Count; i++)
{
DataRow dr = outDataSet.Tables[0].Rows[i];
int SendQty = Convert.IsDBNull(dr["SendQCQty"]) ? 0 : Convert.ToInt32(dr["SendQCQty"]);
string json = "{" + String.Format("\"SendQCReportId\":\"{0}\",\"SendQCReportNumber\":\"{1}\",\"VendorName\":\"{2}\","
+ "\"ProductShortName\":\"{3}\",\"ProductDescription\":\"{4}\",\"SendQCQty\":\"{5}\",\"SendDate\":\"{6}\",\"QCResult\":\"{7}\",\"POName\":\"{8}\"",
dr["SendQCReportId"], dr["SendQCReportNumber"], dr["VendorName"], dr["ProductShortName"],
dr["ProductDescription"], SendQty.ToString(), dr["SendDate"], dr["QCResult"], dr["POName"]) + "}";
sb.Append(json);
if (i != outDataSet.Tables[0].Rows.Count - 1)
{
sb.Append(",");
}
}
sb.Append("]}");
string str = sb.ToString();
Response.Write(sb.ToString());
}
else
{
Response.Write("{\"result\":1,\"msg\":\"获取失败\"}");
}
}
/// <summary>
/// 生产并打印物料标签
/// </summary>
/// <param name="SQCId"></param>
private void PrintSQCLabels(string SQCId, string CYFS, string JCSP, string JYBZ)
{
SendQCReport sqcr = new SendQCReport();
string msg = "";
if (sqcr.PrintSQCLabel(SQCId, CYFS, JCSP, JYBZ, out msg))
{
Response.Write("{\"result\":1,\"msg\":\"" + msg + "\"}");
}
else
{
Response.Write("{\"result\":-1,\"msg\":\"打印样本标签失败:" + msg + "\"}");
}
}
/// <summary>
/// 删除扫描记录
/// </summary>
/// <param name="SQCId"></param>
private void DelScanList(string SQCId, string LotSN)
{
SendQCReport sqcr = new SendQCReport();
string msg = "";
if (sqcr.delScanList(SQCId, LotSN, out msg))
{
Response.Write("{\"result\":1,\"msg\":\"" + msg + "\"}");
}
else
{
Response.Write("{\"result\":-1,\"msg\":\"抽样记录删除失败:" + msg + "\"}");
}
}
/// <summary>
/// 样本抽取数据提交
/// </summary>
/// <param name="SQCId">送检单Id</param>
/// <param name="CYFS">抽样方式</param>
/// <param name="JCSP">检查水平</param>
/// <param name="JYBZ">检验标准</param>
/// <param name="ScanSN">扫描SN</param>
/// <param name="CQ_Qty">抽取数量</param>
private void ScanSubmit(string SQCId, string CYFS, string JCSP, string JYBZ, string ScanSN, string CQ_Qty)
{
SendQCReport sqcr = new SendQCReport();
string msg = "";
if (sqcr.SPec_ScanSubmit(SQCId, CYFS, JCSP, JYBZ, ScanSN, CQ_Qty, out msg))
{
Response.Write("{\"result\":1,\"msg\":\"样本抽取成功:" + msg + "\"}");
}
else
{
Response.Write("{\"result\":-1,\"msg\":\"样本抽取失败:" + msg + "\"}");
}
}
/// <summary>
/// 获取样本扫描列表
/// </summary>
/// <param name="SQCId">送检Id</param>
private void LoadScanList(string SQCId = "SQCR000000TK")
{
try
{
SendQCReport sqcr = new SendQCReport();
DataTable dt = sqcr.getScanList(SQCId);
int T_CQty = 0;
if (dt.Rows.Count > 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("{\"result\":0,\"msg\":\"扫描记录获取成功" + SQCId + "\",\"data\":[");
for (int i = 0; i < dt.Rows.Count; i++)
{
//LotId,LotSN, CYFS,CYSP,CYBZ ,SpecQty
DataRow dr = dt.Rows[i];
string json = "{" + String.Format("\"LotId\":\"{0}\",\"LotSN\":\"{1}\",\"CYFS\":\"{2}\",\"CYSP\":\"{3}\",\"CYBZ\":\"{4}\",\"SpecQty\":\"{5}\"",
dr["LotId"], dr["LotSN"], dr["CYFS"], dr["CYSP"], dr["CYBZ"], dr["SpecQty"]) + "}";
sb.Append(json);
if (i != dt.Rows.Count - 1)
{
sb.Append(",");
}
T_CQty += Convert.ToInt32(dr["SpecQty"]);
/* */
}
sb.Append("],\"T_Qty\":\"" + T_CQty.ToString() + "\"");
sb.Append("}");
Response.Write(sb.ToString());
}
else
{
Response.Write("{\"result\":0,\"msg\":\"扫描记录获取成功\"}");
}
}
catch (Exception ex)
{
Response.Write("{\"result\":-1,\"msg\":\"" + ex.Message + "\"}");
}
}
/// <summary>
/// 抽检 页面加载事件
/// </summary>
private void GetSpecPageLoad(string SendQCReportId)
{
SendQCReportId = "SQCR000000TL";//测试
SendQCReport SQCR = new SendQCReport();
DataTable dt = SQCR.SpecPageLoad(SendQCReportId);
if (dt.Rows.Count > 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("{\"result\":0,\"msg\":\"获取成功\",\"data\":[");
// SendQCReportId, POName, VendorName, ProductId,ProductShortName
//ProductDescription, SendQCQty, CYFS , JYSP , JYBZ , JY_QTY, IsCYDone
DataRow dr = dt.Rows[0];
if (Convert.ToInt32(dr["RetValue"]) == 0)
{
string json = "{" + String.Format("\"SendQCReportId\":\"{0}\" ,\"POName\":\"{1}\"," +
"\"VendorName\":\"{2}\",\"ProductId\":\"{3}\",\"ProductDescription\":\"{4}\"," +
"\"SendQCQty\":\"{5}\",\"CYFS\":\"{6}\",\"JYSP\":\"{7}\",\"JYBZ\":\"{8}\",\"JY_QTY\":\"{9}\",\"IsCYDone\":\"{10}\",\"ProductShortName\":\"{11}\",\"TCQ_Qty\":\"{12}\"",
dr["SendQCReportId"], dr["POName"], dr["VendorName"], dr["ProductId"], dr["ProductDescription"], dr["SendQCQty"], dr["CYFS"]
, dr["JYSP"], dr["JYBZ"], dr["JY_QTY"], dr["IsCYDone"], dr["ProductShortName"], dr["TCQ_Qty"]) + "}";
sb.Append(json);
sb.Append("]}");
string str = sb.ToString();
Response.Write(sb.ToString());
}
else
{
Response.Write("{\"result\":1,\"" + dr["RetMsg"].ToString() + "\":\"获取失败\"}");
}
}
else
{
Response.Write("{\"result\":-1,\"msg\":\"获取失败\"}");
}
}
protected void Page_Load(object sender, EventArgs e)
{
SendQCReport SQ = new SendQCReport();
result.RetStr = SQ.getSendQCReportInfo(SendQCReportId, out outDataSet);
if (result.Code == 0)
{
if (outDataSet.Tables[0].Rows.Count > 0)
{
// studentId.Value = outDataSet.Tables[0].Rows[0]["SendQCReportId"].ToString();
//lblName.Text = outDataSet.Tables[0].Rows[0]["name"].ToString();
//lblSex.Text = outDataSet.Tables[0].Rows[0]["sex"].ToString();
//lblNo.Text = outDataSet.Tables[0].Rows[0]["no"].ToString();
//lblPhone.Text = outDataSet.Tables[0].Rows[0]["phone"].ToString();
//lblAddress.Text = outDataSet.Tables[0].Rows[0]["address"].ToString();
//score.Text = outDataSet.Tables[0].Rows[0]["score"].ToString();
}
}
else
{
Response.Write(result.Msg);
}
}