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