C#調用SP方法封裝(沒寫完)

執行SP的方法，你們可以自己慢慢寫

last那個是指SP的OUT參數是第一個（first）還是最後一個（last）

  public DataTable GetFixtureLodaDataTotal(QueryCondition query)
        {
            string strResult = string.Empty;
            DataTable dt = new DataTable();
            strSQL = "MES1.QUERY";
            if (query.Paramms11 == "DOWNLOAD" || query.Paramms11 == "TOTAL")
            {
                dt = Common.ExecuteSP.ExecuteSPReturnDataTable(strSQL, "last", "SHOW_BY", "", "", "", "", "", "", "", "", "", "size", "page", "login", "", "", "", "", "", query.Paramms11, "");
            }
            else
            {
                dt = Common.ExecuteSP.ExecuteSPReturnDataTable(strSQL, "last", "SHOW_BY", "", "", "", "", "", "", "", "", "", query.Paramms2, query.Paramms1, "login", "", "", "", "", "", query.Paramms11, "");
            }

            return dt;
        }

 

QueryCondition實體類

 public class QueryCondition
    {
        //public string Paramms1 { get; set; } 

        private string paramms1;
        public string Paramms1
        {
            get { return this.paramms1 == null ? "" : this.paramms1; }
            set { this.paramms1 = value; }
        }
        private string paramms2;
        public string Paramms2
        {
            get { return this.paramms2 == null ? "" : this.paramms2; }
            set { this.paramms2 = value; }
        }
        private string paramms3;
        public string Paramms3
        {
            get { return this.paramms3 == null ? "" : this.paramms3; }
            set { this.paramms3 = value; }
        }
        private string paramms4;
        public string Paramms4
        {
            get { return this.paramms4 == null ? "" : this.paramms4; }
            set { this.paramms4 = value; }
        }
        private string paramms5;
        public string Paramms5
        {
            get { return this.paramms5 == null ? "" : this.paramms5; }
            set { this.paramms5 = value; }
        }
        private string paramms6;
        public string Paramms6
        {
            get { return this.paramms6 == null ? "" : this.paramms6; }
            set { this.paramms6 = value; }
        }
        private string paramms7;
        public string Paramms7
        {
            get { return this.paramms7 == null ? "" : this.paramms7; }
            set { this.paramms7 = value; }
        }
        private string paramms8;
        public string Paramms8
        {
            get { return this.paramms8 == null ? "" : this.paramms8; }
            set { this.paramms8 = value; }
        }
        private string paramms9;
        public string Paramms9
        {
            get { return this.paramms9 == null ? "" : this.paramms9; }
            set { this.paramms9 = value; }
        }
        private string paramms10;
        public string Paramms10
        {
            get { return this.paramms10 == null ? "" : this.paramms10; }
            set { this.paramms10 = value; }
        }
        private string paramms11;
        public string Paramms11
        {
            get { return this.paramms11 == null ? "" : this.paramms11; }
            set { this.paramms11 = value; }
        }
    }