// 建立
public OperationResult <MemberViewModel> Create(MemberMD Data, AuthModel Operator)
{
OperationResult <MemberViewModel> result = new OperationResult <MemberViewModel>();
DynamicParameters pars = new DynamicParameters();
DateTime processTime = DateTime.Now;
result.Type = "Create";
sql = "insert into [SpadesKing].[dbo].[Member] ";
sql += "(Name, IdentityNumber, BirthDay, Phone, Address, Email, LineID, WeChatID, FreeChangingAmount, MemberPwd, ConstructTime, UpdateTime, OperatorID, Integration, LastConsumptionDate) values ";
sql += "(@Name, @IdentityNumber, @BirthDay, @Phone, @Address, @Email, @LineID, @WeChatID, @FreeChangingAmount, @MemberPwd, @ConstructTime, @UpdateTime, @OperatorID, @Integration, @LastConsumptionDate) ";
pars.Add("@Name", Data.Name);
pars.Add("@IdentityNumber", Data.IdentityNumber.ToUpper());
pars.Add("@BirthDay", Data.BirthDay);
pars.Add("@Phone", Data.Phone);
pars.Add("@Address", Data.Address);
pars.Add("@Email", Data.Email);
pars.Add("@LineID", Data.LineID);
pars.Add("@WeChatID", Data.WeChatID);
pars.Add("@FreeChangingAmount", Data.FreeChangingAmount);
pars.Add("@MemberPwd", Data.MemberPwd);
pars.Add("@ConstructTime", processTime);
pars.Add("@UpdateTime", processTime);
pars.Add("@OperatorID", Operator.ID);
pars.Add("@Integration", 0);
pars.Add("@LastConsumptionDate", null);
try
{
using (clsDBDapper db = new clsDBDapper())
{
result.Status = db.ToExecute(sql, pars);
if (!result.Status)
{
throw new Exception("無法新增資料列 (會員)，請聯絡系統管理員");
}
result.Message = "新增成功";
result.Data.Add(GetMemberViewModel(new Member {
Phone = Data.Phone
}));
}
}
catch (Exception ex)
{
result.Status = false;
result.Message = "新增失敗 : " + ex.Message;
result.Data = null;
}
return(result);
}
// 更新
public OperationResult <MemberViewModel> Update(MemberMD Data, AuthModel Operator)
{
OperationResult <MemberViewModel> result = new OperationResult <MemberViewModel>();
DynamicParameters pars = new DynamicParameters();
DateTime processTime = DateTime.Now;
result.Type = "Update";
sql = "update [SpadesKing].[dbo].[Member] set ";
sql += "Name = @Name, IdentityNumber = @IdentityNumber, BirthDay = @BirthDay, Address = @Address, Email = @Email, ";
sql += "LineID = @LineID, WeChatID = @WeChatID, FreeChangingAmount = @FreeChangingAmount, MemberPwd = @MemberPwd, ";
sql += "UpdateTime = @UpdateTime, OperatorID = @OperatorID ";
sql += "where RecordID = @RecordID ";
pars.Add("@Name", Data.Name);
pars.Add("@IdentityNumber", Data.IdentityNumber.ToUpper());
pars.Add("@BirthDay", Data.BirthDay);
pars.Add("@Address", Data.Address);
pars.Add("@Email", Data.Email);
pars.Add("@LineID", Data.LineID);
pars.Add("@WeChatID", Data.WeChatID);
pars.Add("@FreeChangingAmount", Data.FreeChangingAmount);
pars.Add("@MemberPwd", Data.MemberPwd);
pars.Add("@UpdateTime", processTime);
pars.Add("@OperatorID", Operator.ID);
pars.Add("@RecordID", Data.RecordID);
try
{
using (clsDBDapper db = new clsDBDapper())
{
result.Status = db.ToExecute(sql, pars);
if (!result.Status)
{
throw new Exception("無法更新資料列 (會員)，請聯絡系統管理員");
}
result.Message = "更新成功";
result.Data.Add(GetMemberViewModel(Data.RecordID));
}
}
catch (Exception ex)
{
result.Status = false;
result.Message = "更新失敗 : " + ex.Message;
result.Data = null;
}
return(result);
}
// 取得編輯資料
public MemberMD GetMemberMD(long RecordID)
{
MemberMD result = new MemberMD();
DynamicParameters pars = new DynamicParameters();
sql = "select * from [SpadesKing].[dbo].[Member] where RecordID = @RecordID ";
pars.Add("@RecordID", RecordID);
try
{
using (clsDBDapper db = new clsDBDapper())
{
result = db.ToClass <MemberMD>(sql, pars).FirstOrDefault();
}
}
catch (Exception ex)
{
result = null;
}
return(result);
}
// 刪除
public OperationResult <MemberViewModel> Delete(MemberMD Data)
{
OperationResult <MemberViewModel> result = new OperationResult <MemberViewModel>();
DynamicParameters pars = new DynamicParameters();
MemberViewModel member = GetMemberViewModel(Data.RecordID);
string administratorPwd = ConfigurationManager.AppSettings["AdministratorPwd"].Trim();
// 驗證管理者密碼
if (!Data.AdministratorPwd.Equals(administratorPwd))
{
result.Status = false;
result.Message = "刪除失敗 : 管理者密碼錯誤";
result.Data = null;
return(result);
}
// 驗證會員
if (member == null)
{
result.Status = false;
result.Message = "刪除失敗 : 系統錯誤，無法取得會員資料";
result.Data = null;
return(result);
}
// 驗證積分
if (member.Integration > 0)
{
result.Status = false;
result.Message = "刪除失敗 : 會員仍有積分未使用，無法刪除該會員";
result.Data = null;
return(result);
}
result.Type = "Delete";
sql = "delete from [SpadesKing].[dbo].[Member] where RecordID = @RecordID ";
pars.Add("@RecordID", Data.RecordID);
try
{
using (clsDBDapper db = new clsDBDapper())
{
result.Status = db.ToExecute(sql, pars);
if (!result.Status)
{
throw new Exception("資料列無法刪除 (會員)，請聯絡系統管理員");
}
result.Message = "刪除成功";
result.Data.Add(member);
}
}
catch (Exception ex)
{
result.Status = false;
result.Message = "刪除失敗 : " + ex.Message;
result.Data = null;
}
return(result);
}
