private DataTable GetQCFactDept()
{
//lấy fact_no
string xmlFact_no = _DropDownList.GetFactNoByUserID(Session["UserID"].ToString().Trim());
bs_BasicData mybs = new bs_BasicData(ConfigurationSettings.AppSettings["AppConnectionType"], ConfigurationSettings.AppSettings["AppConnectionServer"], ConfigurationSettings.AppSettings["AppConnectionDB"], ConfigurationSettings.AppSettings["AppConnectionUser"], ConfigurationSettings.AppSettings["AppConnectionPwd"]);
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("user_id", Session["UserID"].ToString());
myMsg.CreateFirstNode("fact_no", xmlFact_no);
DataSet dsReturn = mybs.DoReturnDataSet("PRO_GET_QCFACTDEPT", myMsg.GetXmlStr, "");
return dsReturn.Tables[0];
}
private DataTable get_Languages()
{
DataTable dt = new DataTable();
PccMsg myMsg = new PccMsg();
bs_BasicData mybs = new bs_BasicData(ConfigurationSettings.AppSettings["AppConnectionType"], ConfigurationSettings.AppSettings["AppConnectionServer"], ConfigurationSettings.AppSettings["AppConnectionDB"], ConfigurationSettings.AppSettings["AppConnectionUser"], ConfigurationSettings.AppSettings["AppConnectionPwd"], "", ConfigurationSettings.AppSettings["EventLogPath"]);
DataSet ds = mybs.DoReturnDataSet("pro_get_languages", myMsg.GetXmlStr, "");
if (ds.Tables.Count > 0)
dt = ds.Tables[0];
return dt;
}