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