Esempio n. 1
0
 public BasicData()
 {
     myBs = new bs_BasicData(ConfigurationSettings.AppSettings["AppConnectionType"], ConfigurationSettings.AppSettings["AppConnectionServer"], ConfigurationSettings.AppSettings["AppConnectionDB"], ConfigurationSettings.AppSettings["AppConnectionUser"], ConfigurationSettings.AppSettings["AppConnectionPwd"]);
 }
Esempio n. 2
0
    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];
    }
Esempio n. 3
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;
    }