DAL/TCWL_D_Services_Z.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_Services_Z
    {
        public bool Add(TCWL_M_Services_Z model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_All_ServiceManagement(");
            builder.Append("Theme,Description,State,ServiceID,ContactInformation,Classificationid,AddUser)");
            builder.Append(" values (");
            builder.Append("@Theme,@Description,@State,@ServiceID,@ContactInformation,@Classificationid,@AddUser)");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@Theme", SqlDbType.NVarChar, 50), new SqlParameter("@Description", SqlDbType.NVarChar, 500), new SqlParameter("@State", SqlDbType.NVarChar, 50), new SqlParameter("@ServiceID", SqlDbType.NVarChar, 50), new SqlParameter("@ContactInformation", SqlDbType.NVarChar, 50), new SqlParameter("@Classificationid", SqlDbType.NVarChar, 50), new SqlParameter("@AddUser", SqlDbType.NVarChar, 50) };
            cmdParms[0].Value = model.Theme;
            cmdParms[1].Value = model.Description;
            cmdParms[2].Value = model.State;
            cmdParms[3].Value = model.ServiceID;
            cmdParms[4].Value = model.ContactInformation;
            cmdParms[5].Value = model.Classificationid;
            cmdParms[6].Value = model.Adduser;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

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

        public DataTable GetListByPage(string strWhere, string orderby, int startIndex, int endIndex, out int total)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("SELECT * FROM ( ");
            builder.Append(" SELECT ROW_NUMBER() OVER (");
            if (!string.IsNullOrEmpty(orderby.Trim()))
            {
                builder.Append("order by T." + orderby);
            }
            else
            {
                builder.Append("order by T.TimeStr desc");
            }
            builder.Append(")AS Row,T.ID,T.Theme,T.Description,CONVERT(varchar(10) , T.TimeStr, 20) as TimeStr,T.Result,CONVERT(varchar(10) , T.TimeEnd, 20) as TimeEnd ,(case T.State when 0 then '未处理' when 1 then '处理中' when '2' then '已处理' end) as State,T.ServiceID,t.ContactInformation,t.Handling,t.ClassificationID,fl.Name from TCWL_All_ServiceManagement T left join TCWL_All_QuestionClassification fl on t.ClassificationID=fl.ID  ");
            if (!string.IsNullOrEmpty(strWhere.Trim()))
            {
                builder.Append(" WHERE " + strWhere);
            }
            builder.Append(" ) TT");
            DataSet set = DBHelper.Query(builder.ToString(), new SqlParameter[0]);