public bool UpdateCheckByTeacher(SurgeryRecordsModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update GP_SurgeryRecords 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);
}
}
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"]));
surgeryRecordsModel = new SurgeryRecordsModel();
surgeryRecordsBLL = new SurgeryRecordsBLL();
surgeryRecordsModel = surgeryRecordsBLL.GetModelById(id);
StudentsRealName.Text = surgeryRecordsModel.StudentsRealName.ToString();
TrainingBaseName.Text = surgeryRecordsModel.TrainingBaseName.ToString();
ProfessionalBaseName.Text = surgeryRecordsModel.ProfessionalBaseName.ToString();
RotaryDept.SelectedItem.Text = surgeryRecordsModel.DeptName.ToString();
RotaryDept.SelectedItem.Value = surgeryRecordsModel.DeptCode.ToString();
Teacher.SelectedItem.Text = surgeryRecordsModel.TeacherName.ToString();
Teacher.SelectedItem.Value = surgeryRecordsModel.TeacherId.ToString();
PatientName.Text = surgeryRecordsModel.PatientName.ToString();
CaseId.Text = surgeryRecordsModel.CaseId.ToString();
SurgeryName.Text = surgeryRecordsModel.SurgeryName.ToString();
IntraoperativePosition.Text = surgeryRecordsModel.IntraoperativePosition.ToString();
RoomId.Text = surgeryRecordsModel.RoomId.ToString();
MainDiagnosis.Text = surgeryRecordsModel.MainDiagnosis.ToString();
SecondaryDiagnosis.Text = surgeryRecordsModel.SecondaryDiagnosis.ToString();
Emergency.SelectedValue = surgeryRecordsModel.Emergency.ToString();
SurgeryDate.Text = surgeryRecordsModel.SurgeryDate.ToString();
SurgeryScale.Text = surgeryRecordsModel.SurgeryScale.ToString();
DoctorInCharge.Text = surgeryRecordsModel.DoctorInCharge.ToString();
Assistant.Text = surgeryRecordsModel.Assistant.ToString();
Nurse.Text = surgeryRecordsModel.Nurse.ToString();
AnesthesiaMethod.Text = surgeryRecordsModel.AnesthesiaMethod.ToString();
Anesthetist.Text = surgeryRecordsModel.Anesthetist.ToString();
SurgeryIsStop.SelectedValue = surgeryRecordsModel.SurgeryIsStop.ToString();
if (surgeryRecordsModel.SurgeryIsStop == "否")
{
//StopReason.Text = surgeryRecordsModel.StopReason.ToString();
StopReason.Enabled = false;
}
else
{
StopReason.Text = surgeryRecordsModel.StopReason.ToString();
StopReason.Enabled = true;
}
Comment.Text = surgeryRecordsModel.Comment.ToString();
Writor.Text = surgeryRecordsModel.Writor.ToString();
RegisterDate.Text = surgeryRecordsModel.RegisterDate.ToString();
}
public SurgeryRecordsModel GetModelById(string Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,StudentsRealName,StudentsName,TrainingBaseCode,TrainingBaseName,ProfessionalBaseCode,ProfessionalBaseName,DeptCode,DeptName,RegisterDate,Writor,TeacherCheck,KzrCheck,BaseCheck,ManagerCheck,PatientName,CaseId,SurgeryName,IntraoperativePosition,RoomId,MainDiagnosis,SecondaryDiagnosis,Emergency,SurgeryDate,SurgeryScale,DoctorInCharge,Assistant,Nurse,AnesthesiaMethod,Anesthetist,SurgeryIsStop,StopReason,Comment,TeacherId,TeacherName from GP_SurgeryRecords ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.NVarChar, 50)
};
parameters[0].Value = Id;
SurgeryRecordsModel model = new SurgeryRecordsModel();
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)
{
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值来做修改操作，则在界面上把值都呈现出来
surgeryRecordsModel = new SurgeryRecordsModel();
surgeryRecordsBLL = new SurgeryRecordsBLL();
surgeryRecordsModel = surgeryRecordsBLL.GetModelById(id);
StudentsRealName.Text = surgeryRecordsModel.StudentsRealName.ToString();
TrainingBaseName.Text = surgeryRecordsModel.TrainingBaseName.ToString();
ProfessionalBaseName.Text = surgeryRecordsModel.ProfessionalBaseName.ToString();
//RotaryDept.SelectedItem.Text = surgeryRecordsModel.DeptName.ToString();
RotaryDept.SelectedValue = surgeryRecordsModel.DeptCode.ToString();
//RotaryDept.Items.Insert(0, new ListItem("==请选择==", "0"));
dt = new LoginBLL().GetTeachersDtByDeptCode(surgeryRecordsModel.TrainingBaseCode, surgeryRecordsModel.ProfessionalBaseCode, surgeryRecordsModel.DeptCode, "teachers");
Teacher.DataSource = dt;
Teacher.DataTextField = "real_name";
Teacher.DataValueField = "name";
Teacher.DataBind();
Teacher.Items.Insert(0, new ListItem("==请选择==", "0"));
Teacher.SelectedValue = surgeryRecordsModel.TeacherId;
//Teacher.SelectedItem.Text = surgeryRecordsModel.TeacherName.ToString();
//Teacher.SelectedItem.Value = surgeryRecordsModel.TeacherId.ToString();
PatientName.Text = surgeryRecordsModel.PatientName.ToString();
CaseId.Text = surgeryRecordsModel.CaseId.ToString();
SurgeryName.Text = surgeryRecordsModel.SurgeryName.ToString();
IntraoperativePosition.Text = surgeryRecordsModel.IntraoperativePosition.ToString();
RoomId.Text = surgeryRecordsModel.RoomId.ToString();
MainDiagnosis.Text = surgeryRecordsModel.MainDiagnosis.ToString();
SecondaryDiagnosis.Text = surgeryRecordsModel.SecondaryDiagnosis.ToString();
Emergency.SelectedValue = surgeryRecordsModel.Emergency.ToString();
SurgeryDate.Text = surgeryRecordsModel.SurgeryDate.ToString();
SurgeryScale.Text = surgeryRecordsModel.SurgeryScale.ToString();
DoctorInCharge.Text = surgeryRecordsModel.DoctorInCharge.ToString();
Assistant.Text = surgeryRecordsModel.Assistant.ToString();
Nurse.Text = surgeryRecordsModel.Nurse.ToString();
AnesthesiaMethod.Text = surgeryRecordsModel.AnesthesiaMethod.ToString();
Anesthetist.Text = surgeryRecordsModel.Anesthetist.ToString();
SurgeryIsStop.SelectedValue = surgeryRecordsModel.SurgeryIsStop.ToString();
if (surgeryRecordsModel.SurgeryIsStop == "否")
{
//StopReason.Text = surgeryRecordsModel.StopReason.ToString();
StopReason.Enabled = false;
}
else
{
StopReason.Text = surgeryRecordsModel.StopReason.ToString();
StopReason.Enabled = true;
}
Comment.Text = surgeryRecordsModel.Comment.ToString();
Writor.Text = surgeryRecordsModel.Writor.ToString();
RegisterDate.Text = surgeryRecordsModel.RegisterDate.ToString();
}
}
}
protected void save_Click(object sender, EventArgs e)
{
surgeryRecordsModel = new SurgeryRecordsModel();
surgeryRecordsBLL = new SurgeryRecordsBLL();
surgeryRecordsModel.DeptCode = CommonFunc.FilterSpecialString(RotaryDept.SelectedItem.Value);
surgeryRecordsModel.DeptName = CommonFunc.FilterSpecialString(RotaryDept.SelectedItem.Text);
surgeryRecordsModel.TeacherId = CommonFunc.FilterSpecialString(Teacher.SelectedItem.Value);
surgeryRecordsModel.TeacherName = CommonFunc.FilterSpecialString(Teacher.SelectedItem.Text);
surgeryRecordsModel.PatientName = CommonFunc.FilterSpecialString(PatientName.Text);
surgeryRecordsModel.CaseId = CommonFunc.FilterSpecialString(CaseId.Text);
surgeryRecordsModel.SurgeryName = CommonFunc.FilterSpecialString(SurgeryName.Text);
surgeryRecordsModel.IntraoperativePosition = CommonFunc.FilterSpecialString(IntraoperativePosition.Text);
surgeryRecordsModel.RoomId = CommonFunc.FilterSpecialString(RoomId.Text);
surgeryRecordsModel.MainDiagnosis = CommonFunc.FilterSpecialString(MainDiagnosis.Text);
surgeryRecordsModel.SecondaryDiagnosis = CommonFunc.FilterSpecialString(SecondaryDiagnosis.Text);
surgeryRecordsModel.Emergency = CommonFunc.FilterSpecialString(Emergency.SelectedItem.Text);
surgeryRecordsModel.SurgeryDate = CommonFunc.FilterSpecialString(SurgeryDate.Text);
surgeryRecordsModel.SurgeryScale = CommonFunc.FilterSpecialString(SurgeryScale.Text);
surgeryRecordsModel.DoctorInCharge = CommonFunc.FilterSpecialString(DoctorInCharge.Text);
surgeryRecordsModel.Assistant = CommonFunc.FilterSpecialString(Assistant.Text);
surgeryRecordsModel.Nurse = CommonFunc.FilterSpecialString(Nurse.Text);
surgeryRecordsModel.AnesthesiaMethod = CommonFunc.FilterSpecialString(AnesthesiaMethod.Text);
surgeryRecordsModel.Anesthetist = CommonFunc.FilterSpecialString(Anesthetist.Text);
surgeryRecordsModel.SurgeryIsStop = CommonFunc.FilterSpecialString(SurgeryIsStop.SelectedItem.Text);
surgeryRecordsModel.StopReason = CommonFunc.FilterSpecialString(StopReason.Text);
surgeryRecordsModel.Comment = CommonFunc.FilterSpecialString(Comment.Text);
surgeryRecordsModel.Writor = CommonFunc.FilterSpecialString(Writor.Text);
surgeryRecordsModel.RegisterDate = CommonFunc.FilterSpecialString(RegisterDate.Text);
if (string.IsNullOrEmpty(id))
{
id = Guid.NewGuid().ToString();
surgeryRecordsModel.Id = id;
surgeryRecordsModel.StudentsName = StudentsName.Value.ToString();
surgeryRecordsModel.StudentsRealName = CommonFunc.FilterSpecialString(StudentsRealName.Text.Trim());
surgeryRecordsModel.TrainingBaseCode = CommonFunc.FilterSpecialString(TrainingBaseCode.Value);
surgeryRecordsModel.TrainingBaseName = CommonFunc.FilterSpecialString(TrainingBaseName.Text);
surgeryRecordsModel.ProfessionalBaseCode = CommonFunc.FilterSpecialString(ProfessionalBaseCode.Value);
surgeryRecordsModel.ProfessionalBaseName = CommonFunc.FilterSpecialString(ProfessionalBaseName.Text);
surgeryRecordsModel.TeacherCheck = teacher_check;
surgeryRecordsModel.KzrCheck = kzr_check;
surgeryRecordsModel.BaseCheck = base_check;
surgeryRecordsModel.ManagerCheck = manager_check;
if (surgeryRecordsModel.DeptCode == "0" || surgeryRecordsModel.DeptName == "==请选择==")
{
ShowMessageBox.Showmessagebox(this, "轮转科室不能为空", null);
return;
}
if (surgeryRecordsModel.TeacherId == "0" || surgeryRecordsModel.TeacherName == "==请选择==")
{
ShowMessageBox.Showmessagebox(this, "指导医师不能为空", null);
return;
}
if (string.IsNullOrEmpty(surgeryRecordsModel.PatientName))
{
ShowMessageBox.Showmessagebox(this, "病人姓名不能为空", null);
return;
}
if (string.IsNullOrEmpty(surgeryRecordsModel.CaseId))
{
ShowMessageBox.Showmessagebox(this, "病历号不能为空", null);
return;
}
if (string.IsNullOrEmpty(surgeryRecordsModel.SurgeryName))
{
ShowMessageBox.Showmessagebox(this, "手术名称不能为空", null);
return;
}
if (string.IsNullOrEmpty(surgeryRecordsModel.IntraoperativePosition))
{
ShowMessageBox.Showmessagebox(this, "术中职务不能为空", null);
return;
}
if (string.IsNullOrEmpty(surgeryRecordsModel.MainDiagnosis))
{
ShowMessageBox.Showmessagebox(this, "主要诊断不能为空", null);
return;
}
if (surgeryRecordsModel.MainDiagnosis.Length > 1000)
{
ShowMessageBox.Showmessagebox(this, "主要诊断字数不能超过1000字", null);
return;
}
if (surgeryRecordsModel.SecondaryDiagnosis.Length > 1000)
{
ShowMessageBox.Showmessagebox(this, "次要诊断字数不能超过1000字", null);
return;
}
if (string.IsNullOrEmpty(surgeryRecordsModel.DoctorInCharge))
{
ShowMessageBox.Showmessagebox(this, "主刀医师不能为空", null);
return;
}
if (surgeryRecordsModel.Comment.Length > 1000)
{
ShowMessageBox.Showmessagebox(this, "备注字数不能超过1000字", null);
return;
}
if (surgeryRecordsBLL.Add(surgeryRecordsModel))
{
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 (surgeryRecordsModel.DeptCode == "0" || surgeryRecordsModel.DeptName == "==请选择==")
{
ShowMessageBox.Showmessagebox(this, "轮转科室不能为空", null);
return;
}
if (surgeryRecordsModel.TeacherId == "0" || surgeryRecordsModel.TeacherName == "==请选择==")
{
ShowMessageBox.Showmessagebox(this, "指导医师不能为空", null);
return;
}
if (string.IsNullOrEmpty(surgeryRecordsModel.PatientName))
{
ShowMessageBox.Showmessagebox(this, "病人姓名不能为空", null);
return;
}
if (string.IsNullOrEmpty(surgeryRecordsModel.CaseId))
{
ShowMessageBox.Showmessagebox(this, "病历号不能为空", null);
return;
}
if (string.IsNullOrEmpty(surgeryRecordsModel.SurgeryName))
{
ShowMessageBox.Showmessagebox(this, "手术名称不能为空", null);
return;
}
if (string.IsNullOrEmpty(surgeryRecordsModel.IntraoperativePosition))
{
ShowMessageBox.Showmessagebox(this, "术中职务不能为空", null);
return;
}
if (string.IsNullOrEmpty(surgeryRecordsModel.MainDiagnosis))
{
ShowMessageBox.Showmessagebox(this, "主要诊断不能为空", null);
return;
}
if (surgeryRecordsModel.MainDiagnosis.Length > 1000)
{
ShowMessageBox.Showmessagebox(this, "主要诊断字数不能超过1000字", null);
return;
}
if (surgeryRecordsModel.SecondaryDiagnosis.Length > 1000)
{
ShowMessageBox.Showmessagebox(this, "次要诊断字数不能超过1000字", null);
return;
}
if (string.IsNullOrEmpty(surgeryRecordsModel.DoctorInCharge))
{
ShowMessageBox.Showmessagebox(this, "主刀医师不能为空", null);
return;
}
if (surgeryRecordsModel.Comment.Length > 1000)
{
ShowMessageBox.Showmessagebox(this, "备注字数不能超过1000字", null);
return;
}
if (surgeryRecordsBLL.Update(surgeryRecordsModel, 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 List <Model.SurgeryRecordsModel> CommonGetPagedList(string StudentsRealName, string TrainingBaseCode, string ProfessionalBaseCode, string DeptCode, string TeachersName, string ProfessionalBaseName, string DeptName, string TeachersRealName,
string PatientName, string CaseId, string SurgeryName, string IntraoperativePosition, string Emergency, string SurgeryDate, string SurgeryIsStop,
int start, int end)
{
string sql = "select * from (select row_number() over(order by RegisterDate desc) as num,* from GP_SurgeryRecords where TrainingBaseCode like '%" + TrainingBaseCode + "%'";
if (!string.IsNullOrEmpty(StudentsRealName))
{
sql += "and StudentsRealName like '%" + StudentsRealName + "%'";
}
if (!string.IsNullOrEmpty(ProfessionalBaseCode))
{
sql += "and ProfessionalBaseCode like '%" + ProfessionalBaseCode + "%'";
}
if (!string.IsNullOrEmpty(DeptCode))
{
sql += "and DeptCode like '%" + DeptCode + "%'";
}
if (!string.IsNullOrEmpty(TeachersName))
{
sql += "and TeacherId like '%" + TeachersName + "%'";
}
if (!string.IsNullOrEmpty(ProfessionalBaseName))
{
sql += "and ProfessionalBaseName like '%" + ProfessionalBaseName + "%'";
}
if (!string.IsNullOrEmpty(DeptName))
{
sql += "and DeptName like '%" + DeptName + "%'";
}
if (!string.IsNullOrEmpty(TeachersRealName))
{
sql += "and TeacherName like '%" + TeachersRealName + "%'";
}
if (!string.IsNullOrEmpty(PatientName))
{
sql += "and PatientName like '%" + PatientName + "%'";
}
if (!string.IsNullOrEmpty(CaseId))
{
sql += "and CaseId like '%" + CaseId + "%'";
}
if (!string.IsNullOrEmpty(SurgeryName))
{
sql += "and SurgeryName like '%" + SurgeryName + "%'";
}
if (!string.IsNullOrEmpty(IntraoperativePosition))
{
sql += "and IntraoperativePosition like '%" + IntraoperativePosition + "%'";
}
if (!string.IsNullOrEmpty(Emergency))
{
sql += "and Emergency = '" + Emergency + "'";
}
if (!string.IsNullOrEmpty(SurgeryDate))
{
sql += "and SurgeryDate like '%" + SurgeryDate + "%'";
}
if (!string.IsNullOrEmpty(SurgeryIsStop))
{
sql += "and SurgeryIsStop = '" + SurgeryIsStop + "'";
}
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 <SurgeryRecordsModel> list = null;
if (dt.Rows.Count > 0)
{
list = new List <SurgeryRecordsModel>();
SurgeryRecordsModel model = null;
foreach (DataRow row in dt.Rows)
{
model = new SurgeryRecordsModel();
model = DataRowToModel(row);
list.Add(model);
}
}
return(list);
}
public bool Update(SurgeryRecordsModel model, string id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update GP_SurgeryRecords 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("SurgeryName=@SurgeryName,");
strSql.Append("IntraoperativePosition=@IntraoperativePosition,");
strSql.Append("RoomId=@RoomId,");
strSql.Append("MainDiagnosis=@MainDiagnosis,");
strSql.Append("SecondaryDiagnosis=@SecondaryDiagnosis,");
strSql.Append("Emergency=@Emergency,");
strSql.Append("SurgeryDate=@SurgeryDate,");
strSql.Append("SurgeryScale=@SurgeryScale,");
strSql.Append("DoctorInCharge=@DoctorInCharge,");
strSql.Append("Assistant=@Assistant,");
strSql.Append("Nurse=@Nurse,");
strSql.Append("AnesthesiaMethod=@AnesthesiaMethod,");
strSql.Append("Anesthetist=@Anesthetist,");
strSql.Append("SurgeryIsStop=@SurgeryIsStop,");
strSql.Append("StopReason=@StopReason,");
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("@SurgeryName", SqlDbType.NVarChar, 500),
new SqlParameter("@IntraoperativePosition", SqlDbType.NVarChar, 50),
new SqlParameter("@RoomId", SqlDbType.NVarChar, 50),
new SqlParameter("@MainDiagnosis", SqlDbType.NVarChar, 1000),
new SqlParameter("@SecondaryDiagnosis", SqlDbType.NVarChar, 1000),
new SqlParameter("@Emergency", SqlDbType.NVarChar, 50),
new SqlParameter("@SurgeryDate", SqlDbType.NVarChar, 50),
new SqlParameter("@SurgeryScale", SqlDbType.NVarChar, 50),
new SqlParameter("@DoctorInCharge", SqlDbType.NVarChar, 50),
new SqlParameter("@Assistant", SqlDbType.NVarChar, 500),
new SqlParameter("@Nurse", SqlDbType.NVarChar, 500),
new SqlParameter("@AnesthesiaMethod", SqlDbType.NVarChar, 500),
new SqlParameter("@Anesthetist", SqlDbType.NVarChar, 50),
new SqlParameter("@SurgeryIsStop", SqlDbType.NVarChar, 50),
new SqlParameter("@StopReason", SqlDbType.NVarChar, 1000),
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.SurgeryName;
parameters[7].Value = model.IntraoperativePosition;
parameters[8].Value = model.RoomId;
parameters[9].Value = model.MainDiagnosis;
parameters[10].Value = model.SecondaryDiagnosis;
parameters[11].Value = model.Emergency;
parameters[12].Value = model.SurgeryDate;
parameters[13].Value = model.SurgeryScale;
parameters[14].Value = model.DoctorInCharge;
parameters[15].Value = model.Assistant;
parameters[16].Value = model.Nurse;
parameters[17].Value = model.AnesthesiaMethod;
parameters[18].Value = model.Anesthetist;
parameters[19].Value = model.SurgeryIsStop;
parameters[20].Value = model.StopReason;
parameters[21].Value = model.Comment;
parameters[22].Value = model.TeacherId;
parameters[23].Value = model.TeacherName;
parameters[24].Value = id;
int rows = db.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Add(SurgeryRecordsModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into GP_SurgeryRecords(");
strSql.Append("Id,StudentsRealName,StudentsName,TrainingBaseCode,TrainingBaseName,ProfessionalBaseCode,ProfessionalBaseName,DeptCode,DeptName,RegisterDate,Writor,TeacherCheck,KzrCheck,BaseCheck,ManagerCheck,PatientName,CaseId,SurgeryName,IntraoperativePosition,RoomId,MainDiagnosis,SecondaryDiagnosis,Emergency,SurgeryDate,SurgeryScale,DoctorInCharge,Assistant,Nurse,AnesthesiaMethod,Anesthetist,SurgeryIsStop,StopReason,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,@SurgeryName,@IntraoperativePosition,@RoomId,@MainDiagnosis,@SecondaryDiagnosis,@Emergency,@SurgeryDate,@SurgeryScale,@DoctorInCharge,@Assistant,@Nurse,@AnesthesiaMethod,@Anesthetist,@SurgeryIsStop,@StopReason,@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("@SurgeryName", SqlDbType.NVarChar, 500),
new SqlParameter("@IntraoperativePosition", SqlDbType.NVarChar, 50),
new SqlParameter("@RoomId", SqlDbType.NVarChar, 50),
new SqlParameter("@MainDiagnosis", SqlDbType.NVarChar, 1000),
new SqlParameter("@SecondaryDiagnosis", SqlDbType.NVarChar, 1000),
new SqlParameter("@Emergency", SqlDbType.NVarChar, 50),
new SqlParameter("@SurgeryDate", SqlDbType.NVarChar, 50),
new SqlParameter("@SurgeryScale", SqlDbType.NVarChar, 50),
new SqlParameter("@DoctorInCharge", SqlDbType.NVarChar, 50),
new SqlParameter("@Assistant", SqlDbType.NVarChar, 500),
new SqlParameter("@Nurse", SqlDbType.NVarChar, 500),
new SqlParameter("@AnesthesiaMethod", SqlDbType.NVarChar, 500),
new SqlParameter("@Anesthetist", SqlDbType.NVarChar, 50),
new SqlParameter("@SurgeryIsStop", SqlDbType.NVarChar, 50),
new SqlParameter("@StopReason", SqlDbType.NVarChar, 1000),
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.SurgeryName;
parameters[18].Value = model.IntraoperativePosition;
parameters[19].Value = model.RoomId;
parameters[20].Value = model.MainDiagnosis;
parameters[21].Value = model.SecondaryDiagnosis;
parameters[22].Value = model.Emergency;
parameters[23].Value = model.SurgeryDate;
parameters[24].Value = model.SurgeryScale;
parameters[25].Value = model.DoctorInCharge;
parameters[26].Value = model.Assistant;
parameters[27].Value = model.Nurse;
parameters[28].Value = model.AnesthesiaMethod;
parameters[29].Value = model.Anesthetist;
parameters[30].Value = model.SurgeryIsStop;
parameters[31].Value = model.StopReason;
parameters[32].Value = model.Comment;
parameters[33].Value = model.TeacherId;
parameters[34].Value = model.TeacherName;
int rows = db.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public SurgeryRecordsModel DataRowToModel(DataRow row)
{
SurgeryRecordsModel model = new SurgeryRecordsModel();
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["SurgeryName"] != null)
{
model.SurgeryName = row["SurgeryName"].ToString();
}
if (row["IntraoperativePosition"] != null)
{
model.IntraoperativePosition = row["IntraoperativePosition"].ToString();
}
if (row["RoomId"] != null)
{
model.RoomId = row["RoomId"].ToString();
}
if (row["MainDiagnosis"] != null)
{
model.MainDiagnosis = row["MainDiagnosis"].ToString();
}
if (row["SecondaryDiagnosis"] != null)
{
model.SecondaryDiagnosis = row["SecondaryDiagnosis"].ToString();
}
if (row["Emergency"] != null)
{
model.Emergency = row["Emergency"].ToString();
}
if (row["SurgeryDate"] != null)
{
model.SurgeryDate = row["SurgeryDate"].ToString();
}
if (row["SurgeryScale"] != null)
{
model.SurgeryScale = row["SurgeryScale"].ToString();
}
if (row["DoctorInCharge"] != null)
{
model.DoctorInCharge = row["DoctorInCharge"].ToString();
}
if (row["Assistant"] != null)
{
model.Assistant = row["Assistant"].ToString();
}
if (row["Nurse"] != null)
{
model.Nurse = row["Nurse"].ToString();
}
if (row["AnesthesiaMethod"] != null)
{
model.AnesthesiaMethod = row["AnesthesiaMethod"].ToString();
}
if (row["Anesthetist"] != null)
{
model.Anesthetist = row["Anesthetist"].ToString();
}
if (row["SurgeryIsStop"] != null)
{
model.SurgeryIsStop = row["SurgeryIsStop"].ToString();
}
if (row["StopReason"] != null)
{
model.StopReason = row["StopReason"].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);
}
public bool UpdateCheckByTeacher(SurgeryRecordsModel model)
{
return(surgeryRecordsDAL.UpdateCheckByTeacher(model));
}
public bool Update(SurgeryRecordsModel model, string id)
{
return(surgeryRecordsDAL.Update(model, id));
}
public bool Add(SurgeryRecordsModel model)
{
return(surgeryRecordsDAL.Add(model));
}
