SysMember SaveMemberData(DataRow row)
{
string phoneNum = Utilities.ToString(row[ORIG_PHONENUMBER]);
SysMember user = UserBLL.GetUserByPhoneNum(phoneNum);
if (user == null)
{
user = new SysMember( );
user.MarkNew( );
foreach (TableSchema.TableColumn col in SysMember.Schema.Columns)
{
if (col.IsReadOnly || col.AutoIncrement || col.IsReservedColumn)
continue;
if (col == SysMember.MemberCompanyIDColumn)
user.SetColumnValue(col.ColumnName, CurrentUser.CompanyId);
else if (col == SysMember.MemberPhoneNumberColumn)
user.SetColumnValue(col.ColumnName, phoneNum);
else if (col == SysMember.MemberDateColumn)
user.SetColumnValue(col.ColumnName, DateTime.Now);
else if (col == SysMember.MemberGradeColumn)
user.SetColumnValue(col.ColumnName, GetMemberGrade(Utilities.ToString(row[ColumnMap[SysCompanyMemberGrade.GradeNameColumn]])));
else if (col == SysMember.MemberRoleIdColumn)
user.SetColumnValue(col.ColumnName, UserBLL.GetDefaultUseRole((int)SubSystem.Member));
else if (col == SysMember.MemberSexColumn)
user.SetColumnValue(col.ColumnName, GetMemberSex(Utilities.ToString(row[ColumnMap[col]])));
else if (ColumnMap.ContainsKey(col))
user.SetColumnValue(col.ColumnName, row[ColumnMap[col]]);
else if (col == SysMember.AdminRoleIdColumn)
user.AdminRoleId = 0;
else if (col == SysMember.CompanyIdColumn)
user.CompanyId = 0;
else if (col == SysMember.CompanyRoleIdColumn)
user.CompanyRoleId = 0;
else if (col == SysMember.MemberStatusColumn)
user.MemberStatus = 1;
else if (col == SysMember.MemberCityColumn)
user.MemberCity = AppContext.Context.Company.CompanyCity;
else if (col == SysMember.MemberAreaColumn)
user.MemberArea = AppContext.Context.Company.CompanyArea;
else if (col == SysMember.MemberLocationColumn)
user.MemberLocation = AppContext.Context.Company.CompanyLocation;
else if (col == SysMember.AreaDepth1Column)
user.AreaDepth1 = AppContext.Context.Company.AreaDepth;
else if (col == SysMember.AreaDepth2Column)
user.AreaDepth2 = null;
else if (col == SysMember.AreaDepth3Column)
user.AreaDepth3 = null;
else if (col == SysMember.AreaModifyDateColumn)
user.AreaModifyDate = null;
else if (col == SysMember.MemberMsnPhoneColumn)
user.MemberMsnPhone = user.MemberPhoneNumber;
else
user.SetColumnValue(col.ColumnName, col.DefaultValue);
}
user.Save( );
}
else
{
user.MarkOld( );
}
return user;
}
protected bool SaveData()
{
SysMember rUser = GetRUser();
int pid = rUser != null ? rUser.Id : 0;
SysMember user = new SysMember
{
MemberAddress1 = string.Empty,
MemberAddress2 = string.Empty,
MemberBalance = 0,
MemberBalanceCash = 0,
MemberBirthday = null,
MemberCompanyID = UserBLL.MainCompanyAccount.Id,
MemberCountry = null,
MemberDate = DateTime.Now,
MemberEmail = null,
MemberFinger = null,
MemberFullname = null,
MemberGrade = 0,
MemberMemo = null,
MemberPhoneNumber = txtMemberPhone.Text.Trim(),
MemberPid = pid,
MemberPwd = Utilities.DESEncrypt(txtMemberPwd1.Text.Trim()),
MemberRoleId = UserBLL.GetDefaultUseRole((int)SubSystem.Member),
MemberSex = null,
MemberState = null,
MemberStatus = 1,
MemberSum = 0,
MemberZip = null,
LastLoginDate = null,
LastLoginSubSys = 0,
AdminRoleId = 0,
CompanyId = 0,
CompanyRoleId = 0,
AreaDepth1 = null,
AreaDepth2 = null,
AreaDepth3 = null,
AreaModifyDate = null,
MemberCity = Utilities.ToInt(AreaSelector.Selector1.GetSelectedValue(0)),
MemberArea = AreaSelector.GetSelectedLocation2(),
MemberLocation = AreaSelector.GetSelectedLocation3(),
ValidateWhenSaving = false,
MemberMsnPhone = txtMemberPhone.Text.Trim()
};
user.Save(0);
//auto login website
SysMember loginUser;
UserBLL.UserLogin(user.Id.ToString(), txtMemberPwd1.Text.Trim(), SubSystem.Member, LoginSystem.Web, out loginUser);
return true;
}
public static void UpdateUserRevenue(SysMember user, decimal dBalance, decimal dBalanceCash, decimal dSum)
{
user.MemberBalance = Convert.ToDecimal(user.MemberBalance) + dBalance;
user.MemberBalanceCash = Convert.ToDecimal(user.MemberBalanceCash) + dBalanceCash;
user.MemberSum = Convert.ToDecimal(user.MemberSum) + dSum;
user.Save( );
if (user.CompanyId > 0)
{
SysCompany company = SysCompany.FetchByID(user.CompanyId);
if (company != null)
{
company.CompanyBalance = Convert.ToDecimal(company.CompanyBalance) + dBalance;
company.CompanyBalanceCash = Convert.ToDecimal(company.CompanyBalanceCash) + dBalanceCash;
company.CompanySaleSum = Convert.ToDecimal(company.CompanySaleSum) + dSum;
company.Save( );
}
}
}
public static SysMember GetOrNewMemberByPhoneNumber(string phoneNumber, SysCompany company, out bool isNew)
{
SysMember user = GetUserByPhoneNum(phoneNumber);
isNew = user == null;
if (isNew)
{
user = new SysMember()
{
MemberPhoneNumber = phoneNumber,
MemberPwd = phoneNumber.Substring(phoneNumber.Length - 6, 6),
MemberAddress1 = null,
MemberAddress2 = null,
MemberBalance = 0,
MemberBalanceCash = 0,
MemberBirthday = null,
MemberCity = 0,
MemberCompanyID = MainAccount.CompanyId,
MemberCountry = "中国",
MemberDate = DateTime.Now,
MemberEmail = null,
MemberFinger = null,
MemberFullname = null,
MemberGrade = 0,
AreaDepth1 = null,
MemberArea = company.CompanyArea,
MemberLocation = company.CompanyLocation,
MemberMemo = null,
MemberPid = -1,
MemberRoleId = 2,
AdminRoleId = 0,
CompanyId = 0,
CompanyRoleId = 0,
MemberSex = null,
MemberState = null,
MemberStatus = 1,
MemberSum = 0,
MemberZip = null,
AreaDepth2 = null,
AreaDepth3 = null,
AreaModifyDate = null,
LastLoginDate = null,
LastLoginSubSys = 0,
};
user.Save();
}
else if (!Utilities.Compare(user.MemberMsnPhone, phoneNumber))
{
user.MemberMsnPhone = phoneNumber;
user.Save();
}
return user;
}
public void Insert(string MemberEmail,string MemberFullname,string MemberPwd,string MemberFinger,string MemberPhoneNumber,int? MemberGrade,string MemberAddress1,string MemberAddress2,string MemberCountry,string MemberState,int? MemberCity,string MemberArea,string MemberLocation,string AreaDepth1,string AreaDepth2,string AreaDepth3,DateTime? AreaModifyDate,string MemberZip,DateTime? MemberDate,decimal? MemberSum,decimal? MemberBalance,decimal? MemberBalanceCash,int? MemberStatus,string MemberMemo,int? MemberPid,int? MemberCompanyID,bool? MemberSex,DateTime? MemberBirthday,int? MemberRoleId,int? CompanyRoleId,int? AdminRoleId,DateTime? LastLoginDate,int? LastLoginSubSys,int? CreatedBy,DateTime? CreatedOn,int? ModifiedBy,DateTime? ModifiedOn,int? CompanyId,string MemberMsnPhone)
{
SysMember item = new SysMember();
item.MemberEmail = MemberEmail;
item.MemberFullname = MemberFullname;
item.MemberPwd = MemberPwd;
item.MemberFinger = MemberFinger;
item.MemberPhoneNumber = MemberPhoneNumber;
item.MemberGrade = MemberGrade;
item.MemberAddress1 = MemberAddress1;
item.MemberAddress2 = MemberAddress2;
item.MemberCountry = MemberCountry;
item.MemberState = MemberState;
item.MemberCity = MemberCity;
item.MemberArea = MemberArea;
item.MemberLocation = MemberLocation;
item.AreaDepth1 = AreaDepth1;
item.AreaDepth2 = AreaDepth2;
item.AreaDepth3 = AreaDepth3;
item.AreaModifyDate = AreaModifyDate;
item.MemberZip = MemberZip;
item.MemberDate = MemberDate;
item.MemberSum = MemberSum;
item.MemberBalance = MemberBalance;
item.MemberBalanceCash = MemberBalanceCash;
item.MemberStatus = MemberStatus;
item.MemberMemo = MemberMemo;
item.MemberPid = MemberPid;
item.MemberCompanyID = MemberCompanyID;
item.MemberSex = MemberSex;
item.MemberBirthday = MemberBirthday;
item.MemberRoleId = MemberRoleId;
item.CompanyRoleId = CompanyRoleId;
item.AdminRoleId = AdminRoleId;
item.LastLoginDate = LastLoginDate;
item.LastLoginSubSys = LastLoginSubSys;
item.CreatedBy = CreatedBy;
item.CreatedOn = CreatedOn;
item.ModifiedBy = ModifiedBy;
item.ModifiedOn = ModifiedOn;
item.CompanyId = CompanyId;
item.MemberMsnPhone = MemberMsnPhone;
item.Save(UserName);
}
