You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
230 lines
8.6 KiB
230 lines
8.6 KiB
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
|
|
}
|
|
}
|
|
|