private DataTable GetUserQC(string dept_no, string sec_no)
{
bs_ApplyData mybs = new bs_ApplyData(ConfigurationSettings.AppSettings["AppConnectionType"], ConfigurationSettings.AppSettings["AppConnectionServer"], ConfigurationSettings.AppSettings["AppConnectionDB"], ConfigurationSettings.AppSettings["AppConnectionUser"], ConfigurationSettings.AppSettings["AppConnectionPwd"]);
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("dept_no", dept_no);
myMsg.CreateFirstNode("sec_no", sec_no);
DataSet dsReturn = mybs.DoReturnDataSet("GETUSERQC", myMsg.GetXmlStr, "");
DataTable dt = dsReturn.Tables[0];
return dt;
}
private DataTable GetBadNo(string type_check, string vou_no, string fact_no, string dept_no, string sec_no, string add_date)
{
bs_ApplyData mybs = new bs_ApplyData(ConfigurationSettings.AppSettings["AppConnectionType"], ConfigurationSettings.AppSettings["AppConnectionServer"], ConfigurationSettings.AppSettings["AppConnectionDB"], ConfigurationSettings.AppSettings["AppConnectionUser"], ConfigurationSettings.AppSettings["AppConnectionPwd"]);
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("type_check", type_check);
myMsg.CreateFirstNode("vou_no", vou_no);
myMsg.CreateFirstNode("fact_no", fact_no);
myMsg.CreateFirstNode("dept_no", dept_no);
myMsg.CreateFirstNode("sec_no", sec_no);
myMsg.CreateFirstNode("add_date", add_date);
DataSet dsReturn = mybs.DoReturnDataSet("SUMBABNO", myMsg.GetXmlStr, "");
DataTable dt = dsReturn.Tables[0];
return dt;
}
private DataTable GetImgLink()
{
bs_ApplyData mybs = new bs_ApplyData(ConfigurationSettings.AppSettings["AppConnectionType"], ConfigurationSettings.AppSettings["AppConnectionServer"], ConfigurationSettings.AppSettings["AppConnectionDB"], ConfigurationSettings.AppSettings["AppConnectionUser"], ConfigurationSettings.AppSettings["AppConnectionPwd"]);
PccMsg myMsg = new PccMsg();
DataSet dsReturn = mybs.DoReturnDataSet("GETIMGCONDITIONS", myMsg.GetXmlStr, "");
DataTable dt = dsReturn.Tables[0];
return dt;
}
private DataTable SumQtyToalQC02(string vou_no, string fact_no, string dept_no, string sec_no, string bad_no,string userQC_id,string add_date, string Type)
{
bs_ApplyData mybs = new bs_ApplyData(ConfigurationSettings.AppSettings["AppConnectionType"], ConfigurationSettings.AppSettings["AppConnectionServer"], ConfigurationSettings.AppSettings["AppConnectionDB"], ConfigurationSettings.AppSettings["AppConnectionUser"], ConfigurationSettings.AppSettings["AppConnectionPwd"]);
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("vou_no", vou_no);
myMsg.CreateFirstNode("fact_no", fact_no);
myMsg.CreateFirstNode("dept_no", dept_no);
myMsg.CreateFirstNode("sec_no", sec_no);
myMsg.CreateFirstNode("bad_no", bad_no);
myMsg.CreateFirstNode("userQC_id", userQC_id);
myMsg.CreateFirstNode("add_date", add_date);
myMsg.CreateFirstNode("Type", Type);
DataSet dsReturn = mybs.DoReturnDataSet("SUMQTYTOALQC02", myMsg.GetXmlStr, "");
DataTable dt = dsReturn.Tables[0];
return dt;
}