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); } } }