public ActionResult Edit(MemberInfo memberInfo)
{
if (memberInfo.MemberID == 0)
{
return Insert(memberInfo);
}
else
{
return Update(memberInfo);
}
}
public ActionResult Insert(MemberInfo memberInfo)
{
try
{
memberInfo.CreatedDate = DateTime.Now;
memberInfo.UpdatedDate = DateTime.Now;
memberInfo.CretaedBy = CurrentUserInfo.UserCode;
memberInfo.UpdatedBy = CurrentUserInfo.UserCode;
IMemberService memberService = UnityHelper.UnityResolve<IMemberService>();
var data = memberService.InsertMember(memberInfo);
LogHelper.LogOperation(CurrentUserInfo.UserCode, string.Format("Insert MemberInfo {0},{1}", LogHelper.ChangeEntityToLog(memberInfo), data));
if (data > 0)
{
return Content("OK");
}
else
{
return Content("Failed");
}
}
catch (BusinessException bex)
{
return Content(bex.Message);
}
catch (Exception ex)
{
LogHelper.LogError(ex, "");
return Content(ex.Message);
}
}
/// <summary>
/// 设置SQL参数表
/// </summary>
/// <param name="Member">Member对象</param>
/// <returns>Member参数数组</returns>
private SqlParameter[] Set_Member_Parameters(MemberInfo memberInfo)
{
SqlParameter[] paramArray = new SqlParameter[] {new SqlParameter("@MemberID",memberInfo.MemberID),
new SqlParameter("@MemberCode",memberInfo.MemberCode),
new SqlParameter("@MemberName",memberInfo.MemberName),
new SqlParameter("@LoginPwd",string.IsNullOrEmpty(memberInfo.LoginPwd)?"":memberInfo.LoginPwd),
new SqlParameter("@PayPwd",string.IsNullOrEmpty(memberInfo.PayPwd)?"":memberInfo.PayPwd),
new SqlParameter("@MemberLevel",string.IsNullOrEmpty(memberInfo.MemberLevel)?"":memberInfo.MemberLevel),
new SqlParameter("@Sex",string.IsNullOrEmpty(memberInfo.Sex)?"":memberInfo.Sex),
new SqlParameter("@Birthday",memberInfo.Birthday),
new SqlParameter("@Age",memberInfo.Age),
new SqlParameter("@Minority",string.IsNullOrEmpty(memberInfo.Minority)?"":memberInfo.Minority),
new SqlParameter("@Trades",string.IsNullOrEmpty(memberInfo.Trades)?"":memberInfo.Trades),
new SqlParameter("@HomeAddress",string.IsNullOrEmpty(memberInfo.HomeAddress)?"":memberInfo.HomeAddress),
new SqlParameter("@PostCode",string.IsNullOrEmpty(memberInfo.PostCode)?"":memberInfo.PostCode),
new SqlParameter("@Email",memberInfo.Email),
new SqlParameter("@OfficePhone",string.IsNullOrEmpty(memberInfo.OfficePhone)?"":memberInfo.OfficePhone),
new SqlParameter("@MobilePhone",memberInfo.MobilePhone),
new SqlParameter("@HomePhone",string.IsNullOrEmpty(memberInfo.HomePhone)?"":memberInfo.HomePhone),
new SqlParameter("@Fax",string.IsNullOrEmpty(memberInfo.Fax)?"":memberInfo.Fax),
new SqlParameter("@QQ",string.IsNullOrEmpty(memberInfo.QQ)?"":memberInfo.QQ),
new SqlParameter("@Msn",string.IsNullOrEmpty(memberInfo.Msn)?"":memberInfo.Msn),
new SqlParameter("@PwdQuestion",string.IsNullOrEmpty(memberInfo.PwdQuestion)?"":memberInfo.PwdQuestion),
new SqlParameter("@PwdAnswer",string.IsNullOrEmpty(memberInfo.PwdAnswer)?"":memberInfo.PwdAnswer),
new SqlParameter("@RegisterDate",memberInfo.RegisterDate),
new SqlParameter("@LastLoginIP",string.IsNullOrEmpty(memberInfo.LastLoginIP)?"":memberInfo.LastLoginIP),
new SqlParameter("@LoginCount",memberInfo.LoginCount),
new SqlParameter("@LastLoginTime",memberInfo.LastLoginTime),
new SqlParameter("@PreDeposits",memberInfo.PreDeposits),
new SqlParameter("@Points",memberInfo.Points),
new SqlParameter("@HoldPreDeposits",memberInfo.HoldPreDeposits),
new SqlParameter("@HoldPoints",memberInfo.HoldPoints),
new SqlParameter("@TotalConsumeMoney",memberInfo.TotalConsumeMoney),
new SqlParameter("@TotalTransCount",memberInfo.TotalTransCount),
new SqlParameter("@IsActive",string.IsNullOrEmpty(memberInfo.IsActive)?"":memberInfo.IsActive),
new SqlParameter("@CretaedBy",string.IsNullOrEmpty(memberInfo.CretaedBy)?"":memberInfo.CretaedBy),
new SqlParameter("@UpdatedBy",string.IsNullOrEmpty(memberInfo.UpdatedBy)?"":memberInfo.UpdatedBy)
};
return paramArray;
}
/// <summary>
/// 初始化MemberInfo
/// </summary>
private MemberInfo InitMemberInfoByDataReader(MemberInfo memberInfo, IDataReader reader)
{
memberInfo = new MemberInfo(reader["MemberID"].ToString() != "" ? Int32.Parse(reader["MemberID"].ToString()) : 0,
reader["MemberCode"].ToString(),
reader["MemberName"].ToString(),
reader["LoginPwd"].ToString(),
reader["PayPwd"].ToString(),
reader["MemberLevel"].ToString(),
reader["Sex"].ToString(),
reader["Birthday"].ToString() != "" ? DateTime.Parse(reader["Birthday"].ToString()) : new DateTime(),
reader["Age"].ToString() != "" ? Int32.Parse(reader["Age"].ToString()) : 0,
reader["Minority"].ToString(),
reader["Trades"].ToString(),
reader["HomeAddress"].ToString(),
reader["PostCode"].ToString(),
reader["Email"].ToString(),
reader["OfficePhone"].ToString(),
reader["MobilePhone"].ToString(),
reader["HomePhone"].ToString(),
reader["Fax"].ToString(),
reader["QQ"].ToString(),
reader["Msn"].ToString(),
reader["PwdQuestion"].ToString(),
reader["PwdAnswer"].ToString(),
reader["RegisterDate"].ToString() != "" ? DateTime.Parse(reader["RegisterDate"].ToString()) : new DateTime(),
reader["LastLoginIP"].ToString(),
reader["LoginCount"].ToString() != "" ? Int32.Parse(reader["LoginCount"].ToString()) : 0,
reader["LastLoginTime"].ToString() != "" ? DateTime.Parse(reader["LastLoginTime"].ToString()) : new DateTime(),
reader["PreDeposits"].ToString() != "" ? Decimal.Parse(reader["PreDeposits"].ToString()) : 0,
reader["Points"].ToString() != "" ? Int32.Parse(reader["Points"].ToString()) : 0,
reader["HoldPreDeposits"].ToString() != "" ? Decimal.Parse(reader["HoldPreDeposits"].ToString()) : 0,
reader["HoldPoints"].ToString() != "" ? Int32.Parse(reader["HoldPoints"].ToString()) : 0,
reader["TotalConsumeMoney"].ToString() != "" ? Decimal.Parse(reader["TotalConsumeMoney"].ToString()) : 0,
reader["TotalTransCount"].ToString() != "" ? Int32.Parse(reader["TotalTransCount"].ToString()) : 0,
reader["IsActive"].ToString(),
reader["CretaedBy"].ToString(),
reader["CreatedDate"].ToString() != "" ? DateTime.Parse(reader["CreatedDate"].ToString()) : new DateTime(),
reader["UpdatedBy"].ToString(),
reader["UpdatedDate"].ToString() != "" ? DateTime.Parse(reader["UpdatedDate"].ToString()) : new DateTime());
return memberInfo;
}
/// <summary>
/// 更新一条Member记录
/// </summary>
/// <param name="db">DataBase对象</param>
/// <param name="tran">一个有效的DbTransaction</param>
/// <param name="member">Member对象</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>执行更新对数据库影响的行数</returns>
public int UpdateMember(Database db, DbTransaction tran, MemberInfo memberInfo)
{
int result = 0;
SqlParameter[] paras = Set_Member_Parameters(memberInfo);
if (paras != null)
{
result += DBHelper.ExecuteNonQuery(db, tran, CommandType.Text, SQL_UPDATE_MEMBER, paras);
}
return result;
}
/// <summary>
/// 新增一条Member记录
/// </summary>
/// <param name="member">Member对象</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>执行新增对数据库影响的行数</returns>
public int InsertMember(MemberInfo memberInfo)
{
int result = 0;
SqlParameter[] paras = Set_Member_Parameters(memberInfo);
if (paras != null)
{
result = DBHelper.ExecuteNonQuery(CommandType.Text, SQL_INSERT_MEMBER, paras);
}
return result;
}
/// <summary>
/// 更新一条Member记录
/// </summary>
/// <param name="member">Member对象</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>执行更新对数据库影响的行数</returns>
public int UpdateMember(MemberInfo memberInfo)
{
return memberDA.UpdateMember(memberInfo);
}
/// <summary>
/// 新增一条Member记录
/// </summary>
/// <param name="member">Member对象</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>执行新增对数据库影响的行数</returns>
public int InsertMember(MemberInfo memberInfo)
{
return memberDA.InsertMember(memberInfo);
}
