|
|
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
}}
|
