public Model.OutDeptExamModel SelectRotaryTimeModel(string students_name, string training_base_code, string rotary_dept_code)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from GP_OutDept_Exam ");
strSql.Append(" where rotary_dept_code=@rotary_dept_code and students_name=@students_name and training_base_code=@training_base_code ");
SqlParameter[] parameters =
{
new SqlParameter("@rotary_dept_code", SqlDbType.NVarChar, 50),
new SqlParameter("@students_name", SqlDbType.NVarChar, 50),
new SqlParameter("@training_base_code", SqlDbType.NVarChar, 50)
};
parameters[0].Value = rotary_dept_code;
parameters[1].Value = students_name;
parameters[2].Value = training_base_code;
OutDeptExamModel model = new OutDeptExamModel();
DataSet ds = db.RunDataSet(strSql.ToString(), parameters, "tbName");
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
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)
{
outDeptExamBLL = new OutDeptExamBLL();
outDeptExamModel = new OutDeptExamModel();
outDeptExamModel = outDeptExamBLL.SelectById(id);
students_real_name.Text = outDeptExamModel.students_real_name;
students_name.Value = outDeptExamModel.students_name;
training_base_code.Value = outDeptExamModel.training_base_code;
training_base_name.Value = outDeptExamModel.training_base_name;
sex.Text = outDeptExamModel.sex;
high_education.Text = outDeptExamModel.high_education;
high_education_time.Text = outDeptExamModel.high_education_time;
professional_base_code.Value = outDeptExamModel.professional_base_code;
professional_base_name.Text = outDeptExamModel.professional_base_name;
students_real_name.Text = outDeptExamModel.students_real_name;
rotary_dept_name.Text = outDeptExamModel.rotary_dept_name;
rotary_dept_code.Value = outDeptExamModel.rotary_dept_code;
rotary_begin_time.Text = outDeptExamModel.rotary_begin_time;
rotary_end_time.Text = outDeptExamModel.rotary_end_time;
instructor.Text = outDeptExamModel.instructor;
instructor_tag.Value = outDeptExamModel.instructor_tag;
kqqk.Text = outDeptExamModel.kqqk;
gztd.Text = outDeptExamModel.gztd;
ydyf.Text = outDeptExamModel.ydyf;
llsp.Text = outDeptExamModel.llsp;
zdzx.Text = outDeptExamModel.zdzx;
blsx.Text = outDeptExamModel.blsx;
clbrnl.Text = outDeptExamModel.clbrnl;
sjcznl.Text = outDeptExamModel.sjcznl;
czjn.Text = outDeptExamModel.czjn;
zdsp.Text = outDeptExamModel.zdsp;
djnl.Text = outDeptExamModel.djnl;
totalscore.Text = outDeptExamModel.total_score;
teacher.Text = outDeptExamModel.instructor;
teacher_time.Text = outDeptExamModel.instructor_date;
kzr.Text = outDeptExamModel.dept_manager;
kzr_time.Text = outDeptExamModel.dept_manager_date;
if (outDeptExamModel.is_pass == "同意出科")
{
ispass.Items[0].Selected = true;
}
else if (outDeptExamModel.is_pass == "顺延一期")
{
ispass.Items[1].Selected = true;
}
}
}
protected void save_Click(object sender, EventArgs e)
{
outDeptExamBLL = new OutDeptExamBLL();
outDeptExamModel = new OutDeptExamModel();
outDeptExamModel.kqqk = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(kqqk.Text));
outDeptExamModel.gztd = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(gztd.Text));
outDeptExamModel.ydyf = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(ydyf.Text));
outDeptExamModel.llsp = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(llsp.Text));
outDeptExamModel.zdzx = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(zdzx.Text));
outDeptExamModel.blsx = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(blsx.Text));
outDeptExamModel.clbrnl = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(clbrnl.Text));
outDeptExamModel.sjcznl = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(sjcznl.Text));
outDeptExamModel.czjn = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(czjn.Text));
outDeptExamModel.zdsp = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(zdsp.Text));
outDeptExamModel.djnl = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(djnl.Text));
outDeptExamModel.total_score = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(totalscore.Text));
outDeptExamModel.instructor_date = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(teacher_time.Text));
outDeptExamModel.dept_manager = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(kzr.Text));
outDeptExamModel.dept_manager_date = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(kzr_time.Text));
outDeptExamModel.is_pass = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(ispass.SelectedItem.Value));
if (string.IsNullOrEmpty(outDeptExamModel.is_pass))
{
ShowMessageBox.Showmessagebox(this, "考核结果不能为空", null);
return;
}
if (string.IsNullOrEmpty(outDeptExamModel.dept_manager))
{
ShowMessageBox.Showmessagebox(this, "科主任不能为空", null);
return;
}
if (outDeptExamModel.is_pass == "同意出科")
{
status = "已出科";
}
else
{
status = "顺延一期";
}
if (new StudentsRotaryBLL().UpdateOutdeptStatusByT(status, id) && outDeptExamBLL.UpdateById(outDeptExamModel, id))
{
try
{
Response.Write("<script language='javascript'> alert('出科考核表修改成功');window.opener.window.loadPageList('" + pi + "');window.close();</script>");
Response.End();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
}
public OutDeptExamModel SelectById(string id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,students_name,students_real_name,sex,training_base_code,training_base_name,high_education,high_education_time,professional_base_code,professional_base_name,rotary_dept_code,rotary_dept_name,rotary_begin_time,rotary_end_time,instructor,instructor_tag,kqqk,gztd,ydyf,llsp,zdzx,blsx,clbrnl,sjcznl,czjn,zdsp,djnl,total_score,instructor_date,is_pass,dept_manager,dept_manager_date from GP_OutDept_Exam ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.NVarChar, 50)
};
parameters[0].Value = id;
OutDeptExamModel model = new OutDeptExamModel();
DataSet ds = db.RunDataSet(strSql.ToString(), parameters, "tbName");
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel2(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public List <Model.OutDeptExamModel> CommonGetPagedList(string StudentsRealName, string TrainingBaseCode, string ProfessionalBaseCode, string ProfessionalBaseName, string DeptName, string TeachersRealName,
string RotaryBeginTime, string RotaryEndTime, string TotalScore, string IsPass,
int start, int end)
{
string sql = "select * from (select row_number() over(order by dept_manager_date desc) as num,* from GP_OutDept_Exam where training_base_code like '%" + TrainingBaseCode + "%'";
if (!string.IsNullOrEmpty(StudentsRealName))
{
sql += "and students_real_name like '%" + StudentsRealName + "%'";
}
if (!string.IsNullOrEmpty(ProfessionalBaseCode))
{
sql += "and professional_base_code like '%" + ProfessionalBaseCode + "%'";
}
if (!string.IsNullOrEmpty(ProfessionalBaseName))
{
sql += "and professional_base_name like '%" + ProfessionalBaseName + "%'";
}
if (!string.IsNullOrEmpty(DeptName))
{
sql += "and rotary_dept_name like '%" + DeptName + "%'";
}
if (!string.IsNullOrEmpty(TeachersRealName))
{
sql += "and instructor like '%" + TeachersRealName + "%'";
}
if (!string.IsNullOrEmpty(RotaryBeginTime))
{
sql += "and rotary_begin_time = '" + RotaryBeginTime + "'";
}
if (!string.IsNullOrEmpty(RotaryEndTime))
{
sql += "and rotary_end_time = '" + RotaryEndTime + "'";
}
if (!string.IsNullOrEmpty(TotalScore))
{
sql += "and total_score = '" + TotalScore + "'";
}
if (!string.IsNullOrEmpty(IsPass))
{
sql += "and is_pass = '******'";
}
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 <OutDeptExamModel> list = null;
if (dt.Rows.Count > 0)
{
list = new List <OutDeptExamModel>();
OutDeptExamModel model = null;
foreach (DataRow row in dt.Rows)
{
model = new OutDeptExamModel();
model = DataRowToModel(row);
list.Add(model);
}
}
return(list);
}
public OutDeptExamModel DataRowToModel(DataRow row)
{
OutDeptExamModel model = new OutDeptExamModel();
if (row != null)
{
if (row["id"] != null)
{
model.id = row["id"].ToString();
}
if (row["students_name"] != null)
{
model.students_name = row["students_name"].ToString();
}
if (row["students_real_name"] != null)
{
model.students_real_name = row["students_real_name"].ToString();
}
if (row["sex"] != null)
{
model.sex = row["sex"].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["high_education"] != null)
{
model.high_education = row["high_education"].ToString();
}
if (row["high_education_time"] != null)
{
model.high_education_time = row["high_education_time"].ToString();
}
if (row["professional_base_code"] != null)
{
model.professional_base_code = row["professional_base_code"].ToString();
}
if (row["professional_base_name"] != null)
{
model.professional_base_name = row["professional_base_name"].ToString();
}
if (row["rotary_dept_code"] != null)
{
model.rotary_dept_code = row["rotary_dept_code"].ToString();
}
if (row["rotary_dept_name"] != null)
{
model.rotary_dept_name = row["rotary_dept_name"].ToString();
}
if (row["rotary_begin_time"] != null)
{
model.rotary_begin_time = row["rotary_begin_time"].ToString();
}
if (row["rotary_end_time"] != null)
{
model.rotary_end_time = row["rotary_end_time"].ToString();
}
if (row["instructor"] != null)
{
model.instructor = row["instructor"].ToString();
}
if (row["instructor_tag"] != null)
{
model.instructor_tag = row["instructor_tag"].ToString();
}
if (row["kqqk"] != null)
{
model.kqqk = row["kqqk"].ToString();
}
if (row["gztd"] != null)
{
model.gztd = row["gztd"].ToString();
}
if (row["ydyf"] != null)
{
model.ydyf = row["ydyf"].ToString();
}
if (row["llsp"] != null)
{
model.llsp = row["llsp"].ToString();
}
if (row["zdzx"] != null)
{
model.zdzx = row["zdzx"].ToString();
}
if (row["blsx"] != null)
{
model.blsx = row["blsx"].ToString();
}
if (row["clbrnl"] != null)
{
model.clbrnl = row["clbrnl"].ToString();
}
if (row["sjcznl"] != null)
{
model.sjcznl = row["sjcznl"].ToString();
}
if (row["czjn"] != null)
{
model.czjn = row["czjn"].ToString();
}
if (row["zdsp"] != null)
{
model.zdsp = row["zdsp"].ToString();
}
if (row["djnl"] != null)
{
model.djnl = row["djnl"].ToString();
}
if (row["total_score"] != null)
{
model.total_score = row["total_score"].ToString();
}
if (row["instructor_date"] != null)
{
model.instructor_date = row["instructor_date"].ToString();
}
if (row["is_pass"] != null)
{
model.is_pass = row["is_pass"].ToString();
}
if (row["dept_manager"] != null)
{
model.dept_manager = row["dept_manager"].ToString();
}
if (row["dept_manager_date"] != null)
{
model.dept_manager_date = row["dept_manager_date"].ToString();
}
}
return(model);
}
public bool UpdateById(OutDeptExamModel model, string id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update GP_OutDept_Exam set ");
strSql.Append("kqqk=@kqqk,");
strSql.Append("gztd=@gztd,");
strSql.Append("ydyf=@ydyf,");
strSql.Append("llsp=@llsp,");
strSql.Append("zdzx=@zdzx,");
strSql.Append("blsx=@blsx,");
strSql.Append("clbrnl=@clbrnl,");
strSql.Append("sjcznl=@sjcznl,");
strSql.Append("czjn=@czjn,");
strSql.Append("zdsp=@zdsp,");
strSql.Append("djnl=@djnl,");
strSql.Append("total_score=@total_score,");
strSql.Append("instructor_date=@instructor_date,");
strSql.Append("is_pass=@is_pass,");
strSql.Append("dept_manager=@dept_manager,");
strSql.Append("dept_manager_date=@dept_manager_date");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@kqqk", SqlDbType.NVarChar, 10),
new SqlParameter("@gztd", SqlDbType.NVarChar, 10),
new SqlParameter("@ydyf", SqlDbType.NVarChar, 10),
new SqlParameter("@llsp", SqlDbType.NVarChar, 10),
new SqlParameter("@zdzx", SqlDbType.NVarChar, 10),
new SqlParameter("@blsx", SqlDbType.NVarChar, 10),
new SqlParameter("@clbrnl", SqlDbType.NVarChar, 10),
new SqlParameter("@sjcznl", SqlDbType.NVarChar, 10),
new SqlParameter("@czjn", SqlDbType.NVarChar, 10),
new SqlParameter("@zdsp", SqlDbType.NVarChar, 10),
new SqlParameter("@djnl", SqlDbType.NVarChar, 10),
new SqlParameter("@total_score", SqlDbType.NVarChar, 10),
new SqlParameter("@instructor_date", SqlDbType.NVarChar, 50),
new SqlParameter("@is_pass", SqlDbType.NVarChar, 10),
new SqlParameter("@dept_manager", SqlDbType.NVarChar, 50),
new SqlParameter("@dept_manager_date", SqlDbType.NVarChar, 10),
new SqlParameter("@id", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.kqqk;
parameters[1].Value = model.gztd;
parameters[2].Value = model.ydyf;
parameters[3].Value = model.llsp;
parameters[4].Value = model.zdzx;
parameters[5].Value = model.blsx;
parameters[6].Value = model.clbrnl;
parameters[7].Value = model.sjcznl;
parameters[8].Value = model.czjn;
parameters[9].Value = model.zdsp;
parameters[10].Value = model.djnl;
parameters[11].Value = model.total_score;
parameters[12].Value = model.instructor_date;
parameters[13].Value = model.is_pass;
parameters[14].Value = model.dept_manager;
parameters[15].Value = model.dept_manager_date;
parameters[16].Value = id;
int rows = db.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool UpdateById(OutDeptExamModel model, string id)
{
return(outDeptExamDAL.UpdateById(model, id));
}
protected void save_Click(object sender, EventArgs e)
{
outDeptExamBLL = new OutDeptExamBLL();
outDeptExamModel = new OutDeptExamModel();
outDeptExamModel.id = Guid.NewGuid().ToString();
outDeptExamModel.students_name = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(students_name.Value));
outDeptExamModel.students_real_name = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(students_real_name.Text));
outDeptExamModel.training_base_code = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(training_base_code.Value));
outDeptExamModel.training_base_name = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(training_base_name.Value));
outDeptExamModel.sex = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(sex.Text));
outDeptExamModel.high_education = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(high_education.Text));
outDeptExamModel.high_education_time = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(high_education_time.Text));
outDeptExamModel.professional_base_code = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(professional_base_code.Value));
outDeptExamModel.professional_base_name = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(professional_base_name.Text));
outDeptExamModel.rotary_dept_code = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(rotary_dept_code.Value));
outDeptExamModel.rotary_dept_name = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(rotary_dept_name.Text));
outDeptExamModel.rotary_begin_time = CommonFunc.SafeGetDateTimeStringFromObjectByFormat(CommonFunc.FilterSpecialString(rotary_begin_time.Text), "yyyy-MM-dd");
outDeptExamModel.rotary_end_time = CommonFunc.SafeGetDateTimeStringFromObjectByFormat(CommonFunc.FilterSpecialString(rotary_end_time.Text), "yyyy-MM-dd");
outDeptExamModel.instructor = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(instructor.Text));
outDeptExamModel.instructor_tag = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(instructor_tag.Value));
outDeptExamModel.kqqk = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(kqqk.Text));
outDeptExamModel.gztd = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(gztd.Text));
outDeptExamModel.ydyf = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(ydyf.Text));
outDeptExamModel.llsp = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(llsp.Text));
outDeptExamModel.zdzx = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(zdzx.Text));
outDeptExamModel.blsx = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(blsx.Text));
outDeptExamModel.clbrnl = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(clbrnl.Text));
outDeptExamModel.sjcznl = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(sjcznl.Text));
outDeptExamModel.czjn = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(czjn.Text));
outDeptExamModel.zdsp = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(zdsp.Text));
outDeptExamModel.djnl = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(djnl.Text));
outDeptExamModel.total_score = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(totalscore.Text));
outDeptExamModel.instructor_date = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(teacher_time.Text));
outDeptExamModel.dept_manager = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(kzr.Text));
outDeptExamModel.dept_manager_date = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(kzr_time.Text));
outDeptExamModel.is_pass = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(ispass.SelectedItem.Value));
//Response.Write("<script> alert('"+totalscore.Text+"');</script>");
if (string.IsNullOrEmpty(outDeptExamModel.total_score))
{
ShowMessageBox.Showmessagebox(this, "合计得分不能为空", null);
return;
}
if (string.IsNullOrEmpty(outDeptExamModel.is_pass))
{
ShowMessageBox.Showmessagebox(this, "考核结果不能为空", null);
return;
}
if (string.IsNullOrEmpty(outDeptExamModel.dept_manager))
{
ShowMessageBox.Showmessagebox(this, "科主任不能为空", null);
return;
}
if (outDeptExamModel.is_pass == "同意出科")
{
status = "1";
}
else
{
status = "2";
//StudentsRotaryInformation2BLL bll = new StudentsRotaryInformation2BLL();
//StudentsRotaryInformation2Model model = new StudentsRotaryInformation2Model();
//model = bll.GetModelById(id);
//model.Id = Guid.NewGuid().ToString();
//model.OutdeptStatus = "0";
//model.OutdeptApplication = "0";
//model.QuestionnaireStatus = "0";
//model.Tag1 = "0";
//bll.AddOne(model);
}
if (outDeptExamBLL.Insert(outDeptExamModel) && new StudentsRotaryInformation2BLL().UpdateOutdeptStatusByT(status, id))
{
try
{
Response.Write("<script language='javascript'> alert('出科考核表提交成功');window.opener.window.loadPageList('" + pi + "');window.close();</script>");
Response.End();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
}
