smssenduserlist.cs

来自「该服务平台解决了计算机网络与移动网络之间信息交换问题」· CS 代码 · 共 43 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

using Microsoft.Practices.EnterpriseLibrary.Common;
using Microsoft.Practices.EnterpriseLibrary.Data;

namespace DataAccess.TableAccessor
{
    public class SMSSendUserList
    {
        private Database db;

        public SMSSendUserList()
        {
            db = DatabaseFactory.CreateDatabase("Connection String");
        }

        public int AddSMSSendUserList(int smsID, int userID)
        {
            String strSql = String.Format("INSERT INTO SMSSendUserList(SMSID, UserID) VALUES ({0},{1})", smsID, userID);
            return db.ExecuteNonQuery(CommandType.Text, strSql);
        }

        public int DeleteSMSSendUser(int smsID)
        {
            String strSql = String.Format("DELETE SMSSendUserList WHERE SMSSendUserID = {0}", smsID);
            return db.ExecuteNonQuery(CommandType.Text, strSql);
        }

        public DataTable GetSendUserInfo(int SMSID)
        {
            String strSql = String.Format("SELECT UserInfo.UserID, Area.AreaName, Corporation.CorporationName, UserInfo.Name, " +
                "UserInfo.Duty, CASE WHEN (Sex) = 0 THEN '男' ELSE '女' END AS Sex, UserInfo.Mobile FROM UserInfo INNER JOIN " +
                "Area ON UserInfo.AreaID = Area.AreaID INNER JOIN SMSSendUserList ON UserInfo.UserID = SMSSendUserList.UserID " +
                "INNER JOIN Corporation ON UserInfo.CountyID = Corporation.CorporationID WHERE (UserInfo.IsValid <> 0) AND " +
                "(SMSSendUserList.SMSID = {0})", SMSID);
            return db.ExecuteDataSet(CommandType.Text, strSql).Tables[0];
        }
    }
}