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;
}
public static SysMember CompanyToMember(SysCompany company)
{
var query = DB.Select().From<SysMember>()
.Where(SysMember.CompanyIdColumn).IsEqualTo(company.Id);
SysMember user = query.ExecuteSingle<SysMember>();
if (user != null)
{
if (user.DirtyColumns.Count > 0)
user.MarkClean();
user.MemberPhoneNumber = company.CompanyTel;
user.MarkOld();
user.MemberEmail = company.CompanyEmail;
user.MemberAddress1 = company.CompanyAddress;
user.MemberCity = company.CompanyCity;
user.MemberLocation = company.CompanyLocation;
user.AreaDepth1 = company.AreaDepth;
user.AreaDepth2 = null;
user.AreaDepth3 = null;
user.AreaModifyDate = null;
user.MemberArea = company.CompanyArea;
user.MemberStatus = company.CompanyStatus;
}
else
{
user = new SysMember();
user.MarkNew();
user.MemberAddress1 = company.CompanyAddress;
user.MemberAddress2 = string.Empty;
user.MemberBalance = 0;
user.MemberBalanceCash = 0;
user.MemberBirthday = null;
user.MemberCity = company.CompanyCity;
user.MemberCompanyID = company.Id;
user.MemberCountry = null;
user.MemberDate = company.CompanyDate;
user.MemberEmail = company.CompanyEmail;
user.MemberFinger = null;
user.MemberFullname = company.CompanyName;
user.MemberGrade = 0;
user.MemberMemo = null;
user.MemberPhoneNumber = company.CompanyTel;
user.MemberPid = 0;
user.MemberPwd = company.CompanyPwd;
user.MemberRoleId = 0;
user.MemberSex = null;
user.MemberState = null;
user.MemberStatus = company.CompanyStatus;
user.MemberSum = 0;
user.MemberZip = null;
user.LastLoginDate = null;
user.LastLoginSubSys = 0;
user.AdminRoleId = 0;
user.CompanyId = company.Id;
user.MemberLocation = company.CompanyLocation;
user.AreaDepth1 = company.AreaDepth;
user.AreaDepth2 = null;
user.AreaDepth3 = null;
user.AreaModifyDate = null;
user.MemberArea = company.CompanyArea;
user.CompanyRoleId = UserBLL.GetDefaultUseRole((int)SubSystem.Company);
}
return user;
}
