public ActionResult Edit(AccountEditModel model) { if (bll.Edit(model)) { return Content("<script>alert('修改成功!!!');location.href='/Prepare/AccountEdit/List';</script>"); } else { return Content("<script>alert('修改失败!!!');location.href='/Prepare/AccountEdit/Index';</script>"); } }
public ActionResult Add(AccountEditModel model) { model.AccountId = Code.SiteCache.Instance.LoginInfo.UserId; if (model != null) { if (bll.Add(model)) { return Content("<script>alert('修改成功!!!');location.href='/Prepare/AccountEdit/List';</script>"); } else { return Content("<script>alert('修改失败!!!');location.href='/Prepare/AccountEdit/Index';</script>"); } } else { return Content("<script>alert('数据为空!!!');location.href='/Prepare/AccountEdit/Index';</script>"); } }
public bool Edit(AccountEditModel model) { return dal.Edit(model); }
public bool Add(AccountEditModel model) { return dal.Add(model); }
private void ConvertToModel(IDataReader reader, AccountEditModel model) { if (reader["UserName"] != DBNull.Value) model.UserName = reader["UserName"].ToString(); if (reader["AccountId"] != DBNull.Value) model.AccountId = Convert.ToInt32(reader["AccountId"]); if (reader["Pic"] != DBNull.Value) model.Pic = reader["Pic"].ToString(); if (reader["RealName"] != DBNull.Value) model.RealName = reader["RealName"].ToString(); if (reader["TeacherNo"] != DBNull.Value) model.TeacherNo = reader["TeacherNo"].ToString(); if (reader["Email"] != DBNull.Value) model.Email = reader["Email"].ToString(); if (reader["Sex"] != DBNull.Value) model.Sex = Convert.ToInt32(reader["Sex"]); if (reader["Birthday"] != DBNull.Value) model.Birthday = Convert.ToDateTime(reader["Birthday"]); if (reader["CredentialsNumber"] != DBNull.Value) model.CredentialsNumber = reader["CredentialsNumber"].ToString(); if (reader["Mobile"] != DBNull.Value) model.Mobile = reader["Mobile"].ToString(); if (reader["Nation"] != DBNull.Value) model.Nation = Convert.ToInt32(reader["Nation"]); if (reader["PoliticalStatus"] != DBNull.Value) model.PoliticalStatus = Convert.ToInt32(reader["PoliticalStatus"]); if (reader["Region"] != DBNull.Value) model.Region = reader["Region"].ToString(); if (reader["StudySection"] != DBNull.Value) model.StudySection = reader["StudySection"].ToString(); if (reader["Organ"] != DBNull.Value) model.Organ = reader["Organ"].ToString(); if (reader["Job"] != DBNull.Value) model.Job = reader["Job"].ToString(); if (reader["WorkRank"] != DBNull.Value) model.WorkRank = reader["WorkRank"].ToString(); if (reader["TeachDate"] != DBNull.Value) model.TeachDate = Convert.ToDateTime(reader["TeachDate"]); //if (reader["TeachStudySection"] != DBNull.Value) // model.TeachStudySection = reader["TeachStudySection"].ToString(); //if (reader["TeachSubject"] != DBNull.Value) // model.TeachSubject = reader["TeachSubject"].ToString(); //if (reader["TeachGrade"] != DBNull.Value) // model.TeachGrade = reader["TeachGrade"].ToString(); if (reader["TraningType"] != DBNull.Value) model.TraningType = reader["TraningType"].ToString(); if (reader["TraningObject"] != DBNull.Value) model.TraningObject = reader["TraningObject"].ToString(); if (reader["EduLevel"] != DBNull.Value) model.EduLevel = Convert.ToInt32(reader["EduLevel"]); if (reader["EduDegree"] != DBNull.Value) model.EduDegree = Convert.ToInt32(reader["EduDegree"]); if (reader["EduMajor"] != DBNull.Value) model.EduMajor = Convert.ToInt32(reader["EduMajor"]); //if (reader["EduMajorOhter"] != DBNull.Value) // model.EduMajorOhter = reader["EduMajorOhter"].ToString(); if (reader["GraduateSchool"] != DBNull.Value) model.GraduateSchool = reader["GraduateSchool"].ToString(); if (reader["GraduateTime"] != DBNull.Value) model.GraduateTime = Convert.ToDateTime(reader["GraduateTime"]); }
public bool Edit(AccountEditModel model) { int i = 0; StringBuilder sql = new StringBuilder(); sql.Append(" update Member_Account set Email = @Email,Pic = @Pic,Nickname=@Nickname,OrganId=@OrganId where Id = @AccountId "); SqlParameter[] pame ={ new SqlParameter("@Email",SqlDbType.VarChar), new SqlParameter("@AccountId",SqlDbType.Int), new SqlParameter("@Pic",SqlDbType.VarChar), new SqlParameter("@Nickname",SqlDbType.VarChar), new SqlParameter("@OrganId",SqlDbType.Int) }; pame[0].Value = model.Email; pame[1].Value = model.AccountId; pame[2].Value = model.Pic; pame[3].Value = model.RealName; if (model.Organ == null || model.Organ == "") { pame[4].Value = model.Region; } else { pame[4].Value = model.Organ; } i += MSEntLibSqlHelper.ExecuteNonQueryBySql(sql.ToString(), pame); StringBuilder sb = new StringBuilder(); sb.Append(" update Member_BaseInfo set RealName=@RealName,TeacherNo=@TeacherNo,Mobile=@Mobile,CredentialsNumber=@CredentialsNumber,Sex=@Sex, "); sb.Append(" Birthday=@Birthday,Nation=@Nation,PoliticalStatus=@PoliticalStatus,RegionId=@RegionId,Organid=@Organid,Job=@Job, "); sb.Append(" WorkRank=@WorkRank,TeachDate=@TeachDate,TraningType=@TraningType,TraningObject=@TraningObject,EduLevel=@EduLevel, "); sb.Append(" EduDegree=@EduDegree,EduMajor=@EduMajor,GraduateSchool=@GraduateSchool,GraduateTime=@GraduateTime "); sb.Append(" where AccountId = @AccountId "); SqlParameter[] para ={ new SqlParameter("@AccountId",SqlDbType.Int), new SqlParameter("@Mobile",SqlDbType.VarChar), new SqlParameter("@CredentialsNumber",SqlDbType.VarChar), new SqlParameter("@Sex",SqlDbType.Int), new SqlParameter("@Birthday",SqlDbType.DateTime), new SqlParameter("@Nation",SqlDbType.Int), new SqlParameter("@PoliticalStatus",SqlDbType.Int), new SqlParameter("@RegionId",SqlDbType.Int), new SqlParameter("@Organid",SqlDbType.Int), new SqlParameter("@Job",SqlDbType.Int), new SqlParameter("@WorkRank",SqlDbType.Int), new SqlParameter("@TeachDate",SqlDbType.DateTime), new SqlParameter("@TraningType",SqlDbType.Int), new SqlParameter("@TraningObject",SqlDbType.Int), new SqlParameter("@EduLevel",SqlDbType.Int), new SqlParameter("@EduDegree",SqlDbType.Int), new SqlParameter("@EduMajor",SqlDbType.Int), new SqlParameter("@GraduateSchool",SqlDbType.VarChar), new SqlParameter("@GraduateTime",SqlDbType.DateTime), new SqlParameter("@RealName",SqlDbType.VarChar), new SqlParameter("@TeacherNo",SqlDbType.VarChar) }; para[0].Value = model.AccountId; para[1].Value = model.Mobile; para[2].Value = model.CredentialsNumber; para[3].Value = model.Sex; para[4].Value = model.Birthday; para[5].Value = model.Nation; para[6].Value = model.PoliticalStatus; para[7].Value = model.Region; para[8].Value = model.Organ; para[9].Value = model.Job; para[10].Value = model.WorkRank; para[11].Value = model.TeachDate; para[12].Value = model.TraningType; para[13].Value = model.TraningObject; para[14].Value = model.EduLevel; para[15].Value = model.EduDegree; para[16].Value = model.EduMajor; para[17].Value = model.GraduateSchool; para[18].Value = model.GraduateTime; para[19].Value = model.RealName; para[20].Value = model.TeacherNo; i += MSEntLibSqlHelper.ExecuteNonQueryBySql(sb.ToString(), para); string TeachStudySection = ""; string TeachSubject = ""; string TeachGrade = ""; if (model.TeachStudySection != null && model.TeachStudySection != "") { TeachStudySection = model.TeachStudySection.TrimEnd(','); } if (model.TeachSubject != null && model.TeachSubject != "") { TeachSubject = model.TeachSubject.TrimEnd(','); } if (model.TeachGrade != null && model.TeachGrade != "") { TeachGrade = model.TeachGrade.TrimEnd(','); } StringBuilder SectionDel = new StringBuilder(); SectionDel.Append(" delete from Member_StudySection where AccountId = " + model.AccountId + " "); i += MSEntLibSqlHelper.ExecuteNonQueryBySql(SectionDel.ToString()); string[] src = TeachStudySection.Split(','); for (int k = 0; k < src.Length; k++) { if (src[k] != "" && src[k] != null) { StringBuilder Section = new StringBuilder(); Section.Append(" insert into Member_StudySection (AccountId,StudySection,Delflag,CreateDate) "); Section.Append(" values (" + model.AccountId + "," + src[k] + ",'false','" + DateTime.Now + "') "); i += MSEntLibSqlHelper.ExecuteNonQueryBySql(Section.ToString()); } } StringBuilder SubjectDel = new StringBuilder(); SubjectDel.Append(" delete from Member_TeachSubject where AccountId = " + model.AccountId + " "); i += MSEntLibSqlHelper.ExecuteNonQueryBySql(SubjectDel.ToString()); string[] src1 = TeachSubject.Split(','); for (int k = 0; k < src1.Length; k++) { if (src1[k] != "" && src1[k] != null) { StringBuilder Subject = new StringBuilder(); Subject.Append(" insert into Member_TeachSubject (AccountId,TeachSubject,Delflag,CreateDate) "); Subject.Append(" values (" + model.AccountId + "," + src1[k] + ",'false','" + DateTime.Now + "') "); i += MSEntLibSqlHelper.ExecuteNonQueryBySql(Subject.ToString()); } } StringBuilder GradeDel = new StringBuilder(); GradeDel.Append(" delete from Member_TeachGrade where AccountId = " + model.AccountId + " "); i += MSEntLibSqlHelper.ExecuteNonQueryBySql(GradeDel.ToString()); string[] src2 = TeachGrade.Split(','); for (int k = 0; k < src2.Length; k++) { if (src2[k] != "" && src2[k] != null) { StringBuilder Grade = new StringBuilder(); Grade.Append(" insert into Member_TeachGrade (AccountId,TeachGrade,Delflag,CreateDate) "); Grade.Append(" values (" + model.AccountId + "," + src2[k] + ",'false','" + DateTime.Now + "') "); i += MSEntLibSqlHelper.ExecuteNonQueryBySql(Grade.ToString()); } } if (i > 0) { return true; } else { return false; } }