public int InsertStudentsPersonalInformation(StudentsPersonalInformationModel studentspersonalinformationModel)
{
int count = 0;
string sql = string.Format("insert into GP_Students_Personal_Information (id,name,real_name,sex,age,datebirth,"
+ "minzu,province,city,area,detail_address,id_number,telephon,mail,bk_school,bk_major,graduation_time,"
+ "high_education,high_school,high_major,high_education_time,identity_type,send_unit,training_base_province_code,"
+ "training_base_province_name,training_base_code,training_base_name,collaborative_unit,"
+ "professional_base_code,professional_base_name,training_time,plan_training_time,writor,register_date,urgent,urgent_telephon,image_path,province_code,city_code,area_code) values(@id,@name,@real_name,@sex,@age,@datebirth,"
+ "@minzu,@province,@city,@area,@detail_address,@id_number,@telephon,@mail,@bk_school,@bk_major,@graduation_time,"
+ "@high_education,@high_school,@high_major,@high_education_time,@identity_type,@send_unit,@training_base_province_code,"
+ "@training_base_province_name,@training_base_code,@training_base_name,@collaborative_unit,"
+ "@professional_base_code,@professional_base_name,@training_time,@plan_training_time,@writor,@register_date,@urgent,@urgent_telephon,@image_path,@province_code,@city_code,@area_code)");
SqlParameter[] prams = { db.MakeInParam("@id", SqlDbType.NVarChar, 50, studentspersonalinformationModel.id),
db.MakeInParam("@name", SqlDbType.NVarChar, 50, studentspersonalinformationModel.name),
db.MakeInParam("@real_name", SqlDbType.NVarChar, 50, studentspersonalinformationModel.real_name),
db.MakeInParam("@sex", SqlDbType.NVarChar, 50, studentspersonalinformationModel.sex),
db.MakeInParam("@age", SqlDbType.NVarChar, 50, studentspersonalinformationModel.age),
db.MakeInParam("@datebirth", SqlDbType.NVarChar, 50, studentspersonalinformationModel.datebirth),
db.MakeInParam("@minzu", SqlDbType.NVarChar, 50, studentspersonalinformationModel.minzu),
db.MakeInParam("@province", SqlDbType.NVarChar, 50, studentspersonalinformationModel.province),
db.MakeInParam("@city", SqlDbType.NVarChar, 50, studentspersonalinformationModel.city),
db.MakeInParam("@area", SqlDbType.NVarChar, 50, studentspersonalinformationModel.area),
db.MakeInParam("@detail_address", SqlDbType.NVarChar, 500, studentspersonalinformationModel.detail_address),
db.MakeInParam("@id_number", SqlDbType.NVarChar, 50, studentspersonalinformationModel.id_number),
db.MakeInParam("@telephon", SqlDbType.NVarChar, 50, studentspersonalinformationModel.telephon),
db.MakeInParam("@mail", SqlDbType.NVarChar, 50, studentspersonalinformationModel.mail),
db.MakeInParam("@bk_school", SqlDbType.NVarChar, 50, studentspersonalinformationModel.bk_school),
db.MakeInParam("@bk_major", SqlDbType.NVarChar, 50, studentspersonalinformationModel.bk_major),
db.MakeInParam("@graduation_time", SqlDbType.NVarChar, 50, studentspersonalinformationModel.graduation_time),
db.MakeInParam("@high_education", SqlDbType.NVarChar, 50, studentspersonalinformationModel.high_education),
db.MakeInParam("@high_school", SqlDbType.NVarChar, 50, studentspersonalinformationModel.high_school),
db.MakeInParam("@high_major", SqlDbType.NVarChar, 50, studentspersonalinformationModel.high_major),
db.MakeInParam("@high_education_time", SqlDbType.NVarChar, 50, studentspersonalinformationModel.high_education_time),
db.MakeInParam("@identity_type", SqlDbType.NVarChar, 50, studentspersonalinformationModel.identity_type),
db.MakeInParam("@send_unit", SqlDbType.NVarChar, 50, studentspersonalinformationModel.send_unit),
db.MakeInParam("@training_base_province_code", SqlDbType.NVarChar, 50, studentspersonalinformationModel.training_base_province_code),
db.MakeInParam("@training_base_province_name", SqlDbType.NVarChar, 50, studentspersonalinformationModel.training_base_province_name),
db.MakeInParam("@training_base_code", SqlDbType.NVarChar, 50, studentspersonalinformationModel.training_base_code),
db.MakeInParam("@training_base_name", SqlDbType.NVarChar, 50, studentspersonalinformationModel.training_base_name),
db.MakeInParam("@collaborative_unit", SqlDbType.NVarChar, 50, studentspersonalinformationModel.collaborative_unit),
db.MakeInParam("@professional_base_code", SqlDbType.NVarChar, 50, studentspersonalinformationModel.professional_base_code),
db.MakeInParam("@professional_base_name", SqlDbType.NVarChar, 50, studentspersonalinformationModel.professional_base_name),
db.MakeInParam("@training_time", SqlDbType.NVarChar, 50, studentspersonalinformationModel.training_time),
db.MakeInParam("@plan_training_time", SqlDbType.NVarChar, 50, studentspersonalinformationModel.plan_training_time),
db.MakeInParam("@writor", SqlDbType.NVarChar, 50, studentspersonalinformationModel.writor),
db.MakeInParam("@register_date", SqlDbType.NVarChar, 50, studentspersonalinformationModel.register_date),
db.MakeInParam("@urgent", SqlDbType.NVarChar, 50, studentspersonalinformationModel.urgent),
db.MakeInParam("@urgent_telephon", SqlDbType.NVarChar, 50, studentspersonalinformationModel.urgent_telephon),
db.MakeInParam("@image_path", SqlDbType.NVarChar, 50, studentspersonalinformationModel.image_path),
db.MakeInParam("@province_code", SqlDbType.NVarChar, 50, studentspersonalinformationModel.province_code),
db.MakeInParam("@city_code", SqlDbType.NVarChar, 50, studentspersonalinformationModel.city_code),
db.MakeInParam("@area_code", SqlDbType.NVarChar, 50, studentspersonalinformationModel.area_code) };
count = db.RunExecuteNonQuery(sql, prams);
return(count);
}
public Model.StudentsPersonalInformationModel GetModelById(string id)
{
string sql = string.Format("select * from GP_Students_Personal_Information where id=@id");
SqlParameter[] prams = { db.MakeInParam("@id", SqlDbType.NVarChar, 50, id) };
DataTable dt = db.RunDataTable(sql, prams);
StudentsPersonalInformationModel studentsPersonalInformationModel = new StudentsPersonalInformationModel();
studentsPersonalInformationModel = (StudentsPersonalInformationModel)ConvertTo.convertToModel(dt, studentsPersonalInformationModel);
return(studentsPersonalInformationModel);
}
public Model.StudentsPersonalInformationModel GetModelByNameTBCode(string name, string training_base_code)
{
string sql = string.Format("select * from GP_Students_Personal_Information where name=@name and training_base_code=@training_base_code");
SqlParameter[] prams = { db.MakeInParam("@name", SqlDbType.NVarChar, 50, name),
db.MakeInParam("@training_base_code", SqlDbType.NVarChar, 50, training_base_code) };
DataTable dt = db.RunDataTable(sql, prams);
StudentsPersonalInformationModel studentsPersonalInformationModel = new StudentsPersonalInformationModel();
studentsPersonalInformationModel = (StudentsPersonalInformationModel)ConvertTo.convertToModel(dt, studentsPersonalInformationModel);
return(studentsPersonalInformationModel);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["loginModel"] == null)
{
ShowMessageBox.Showmessagebox(this, "请重新登录", "../../Default.aspx");
return;
}
if (!IsPostBack)
{
StudentsPersonalInformationModel studentsPersonalInformationModel = new StudentsPersonalInformationModel();
StudentsPersonalInformationBLL studentsPersonalInformationBLL = new StudentsPersonalInformationBLL();
loginModel = (LoginModel)Session["loginModel"];
students_name = loginModel.name;
}
}
protected void save_Click(object sender, EventArgs e)
{
bool count;
datebirth.Text = datebirth1.Value;
age.Text = age1.Value;
StudentsPersonalInformationModel studentspersonalinformationModel = new StudentsPersonalInformationModel();
studentspersonalinformationModel.id = id;
studentspersonalinformationModel.real_name = CommonFunc.FilterSpecialString(real_name.Text.Trim());
studentspersonalinformationModel.sex = CommonFunc.FilterSpecialString(sex.SelectedValue.Trim());
studentspersonalinformationModel.age = CommonFunc.FilterSpecialString(age.Text.Trim());
studentspersonalinformationModel.datebirth = CommonFunc.FilterSpecialString(datebirth.Text.Trim());
studentspersonalinformationModel.minzu = CommonFunc.FilterSpecialString(minzu.SelectedValue.Trim());
studentspersonalinformationModel.province = CommonFunc.FilterSpecialString(province1.Value.Trim());
studentspersonalinformationModel.city = CommonFunc.FilterSpecialString(city1.Value.Trim());
studentspersonalinformationModel.area = CommonFunc.FilterSpecialString(area1.Value.Trim());
studentspersonalinformationModel.detail_address = CommonFunc.FilterSpecialString(detail_address.Text.Trim());
studentspersonalinformationModel.id_number = CommonFunc.FilterSpecialString(id_number.Text.Trim());
studentspersonalinformationModel.telephon = CommonFunc.FilterSpecialString(telephon.Text.Trim());
studentspersonalinformationModel.mail = CommonFunc.FilterSpecialString(mail.Text.Trim());
studentspersonalinformationModel.bk_school = CommonFunc.FilterSpecialString(bk_school.Text.Trim());
studentspersonalinformationModel.bk_major = CommonFunc.FilterSpecialString(bk_major.Text.Trim());
studentspersonalinformationModel.graduation_time = CommonFunc.SafeGetDateTimeStringFromObjectByFormat(CommonFunc.FilterSpecialString(graduation_time.Text.Trim()), "yyyy-MM");
studentspersonalinformationModel.high_education = CommonFunc.FilterSpecialString(high_education.Text.Trim());
studentspersonalinformationModel.high_school = CommonFunc.FilterSpecialString(high_school.Text.Trim());
studentspersonalinformationModel.high_major = CommonFunc.FilterSpecialString(high_major.Text.Trim());
studentspersonalinformationModel.high_education_time = CommonFunc.SafeGetDateTimeStringFromObjectByFormat(CommonFunc.FilterSpecialString(high_education_time.Text.Trim()), "yyyy-MM");
studentspersonalinformationModel.identity_type = CommonFunc.FilterSpecialString(identity_type.SelectedValue.Trim());
studentspersonalinformationModel.send_unit = CommonFunc.FilterSpecialString(send_unit.Text.Trim());
studentspersonalinformationModel.training_base_province_code = CommonFunc.FilterSpecialString(training_base_province_code.Value.Trim());
studentspersonalinformationModel.training_base_province_name = CommonFunc.FilterSpecialString(training_base_province_name.Value.Trim());
studentspersonalinformationModel.training_base_code = CommonFunc.FilterSpecialString(training_base_code.Value.Trim());
studentspersonalinformationModel.training_base_name = CommonFunc.FilterSpecialString(training_base_name.Value.Trim());
studentspersonalinformationModel.collaborative_unit = CommonFunc.FilterSpecialString(collaborative_unit.Text.Trim());
studentspersonalinformationModel.professional_base_code = CommonFunc.FilterSpecialString(professional_base_code.Value.Trim());
studentspersonalinformationModel.professional_base_name = CommonFunc.FilterSpecialString(professional_base_name.Value.Trim());
studentspersonalinformationModel.training_time = CommonFunc.FilterSpecialString(training_time.Text.Trim());
studentspersonalinformationModel.plan_training_time = CommonFunc.FilterSpecialString(plan_training_time.Text.Trim());
studentspersonalinformationModel.writor = CommonFunc.FilterSpecialString(writor.Text.Trim());
studentspersonalinformationModel.register_date = CommonFunc.FilterSpecialString(register_date.Text.Trim());
if (string.IsNullOrEmpty(studentspersonalinformationModel.id_number))
{
ShowMessageBox.Showmessagebox(this, "居民身份证号码不能为空", null);
return;
}
if (string.IsNullOrEmpty(studentspersonalinformationModel.detail_address))
{
ShowMessageBox.Showmessagebox(this, "家庭详细地址不能为空", null);
return;
}
if (studentspersonalinformationModel.detail_address.Length > 70)
{
ShowMessageBox.Showmessagebox(this, "家庭常住地址不能大于70个字符", null);
return;
}
if (string.IsNullOrEmpty(studentspersonalinformationModel.sex))
{
ShowMessageBox.Showmessagebox(this, "性别不能为空", null);
return;
}
if (string.IsNullOrEmpty(studentspersonalinformationModel.telephon))
{
ShowMessageBox.Showmessagebox(this, "常用手机号码不能为空", null);
return;
}
if (!ValidityCheck.PhoneNumIsValid(studentspersonalinformationModel.telephon, this))
{
return;
}
if (string.IsNullOrEmpty(studentspersonalinformationModel.mail))
{
ShowMessageBox.Showmessagebox(this, "常用邮箱不能为空", null);
return;
}
if (!ValidityCheck.EmailIsValid(studentspersonalinformationModel.mail, this))
{
return;
}
if (string.IsNullOrEmpty(studentspersonalinformationModel.high_school))
{
ShowMessageBox.Showmessagebox(this, "最高学历毕业院校不能为空", null);
return;
}
if (string.IsNullOrEmpty(studentspersonalinformationModel.high_major))
{
ShowMessageBox.Showmessagebox(this, "最高学历专业不能为空", null);
return;
}
if (string.IsNullOrEmpty(studentspersonalinformationModel.high_education_time))
{
ShowMessageBox.Showmessagebox(this, "获得最高学历时间不能为空", null);
return;
}
if (studentspersonalinformationModel.identity_type == "单位人")
{
if (string.IsNullOrEmpty(studentspersonalinformationModel.send_unit))
{
ShowMessageBox.Showmessagebox(this, "派出单位不能为空", null);
}
}
if (string.IsNullOrEmpty(studentspersonalinformationModel.training_base_name))
{
ShowMessageBox.Showmessagebox(this, "培训基地不能为空", null);
return;
}
if (string.IsNullOrEmpty(studentspersonalinformationModel.professional_base_name))
{
ShowMessageBox.Showmessagebox(this, "培训专业不能为空", null);
return;
}
if (string.IsNullOrEmpty(studentspersonalinformationModel.training_time))
{
ShowMessageBox.Showmessagebox(this, "参训时间不能为空", null);
return;
}
if (string.IsNullOrEmpty(studentspersonalinformationModel.plan_training_time))
{
ShowMessageBox.Showmessagebox(this, "计划参训时间不能为空", null);
return;
}
StudentsPersonalInformationBLL studentspersonalinformationBLL = new StudentsPersonalInformationBLL();
count = studentspersonalinformationBLL.UpdateStudentsPersonalInformation(studentspersonalinformationModel);
if (count)
{
try
{
Response.Write("<script> alert('个人信息修改成功');window.opener.window.loadPageList('" + pi + "');window.close();</script>");
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
else
{
Response.Write("<script> alert('个人信息修改失败');</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
StudentsPersonalInformationModel studentsPersonalInformationModel = null;
id = CommonFunc.SafeGetStringFromObj(Request.QueryString["id"]);
pi = CommonFunc.SafeGetStringFromObj(Request.QueryString["pi"]);
if (Session["loginModel"] == null)
{
Response.Write("<script>alert('请重新登录');opener.top.location.href='../../Default.aspx';window.close();</script>");
return;
}
if (!IsPostBack)
{
studentsPersonalInformationModel = new StudentsPersonalInformationModel();
studentsPersonalInformationModel = studentsPersonalInformationBLL.GetModelById(id);
real_name.Text = studentsPersonalInformationModel.real_name.ToString();
sex.SelectedValue = studentsPersonalInformationModel.sex.ToString();
id_number.Text = studentsPersonalInformationModel.id_number.ToString();
datebirth.Text = studentsPersonalInformationModel.datebirth.ToString();
age.Text = studentsPersonalInformationModel.age.ToString();
datebirth1.Value = studentsPersonalInformationModel.datebirth.ToString();
age1.Value = studentsPersonalInformationModel.age.ToString();
province1.Value = studentsPersonalInformationModel.province.ToString();
city1.Value = studentsPersonalInformationModel.city.ToString();
area1.Value = studentsPersonalInformationModel.area.ToString();
detail_address.Text = studentsPersonalInformationModel.detail_address.ToString();
telephon.Text = studentsPersonalInformationModel.telephon.ToString();
mail.Text = studentsPersonalInformationModel.mail.ToString();
minzu.SelectedValue = studentsPersonalInformationModel.minzu.ToString();
bk_school.Text = studentsPersonalInformationModel.bk_school.ToString();
bk_major.Text = studentsPersonalInformationModel.bk_major.ToString();
graduation_time.Text = studentsPersonalInformationModel.graduation_time.ToString();
high_education.SelectedValue = studentsPersonalInformationModel.high_education.ToString();
high_school.Text = studentsPersonalInformationModel.high_school.ToString();
high_major.Text = studentsPersonalInformationModel.high_major.ToString();
high_education_time.Text = studentsPersonalInformationModel.high_education_time.ToString();
identity_type.SelectedValue = studentsPersonalInformationModel.identity_type.ToString();
send_unit.Text = studentsPersonalInformationModel.send_unit.ToString();
training_base_province_code.Value = studentsPersonalInformationModel.training_base_province_code.ToString();
training_base_province_name.Value = studentsPersonalInformationModel.training_base_province_name.ToString();
training_base_code.Value = studentsPersonalInformationModel.training_base_code.ToString();
training_base_name.Value = studentsPersonalInformationModel.training_base_name.ToString();
collaborative_unit.Text = studentsPersonalInformationModel.collaborative_unit.ToString();
professional_base_code.Value = studentsPersonalInformationModel.professional_base_code.ToString();
professional_base_name.Value = studentsPersonalInformationModel.professional_base_name.ToString();
training_time.Text = studentsPersonalInformationModel.training_time.ToString();
plan_training_time.SelectedValue = studentsPersonalInformationModel.plan_training_time.ToString();
writor.Text = studentsPersonalInformationModel.writor.ToString();
register_date.Text = studentsPersonalInformationModel.register_date.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["loginModel"] == null)
{
Response.Write("<script>alert('请重新登录');opener.top.location.href='../../Default.aspx';window.close();</script>");
return;
}
id = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(Request.QueryString["id"]));
pi = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(Request.QueryString["pi"]));
if (!IsPostBack)
{
loginModel = new LoginModel();
studentsPersonalInformationModel = new StudentsPersonalInformationModel();
studentsPersonalInformationBLL = new StudentsPersonalInformationBLL();
dt = new DataTable();
professionalBaseDeptBLL = new ProfessionalBaseDeptBLL();
loginModel = (LoginModel)Session["loginModel"];
writor.Text = loginModel.real_name;
real_name.Text = loginModel.real_name; real_name.ReadOnly = true;
if (string.IsNullOrEmpty(id))
{
register_date.Text = DateTime.Now.Date.ToString("yyyy-MM-dd");
}
na = loginModel.name;
name.Value = na;
tbcode = loginModel.training_base_code;
studentsPersonalInformationModel = studentsPersonalInformationBLL.GetModelByNameTBCode(na, tbcode);
if (studentsPersonalInformationModel == null)
{
Response.Write("<script> alert('请完善个人基本信息');window.close();</script>");
return;
}
else
{
training_base_code.Value = studentsPersonalInformationModel.training_base_code.ToString();
training_base_name.Text = studentsPersonalInformationModel.training_base_name.ToString(); training_base_name.ReadOnly = true;
professional_base_code.Value = studentsPersonalInformationModel.professional_base_code.ToString();
professional_base_name.Text = studentsPersonalInformationModel.professional_base_name.ToString(); professional_base_name.ReadOnly = true;
dt = professionalBaseDeptBLL.GetDeptDataTableByCode(studentsPersonalInformationModel.professional_base_code.ToString());
rotary_dept_name.DataSource = dt;
rotary_dept_name.DataTextField = "dept_name";
rotary_dept_name.DataValueField = "dept_code";
rotary_dept_name.DataBind();
rotary_dept_name.Items.Insert(0, new ListItem("==请选择==", "0"));
}
if (!string.IsNullOrEmpty(id))
{//如果不是表单提交，并且带了id值来做修改操作，则在界面上把值都呈现出来
studentsRotaryModel = new StudentsRotaryModel();
studentsRotaryBLL = new StudentsRotaryBLL();
studentsRotaryModel = studentsRotaryBLL.GetModelById(id);
//rotary_dept_name.SelectedItem.Text = studentsRotaryModel.rotary_dept_name.ToString();
rotary_dept_name.SelectedValue = studentsRotaryModel.rotary_dept_code.ToString();
dt = new LoginBLL().GetTeachersDtByDeptCode(studentsRotaryModel.training_base_code, studentsRotaryModel.professional_base_code, studentsRotaryModel.rotary_dept_code, "teachers");
Teacher.DataSource = dt;
Teacher.DataTextField = "real_name";
Teacher.DataValueField = "name";
Teacher.DataBind();
Teacher.Items.Insert(0, new ListItem("==请选择==", "0"));
Teacher.SelectedValue = studentsRotaryModel.instructor_tag;
//instructor.Text = studentsRotaryModel.instructor.ToString();
//instructor_tag.Value = studentsRotaryModel.instructor_tag.ToString();
//Teacher.SelectedItem.Text = studentsRotaryModel.instructor.ToString();
//Teacher.SelectedItem.Value = studentsRotaryModel.instructor_tag.ToString();
rotary_begin_time.Text = studentsRotaryModel.rotary_begin_time.ToString();
rotary_end_time.Text = studentsRotaryModel.rotary_end_time.ToString();
register_date.Text = studentsRotaryModel.register_date.ToString();
}
}
}
public bool UpdateStudentsPersonalInformation(StudentsPersonalInformationModel model)
{
return(studentsPersonalInformationDAL.UpdateStudentsPersonalInformation(model));
}
public int InsertStudentsPersonalInformation(StudentsPersonalInformationModel studentspersonalinformationModel)
{
return(studentsPersonalInformationDAL.InsertStudentsPersonalInformation(studentspersonalinformationModel));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["loginModel"] == null)
{
Response.Write("<script>alert('请重新登录');opener.top.location.href='../../Default.aspx';window.close();</script>");
return;
}
pi = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(Request.QueryString["pi"]));
id = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(Request.QueryString["id"]));
if (!IsPostBack)
{
loginModel = (LoginModel)Session["loginModel"];
writor.Text = loginModel.real_name;
real_name.Text = loginModel.real_name;
register_date.Text = DateTime.Now.Date.ToString("yyyy-MM-dd");
na = loginModel.name;
training_time.Text = DateTime.Now.Year.ToString() + "年";
if (!string.IsNullOrEmpty(id))
{//如果不是表单提交，并且带了id值来做修改操作，则在界面上把值都呈现出来
studentsPersonalInformationModel = new StudentsPersonalInformationModel();
studentsPersonalInformationBLL = new StudentsPersonalInformationBLL();
studentsPersonalInformationModel = studentsPersonalInformationBLL.GetModelById(id);
real_name.Text = studentsPersonalInformationModel.real_name == null?"":studentsPersonalInformationModel.real_name.ToString();
sex.SelectedValue = studentsPersonalInformationModel.sex == null?"":studentsPersonalInformationModel.sex.ToString();
id_number.Text = studentsPersonalInformationModel.id_number == null ? "" : studentsPersonalInformationModel.id_number.ToString();
datebirth.Text = studentsPersonalInformationModel.datebirth == null ? "" : studentsPersonalInformationModel.datebirth.ToString();
age.Text = studentsPersonalInformationModel.age == null ? "" : studentsPersonalInformationModel.age.ToString();
datebirth.Text = studentsPersonalInformationModel.datebirth == null ? "" : studentsPersonalInformationModel.datebirth.ToString();
age.Text = studentsPersonalInformationModel.age == null ? "" : studentsPersonalInformationModel.age.ToString();
province_name.Value = studentsPersonalInformationModel.province == null ? "" : studentsPersonalInformationModel.province.ToString();
city_name.Value = studentsPersonalInformationModel.city == null ? "" : studentsPersonalInformationModel.city.ToString();
area_name.Value = studentsPersonalInformationModel.area == null ? "" : studentsPersonalInformationModel.area.ToString();
province_code.Value = studentsPersonalInformationModel.province_code == null ? "" : studentsPersonalInformationModel.province_code.ToString();
city_code.Value = studentsPersonalInformationModel.city_code == null ? "" : studentsPersonalInformationModel.city_code.ToString();
area_code.Value = studentsPersonalInformationModel.area_code == null ? "" : studentsPersonalInformationModel.area_code.ToString();
detail_address.Text = studentsPersonalInformationModel.detail_address == null ? "" : studentsPersonalInformationModel.detail_address.ToString();
telephon.Text = studentsPersonalInformationModel.telephon == null ? "" : studentsPersonalInformationModel.telephon.ToString();
mail.Text = studentsPersonalInformationModel.mail == null ? "" : studentsPersonalInformationModel.mail.ToString();
minzu.SelectedValue = studentsPersonalInformationModel.minzu == null ? "" : studentsPersonalInformationModel.minzu.ToString();
bk_school.Text = studentsPersonalInformationModel.bk_school == null ? "" : studentsPersonalInformationModel.bk_school.ToString();
bk_major.Text = studentsPersonalInformationModel.bk_major == null ? "" : studentsPersonalInformationModel.bk_major.ToString();
graduation_time.Text = studentsPersonalInformationModel.graduation_time == null ? "" : studentsPersonalInformationModel.graduation_time.ToString();
high_education.SelectedValue = studentsPersonalInformationModel.sex == null ? "" : studentsPersonalInformationModel.high_education.ToString();
high_school.Text = studentsPersonalInformationModel.high_school == null ? "" : studentsPersonalInformationModel.high_school.ToString();
high_major.Text = studentsPersonalInformationModel.high_major == null ? "" : studentsPersonalInformationModel.high_major.ToString();
high_education_time.Text = studentsPersonalInformationModel.high_education_time == null ? "" : studentsPersonalInformationModel.high_education_time.ToString();
identity_type.SelectedValue = studentsPersonalInformationModel.identity_type == null ? "" : studentsPersonalInformationModel.identity_type.ToString();
send_unit.Text = studentsPersonalInformationModel.send_unit == null ? "" : studentsPersonalInformationModel.send_unit.ToString();
training_base_province_code.Value = studentsPersonalInformationModel.training_base_province_code == null ? "" : studentsPersonalInformationModel.training_base_province_code.ToString();
training_base_province_name.Value = studentsPersonalInformationModel.training_base_province_name == null ? "" : studentsPersonalInformationModel.training_base_province_name.ToString();
training_base_code.Value = studentsPersonalInformationModel.training_base_code == null ? "" : studentsPersonalInformationModel.training_base_code.ToString();
training_base_name.Value = studentsPersonalInformationModel.training_base_name == null ? "" : studentsPersonalInformationModel.training_base_name.ToString();
collaborative_unit.Text = studentsPersonalInformationModel.collaborative_unit == null ? "" : studentsPersonalInformationModel.collaborative_unit.ToString();
professional_base_code.Value = studentsPersonalInformationModel.professional_base_code == null ? "" : studentsPersonalInformationModel.professional_base_code.ToString();
professional_base_name.Value = studentsPersonalInformationModel.professional_base_name == null ? "" : studentsPersonalInformationModel.professional_base_name.ToString();
training_time.Text = studentsPersonalInformationModel.training_time == null ? "" : studentsPersonalInformationModel.training_time.ToString();
plan_training_time.SelectedValue = studentsPersonalInformationModel.plan_training_time == null ? "" : studentsPersonalInformationModel.plan_training_time.ToString();
writor.Text = studentsPersonalInformationModel.writor == null ? "" : studentsPersonalInformationModel.writor.ToString();
register_date.Text = studentsPersonalInformationModel.register_date == null ? "" : studentsPersonalInformationModel.register_date.ToString();
urgent.Text = studentsPersonalInformationModel.urgent == null ? "" : studentsPersonalInformationModel.urgent.ToString();
urgent_telephon.Text = studentsPersonalInformationModel.urgent_telephon == null ? "" : studentsPersonalInformationModel.urgent_telephon.ToString();
image_path.Value = studentsPersonalInformationModel.image_path == null ? "" : studentsPersonalInformationModel.image_path.ToString();
}
}
}
public StudentsPersonalInformationModel DataRowToModel(DataRow row)
{
StudentsPersonalInformationModel model = new StudentsPersonalInformationModel();
if (row != null)
{
if (row["id"] != null)
{
model.id = row["id"].ToString();
}
if (row["name"] != null)
{
model.name = row["name"].ToString();
}
if (row["real_name"] != null)
{
model.real_name = row["real_name"].ToString();
}
if (row["sex"] != null)
{
model.sex = row["sex"].ToString();
}
if (row["age"] != null)
{
model.age = row["age"].ToString();
}
if (row["datebirth"] != null)
{
model.datebirth = row["datebirth"].ToString();
}
if (row["minzu"] != null)
{
model.minzu = row["minzu"].ToString();
}
if (row["province"] != null)
{
model.province = row["province"].ToString();
}
if (row["city"] != null)
{
model.city = row["city"].ToString();
}
if (row["area"] != null)
{
model.area = row["area"].ToString();
}
if (row["detail_address"] != null)
{
model.detail_address = row["detail_address"].ToString();
}
if (row["id_number"] != null)
{
model.id_number = row["id_number"].ToString();
}
if (row["telephon"] != null)
{
model.telephon = row["telephon"].ToString();
}
if (row["mail"] != null)
{
model.mail = row["mail"].ToString();
}
if (row["bk_school"] != null)
{
model.bk_school = row["bk_school"].ToString();
}
if (row["bk_major"] != null)
{
model.bk_major = row["bk_major"].ToString();
}
if (row["graduation_time"] != null)
{
model.graduation_time = row["graduation_time"].ToString();
}
if (row["high_education"] != null)
{
model.high_education = row["high_education"].ToString();
}
if (row["high_school"] != null)
{
model.high_school = row["high_school"].ToString();
}
if (row["high_major"] != null)
{
model.high_major = row["high_major"].ToString();
}
if (row["high_education_time"] != null)
{
model.high_education_time = row["high_education_time"].ToString();
}
if (row["identity_type"] != null)
{
model.identity_type = row["identity_type"].ToString();
}
if (row["send_unit"] != null)
{
model.send_unit = row["send_unit"].ToString();
}
if (row["training_base_province_code"] != null)
{
model.training_base_province_code = row["training_base_province_code"].ToString();
}
if (row["training_base_province_name"] != null)
{
model.training_base_province_name = row["training_base_province_name"].ToString();
}
if (row["training_base_code"] != null)
{
model.training_base_code = row["training_base_code"].ToString();
}
if (row["training_base_name"] != null)
{
model.training_base_name = row["training_base_name"].ToString();
}
if (row["collaborative_unit"] != null)
{
model.collaborative_unit = row["collaborative_unit"].ToString();
}
if (row["professional_base_name"] != null)
{
model.professional_base_name = row["professional_base_name"].ToString();
}
if (row["professional_base_code"] != null)
{
model.professional_base_code = row["professional_base_code"].ToString();
}
if (row["training_time"] != null)
{
model.training_time = row["training_time"].ToString();
}
if (row["plan_training_time"] != null)
{
model.plan_training_time = row["plan_training_time"].ToString();
}
if (row["writor"] != null)
{
model.writor = row["writor"].ToString();
}
if (row["register_date"] != null)
{
model.register_date = row["register_date"].ToString();
}
if (row["urgent"] != null)
{
model.urgent = row["urgent"].ToString();
}
if (row["urgent_telephon"] != null)
{
model.urgent_telephon = row["urgent_telephon"].ToString();
}
if (row["image_path"] != null)
{
model.image_path = row["image_path"].ToString();
}
if (row["province_code"] != null)
{
model.province_code = row["province_code"].ToString();
}
if (row["city_code"] != null)
{
model.city_code = row["city_code"].ToString();
}
if (row["area_code"] != null)
{
model.area_code = row["area_code"].ToString();
}
}
return(model);
}
public List <Model.StudentsPersonalInformationModel> CommonGetPagedList(string TrainingBaseCode, string ProfessionalBaseCode,
string StudentsRealName, string Sex, string MinZu, string HighEducation, string HighSchool,
string IdentityType, string SendUnit, string CollaborativeUnit, string TrainingTime, string PlanTrainingTime,
int start, int end)
{
string sql = "select * from (select row_number() over(order by register_date desc) as num,* from GP_Students_Personal_Information where training_base_code like '%" + TrainingBaseCode + "%'";
if (!string.IsNullOrEmpty(ProfessionalBaseCode))
{
sql += "and professional_base_code like '%" + ProfessionalBaseCode + "%'";
}
if (!string.IsNullOrEmpty(StudentsRealName))
{
sql += "and real_name like '%" + StudentsRealName + "%'";
}
if (!string.IsNullOrEmpty(Sex))
{
sql += "and sex ='" + Sex + "'";
}
if (!string.IsNullOrEmpty(MinZu))
{
sql += "and minzu like '%" + MinZu + "%'";
}
if (!string.IsNullOrEmpty(HighEducation))
{
sql += "and high_education like '%" + HighEducation + "%'";
}
if (!string.IsNullOrEmpty(HighSchool))
{
sql += "and high_school like '%" + HighSchool + "%'";
}
if (!string.IsNullOrEmpty(IdentityType))
{
sql += "and identity_type like '%" + IdentityType + "%'";
}
if (!string.IsNullOrEmpty(SendUnit))
{
sql += "and send_unit = '" + SendUnit + "'";
}
if (!string.IsNullOrEmpty(CollaborativeUnit))
{
sql += "and collaborative_unit like '%" + CollaborativeUnit + "%'";
}
if (!string.IsNullOrEmpty(TrainingTime))
{
sql += "and training_time like '%" + TrainingTime + "%'";
}
if (!string.IsNullOrEmpty(PlanTrainingTime))
{
sql += "and plan_training_time = '" + PlanTrainingTime + "'";
}
sql += ")as t where t.num>=@start and t.num<=@end";
SqlParameter[] pars =
{
new SqlParameter("@start", SqlDbType.Int),
new SqlParameter("@end", SqlDbType.Int)
};
pars[0].Value = start;
pars[1].Value = end;
DataTable dt = db.RunDataTable(sql, pars);
List <StudentsPersonalInformationModel> list = null;
if (dt.Rows.Count > 0)
{
list = new List <StudentsPersonalInformationModel>();
StudentsPersonalInformationModel model = null;
foreach (DataRow row in dt.Rows)
{
model = new StudentsPersonalInformationModel();
model = DataRowToModel(row);
list.Add(model);
}
}
return(list);
}
public bool UpdateStudentsPersonalInformation(StudentsPersonalInformationModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update GP_Students_Personal_Information set ");
strSql.Append("real_name=@real_name,");
strSql.Append("sex=@sex,");
strSql.Append("age=@age,");
strSql.Append("datebirth=@datebirth,");
strSql.Append("minzu=@minzu,");
strSql.Append("province=@province,");
strSql.Append("city=@city,");
strSql.Append("area=@area,");
strSql.Append("detail_address=@detail_address,");
strSql.Append("id_number=@id_number,");
strSql.Append("telephon=@telephon,");
strSql.Append("mail=@mail,");
strSql.Append("bk_school=@bk_school,");
strSql.Append("bk_major=@bk_major,");
strSql.Append("graduation_time=@graduation_time,");
strSql.Append("high_education=@high_education,");
strSql.Append("high_school=@high_school,");
strSql.Append("high_major=@high_major,");
strSql.Append("high_education_time=@high_education_time,");
strSql.Append("identity_type=@identity_type,");
strSql.Append("send_unit=@send_unit,");
strSql.Append("training_base_province_code=@training_base_province_code,");
strSql.Append("training_base_province_name=@training_base_province_name,");
strSql.Append("training_base_code=@training_base_code,");
strSql.Append("training_base_name=@training_base_name,");
strSql.Append("collaborative_unit=@collaborative_unit,");
strSql.Append("professional_base_code=@professional_base_code,");
strSql.Append("professional_base_name=@professional_base_name,");
strSql.Append("training_time=@training_time,");
strSql.Append("plan_training_time=@plan_training_time,");
strSql.Append("writor=@writor,");
strSql.Append("register_date=@register_date,");
strSql.Append("urgent=@urgent,");
strSql.Append("urgent_telephon=@urgent_telephon,");
strSql.Append("image_path=@image_path,");
strSql.Append("province_code=@province_code,");
strSql.Append("city_code=@city_code,");
strSql.Append("area_code=@area_code");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@real_name", SqlDbType.NVarChar, 50),
new SqlParameter("@sex", SqlDbType.NVarChar, 50),
new SqlParameter("@age", SqlDbType.NVarChar, 50),
new SqlParameter("@datebirth", SqlDbType.NVarChar, 50),
new SqlParameter("@minzu", SqlDbType.NVarChar, 50),
new SqlParameter("@province", SqlDbType.NVarChar, 50),
new SqlParameter("@city", SqlDbType.NVarChar, 50),
new SqlParameter("@area", SqlDbType.NVarChar, 50),
new SqlParameter("@detail_address", SqlDbType.NVarChar, 500),
new SqlParameter("@id_number", SqlDbType.NVarChar, 50),
new SqlParameter("@telephon", SqlDbType.NVarChar, 50),
new SqlParameter("@mail", SqlDbType.NVarChar, 50),
new SqlParameter("@bk_school", SqlDbType.NVarChar, 50),
new SqlParameter("@bk_major", SqlDbType.NVarChar, 50),
new SqlParameter("@graduation_time", SqlDbType.NVarChar, 50),
new SqlParameter("@high_education", SqlDbType.NVarChar, 50),
new SqlParameter("@high_school", SqlDbType.NVarChar, 50),
new SqlParameter("@high_major", SqlDbType.NVarChar, 50),
new SqlParameter("@high_education_time", SqlDbType.NVarChar, 50),
new SqlParameter("@identity_type", SqlDbType.NVarChar, 50),
new SqlParameter("@send_unit", SqlDbType.NVarChar, 50),
new SqlParameter("@training_base_province_code", SqlDbType.NVarChar, 50),
new SqlParameter("@training_base_province_name", SqlDbType.NVarChar, 50),
new SqlParameter("@training_base_code", SqlDbType.NVarChar, 50),
new SqlParameter("@training_base_name", SqlDbType.NVarChar, 50),
new SqlParameter("@collaborative_unit", SqlDbType.NVarChar, 50),
new SqlParameter("@professional_base_code", SqlDbType.NVarChar, 50),
new SqlParameter("@professional_base_name", SqlDbType.NVarChar, 50),
new SqlParameter("@training_time", SqlDbType.NVarChar, 50),
new SqlParameter("@plan_training_time", SqlDbType.NVarChar, 50),
new SqlParameter("@writor", SqlDbType.NVarChar, 50),
new SqlParameter("@register_date", SqlDbType.NVarChar, 50),
new SqlParameter("@urgent", SqlDbType.NVarChar, 50),
new SqlParameter("@urgent_telephon", SqlDbType.NVarChar, 50),
new SqlParameter("@image_path", SqlDbType.NVarChar, 50),
new SqlParameter("@province_code", SqlDbType.NVarChar, 50),
new SqlParameter("@city_code", SqlDbType.NVarChar, 50),
new SqlParameter("@area_code", SqlDbType.NVarChar, 50),
new SqlParameter("@id", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.real_name;
parameters[1].Value = model.sex;
parameters[2].Value = model.age;
parameters[3].Value = model.datebirth;
parameters[4].Value = model.minzu;
parameters[5].Value = model.province;
parameters[6].Value = model.city;
parameters[7].Value = model.area;
parameters[8].Value = model.detail_address;
parameters[9].Value = model.id_number;
parameters[10].Value = model.telephon;
parameters[11].Value = model.mail;
parameters[12].Value = model.bk_school;
parameters[13].Value = model.bk_major;
parameters[14].Value = model.graduation_time;
parameters[15].Value = model.high_education;
parameters[16].Value = model.high_school;
parameters[17].Value = model.high_major;
parameters[18].Value = model.high_education_time;
parameters[19].Value = model.identity_type;
parameters[20].Value = model.send_unit;
parameters[21].Value = model.training_base_province_code;
parameters[22].Value = model.training_base_province_name;
parameters[23].Value = model.training_base_code;
parameters[24].Value = model.training_base_name;
parameters[25].Value = model.collaborative_unit;
parameters[26].Value = model.professional_base_code;
parameters[27].Value = model.professional_base_name;
parameters[28].Value = model.training_time;
parameters[29].Value = model.plan_training_time;
parameters[30].Value = model.writor;
parameters[31].Value = model.register_date;
parameters[32].Value = model.urgent;
parameters[33].Value = model.urgent_telephon;
parameters[34].Value = model.image_path;
parameters[35].Value = model.province_code;
parameters[36].Value = model.city_code;
parameters[37].Value = model.area_code;
parameters[38].Value = model.id;
int rows = db.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
