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"])); bedManagementMode = new BedManagementModel(); bedManagementBLL = new BedManagementBLL(); bedManagementMode = bedManagementBLL.GetModelById(id); students_real_name.Text = bedManagementMode.students_real_name.ToString(); training_base_name.Text = bedManagementMode.training_base_name.ToString(); professional_base_name.Text = bedManagementMode.professional_base_name.ToString(); rotary_dept.SelectedItem.Text = bedManagementMode.dept_name.ToString(); rotary_dept.SelectedItem.Value = bedManagementMode.dept_code.ToString(); Teacher.SelectedItem.Text = bedManagementMode.TeacherName.ToString(); Teacher.SelectedItem.Value = bedManagementMode.TeacherId.ToString(); patient_name.Text = bedManagementMode.patient_name.ToString(); patient_id.Text = bedManagementMode.patient_id.ToString(); bed_id.Text = bedManagementMode.bed_id.ToString(); bed_card.Text = bedManagementMode.bed_card.ToString(); bed_price.Text = bedManagementMode.bed_price.ToString(); bed_status.Text = bedManagementMode.bed_status.ToString(); room_id.Text = bedManagementMode.room_id.ToString(); building_id.Text = bedManagementMode.building_id.ToString(); comment.Text = bedManagementMode.comment.ToString(); writor.Text = bedManagementMode.writor.ToString(); register_date.Text = bedManagementMode.register_date.ToString(); }
public bool UpdateCheckByTeacher(BedManagementModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update GP_Bed_Management set "); strSql.Append("teacher_check=@teacher_check"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@teacher_check", SqlDbType.NVarChar, 50), new SqlParameter("@id", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.teacher_check; parameters[1].Value = model.id; int rows = db.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public List <Model.BedManagementModel> GetPagedList(string students_name, string training_base_code, string dept_name, string patient_name, string bed_id, string bed_status, string room_id, string building_id, int start, int end) { string sql = "select * from (select row_number() over(order by register_date desc) as num,* from GP_Bed_Management where students_name='" + students_name + "' and training_base_code='" + training_base_code + "'"; if (!string.IsNullOrEmpty(dept_name)) { sql += "and dept_name like '%" + dept_name + "%'"; } if (!string.IsNullOrEmpty(patient_name)) { sql += "and patient_name like '%" + patient_name + "%'"; } if (!string.IsNullOrEmpty(bed_id)) { sql += "and bed_id like '%" + bed_id + "%'"; } if (!string.IsNullOrEmpty(bed_status)) { sql += "and bed_status like '%" + bed_status + "%'"; } if (!string.IsNullOrEmpty(room_id)) { sql += "and room_id like '%" + room_id + "%'"; } if (!string.IsNullOrEmpty(building_id)) { sql += "and building_id like '%" + building_id + "%'"; } 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 <BedManagementModel> list = null; if (dt.Rows.Count > 0) { list = new List <BedManagementModel>(); BedManagementModel model = null; foreach (DataRow row in dt.Rows) { model = new BedManagementModel(); model = DataRowToModel(row); list.Add(model); } } return(list); }
public BedManagementModel GetModelById(string id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,students_name,students_real_name,training_base_code,training_base_name,professional_base_code,professional_base_name,dept_code,dept_name,patient_name,patient_id,bed_id,bed_card,bed_price,bed_status,room_id,building_id,comment,writor,register_date,teacher_check,kzr_check,base_check,manager_check,TeacherId,TeacherName from GP_Bed_Management "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.NVarChar, 50) }; parameters[0].Value = id; BedManagementModel model = new BedManagementModel(); 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); } }
public bool Update(BedManagementModel model, string id) { StringBuilder strSql = new StringBuilder(); strSql.Append("update GP_Bed_Management set "); strSql.Append("dept_code=@dept_code,"); strSql.Append("dept_name=@dept_name,"); strSql.Append("patient_name=@patient_name,"); strSql.Append("patient_id=@patient_id,"); strSql.Append("bed_id=@bed_id,"); strSql.Append("bed_card=@bed_card,"); strSql.Append("bed_price=@bed_price,"); strSql.Append("bed_status=@bed_status,"); strSql.Append("room_id=@room_id,"); strSql.Append("building_id=@building_id,"); strSql.Append("comment=@comment,"); strSql.Append("writor=@writor,"); strSql.Append("register_date=@register_date,"); strSql.Append("TeacherId=@TeacherId,"); strSql.Append("TeacherName=@TeacherName"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@dept_code", SqlDbType.NVarChar, 50), new SqlParameter("@dept_name", SqlDbType.NVarChar, 500), new SqlParameter("@patient_name", SqlDbType.NVarChar, 50), new SqlParameter("@patient_id", SqlDbType.NVarChar, 50), new SqlParameter("@bed_id", SqlDbType.NVarChar, 50), new SqlParameter("@bed_card", SqlDbType.NVarChar, 50), new SqlParameter("@bed_price", SqlDbType.NVarChar, 50), new SqlParameter("@bed_status", SqlDbType.NVarChar, 50), new SqlParameter("@room_id", SqlDbType.NVarChar, 50), new SqlParameter("@building_id", SqlDbType.NVarChar, 50), new SqlParameter("@comment", SqlDbType.NVarChar, 1000), new SqlParameter("@writor", SqlDbType.NVarChar, 50), new SqlParameter("@register_date", SqlDbType.NVarChar, 50), new SqlParameter("@TeacherId", SqlDbType.NVarChar, 50), new SqlParameter("@TeacherName", SqlDbType.NVarChar, 50), new SqlParameter("@id", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.dept_code; parameters[1].Value = model.dept_name; parameters[2].Value = model.patient_name; parameters[3].Value = model.patient_id; parameters[4].Value = model.bed_id; parameters[5].Value = model.bed_card; parameters[6].Value = model.bed_price; parameters[7].Value = model.bed_status; parameters[8].Value = model.room_id; parameters[9].Value = model.building_id; parameters[10].Value = model.comment; parameters[11].Value = model.writor; parameters[12].Value = model.register_date; parameters[13].Value = model.TeacherId; parameters[14].Value = model.TeacherName; parameters[15].Value = id; int rows = db.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public BedManagementModel DataRowToModel(DataRow row) { BedManagementModel model = new BedManagementModel(); 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["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["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["dept_code"] != null) { model.dept_code = row["dept_code"].ToString(); } if (row["dept_name"] != null) { model.dept_name = row["dept_name"].ToString(); } if (row["patient_name"] != null) { model.patient_name = row["patient_name"].ToString(); } if (row["patient_id"] != null) { model.patient_id = row["patient_id"].ToString(); } if (row["bed_id"] != null) { model.bed_id = row["bed_id"].ToString(); } if (row["bed_card"] != null) { model.bed_card = row["bed_card"].ToString(); } if (row["bed_price"] != null) { model.bed_price = row["bed_price"].ToString(); } if (row["bed_status"] != null) { model.bed_status = row["bed_status"].ToString(); } if (row["room_id"] != null) { model.room_id = row["room_id"].ToString(); } if (row["building_id"] != null) { model.building_id = row["building_id"].ToString(); } if (row["comment"] != null) { model.comment = row["comment"].ToString(); } if (row["writor"] != null) { model.writor = row["writor"].ToString(); } if (row["register_date"] != null) { model.register_date = row["register_date"].ToString(); } if (row["teacher_check"] != null) { model.teacher_check = row["teacher_check"].ToString(); } if (row["kzr_check"] != null) { model.kzr_check = row["kzr_check"].ToString(); } if (row["base_check"] != null) { model.base_check = row["base_check"].ToString(); } if (row["manager_check"] != null) { model.manager_check = row["manager_check"].ToString(); } if (row["TeacherId"] != null) { model.TeacherId = row["TeacherId"].ToString(); } if (row["TeacherName"] != null) { model.TeacherName = row["TeacherName"].ToString(); } } return(model); }
public bool Add(BedManagementModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into GP_Bed_Management("); strSql.Append("id,students_name,students_real_name,training_base_code,training_base_name,professional_base_code,professional_base_name,dept_code,dept_name,patient_name,patient_id,bed_id,bed_card,bed_price,bed_status,room_id,building_id,comment,writor,register_date,teacher_check,kzr_check,base_check,manager_check,TeacherId,TeacherName)"); strSql.Append(" values ("); strSql.Append("@id,@students_name,@students_real_name,@training_base_code,@training_base_name,@professional_base_code,@professional_base_name,@dept_code,@dept_name,@patient_name,@patient_id,@bed_id,@bed_card,@bed_price,@bed_status,@room_id,@building_id,@comment,@writor,@register_date,@teacher_check,@kzr_check,@base_check,@manager_check,@TeacherId,@TeacherName)"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.NVarChar, 50), new SqlParameter("@students_name", SqlDbType.NVarChar, 50), new SqlParameter("@students_real_name", SqlDbType.NVarChar, 50), new SqlParameter("@training_base_code", SqlDbType.NVarChar, 50), new SqlParameter("@training_base_name", SqlDbType.NVarChar, 50), new SqlParameter("@professional_base_code", SqlDbType.NVarChar, 50), new SqlParameter("@professional_base_name", SqlDbType.NVarChar, 50), new SqlParameter("@dept_code", SqlDbType.NVarChar, 50), new SqlParameter("@dept_name", SqlDbType.NVarChar, 500), new SqlParameter("@patient_name", SqlDbType.NVarChar, 50), new SqlParameter("@patient_id", SqlDbType.NVarChar, 50), new SqlParameter("@bed_id", SqlDbType.NVarChar, 50), new SqlParameter("@bed_card", SqlDbType.NVarChar, 50), new SqlParameter("@bed_price", SqlDbType.NVarChar, 50), new SqlParameter("@bed_status", SqlDbType.NVarChar, 50), new SqlParameter("@room_id", SqlDbType.NVarChar, 50), new SqlParameter("@building_id", SqlDbType.NVarChar, 50), new SqlParameter("@comment", SqlDbType.NVarChar, 1000), new SqlParameter("@writor", SqlDbType.NVarChar, 50), new SqlParameter("@register_date", SqlDbType.NVarChar, 50), new SqlParameter("@teacher_check", SqlDbType.NVarChar, 50), new SqlParameter("@kzr_check", SqlDbType.NVarChar, 50), new SqlParameter("@base_check", SqlDbType.NVarChar, 50), new SqlParameter("@manager_check", SqlDbType.NVarChar, 50), new SqlParameter("@TeacherId", SqlDbType.NVarChar, 50), new SqlParameter("@TeacherName", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.id; parameters[1].Value = model.students_name; parameters[2].Value = model.students_real_name; parameters[3].Value = model.training_base_code; parameters[4].Value = model.training_base_name; parameters[5].Value = model.professional_base_code; parameters[6].Value = model.professional_base_name; parameters[7].Value = model.dept_code; parameters[8].Value = model.dept_name; parameters[9].Value = model.patient_name; parameters[10].Value = model.patient_id; parameters[11].Value = model.bed_id; parameters[12].Value = model.bed_card; parameters[13].Value = model.bed_price; parameters[14].Value = model.bed_status; parameters[15].Value = model.room_id; parameters[16].Value = model.building_id; parameters[17].Value = model.comment; parameters[18].Value = model.writor; parameters[19].Value = model.register_date; parameters[20].Value = model.teacher_check; parameters[21].Value = model.kzr_check; parameters[22].Value = model.base_check; parameters[23].Value = model.manager_check; parameters[24].Value = model.TeacherId; parameters[25].Value = model.TeacherName; int rows = db.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
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 StudentsPersonalInformation2Model(); studentsPersonalInformationBLL = new StudentsPersonalInformation2BLL(); dt = new DataTable(); professionalBaseDeptBLL = new ProfessionalBaseDeptBLL(); loginModel = (LoginModel)Session["loginModel"]; writor.Text = loginModel.real_name; students_real_name.Text = loginModel.real_name; students_real_name.ReadOnly = true; if (string.IsNullOrEmpty(id)) { register_date.Text = DateTime.Now.Date.ToString("yyyy-MM-dd"); } na = loginModel.name; students_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 { TrainingBaseCode.Value = studentsPersonalInformationModel.TrainingBaseCode.ToString(); training_base_name.Text = studentsPersonalInformationModel.TrainingBaseName.ToString(); training_base_name.ReadOnly = true; ProfessionalBaseCode.Value = studentsPersonalInformationModel.ProfessionalBaseCode.ToString(); professional_base_name.Text = studentsPersonalInformationModel.ProfessionalBaseName.ToString(); professional_base_name.ReadOnly = true; dt = professionalBaseDeptBLL.GetDeptDataTableByCode(studentsPersonalInformationModel.ProfessionalBaseCode.ToString()); RotaryDept.DataSource = dt; RotaryDept.DataTextField = "dept_name"; RotaryDept.DataValueField = "dept_code"; RotaryDept.DataBind(); RotaryDept.Items.Insert(0, new ListItem("==请选择==", "0")); } if (!string.IsNullOrEmpty(id)) {//如果不是表单提交,并且带了id值来做修改操作,则在界面上把值都呈现出来 bedManagementMode = new BedManagementModel(); bedManagementBLL = new BedManagementBLL(); bedManagementMode = bedManagementBLL.GetModelById(id); students_real_name.Text = bedManagementMode.students_real_name.ToString(); training_base_name.Text = bedManagementMode.training_base_name.ToString(); professional_base_name.Text = bedManagementMode.professional_base_name.ToString(); //RotaryDept.SelectedItem.Text = bedManagementMode.dept_name.ToString(); RotaryDept.SelectedValue = bedManagementMode.dept_code.ToString(); //RotaryDept.Items.Insert(0, new ListItem("==请选择==", "0")); dt = new LoginBLL().GetTeachersDtByDeptCode(bedManagementMode.training_base_code, bedManagementMode.professional_base_code, bedManagementMode.dept_code, "teachers"); Teacher.DataSource = dt; Teacher.DataTextField = "real_name"; Teacher.DataValueField = "name"; Teacher.DataBind(); Teacher.Items.Insert(0, new ListItem("==请选择==", "0")); Teacher.SelectedValue = bedManagementMode.TeacherId; //Teacher.SelectedItem.Text = bedManagementMode.TeacherName.ToString(); //Teacher.SelectedItem.Value = bedManagementMode.TeacherId.ToString(); patient_name.Text = bedManagementMode.patient_name.ToString(); patient_id.Text = bedManagementMode.patient_id.ToString(); bed_id.Text = bedManagementMode.bed_id.ToString(); bed_card.Text = bedManagementMode.bed_card.ToString(); bed_price.Text = bedManagementMode.bed_price.ToString(); bed_status.Text = bedManagementMode.bed_status.ToString(); room_id.Text = bedManagementMode.room_id.ToString(); building_id.Text = bedManagementMode.building_id.ToString(); comment.Text = bedManagementMode.comment.ToString(); writor.Text = bedManagementMode.writor.ToString(); register_date.Text = bedManagementMode.register_date.ToString(); } } }
protected void save_Click(object sender, EventArgs e) { bedManagementMode = new BedManagementModel(); bedManagementBLL = new BedManagementBLL(); bedManagementMode.dept_code = CommonFunc.FilterSpecialString(RotaryDept.SelectedItem.Value); bedManagementMode.dept_name = CommonFunc.FilterSpecialString(RotaryDept.SelectedItem.Text); bedManagementMode.TeacherId = CommonFunc.FilterSpecialString(Teacher.SelectedItem.Value); bedManagementMode.TeacherName = CommonFunc.FilterSpecialString(Teacher.SelectedItem.Text); bedManagementMode.patient_name = CommonFunc.FilterSpecialString(patient_name.Text); bedManagementMode.patient_id = CommonFunc.FilterSpecialString(patient_id.Text); bedManagementMode.bed_id = CommonFunc.FilterSpecialString(bed_id.Text); bedManagementMode.bed_card = CommonFunc.FilterSpecialString(bed_card.Text); bedManagementMode.bed_price = CommonFunc.FilterSpecialString(bed_price.Text); bedManagementMode.bed_status = CommonFunc.FilterSpecialString(bed_status.Text); bedManagementMode.room_id = CommonFunc.FilterSpecialString(room_id.Text); bedManagementMode.building_id = CommonFunc.FilterSpecialString(building_id.Text); bedManagementMode.comment = CommonFunc.FilterSpecialString(comment.Text); bedManagementMode.writor = CommonFunc.FilterSpecialString(writor.Text); bedManagementMode.register_date = CommonFunc.FilterSpecialString(register_date.Text.Trim()); if (string.IsNullOrEmpty(id)) { id = Guid.NewGuid().ToString(); bedManagementMode.id = id; bedManagementMode.students_name = students_name.Value.ToString(); bedManagementMode.students_real_name = CommonFunc.FilterSpecialString(students_real_name.Text.Trim()); bedManagementMode.training_base_code = CommonFunc.FilterSpecialString(TrainingBaseCode.Value); bedManagementMode.training_base_name = CommonFunc.FilterSpecialString(training_base_name.Text); bedManagementMode.professional_base_code = CommonFunc.FilterSpecialString(ProfessionalBaseCode.Value); bedManagementMode.professional_base_name = CommonFunc.FilterSpecialString(professional_base_name.Text); bedManagementMode.teacher_check = teacher_check; bedManagementMode.kzr_check = kzr_check; bedManagementMode.base_check = base_check; bedManagementMode.manager_check = manager_check; if (bedManagementMode.dept_code == "0" || bedManagementMode.dept_name == "==请选择==") { ShowMessageBox.Showmessagebox(this, "轮转科室不能为空", null); return; } if (bedManagementMode.TeacherId == "0" || bedManagementMode.TeacherName == "==请选择==") { ShowMessageBox.Showmessagebox(this, "指导医师不能为空", null); return; } if (string.IsNullOrEmpty(bedManagementMode.patient_name)) { ShowMessageBox.Showmessagebox(this, "病人姓名不能为空", null); return; } if (string.IsNullOrEmpty(bedManagementMode.bed_id)) { ShowMessageBox.Showmessagebox(this, "床位编号不能为空", null); return; } if (string.IsNullOrEmpty(bedManagementMode.bed_status)) { ShowMessageBox.Showmessagebox(this, "床位状态不能为空", null); return; } if (string.IsNullOrEmpty(bedManagementMode.room_id)) { ShowMessageBox.Showmessagebox(this, "房间号不能为空", null); return; } if (string.IsNullOrEmpty(bedManagementMode.building_id)) { ShowMessageBox.Showmessagebox(this, "所在楼不能为空", null); return; } if (bedManagementMode.comment.Length > 1000) { ShowMessageBox.Showmessagebox(this, "备注字数不能超过1000字", null); return; } if (bedManagementBLL.Add(bedManagementMode)) { try { Response.Write("<script language='javascript'> alert('床位管理信息添加成功');window.opener.parent.frames.bodyFrame.frames.frmright.window.loadPageList(1);window.close();</script>"); } catch (Exception ex) { Response.Write(ex.Message); } } } else { if (bedManagementMode.dept_code == "0" || bedManagementMode.dept_name == "==请选择==") { ShowMessageBox.Showmessagebox(this, "轮转科室不能为空", null); return; } if (string.IsNullOrEmpty(bedManagementMode.patient_name)) { ShowMessageBox.Showmessagebox(this, "病人姓名不能为空", null); return; } if (string.IsNullOrEmpty(bedManagementMode.bed_id)) { ShowMessageBox.Showmessagebox(this, "床位编号不能为空", null); return; } if (string.IsNullOrEmpty(bedManagementMode.bed_status)) { ShowMessageBox.Showmessagebox(this, "床位状态不能为空", null); return; } if (string.IsNullOrEmpty(bedManagementMode.room_id)) { ShowMessageBox.Showmessagebox(this, "房间号不能为空", null); return; } if (string.IsNullOrEmpty(bedManagementMode.building_id)) { ShowMessageBox.Showmessagebox(this, "所在楼不能为空", null); return; } if (bedManagementMode.comment.Length > 1000) { ShowMessageBox.Showmessagebox(this, "备注字数不能超过1000字", null); return; } if (bedManagementBLL.Update(bedManagementMode, id)) { try { Response.Write("<script language='javascript'> alert('床位管理信息修改成功');window.opener.window.loadPageList('" + pi + "');window.close();</script>"); } catch (Exception ex) { Response.Write(ex.Message); } } } }
public bool UpdateCheckByTeacher(BedManagementModel model) { return(bedManagementDAL.UpdateCheckByTeacher(model)); }
public bool Update(BedManagementModel model, string id) { return(bedManagementDAL.Update(model, id)); }
public bool Add(BedManagementModel model) { return(bedManagementDAL.Add(model)); }