DAL/TCWL_D_LocationSet.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

namespace DAL
{
    using Common;
    using Model;
    using System;
    using System.Data;
    using System.Data.SqlClient;
    using System.Runtime.InteropServices;
    using System.Text;

    public class TCWL_D_LocationSet
    {
        public bool Add(TCWL_M_LocationSet model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_LocationSet(");
            builder.Append("LocName,locDistrict,AddUser,locCdn,reMark,ServiceID,locDistance)");
            builder.Append(" values (");
            builder.Append("@LocName,@locDistrict,@AddUser,@locCdn,@reMark,@ServiceID,@locDistance)");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@LocName", SqlDbType.NVarChar, 50), new SqlParameter("@locDistrict", SqlDbType.NVarChar, 100), new SqlParameter("@AddUser", SqlDbType.NVarChar, 0x24), new SqlParameter("@locCdn", SqlDbType.VarChar, 100), new SqlParameter("@reMark", SqlDbType.NVarChar, 100), new SqlParameter("@ServiceID", SqlDbType.VarChar, 50), new SqlParameter("@locDistance", SqlDbType.Int, 4) };
            cmdParms[0].Value = model.LocName;
            cmdParms[1].Value = model.locDistrict;
            cmdParms[2].Value = model.AddUser;
            cmdParms[3].Value = model.locCdn;
            cmdParms[4].Value = model.reMark;
            cmdParms[5].Value = model.ServiceID;
            cmdParms[6].Value = model.locDistance;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public bool Delete(string ID)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("delete from TCWL_LocationSet ");
            builder.Append(" where ID=@ID ");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.VarChar, 0x24) };
            cmdParms[0].Value = ID;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public DataTable GetListByID(string ID)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("select ID,LocName,locDistrict,locCdn,reMark,locDistance ");
            builder.Append(" FROM TCWL_LocationSet where ID='" + ID + "'");
            return DBHelper.Query(builder.ToString(), new SqlParameter[0]).Tables[0];
        }

        public DataTable GetListByPage(string strWhere, int startIndex, int endIndex, out int total)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("SELECT * FROM ( ");
            builder.Append(" SELECT ROW_NUMBER() OVER (order by T.ID desc) AS Row, T.ID,T.LocName,T.locDistrict,T.locCdn,T.reMark,T.locDistance from TCWL_LocationSet T ");
            if (!string.IsNullOrEmpty(strWhere.Trim()))
            {
                builder.Append(" WHERE " + strWhere);
            }
            builder.Append(" ) TT");
            DataSet set = DBHelper.Query(builder.ToString(), new SqlParameter[0]);
            total = set.Tables[0].Rows.Count;