public string SaveApplyCheckDataQC(string ac_id, string fact_no, string dept_no, string sec_no, string type_check, string vou_no, string total, string floor, string build_no, string myType)
{
bs_ApplyData myBs = new bs_ApplyData(ConfigurationSettings.AppSettings["AppConnectionType"], ConfigurationSettings.AppSettings["AppConnectionServer"], ConfigurationSettings.AppSettings["AppConnectionDB"], ConfigurationSettings.AppSettings["AppConnectionUser"], ConfigurationSettings.AppSettings["AppConnectionPwd"], "", ConfigurationSettings.AppSettings["EventLogPath"]);
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("ac_id", ac_id);
myMsg.CreateFirstNode("fact_no", fact_no);
myMsg.CreateFirstNode("dept_no", dept_no);
myMsg.CreateFirstNode("sec_no", sec_no);
myMsg.CreateFirstNode("type_check", type_check);
myMsg.CreateFirstNode("vou_no", vou_no);
myMsg.CreateFirstNode("total", total);
myMsg.CreateFirstNode("floor", floor);
myMsg.CreateFirstNode("build_no", build_no);
myMsg.CreateFirstNode("Type", myType);
string strXML = myMsg.GetXmlStr;
string strReturn = myBs.DoReturnStr("INSUPDAPPLYCHECKQ", strXML, "");
myMsg.LoadXml(strReturn);
return strReturn;
//return myMsg.Query("Err");
}
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 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 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;
}
public string SaveCheckDetail(string appd_id, string ac_id, string bad_no, string bad_desc, string bad_descVN, string userQC_id, string qty,string qtyOKitem, string myType)
{
bs_ApplyData myBs = new bs_ApplyData(ConfigurationSettings.AppSettings["AppConnectionType"], ConfigurationSettings.AppSettings["AppConnectionServer"], ConfigurationSettings.AppSettings["AppConnectionDB"], ConfigurationSettings.AppSettings["AppConnectionUser"], ConfigurationSettings.AppSettings["AppConnectionPwd"], "", ConfigurationSettings.AppSettings["EventLogPath"]);
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("appd_id", appd_id);
myMsg.CreateFirstNode("ac_id", ac_id);
myMsg.CreateFirstNode("bad_no", bad_no);
myMsg.CreateFirstNode("bad_desc", bad_desc);
myMsg.CreateFirstNode("bad_descVN", bad_descVN);
myMsg.CreateFirstNode("userQC_id", userQC_id);
myMsg.CreateFirstNode("qty", qty);
myMsg.CreateFirstNode("qtyOKitem", qtyOKitem);
myMsg.CreateFirstNode("Type", myType);
string strXML = myMsg.GetXmlStr;
string strReturn = myBs.DoReturnStr("INSUPDAPPLYCHECKDETAIL", strXML, "");
myMsg.LoadXml(strReturn);
//return strReturn;
return myMsg.Query("Err");
}
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;
}
