using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using Pub_Class;

namespace SQLHelper
{
    public  class ClsCNmaster:ClsCN
    {
        public ClsCNmaster()
        {
            ClsIni oIni = new ClsIni();
            sServer = ClsIni.ReadIni("Erp", "Server", ClsPub.AppPath + @"\" + "HXErp.ini");
            sDataBase = "master";
            sUser = ClsIni.ReadIni("Erp", "UserName", ClsPub.AppPath + @"\" + "HXErp.ini");
            sPassword = ClsIni.ReadIni("Erp", "PassWord", ClsPub.AppPath + @"\" + "HXErp.ini");
        }

        public string GetDataBase(string sItem,ref string sK3 )
        {
            string[] sNumber;
            ClsCNmaster oCn = new ClsCNmaster();
            char c = Convert.ToChar("-");
            sNumber = sItem.Split(c);
            ClsPub.AccNumber = sNumber[0];
            ClsPub.AccName = sNumber[1];
            DataSet Ds = oCn.RunProcReturn("select DataBasesName,K3Erp from HDSystem_DataBases where Number='" + sNumber[0] + "'", "HDSystem_DataBases");
            if (Ds.Tables[0].Rows.Count > 0)
            {
                sK3 = Ds.Tables[0].Rows[0]["K3Erp"].ToString();
                //sK32 = Ds.Tables[0].Rows[0]["K32Erp"].ToString();
                //sK33 = Ds.Tables[0].Rows[0]["K33Erp"].ToString();
                return Ds.Tables[0].Rows[0]["DataBasesName"].ToString();
            }
            else
            {
                return "";
            }
        }

        public string GetDataBase(string sItem)
        {
            string[] sNumber;
            ClsCNmaster oCn = new ClsCNmaster();
            char c = Convert.ToChar("-");
            sNumber = sItem.Split(c);
            ClsPub.AccNumber = sNumber[0];
            ClsPub.AccName = sNumber[1];
            DataSet Ds = oCn.RunProcReturn("select DataBasesName  From HDSystem_DataBases where Number='" + sNumber[0] + "'", "HDSystem_DataBases");
            if (Ds.Tables[0].Rows.Count > 0)
            {
                //sK3 = Ds.Tables[0].Rows[0]["K3Erp"].ToString();
                //sK32 = Ds.Tables[0].Rows[0]["K32Erp"].ToString();
                //sK33 = Ds.Tables[0].Rows[0]["K33Erp"].ToString();
                return Ds.Tables[0].Rows[0]["DataBasesName"].ToString();
            }
            else
            {
                return "";
            }
        }
    }
}