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"])); writeMedicalRecordsModel = new WriteMedicalRecordsModel(); writeMedicalRecordsBLL = new WriteMedicalRecordsBLL(); writeMedicalRecordsModel = writeMedicalRecordsBLL.GetModelById(id); StudentsRealName.Text = writeMedicalRecordsModel.StudentsRealName.ToString(); TrainingBaseName.Text = writeMedicalRecordsModel.TrainingBaseName.ToString(); ProfessionalBaseName.Text = writeMedicalRecordsModel.ProfessionalBaseName.ToString(); RotaryDept.SelectedItem.Text = writeMedicalRecordsModel.DeptName.ToString(); RotaryDept.SelectedValue = writeMedicalRecordsModel.DeptCode.ToString(); Teacher.SelectedItem.Text = writeMedicalRecordsModel.TeacherName.ToString(); Teacher.SelectedItem.Value = writeMedicalRecordsModel.TeacherId.ToString(); PatientName.Text = writeMedicalRecordsModel.PatientName.ToString(); CaseId.Text = writeMedicalRecordsModel.CaseId.ToString(); MainDiagnosis.Text = writeMedicalRecordsModel.MainDiagnosis.ToString(); SuperiorDoctor.Text = writeMedicalRecordsModel.SuperiorDoctor.ToString(); IsBigCase.SelectedValue = writeMedicalRecordsModel.IsBigCase.ToString(); Comment.Text = writeMedicalRecordsModel.Comment.ToString(); Writor.Text = writeMedicalRecordsModel.Writor.ToString(); RegisterDate.Text = writeMedicalRecordsModel.RegisterDate.ToString(); }
public bool UpdateCheckByTeacher(WriteMedicalRecordsModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update GP_WriteMedicalRecords set "); strSql.Append("TeacherCheck=@TeacherCheck"); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@TeacherCheck", SqlDbType.NVarChar, 50), new SqlParameter("@Id", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.TeacherCheck; parameters[1].Value = model.Id; int rows = db.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public bool Update(WriteMedicalRecordsModel model, string id) { StringBuilder strSql = new StringBuilder(); strSql.Append("update GP_WriteMedicalRecords set "); strSql.Append("DeptCode=@DeptCode,"); strSql.Append("DeptName=@DeptName,"); strSql.Append("RegisterDate=@RegisterDate,"); strSql.Append("Writor=@Writor,"); strSql.Append("PatientName=@PatientName,"); strSql.Append("CaseId=@CaseId,"); strSql.Append("MainDiagnosis=@MainDiagnosis,"); strSql.Append("SuperiorDoctor=@SuperiorDoctor,"); strSql.Append("IsBigCase=@IsBigCase,"); strSql.Append("Comment=@Comment,"); strSql.Append("TeacherId=@TeacherId,"); strSql.Append("TeacherName=@TeacherName"); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@DeptCode", SqlDbType.NVarChar, 50), new SqlParameter("@DeptName", SqlDbType.NVarChar, 500), new SqlParameter("@RegisterDate", SqlDbType.NVarChar, 50), new SqlParameter("@Writor", SqlDbType.NVarChar, 50), new SqlParameter("@PatientName", SqlDbType.NVarChar, 50), new SqlParameter("@CaseId", SqlDbType.NVarChar, 50), new SqlParameter("@MainDiagnosis", SqlDbType.NVarChar, 2000), new SqlParameter("@SuperiorDoctor", SqlDbType.NVarChar, 50), new SqlParameter("@IsBigCase", SqlDbType.NVarChar, 50), new SqlParameter("@Comment", SqlDbType.NVarChar, 1000), new SqlParameter("@TeacherId", SqlDbType.NVarChar, 50), new SqlParameter("@TeacherName", SqlDbType.NVarChar, 50), new SqlParameter("@Id", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.DeptCode; parameters[1].Value = model.DeptName; parameters[2].Value = model.RegisterDate; parameters[3].Value = model.Writor; parameters[4].Value = model.PatientName; parameters[5].Value = model.CaseId; parameters[6].Value = model.MainDiagnosis; parameters[7].Value = model.SuperiorDoctor; parameters[8].Value = model.IsBigCase; parameters[9].Value = model.Comment; parameters[10].Value = model.TeacherId; parameters[11].Value = model.TeacherName; parameters[12].Value = id; int rows = db.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public List <Model.WriteMedicalRecordsModel> GetPagedList(string StudentsName, string TrainingBaseCode, string DeptName, string PatientName, string CaseId, string IsBigCase, int start, int end) { string sql = "select * from (select row_number() over(order by RegisterDate desc) as num,* from GP_WriteMedicalRecords where StudentsName='" + StudentsName + "' and TrainingBaseCode='" + TrainingBaseCode + "'"; if (!string.IsNullOrEmpty(DeptName)) { sql += "and DeptName like '%" + DeptName + "%'"; } if (!string.IsNullOrEmpty(PatientName)) { sql += "and PatientName like '%" + PatientName + "%'"; } if (!string.IsNullOrEmpty(CaseId)) { sql += "and CaseId like '%" + CaseId + "%'"; } if (!string.IsNullOrEmpty(IsBigCase)) { sql += "and IsBigCase='" + IsBigCase + "'"; } 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 <WriteMedicalRecordsModel> list = null; if (dt.Rows.Count > 0) { list = new List <WriteMedicalRecordsModel>(); WriteMedicalRecordsModel model = null; foreach (DataRow row in dt.Rows) { model = new WriteMedicalRecordsModel(); model = DataRowToModel(row); list.Add(model); } } return(list); }
public WriteMedicalRecordsModel GetModelById(string Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,StudentsRealName,StudentsName,TrainingBaseCode,TrainingBaseName,ProfessionalBaseCode,ProfessionalBaseName,DeptCode,DeptName,RegisterDate,Writor,TeacherCheck,KzrCheck,BaseCheck,ManagerCheck,PatientName,CaseId,MainDiagnosis,SuperiorDoctor,IsBigCase,Comment,TeacherId,TeacherName from GP_WriteMedicalRecords "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.NVarChar, 50) }; parameters[0].Value = Id; WriteMedicalRecordsModel model = new WriteMedicalRecordsModel(); 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 Add(WriteMedicalRecordsModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into GP_WriteMedicalRecords("); strSql.Append("Id,StudentsRealName,StudentsName,TrainingBaseCode,TrainingBaseName,ProfessionalBaseCode,ProfessionalBaseName,DeptCode,DeptName,RegisterDate,Writor,TeacherCheck,KzrCheck,BaseCheck,ManagerCheck,PatientName,CaseId,MainDiagnosis,SuperiorDoctor,IsBigCase,Comment,TeacherId,TeacherName)"); strSql.Append(" values ("); strSql.Append("@Id,@StudentsRealName,@StudentsName,@TrainingBaseCode,@TrainingBaseName,@ProfessionalBaseCode,@ProfessionalBaseName,@DeptCode,@DeptName,@RegisterDate,@Writor,@TeacherCheck,@KzrCheck,@BaseCheck,@ManagerCheck,@PatientName,@CaseId,@MainDiagnosis,@SuperiorDoctor,@IsBigCase,@Comment,@TeacherId,@TeacherName)"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.NVarChar, 50), new SqlParameter("@StudentsRealName", SqlDbType.NVarChar, 50), new SqlParameter("@StudentsName", SqlDbType.NVarChar, 50), new SqlParameter("@TrainingBaseCode", SqlDbType.NVarChar, 50), new SqlParameter("@TrainingBaseName", SqlDbType.NVarChar, 50), new SqlParameter("@ProfessionalBaseCode", SqlDbType.NVarChar, 50), new SqlParameter("@ProfessionalBaseName", SqlDbType.NVarChar, 50), new SqlParameter("@DeptCode", SqlDbType.NVarChar, 50), new SqlParameter("@DeptName", SqlDbType.NVarChar, 500), new SqlParameter("@RegisterDate", SqlDbType.NVarChar, 50), new SqlParameter("@Writor", SqlDbType.NVarChar, 50), new SqlParameter("@TeacherCheck", SqlDbType.NVarChar, 50), new SqlParameter("@KzrCheck", SqlDbType.NVarChar, 50), new SqlParameter("@BaseCheck", SqlDbType.NVarChar, 50), new SqlParameter("@ManagerCheck", SqlDbType.NVarChar, 50), new SqlParameter("@PatientName", SqlDbType.NVarChar, 50), new SqlParameter("@CaseId", SqlDbType.NVarChar, 50), new SqlParameter("@MainDiagnosis", SqlDbType.NVarChar, 2000), new SqlParameter("@SuperiorDoctor", SqlDbType.NVarChar, 50), new SqlParameter("@IsBigCase", SqlDbType.NVarChar, 50), new SqlParameter("@Comment", SqlDbType.NVarChar, 1000), new SqlParameter("@TeacherId", SqlDbType.NVarChar, 50), new SqlParameter("@TeacherName", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.Id; parameters[1].Value = model.StudentsRealName; parameters[2].Value = model.StudentsName; parameters[3].Value = model.TrainingBaseCode; parameters[4].Value = model.TrainingBaseName; parameters[5].Value = model.ProfessionalBaseCode; parameters[6].Value = model.ProfessionalBaseName; parameters[7].Value = model.DeptCode; parameters[8].Value = model.DeptName; parameters[9].Value = model.RegisterDate; parameters[10].Value = model.Writor; parameters[11].Value = model.TeacherCheck; parameters[12].Value = model.KzrCheck; parameters[13].Value = model.BaseCheck; parameters[14].Value = model.ManagerCheck; parameters[15].Value = model.PatientName; parameters[16].Value = model.CaseId; parameters[17].Value = model.MainDiagnosis; parameters[18].Value = model.SuperiorDoctor; parameters[19].Value = model.IsBigCase; parameters[20].Value = model.Comment; parameters[21].Value = model.TeacherId; parameters[22].Value = model.TeacherName; int rows = db.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public WriteMedicalRecordsModel DataRowToModel(DataRow row) { WriteMedicalRecordsModel model = new WriteMedicalRecordsModel(); if (row != null) { if (row["Id"] != null) { model.Id = row["Id"].ToString(); } if (row["StudentsRealName"] != null) { model.StudentsRealName = row["StudentsRealName"].ToString(); } if (row["StudentsName"] != null) { model.StudentsName = row["StudentsName"].ToString(); } if (row["TrainingBaseCode"] != null) { model.TrainingBaseCode = row["TrainingBaseCode"].ToString(); } if (row["TrainingBaseName"] != null) { model.TrainingBaseName = row["TrainingBaseName"].ToString(); } if (row["ProfessionalBaseCode"] != null) { model.ProfessionalBaseCode = row["ProfessionalBaseCode"].ToString(); } if (row["ProfessionalBaseName"] != null) { model.ProfessionalBaseName = row["ProfessionalBaseName"].ToString(); } if (row["DeptCode"] != null) { model.DeptCode = row["DeptCode"].ToString(); } if (row["DeptName"] != null) { model.DeptName = row["DeptName"].ToString(); } if (row["RegisterDate"] != null) { model.RegisterDate = row["RegisterDate"].ToString(); } if (row["Writor"] != null) { model.Writor = row["Writor"].ToString(); } if (row["TeacherCheck"] != null) { model.TeacherCheck = row["TeacherCheck"].ToString(); } if (row["KzrCheck"] != null) { model.KzrCheck = row["KzrCheck"].ToString(); } if (row["BaseCheck"] != null) { model.BaseCheck = row["BaseCheck"].ToString(); } if (row["ManagerCheck"] != null) { model.ManagerCheck = row["ManagerCheck"].ToString(); } if (row["PatientName"] != null) { model.PatientName = row["PatientName"].ToString(); } if (row["CaseId"] != null) { model.CaseId = row["CaseId"].ToString(); } if (row["MainDiagnosis"] != null) { model.MainDiagnosis = row["MainDiagnosis"].ToString(); } if (row["SuperiorDoctor"] != null) { model.SuperiorDoctor = row["SuperiorDoctor"].ToString(); } if (row["IsBigCase"] != null) { model.IsBigCase = row["IsBigCase"].ToString(); } if (row["Comment"] != null) { model.Comment = row["Comment"].ToString(); } if (row["TeacherId"] != null) { model.TeacherId = row["TeacherId"].ToString(); } if (row["TeacherName"] != null) { model.TeacherName = row["TeacherName"].ToString(); } } return(model); }
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; StudentsRealName.Text = loginModel.real_name; StudentsRealName.ReadOnly = true; RegisterDate.Text = DateTime.Now.Date.ToString("yyyy-MM-dd"); RegisterDate.ReadOnly = true; na = loginModel.name; StudentsName.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(); TrainingBaseName.Text = studentsPersonalInformationModel.TrainingBaseName.ToString(); TrainingBaseName.ReadOnly = true; ProfessionalBaseCode.Value = studentsPersonalInformationModel.ProfessionalBaseCode.ToString(); ProfessionalBaseName.Text = studentsPersonalInformationModel.ProfessionalBaseName.ToString(); ProfessionalBaseName.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值来做修改操作,则在界面上把值都呈现出来 writeMedicalRecordsModel = new WriteMedicalRecordsModel(); writeMedicalRecordsBLL = new WriteMedicalRecordsBLL(); writeMedicalRecordsModel = writeMedicalRecordsBLL.GetModelById(id); StudentsRealName.Text = writeMedicalRecordsModel.StudentsRealName.ToString(); TrainingBaseName.Text = writeMedicalRecordsModel.TrainingBaseName.ToString(); ProfessionalBaseName.Text = writeMedicalRecordsModel.ProfessionalBaseName.ToString(); //RotaryDept.SelectedItem.Text = writeMedicalRecordsModel.DeptName.ToString(); RotaryDept.SelectedValue = writeMedicalRecordsModel.DeptCode.ToString(); dt = new LoginBLL().GetTeachersDtByDeptCode(writeMedicalRecordsModel.TrainingBaseCode, writeMedicalRecordsModel.ProfessionalBaseCode, writeMedicalRecordsModel.DeptCode, "teachers"); Teacher.DataSource = dt; Teacher.DataTextField = "real_name"; Teacher.DataValueField = "name"; Teacher.DataBind(); Teacher.Items.Insert(0, new ListItem("==请选择==", "0")); Teacher.SelectedValue = writeMedicalRecordsModel.TeacherId; //Teacher.SelectedItem.Text = writeMedicalRecordsModel.TeacherName.ToString(); //Teacher.SelectedItem.Value = writeMedicalRecordsModel.TeacherId.ToString(); //RotaryDept.Items.Insert(0, new ListItem("==请选择==", "0")); PatientName.Text = writeMedicalRecordsModel.PatientName.ToString(); CaseId.Text = writeMedicalRecordsModel.CaseId.ToString(); MainDiagnosis.Text = writeMedicalRecordsModel.MainDiagnosis.ToString(); SuperiorDoctor.Text = writeMedicalRecordsModel.SuperiorDoctor.ToString(); IsBigCase.SelectedValue = writeMedicalRecordsModel.IsBigCase.ToString(); Comment.Text = writeMedicalRecordsModel.Comment.ToString(); Writor.Text = writeMedicalRecordsModel.Writor.ToString(); RegisterDate.Text = writeMedicalRecordsModel.RegisterDate.ToString(); } } }
protected void save_Click(object sender, EventArgs e) { writeMedicalRecordsModel = new WriteMedicalRecordsModel(); writeMedicalRecordsBLL = new WriteMedicalRecordsBLL(); writeMedicalRecordsModel.DeptCode = CommonFunc.FilterSpecialString(RotaryDept.SelectedItem.Value); writeMedicalRecordsModel.DeptName = CommonFunc.FilterSpecialString(RotaryDept.SelectedItem.Text); writeMedicalRecordsModel.TeacherId = CommonFunc.FilterSpecialString(Teacher.SelectedItem.Value); writeMedicalRecordsModel.TeacherName = CommonFunc.FilterSpecialString(Teacher.SelectedItem.Text); writeMedicalRecordsModel.PatientName = CommonFunc.FilterSpecialString(PatientName.Text); writeMedicalRecordsModel.CaseId = CommonFunc.FilterSpecialString(CaseId.Text); writeMedicalRecordsModel.MainDiagnosis = CommonFunc.FilterSpecialString(MainDiagnosis.Text); writeMedicalRecordsModel.SuperiorDoctor = CommonFunc.FilterSpecialString(SuperiorDoctor.Text); writeMedicalRecordsModel.IsBigCase = CommonFunc.FilterSpecialString(IsBigCase.SelectedItem.Value); writeMedicalRecordsModel.Comment = CommonFunc.FilterSpecialString(Comment.Text); writeMedicalRecordsModel.Writor = CommonFunc.FilterSpecialString(Writor.Text); writeMedicalRecordsModel.RegisterDate = CommonFunc.FilterSpecialString(RegisterDate.Text); if (string.IsNullOrEmpty(id)) { id = Guid.NewGuid().ToString(); writeMedicalRecordsModel.Id = id; writeMedicalRecordsModel.StudentsName = StudentsName.Value.ToString(); writeMedicalRecordsModel.StudentsRealName = CommonFunc.FilterSpecialString(StudentsRealName.Text.Trim()); writeMedicalRecordsModel.TrainingBaseCode = CommonFunc.FilterSpecialString(TrainingBaseCode.Value); writeMedicalRecordsModel.TrainingBaseName = CommonFunc.FilterSpecialString(TrainingBaseName.Text); writeMedicalRecordsModel.ProfessionalBaseCode = CommonFunc.FilterSpecialString(ProfessionalBaseCode.Value); writeMedicalRecordsModel.ProfessionalBaseName = CommonFunc.FilterSpecialString(ProfessionalBaseName.Text); writeMedicalRecordsModel.TeacherCheck = teacher_check; writeMedicalRecordsModel.KzrCheck = kzr_check; writeMedicalRecordsModel.BaseCheck = base_check; writeMedicalRecordsModel.ManagerCheck = manager_check; if (writeMedicalRecordsModel.DeptCode == "0" || writeMedicalRecordsModel.DeptName == "==请选择==") { ShowMessageBox.Showmessagebox(this, "轮转科室不能为空", null); return; } if (writeMedicalRecordsModel.TeacherId == "0" || writeMedicalRecordsModel.TeacherName == "==请选择==") { ShowMessageBox.Showmessagebox(this, "指导医师不能为空", null); return; } if (string.IsNullOrEmpty(writeMedicalRecordsModel.PatientName)) { ShowMessageBox.Showmessagebox(this, "病人姓名不能为空", null); return; } if (string.IsNullOrEmpty(writeMedicalRecordsModel.CaseId)) { ShowMessageBox.Showmessagebox(this, "病历号不能为空", null); return; } if (string.IsNullOrEmpty(writeMedicalRecordsModel.MainDiagnosis)) { ShowMessageBox.Showmessagebox(this, "主要诊断不能为空", null); return; } if (writeMedicalRecordsModel.MainDiagnosis.Length > 2000) { ShowMessageBox.Showmessagebox(this, "主要诊断字数不能超过2000字", null); return; } if (writeMedicalRecordsModel.Comment.Length > 1000) { ShowMessageBox.Showmessagebox(this, "备注字数不能超过1000字", null); return; } if (writeMedicalRecordsBLL.Add(writeMedicalRecordsModel)) { 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 (writeMedicalRecordsModel.DeptCode == "0" || writeMedicalRecordsModel.DeptName == "==请选择==") { ShowMessageBox.Showmessagebox(this, "轮转科室不能为空", null); return; } if (string.IsNullOrEmpty(writeMedicalRecordsModel.PatientName)) { ShowMessageBox.Showmessagebox(this, "病人姓名不能为空", null); return; } if (string.IsNullOrEmpty(writeMedicalRecordsModel.CaseId)) { ShowMessageBox.Showmessagebox(this, "病历号不能为空", null); return; } if (string.IsNullOrEmpty(writeMedicalRecordsModel.MainDiagnosis)) { ShowMessageBox.Showmessagebox(this, "主要诊断不能为空", null); return; } if (writeMedicalRecordsModel.MainDiagnosis.Length > 2000) { ShowMessageBox.Showmessagebox(this, "主要诊断字数不能超过2000字", null); return; } if (writeMedicalRecordsModel.Comment.Length > 1000) { ShowMessageBox.Showmessagebox(this, "备注字数不能超过1000字", null); return; } if (writeMedicalRecordsBLL.Update(writeMedicalRecordsModel, 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(WriteMedicalRecordsModel model) { return(writeMedicalRecordsDAL.UpdateCheckByTeacher(model)); }
public bool Update(WriteMedicalRecordsModel model, string id) { return(writeMedicalRecordsDAL.Update(model, id)); }
public bool Add(WriteMedicalRecordsModel model) { return(writeMedicalRecordsDAL.Add(model)); }