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