java中如何调用dal接口案例_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

{

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 FyShowlist(ParaModel model)

{

PageList pageList = PageCommon.StoredList(model);

return pageList;

}

public List Hshow()

{

string sql = "select * from Housepe";

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

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

return list;

}

public List Rshow()

{

string sql = "select * from Ridgepole";

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

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

return list;

}

public List Sshow()

{

string sql = "select * from States";

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

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

return list;

}

public List Xshow()

{

string sql = "select * from Housing";

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

List list = JsonConvert.DeserializeObject>(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

{

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 FyShowlist(ParaModel model)

{

PageList pageList = PageCommon.StoredList(model);

return pageList;

}

public List Hshow()

{

string sql = "select * from Housepe";

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

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

return list;

}

public List Rshow()

{

string sql = "select * from Ridgepole";

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

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

return list;

}

public List Sshow()

{

string sql = "select * from States";

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

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

return list;

}

public List Xshow()

{

string sql = "select * from Housing";

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

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

return list;

}

}

}