public int AddMemberBaseInfo(MemberBaseInfo model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into [dbo].[Member_BaseInfo] ([AccountId],[TeacherNo],[GroupId],[RealName],[Mobile],[Phone],[Address],[PostCode],[CredentialsType],[CredentialsNumber],[Sex],[Birthday],[Nation],[PoliticalStatus],[Delflag],[CreateDate],[RegionId],[StudySection],[Organid],[Job],[WorkRank],[TeachDate],[TeachStudySection],[TeachSubject],[TeachGrade],[TraningType],[TraningObject],[EduLevel],[EduDegree],[EduMajor],[EduMajorOhter],[GraduateSchool],[GraduateTime])");
sql.Append(" values (@AccountId,@TeacherNo,@GroupId,@RealName,@Mobile,@Phone,@Address,@PostCode,@CredentialsType,@CredentialsNumber,@Sex,@Birthday,@Nation,@PoliticalStatus,@Delflag,@CreateDate,@RegionId,@StudySection,@Organid,@Job,@WorkRank,@TeachDate,@TeachStudySection,@TeachSubject,@TeachGrade,@TraningType,@TraningObject,@EduLevel,@EduDegree,@EduMajor,@EduMajorOhter,@GraduateSchool,@GraduateTime)");
sql.Append(" set @Id=@@IDENTITY");
SqlParameter[] cmdParams = new SqlParameter[]{
new SqlParameter("@Id", SqlDbType.Int, 4) { Value = model.Id, Direction = ParameterDirection.Output },
new SqlParameter("@AccountId", SqlDbType.Int, 4) { Value = model.AccountId },
new SqlParameter("@TeacherNo", SqlDbType.VarChar, 100) { Value = model.TeacherNo },
new SqlParameter("@GroupId", SqlDbType.Int, 4) { Value = model.GroupId },
new SqlParameter("@RealName", SqlDbType.VarChar, 120) { Value = model.RealName },
new SqlParameter("@Mobile", SqlDbType.VarChar, 30) { Value = model.Mobile },
new SqlParameter("@Phone", SqlDbType.VarChar, 30) { Value = model.Phone },
new SqlParameter("@Address", SqlDbType.VarChar, 300) { Value = model.Address },
new SqlParameter("@PostCode", SqlDbType.VarChar, 50) { Value = model.PostCode },
new SqlParameter("@CredentialsType", SqlDbType.Int, 4) { Value = model.CredentialsType },
new SqlParameter("@CredentialsNumber", SqlDbType.VarChar, 30) { Value = model.CredentialsNumber },
new SqlParameter("@Sex", SqlDbType.Int, 4) { Value = model.Sex },
new SqlParameter("@Birthday", SqlDbType.DateTime, 8) { Value = model.Birthday },
new SqlParameter("@Nation", SqlDbType.Int, 4) { Value = model.Nation },
new SqlParameter("@PoliticalStatus", SqlDbType.Int, 4) { Value = model.PoliticalStatus },
new SqlParameter("@Delflag", SqlDbType.Bit, 1) { Value = model.Delflag },
new SqlParameter("@CreateDate", SqlDbType.DateTime, 8) { Value = model.CreateDate },
new SqlParameter("@RegionId", SqlDbType.Int, 4) { Value = model.RegionId },
new SqlParameter("@StudySection", SqlDbType.VarChar, 200) { Value = model.StudySection },
new SqlParameter("@Organid", SqlDbType.Int, 4) { Value = model.Organid },
new SqlParameter("@Job", SqlDbType.Int, 4) { Value = model.Job },
new SqlParameter("@WorkRank", SqlDbType.Int, 4) { Value = model.WorkRank },
new SqlParameter("@TeachDate", SqlDbType.DateTime, 8) { Value = model.TeachDate },
new SqlParameter("@TeachStudySection", SqlDbType.VarChar, 200) { Value = model.TeachStudySection },
new SqlParameter("@TeachSubject", SqlDbType.VarChar, 200) { Value = model.TeachSubject },
new SqlParameter("@TeachGrade", SqlDbType.VarChar, 200) { Value = model.TeachGrade },
new SqlParameter("@TraningType", SqlDbType.Int, 4) { Value = model.TraningType },
new SqlParameter("@TraningObject", SqlDbType.Int, 4) { Value = model.TraningObject },
new SqlParameter("@EduLevel", SqlDbType.Int, 4) { Value = model.EduLevel },
new SqlParameter("@EduDegree", SqlDbType.Int, 4) { Value = model.EduDegree },
new SqlParameter("@EduMajor", SqlDbType.Int, 4) { Value = model.EduMajor },
new SqlParameter("@EduMajorOhter", SqlDbType.VarChar, 200) { Value = model.EduMajorOhter },
new SqlParameter("@GraduateSchool", SqlDbType.VarChar, 200) { Value = model.GraduateSchool },
new SqlParameter("@GraduateTime", SqlDbType.DateTime, 8) { Value = model.GraduateTime }
};
int result = Convert.ToInt32(MSEntLibSqlHelper.ExecuteNonQueryBySql(sql.ToString(), cmdParams));
model.Id = Convert.ToInt32(cmdParams[0].Value);
return result;
}
private MemberBaseInfo ToMemberBaseInfo(CBK_SHERC_USERINFO model)
{
APIBLL api = new APIBLL();
MemberBaseInfo info = new MemberBaseInfo();
info.TeacherNo = model.TEACHNUMBER;
info.RealName = model.REALNAME;
if (!string.IsNullOrEmpty(model.TELE))
{
if (model.TELE.Split('@').Length == 2)
{
info.Mobile = model.TELE.Split('@')[1];
info.Phone = model.TELE.Split('@')[0];
}
else
{
info.Mobile = "";
info.Phone = "";
}
}
else
{
info.Mobile = "";
info.Phone = "";
}
info.Address = string.IsNullOrEmpty(model.ADDRESS) ? "" : model.ADDRESS;
info.PostCode = model.POST;
info.CredentialsType = 57;
info.CredentialsNumber = model.IDCARD;
if (model.SEX == "男")
info.Sex = 1;
else
info.Sex = 0;
if (string.IsNullOrEmpty(model.BIRTHDAY))
info.Birthday = new DateTime(1900, 1, 1);
else
info.Birthday = Convert.ToDateTime(model.BIRTHDAY);
string nation = model.NATIONALID == null ? "" : model.NATIONALID.ToString();
nation = api.ConvertKey("Nation", nation);
if (!string.IsNullOrEmpty(nation))
info.Nation = Convert.ToInt32(nation);
else
info.Nation = 0;
string political = model.POLITICSID == null ? "" : model.POLITICSID.ToString();
political = api.ConvertKey("Political", political);
if (!string.IsNullOrEmpty(political))
info.PoliticalStatus = Convert.ToInt32(political);
else
info.PoliticalStatus = 0;
string region = model.QUXIANID == null ? "" : model.QUXIANID.ToString();//RegionId是区县Id
region = api.ConvertKey("Organ", region);
if (!string.IsNullOrEmpty(region))
info.RegionId = Convert.ToInt32(region);
else
info.RegionId = 0;
string organ = model.SCHOOLID == null ? "" : model.SCHOOLID.ToString();
organ = api.ConvertKey("Organ", organ);
if (!string.IsNullOrEmpty(organ))
info.Organid = Convert.ToInt32(organ);
else
info.Organid = 0;
info.StudySection = model.XUEDUANID;
info.TraningObject = model.TrainingObjectID;
info.EduLevel = model.XUELIID;
info.EduDegree = model.XUEWEIID;
info.EduMajor = model.ZYDM;
info.GraduateSchool = model.SchoolTag;
info.GraduateTime = model.TIMESOFGRADUATE;
info.CreateDate = DateTime.Now;
return info;
}
public int UpdateMemberBaseInfo(MemberBaseInfo model)
{
StringBuilder sql = new StringBuilder();
sql.Append("update [dbo].[Member_BaseInfo] set ");
sql.Append("[TeacherNo]=@TeacherNo,[GroupId]=@GroupId,[RealName]=@RealName,[Mobile]=@Mobile,[Phone]=@Phone,[Address]=@Address,[PostCode]=@PostCode,[CredentialsType]=@CredentialsType,[CredentialsNumber]=@CredentialsNumber,[Sex]=@Sex,[Birthday]=@Birthday,[Nation]=@Nation,[PoliticalStatus]=@PoliticalStatus,[Delflag]=@Delflag,[CreateDate]=@CreateDate,[RegionId]=@RegionId,[StudySection]=@StudySection,[Organid]=@Organid,[Job]=@Job,[WorkRank]=@WorkRank,[TeachDate]=@TeachDate,[TeachStudySection]=@TeachStudySection,[TeachSubject]=@TeachSubject,[TeachGrade]=@TeachGrade,[TraningType]=@TraningType,[TraningObject]=@TraningObject,[EduLevel]=@EduLevel,[EduDegree]=@EduDegree,[EduMajor]=@EduMajor,[EduMajorOhter]=@EduMajorOhter,[GraduateSchool]=@GraduateSchool,[GraduateTime]=@GraduateTime");
sql.Append(" where [AccountId]=@AccountId");
SqlParameter[] cmdParams = new SqlParameter[] {
new SqlParameter("@Id", SqlDbType.Int, 4) { Value = model.Id },
new SqlParameter("@AccountId", SqlDbType.Int, 4) { Value = model.AccountId },
new SqlParameter("@TeacherNo", SqlDbType.VarChar, 100) { Value = model.TeacherNo },
new SqlParameter("@GroupId", SqlDbType.Int, 4) { Value = model.GroupId },
new SqlParameter("@RealName", SqlDbType.VarChar, 120) { Value = model.RealName },
new SqlParameter("@Mobile", SqlDbType.VarChar, 30) { Value = model.Mobile },
new SqlParameter("@Phone", SqlDbType.VarChar, 30) { Value = model.Phone },
new SqlParameter("@Address", SqlDbType.VarChar, 300) { Value = model.Address },
new SqlParameter("@PostCode", SqlDbType.VarChar, 50) { Value = model.PostCode },
new SqlParameter("@CredentialsType", SqlDbType.Int, 4) { Value = model.CredentialsType },
new SqlParameter("@CredentialsNumber", SqlDbType.VarChar, 30) { Value = model.CredentialsNumber },
new SqlParameter("@Sex", SqlDbType.Int, 4) { Value = model.Sex },
new SqlParameter("@Birthday", SqlDbType.DateTime, 8) { Value = model.Birthday },
new SqlParameter("@Nation", SqlDbType.Int, 4) { Value = model.Nation },
new SqlParameter("@PoliticalStatus", SqlDbType.Int, 4) { Value = model.PoliticalStatus },
new SqlParameter("@Delflag", SqlDbType.Bit, 1) { Value = model.Delflag },
new SqlParameter("@CreateDate", SqlDbType.DateTime, 8) { Value = model.CreateDate },
new SqlParameter("@RegionId", SqlDbType.Int, 4) { Value = model.RegionId },
new SqlParameter("@StudySection", SqlDbType.VarChar, 200) { Value = model.StudySection },
new SqlParameter("@Organid", SqlDbType.Int, 4) { Value = model.Organid },
new SqlParameter("@Job", SqlDbType.Int, 4) { Value = model.Job },
new SqlParameter("@WorkRank", SqlDbType.Int, 4) { Value = model.WorkRank },
new SqlParameter("@TeachDate", SqlDbType.DateTime, 8) { Value = model.TeachDate },
new SqlParameter("@TeachStudySection", SqlDbType.VarChar, 200) { Value = model.TeachStudySection },
new SqlParameter("@TeachSubject", SqlDbType.VarChar, 200) { Value = model.TeachSubject },
new SqlParameter("@TeachGrade", SqlDbType.VarChar, 200) { Value = model.TeachGrade },
new SqlParameter("@TraningType", SqlDbType.Int, 4) { Value = model.TraningType },
new SqlParameter("@TraningObject", SqlDbType.Int, 4) { Value = model.TraningObject },
new SqlParameter("@EduLevel", SqlDbType.Int, 4) { Value = model.EduLevel },
new SqlParameter("@EduDegree", SqlDbType.Int, 4) { Value = model.EduDegree },
new SqlParameter("@EduMajor", SqlDbType.Int, 4) { Value = model.EduMajor },
new SqlParameter("@EduMajorOhter", SqlDbType.VarChar, 200) { Value = model.EduMajorOhter },
new SqlParameter("@GraduateSchool", SqlDbType.VarChar, 200) { Value = model.GraduateSchool },
new SqlParameter("@GraduateTime", SqlDbType.DateTime, 8) { Value = model.GraduateTime }
};
return MSEntLibSqlHelper.ExecuteNonQueryBySql(sql.ToString(), cmdParams);
}
public bool AddMemberBaseInfo(MemberBaseInfo model)
{
return dal.AddMemberBaseInfo(model) > 0;
}
public bool UpdateMemberBaseInfo(MemberBaseInfo model)
{
return dal.UpdateMemberBaseInfo(model) > 0;
}
