DAL/TCWL_D_StationNews.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_StationNews
    {
        public bool Add(TCWL_M_StationNews model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_StationNews(");
            builder.Append("Title,Sender,Content,Annex,Recipient,SeePeople,Type,RelevantNumber,OrchestrationType,State,ServiceID,Recipient_Name,Seepeople_Name)");
            builder.Append(" values (");
            builder.Append("@Title,@Sender,@Content,@Annex,@Recipient,@SeePeople,@Type,@RelevantNumber,@OrchestrationType,@State,@ServiceID,@Recipient_Name,@Seepeople_Name)");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@Title", SqlDbType.NVarChar, 300), new SqlParameter("@Sender", SqlDbType.NVarChar, 50), new SqlParameter("@Content", SqlDbType.Text), new SqlParameter("@Annex", SqlDbType.NVarChar, 200), new SqlParameter("@Recipient", SqlDbType.NVarChar, 500), new SqlParameter("@SeePeople", SqlDbType.NVarChar, 500), new SqlParameter("@Type", SqlDbType.NVarChar, 2), new SqlParameter("@RelevantNumber", SqlDbType.NVarChar, 50), new SqlParameter("@OrchestrationType", SqlDbType.NVarChar, 50), new SqlParameter("@State", SqlDbType.NVarChar, 1), new SqlParameter("@ServiceID", SqlDbType.NVarChar, 50), new SqlParameter("@Recipient_Name", SqlDbType.NVarChar, 500), new SqlParameter("@Seepeople_Name", SqlDbType.NVarChar, 500) };
            cmdParms[0].Value = model.Title;
            cmdParms[1].Value = model.Sender;
            cmdParms[2].Value = model.Content;
            cmdParms[3].Value = model.Annex;
            cmdParms[4].Value = model.Recipient;
            cmdParms[5].Value = model.SeePeople;
            cmdParms[6].Value = model.Type;
            cmdParms[7].Value = model.RelevantNumber;
            cmdParms[8].Value = model.OrchestrationType;
            cmdParms[9].Value = model.State;
            cmdParms[10].Value = model.ServiceID;
            cmdParms[11].Value = model.Recipient_name;
            cmdParms[12].Value = model.Seepeople_name;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public bool Delete(string ID)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("delete from TCWL_StationNews ");
            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 bool DeleteList(string IDlist)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("delete from TCWL_StationNews ");
            builder.Append(" where ID in (" + IDlist + ")  ");
            return (DBHelper.ExecuteSql(builder.ToString(), new SqlParameter[0]) > 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()))