private void ConvertToModelTo(IDataReader reader, AccountEdit 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["RegionId"] != DBNull.Value)
model.Region = Convert.ToInt32(reader["RegionId"]);
if (reader["OrganId"] != DBNull.Value)
model.Organ = Convert.ToInt32(reader["OrganId"]);
if (reader["Job"] != DBNull.Value)
model.Job = Convert.ToInt32(reader["Job"]);
if (reader["WorkRank"] != DBNull.Value)
model.WorkRank = Convert.ToInt32(reader["WorkRank"]);
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 = Convert.ToInt32(reader["TraningType"]);
if (reader["TraningObject"] != DBNull.Value)
model.TraningObject = Convert.ToInt32(reader["TraningObject"]);
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 ActionResult Index()
{
int AccountId = Code.SiteCache.Instance.LoginInfo.UserId;
DataTable Nationdt = bll.GetNation(1);
DataTable Politicaldt = bll.GetNation(3);
DataTable EduLeveldt = bll.GetNation(4);
DataTable EduDegreedt = bll.GetNation(5);
DataTable EduMajordt = bll.GetNation(6);
DataTable Jobdt = bll.GetTraning_InfoFk(10);
DataTable Regindt = bll.GetOutRegin(5, 4);
DataTable WorkRankdt = bll.GetTraning_InfoFk(8);
DataTable TeachStudySectiondt = bll.GetTraning_InfoFk(4);
DataTable TeachSubjectdt = bll.GetTraning_InfoFk(3);
DataTable TeachGradedt = bll.GetTraning_InfoFk(7);
DataTable TraningTypedt = bll.GetTraning_InfoFk(5);
DataTable TraningObjectdt = bll.GetTraning_InfoFk(2);
List<SelectListItem> Nation = new List<SelectListItem>();
List<SelectListItem> Political = new List<SelectListItem>();
List<SelectListItem> EduLevel = new List<SelectListItem>();
List<SelectListItem> EduDegree = new List<SelectListItem>();
List<SelectListItem> EduMajor = new List<SelectListItem>();
List<SelectListItem> Regin = new List<SelectListItem>();
List<SelectListItem> Job = new List<SelectListItem>();
List<SelectListItem> WorkRank = new List<SelectListItem>();
List<SelectListItem> TraningType = new List<SelectListItem>();
List<SelectListItem> TraningObject = new List<SelectListItem>();
for (int i = 0; i < Nationdt.Rows.Count; i++)
{
SelectListItem item = new SelectListItem();
item.Text = Nationdt.Rows[i][1].ToString();
item.Value = Nationdt.Rows[i][0].ToString();
Nation.Add(item);
}
for (int i = 0; i < Politicaldt.Rows.Count; i++)
{
SelectListItem item = new SelectListItem();
item.Text = Politicaldt.Rows[i][1].ToString();
item.Value = Politicaldt.Rows[i][0].ToString();
Political.Add(item);
}
for (int i = 0; i < EduLeveldt.Rows.Count; i++)
{
SelectListItem item = new SelectListItem();
item.Text = EduLeveldt.Rows[i][1].ToString();
item.Value = EduLeveldt.Rows[i][0].ToString();
EduLevel.Add(item);
}
for (int i = 0; i < EduDegreedt.Rows.Count; i++)
{
SelectListItem item = new SelectListItem();
item.Text = EduDegreedt.Rows[i][1].ToString();
item.Value = EduDegreedt.Rows[i][0].ToString();
EduDegree.Add(item);
}
for (int i = 0; i < EduMajordt.Rows.Count; i++)
{
SelectListItem item = new SelectListItem();
item.Text = EduMajordt.Rows[i][1].ToString();
item.Value = EduMajordt.Rows[i][0].ToString();
EduMajor.Add(item);
}
for (int i = 0; i < Regindt.Rows.Count; i++)
{
SelectListItem item = new SelectListItem();
item.Text = Regindt.Rows[i][1].ToString();
item.Value = Regindt.Rows[i][0].ToString();
Regin.Add(item);
}
for (int i = 0; i < Jobdt.Rows.Count; i++)
{
SelectListItem item = new SelectListItem();
item.Text = Jobdt.Rows[i][1].ToString();
item.Value = Jobdt.Rows[i][0].ToString();
Job.Add(item);
}
for (int i = 0; i < WorkRankdt.Rows.Count; i++)
{
SelectListItem item = new SelectListItem();
item.Text = WorkRankdt.Rows[i][1].ToString();
item.Value = WorkRankdt.Rows[i][0].ToString();
WorkRank.Add(item);
}
for (int i = 0; i < TraningTypedt.Rows.Count; i++)
{
SelectListItem item = new SelectListItem();
item.Text = TraningTypedt.Rows[i][1].ToString();
item.Value = TraningTypedt.Rows[i][0].ToString();
TraningType.Add(item);
}
for (int i = 0; i < TraningObjectdt.Rows.Count; i++)
{
SelectListItem item = new SelectListItem();
item.Text = TraningObjectdt.Rows[i][1].ToString();
item.Value = TraningObjectdt.Rows[i][0].ToString();
TraningObject.Add(item);
}
ViewData["NationList"] = Nation;
ViewData["PoliticalList"] = Political;
ViewData["EduLevelList"] = EduLevel;
ViewData["EduDegreeList"] = EduDegree;
ViewData["EduMajorList"] = EduMajor;
ViewData["ReginList"] = Regin;
ViewData["OrganList"] = Regin;
ViewData["JobList"] = Job;
ViewData["WorkRankList"] = WorkRank;
ViewData["TeachStudySectiondt"] = TeachStudySectiondt;
ViewData["TeachSubjectdt"] = TeachSubjectdt;
ViewData["TeachGradedt"] = TeachGradedt;
ViewData["TraningTypeList"] = TraningType;
ViewData["TraningObjectList"] = TraningObject;
AccountEdit model = bll.GetModel(AccountId);
ViewData["UserName"] = Code.SiteCache.Instance.UserName.ToString();
ViewData["Email"] = bll.GetEmail(AccountId);
ViewData["Region"] = bll.GetAccountOrgan(AccountId).Rows[0][1];
ViewData["OrganId"] = bll.GetAccountOrgan(AccountId).Rows[0][0];
if (bll.GetAccountCount(Code.SiteCache.Instance.LoginInfo.UserId) == 0)
{
if(model==null)
{
model = new AccountEdit();
}
ViewData["Type"] = "Add";
}
else
{
ViewData["Type"] = "Edit";
model.TeachStudySection = bll.TeachStudySection(model.AccountId);
model.TeachSubject = bll.TeachSubject(model.AccountId);
model.TeachGrade = bll.TeachGrade(model.AccountId);
ViewData["Nation"] = model.Nation;
ViewData["PoliticalStatus"] = model.PoliticalStatus;
ViewData["EduLevel"] = model.EduLevel;
ViewData["EduDegree"] = model.EduDegree;
ViewData["EduMajor"] = model.EduMajor;
ViewData["Sex"] = model.Sex;
ViewData["Job"] = model.Job;
ViewData["WorkRank"] = model.WorkRank;
ViewData["TeachStudySection"] = model.TeachStudySection;
ViewData["TeachSubject"] = model.TeachSubject;
ViewData["TeachGrade"] = model.TeachGrade;
ViewData["TraningType"] = model.TraningType;
ViewData["TraningObject"] = model.TraningObject;
}
return View(model);
}
public AccountEdit GetModel(int AccountId)
{
List<AccountEditModel> list = new List<AccountEditModel>();
StringBuilder sql = new StringBuilder();
sql.Append(" select a.UserName,a.Pic,b.RealName,b.AccountId,b.TeacherNo,a.Email,b.Sex,b.Birthday, ");
sql.Append(" b.CredentialsNumber,b.Mobile,b.Nation,b.PoliticalStatus, ");
sql.Append(" (select ParentId from Organ_Detail where Id = a.OrganId) as RegionId,a.OrganId,b.Job, ");
sql.Append(" b.WorkRank,b.TeachDate,b.TraningType,b.TraningObject, ");
sql.Append(" b.EduLevel,b.EduDegree,b.EduMajor, ");
sql.Append(" GraduateSchool,GraduateTime ");
sql.Append(" from dbo.Member_Account a ");
sql.Append(" left join dbo.Member_BaseInfo b on a.Id=b.AccountId ");
sql.Append(" where a.id = " + AccountId + " and b.Delflag = 'false' ");
IDataReader dr = MSEntLibSqlHelper.ExecuteDataReaderBySql(sql.ToString());
if (dr.Read())
{
AccountEdit model = new AccountEdit();
ConvertToModelTo(dr, model);
return model;
}
else
{
return null;
}
}