DAL调用接口方法

using Model;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using Model.DTO;

using System.Data.SqlClient;

using DB;

using System.Data;

using Newtonsoft.Json;

namespace DAL

{

    public class AccressDAL : IDAL.idals<Commodity>

    {

        public int Adection(Commodity asd)

        {

            string sql = "up_CommodityAdd";

            SqlParameter[] pars = new SqlParameter[10];

            pars[0] = new SqlParameter("@Wez", asd.Wez);

            pars[1] = new SqlParameter("@Farea", asd.Farea);

            pars[2] = new SqlParameter("@Jarea", asd.Jarea);

            pars[3] = new SqlParameter("@structure", asd.structure);

            pars[4] = new SqlParameter("@Nature", asd.Nature);

            pars[5] = new SqlParameter("@Sid", asd.Sid);

            pars[6] = new SqlParameter("@Xid", asd.Xid);

            pars[7] = new SqlParameter("@Rid", asd.Rid);

            pars[8] = new SqlParameter("@Hid", asd.Hid);

            pars[9] = new SqlParameter("@Lid", asd.Lid);

            int i = DbHelperSQL.ExecuteNonQuery(DbHelperSQL.ConnB2c, CommandType.StoredProcedure, sql, pars);

            return i;

        }

 

        public int Delete(string id)

        {

            string sql = "up_CommodityDelete";

            SqlParameter ids = new SqlParameter("@id", id);

            SqlParameter tableName = new SqlParameter("@TableName", "Commodity");

            SqlParameter[] pras = new SqlParameter[] {tableName, ids };

            int i = DbHelperSQL.ExecuteNonQuery(DbHelperSQL.ConnB2c, CommandType.StoredProcedure, sql, pras);

            return i;

        }

 

        public int Dels(int id)

        {

            string sql = "up_CommodityDels";

            SqlParameter ids = new SqlParameter("@id", id);

            SqlParameter[] pars = new SqlParameter[] { ids };

            int i = DbHelperSQL.ExecuteNonQuery(DbHelperSQL.ConnB2c, CommandType.StoredProcedure, sql, pars);

            return i;

        }

 

        public PageList<Commodity> FyShowlist(ParaModel model)

        {

            PageList<Commodity> pageList = PageCommon.StoredList<Commodity>(model);

            return pageList;

        }

 

        public List<Housepe> Hshow()

        {

            string sql = "select * from Housepe";

            DataTable dt = DbHelperSQL.ExecuteDataTable(DbHelperSQL.ConnB2c, CommandType.Text, sql, null);

            List<Housepe> list = JsonConvert.DeserializeObject<List<Housepe>>(JsonConvert.SerializeObject(dt));

            return list;

        }

 

        public List<Ridgepole> Rshow()

        {

            string sql = "select * from Ridgepole";

            DataTable dt = DbHelperSQL.ExecuteDataTable(DbHelperSQL.ConnB2c, CommandType.Text, sql, null);

            List<Ridgepole> list = JsonConvert.DeserializeObject<List<Ridgepole>>(JsonConvert.SerializeObject(dt));

            return list;

        }

 

        public List<States> Sshow()

        {

            string sql = "select * from States";

            DataTable dt = DbHelperSQL.ExecuteDataTable(DbHelperSQL.ConnB2c, CommandType.Text, sql, null);

            List<States> list = JsonConvert.DeserializeObject<List<States>>(JsonConvert.SerializeObject(dt));

            return list;

        }

 

        public List<Housing> Xshow()

        {

            string sql = "select * from Housing";

            DataTable dt = DbHelperSQL.ExecuteDataTable(DbHelperSQL.ConnB2c, CommandType.Text, sql, null);

            List<Housing> list = JsonConvert.DeserializeObject<List<Housing>>(JsonConvert.SerializeObject(dt));

            return list;

        }

    }

}

using Model;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using Model.DTO;

using System.Data.SqlClient;

using DB;

using System.Data;

using Newtonsoft.Json;

namespace DAL

{

    public class AccressDAL : IDAL.idals<Commodity>

    {

        public int Adection(Commodity asd)

        {

            string sql = "up_CommodityAdd";

            SqlParameter[] pars = new SqlParameter[10];

            pars[0] = new SqlParameter("@Wez", asd.Wez);

            pars[1] = new SqlParameter("@Farea", asd.Farea);

            pars[2] = new SqlParameter("@Jarea", asd.Jarea);

            pars[3] = new SqlParameter("@structure", asd.structure);

            pars[4] = new SqlParameter("@Nature", asd.Nature);

            pars[5] = new SqlParameter("@Sid", asd.Sid);

            pars[6] = new SqlParameter("@Xid", asd.Xid);

            pars[7] = new SqlParameter("@Rid", asd.Rid);

            pars[8] = new SqlParameter("@Hid", asd.Hid);

            pars[9] = new SqlParameter("@Lid", asd.Lid);

            int i = DbHelperSQL.ExecuteNonQuery(DbHelperSQL.ConnB2c, CommandType.StoredProcedure, sql, pars);

            return i;

        }

 

        public int Delete(string id)

        {

            string sql = "up_CommodityDelete";

            SqlParameter ids = new SqlParameter("@id", id);

            SqlParameter tableName = new SqlParameter("@TableName", "Commodity");

            SqlParameter[] pras = new SqlParameter[] {tableName, ids };

            int i = DbHelperSQL.ExecuteNonQuery(DbHelperSQL.ConnB2c, CommandType.StoredProcedure, sql, pras);

            return i;

        }

 

        public int Dels(int id)

        {

            string sql = "up_CommodityDels";

            SqlParameter ids = new SqlParameter("@id", id);

            SqlParameter[] pars = new SqlParameter[] { ids };

            int i = DbHelperSQL.ExecuteNonQuery(DbHelperSQL.ConnB2c, CommandType.StoredProcedure, sql, pars);

            return i;

        }

 

        public PageList<Commodity> FyShowlist(ParaModel model)

        {

            PageList<Commodity> pageList = PageCommon.StoredList<Commodity>(model);

            return pageList;

        }

 

        public List<Housepe> Hshow()

        {

            string sql = "select * from Housepe";

            DataTable dt = DbHelperSQL.ExecuteDataTable(DbHelperSQL.ConnB2c, CommandType.Text, sql, null);

            List<Housepe> list = JsonConvert.DeserializeObject<List<Housepe>>(JsonConvert.SerializeObject(dt));

            return list;

        }

 

        public List<Ridgepole> Rshow()

        {

            string sql = "select * from Ridgepole";

            DataTable dt = DbHelperSQL.ExecuteDataTable(DbHelperSQL.ConnB2c, CommandType.Text, sql, null);

            List<Ridgepole> list = JsonConvert.DeserializeObject<List<Ridgepole>>(JsonConvert.SerializeObject(dt));

            return list;

        }

 

        public List<States> Sshow()

        {

            string sql = "select * from States";

            DataTable dt = DbHelperSQL.ExecuteDataTable(DbHelperSQL.ConnB2c, CommandType.Text, sql, null);

            List<States> list = JsonConvert.DeserializeObject<List<States>>(JsonConvert.SerializeObject(dt));

            return list;

        }

 

        public List<Housing> Xshow()

        {

            string sql = "select * from Housing";

            DataTable dt = DbHelperSQL.ExecuteDataTable(DbHelperSQL.ConnB2c, CommandType.Text, sql, null);

            List<Housing> list = JsonConvert.DeserializeObject<List<Housing>>(JsonConvert.SerializeObject(dt));

            return list;

        }

    }

}