using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using OT.IDAL;
using DBUtility;//Please add references
using System.Collections.Generic;
namespace OT.SQLServerDAL
{
    /// <summary>
    /// 資料訪問類:OTB_SYS_MembersToRule
    /// </summary>
    public partial class OTB_SYS_MembersToRule : IOTB_SYS_MembersToRule
    {
        public OTB_SYS_MembersToRule()
        { }
        #region  Method
        /// <summary>
        /// 是否存在該記錄
        /// </summary>
        public bool Exists(string MemberID, string RuleID)
        {
            int rowsAffected;
            SqlParameter[] parameters = {
					
					new SqlParameter("@MemberID", SqlDbType.VarChar,50),
					new SqlParameter("@RuleID", SqlDbType.VarChar,20)			};
          
            parameters[0].Value = MemberID;
            parameters[1].Value = RuleID;
            int result = DbHelperSQL.RunProcedure("OSP_OTB_SYS_MembersToRule_Exists", parameters, out rowsAffected);
            if (result == 1)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        ///  增加一條資料
        /// </summary>
        public bool Add(OT.Model.OTB_SYS_MembersToRule model)
        {
            int rowsAffected;
            SqlParameter[] parameters = {
					
					new SqlParameter("@MemberID", SqlDbType.VarChar,50),
					new SqlParameter("@RuleID", SqlDbType.VarChar,20),
					new SqlParameter("@Memo", SqlDbType.Text),
					new SqlParameter("@CreateUser", SqlDbType.VarChar,50),
					new SqlParameter("@CreateDate", SqlDbType.DateTime),
					new SqlParameter("@ModifyUser", SqlDbType.VarChar,50),
					new SqlParameter("@ModifyDate", SqlDbType.DateTime)};
            parameters[0].Value = model.MemberID;
            parameters[1].Value = model.RuleID;
            parameters[2].Value = model.Memo;
            parameters[3].Value = model.CreateUser;
            parameters[4].Value = model.CreateDate;
            parameters[5].Value = model.ModifyUser;
            parameters[6].Value = model.ModifyDate;
            DbHelperSQL.RunProcedure("OSP_OTB_SYS_MembersToRule_ADD", parameters, out rowsAffected);
            if (rowsAffected > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        ///  更新一條資料
        /// </summary>
        public bool Update(OT.Model.OTB_SYS_MembersToRule model)
        {
            int rowsAffected = 0;
            SqlParameter[] parameters = {
					
					new SqlParameter("@MemberID", SqlDbType.VarChar,50),
					new SqlParameter("@RuleID", SqlDbType.VarChar,20),
					new SqlParameter("@Memo", SqlDbType.Text),
					new SqlParameter("@CreateUser", SqlDbType.VarChar,50),
					new SqlParameter("@CreateDate", SqlDbType.DateTime),
					new SqlParameter("@ModifyUser", SqlDbType.VarChar,50),
					new SqlParameter("@ModifyDate", SqlDbType.DateTime)};
           
            parameters[0].Value = model.MemberID;
            parameters[1].Value = model.RuleID;
            parameters[2].Value = model.Memo;
            parameters[3].Value = model.CreateUser;
            parameters[4].Value = model.CreateDate;
            parameters[5].Value = model.ModifyUser;
            parameters[6].Value = model.ModifyDate;

            DbHelperSQL.RunProcedure("OSP_OTB_SYS_MembersToRule_Update", parameters, out rowsAffected);
            if (rowsAffected > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        /// 刪除一條資料
        /// </summary>
        public bool Delete(string MemberID, string RuleID)
        {
            int rowsAffected = 0;
            SqlParameter[] parameters = {
				
					new SqlParameter("@MemberID", SqlDbType.VarChar,50),
					new SqlParameter("@RuleID", SqlDbType.VarChar,20)			};
         
            parameters[0].Value = MemberID;
            parameters[1].Value = RuleID;

            DbHelperSQL.RunProcedure("OSP_OTB_SYS_MembersToRule_Delete", parameters, out rowsAffected);
            if (rowsAffected > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        /// 得到一個對象實體
        /// </summary>
        public OT.Model.OTB_SYS_MembersToRule GetModel(string MemberID, string RuleID)
        {
            SqlParameter[] parameters = {
					
					new SqlParameter("@MemberID", SqlDbType.VarChar,50),
					new SqlParameter("@RuleID", SqlDbType.VarChar,20)			};
            
            parameters[0].Value = MemberID;
            parameters[1].Value = RuleID;

            OT.Model.OTB_SYS_MembersToRule model = new OT.Model.OTB_SYS_MembersToRule();
            DataSet ds = DbHelperSQL.RunProcedure("OSP_OTB_SYS_MembersToRule_GetModel", parameters, "ds");
            if (ds.Tables[0].Rows.Count > 0)
            {
               
                if (ds.Tables[0].Rows[0]["MemberID"] != null && ds.Tables[0].Rows[0]["MemberID"].ToString() != "")
                {
                    model.MemberID = ds.Tables[0].Rows[0]["MemberID"].ToString();
                }
                if (ds.Tables[0].Rows[0]["RuleID"] != null && ds.Tables[0].Rows[0]["RuleID"].ToString() != "")
                {
                    model.RuleID = ds.Tables[0].Rows[0]["RuleID"].ToString();
                }
                if (ds.Tables[0].Rows[0]["Memo"] != null && ds.Tables[0].Rows[0]["Memo"].ToString() != "")
                {
                    model.Memo = ds.Tables[0].Rows[0]["Memo"].ToString();
                }
                if (ds.Tables[0].Rows[0]["CreateUser"] != null && ds.Tables[0].Rows[0]["CreateUser"].ToString() != "")
                {
                    model.CreateUser = ds.Tables[0].Rows[0]["CreateUser"].ToString();
                }
                if (ds.Tables[0].Rows[0]["CreateDate"] != null && ds.Tables[0].Rows[0]["CreateDate"].ToString() != "")
                {
                    model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["ModifyUser"] != null && ds.Tables[0].Rows[0]["ModifyUser"].ToString() != "")
                {
                    model.ModifyUser = ds.Tables[0].Rows[0]["ModifyUser"].ToString();
                }
                if (ds.Tables[0].Rows[0]["ModifyDate"] != null && ds.Tables[0].Rows[0]["ModifyDate"].ToString() != "")
                {
                    model.ModifyDate = DateTime.Parse(ds.Tables[0].Rows[0]["ModifyDate"].ToString());
                }
                return model;
            }
            else
            {
                return null;
            }
        }


        /// <summary>
        /// 獲得資料列表
        /// </summary>
        public DataSet GetList(int StartRecordIndex, int EndRecordIndex, string MemberID, string RuleID, string Name, string SortExpression)
        {
            SqlParameter[] parameters = {
                    new SqlParameter("@StartRecordIndex", SqlDbType.Int)	
					,new SqlParameter("@EndRecordIndex", SqlDbType.Int)	
					,new SqlParameter("@MemberID", SqlDbType.VarChar,50)	
					,new SqlParameter("@RuleID", SqlDbType.VarChar,20) 
                    ,new SqlParameter("@name", SqlDbType.VarChar,20) 
	                ,new SqlParameter("@SortExpression", SqlDbType.NVarChar,500)
                                        };
            parameters[0].Value = StartRecordIndex;
            parameters[1].Value = EndRecordIndex;
            parameters[2].Value = "%" + MemberID + "%";
            parameters[3].Value = "%" + RuleID + "%";
            parameters[4].Value = Name;
            parameters[5].Value = SortExpression;
            return DbHelperSQL.RunProcedure("OSP_OTB_SYS_MembersToRule_GetListByID", parameters, "ds");
        }

        /// <summary>
        /// 獲得資料總筆數
        /// </summary>
        public int GetListCount(string MemberID, string RuleID, string Name)
        {
            SqlParameter[] parameters = {
					new SqlParameter("@MemberID", SqlDbType.VarChar,50)	
					,new SqlParameter("@RuleID", SqlDbType.VarChar,20) 
                    ,new SqlParameter("@name", SqlDbType.VarChar,20) 
                                        };
            parameters[0].Value = "%" + MemberID + "%";
            parameters[1].Value = "%" + RuleID + "%";
            parameters[2].Value = Name;
            return (int)DbHelperSQL.GetSingle("OSP_OTB_SYS_MembersToRule_GetCount", parameters);
        }
        #endregion  Method
    }
}