public ZymosisReportEntity GetInpatientByNoofinpat(string noofinpat)
{
ZymosisReportEntity _ZymosisReportEntity = new ZymosisReportEntity();
SqlParameter[] sqlParam = new SqlParameter[]
{
new SqlParameter("@Noofinpat", SqlDbType.VarChar)
};
sqlParam[0].Value = noofinpat;
DataTable dt = m_IDataAccess.ExecuteDataTable("Emr_Zymosis_Report.usp_GetInpatientByNofinpat", sqlParam, CommandType.StoredProcedure);
if (dt.Rows.Count == 0)
{
return(null);
}
foreach (DataRow dr in dt.Rows)
{
_ZymosisReportEntity.Noofinpat = dr["Noofinpat"].ToString();
_ZymosisReportEntity.Patid = dr["patid"].ToString();
_ZymosisReportEntity.Name = dr["name"].ToString();
_ZymosisReportEntity.Idno = dr["idno"].ToString();
_ZymosisReportEntity.Sex = dr["sexid"].ToString();
_ZymosisReportEntity.Birth = dr["birth"].ToString();
_ZymosisReportEntity.Age = dr["age"].ToString();
_ZymosisReportEntity.AgeUnit = dr["ageUint"].ToString();
_ZymosisReportEntity.Organization = dr["organization"].ToString();
_ZymosisReportEntity.Officeplace = dr["officeplace"].ToString();
_ZymosisReportEntity.Officetel = dr["officetel"].ToString();
_ZymosisReportEntity.Reportdeptcode = dr["outhosdept"].ToString();
_ZymosisReportEntity.Reportdoccode = dr["attend"].ToString();
// _ZymosisReportEntity.Address = dr["address"].ToString();//原来的抓的地址
_ZymosisReportEntity.Address = dr["nativeaddress"].ToString();//现在改为这个地址
_ZymosisReportEntity.ReportDate = dr["reportdate"].ToString();
}
return(_ZymosisReportEntity);
}
/// <summary>
/// 根据用户控件的所有项的值设置获取报告卡实体
/// </summary>
/// <param name="_ZymosisReportEntity"></param>
/// <returns></returns>
private ZymosisReportEntity GetEntityUI()
{
ZymosisReportEntity _ZymosisReportEntity = new ZymosisReportEntity();
UCReportCard myCard = xtraTabPageCardInfo.Controls[0] as UCReportCard;//panelControl2.Controls[0] as UCReportCard; edit by cyq 2012-10-30
#region new code
#region 取到用户控件中更改后的值赋给实体
//报告卡类型 1、初次报告 2、订正报告
CheckEdit cheReporTtype1 = myCard.Controls["chkReportType1"] as CheckEdit;
CheckEdit cheReporTtype2 = myCard.Controls["chkReportType2"] as CheckEdit;
if (cheReporTtype1.Checked)
{
_ZymosisReportEntity.ReportType = "1";
}
else if (cheReporTtype2.Checked)
{
_ZymosisReportEntity.ReportType = "2";
}
//患者姓名
TextEdit txtName = myCard.Controls["txtName"] as TextEdit;
string txtname = txtName.EditValue.ToString();
_ZymosisReportEntity.Name = txtname;
//家长姓名
TextEdit txtParentName = myCard.Controls["txtParentname"] as TextEdit;
string txtparentname = txtParentName.EditValue.ToString();
_ZymosisReportEntity.Parentname = txtparentname;
//身份证号码
TextEdit txtIdNo = myCard.Controls["txtIdno"] as TextEdit;
string txtidno = txtIdNo.EditValue.ToString();
_ZymosisReportEntity.Idno = txtidno;
//患者性别
CheckEdit chksex1 = myCard.Controls["chkSex1"] as CheckEdit;
CheckEdit chksex2 = myCard.Controls["chkSex2"] as CheckEdit;
if (chksex1.Checked)
{
_ZymosisReportEntity.Sex = "1";
}
else if (chksex2.Checked)
{
_ZymosisReportEntity.Sex = "2";
}
//出生日期
DateEdit dateBrith = myCard.Controls["dateBirth"] as DateEdit;
if (!(dateBrith.DateTime.CompareTo(DateTime.MinValue) == 0))
{
_ZymosisReportEntity.Birth = dateBrith.DateTime.ToString("yyyy-MM-dd");
}
//实足年龄
TextEdit txtAge = myCard.Controls["txtAge"] as TextEdit;
string txtage = txtAge.EditValue.ToString();
_ZymosisReportEntity.Age = txtage;
//实足年龄单位
CheckEdit chkAgeUnit1 = myCard.Controls["chkAgeUnit1"] as CheckEdit;
CheckEdit chkAgeUnit2 = myCard.Controls["chkAgeUnit2"] as CheckEdit;
CheckEdit chkAgeUnit3 = myCard.Controls["chkAgeUnit3"] as CheckEdit;
if (chkAgeUnit1.Checked)
{
_ZymosisReportEntity.AgeUnit = "1";
}
else if (chkAgeUnit2.Checked)
{
_ZymosisReportEntity.AgeUnit = "2";
}
else if (chkAgeUnit3.Checked)
{
_ZymosisReportEntity.AgeUnit = "3";
}
//工作单位
TextEdit txtOrganization = myCard.Controls["txtOrganization"] as TextEdit;
string txtorganization = txtOrganization.EditValue.ToString();
_ZymosisReportEntity.Organization = txtorganization;
//单位电话
TextEdit txtOfficetel = myCard.Controls["txtOfficetel"] as TextEdit;
string txtofficetel = txtOfficetel.EditValue.ToString();
_ZymosisReportEntity.Officetel = txtofficetel;
//病人属于地区
CheckEdit chkAddresstype1 = myCard.Controls["chkAddresstype1"] as CheckEdit;
CheckEdit chkAddresstype2 = myCard.Controls["chkAddresstype2"] as CheckEdit;
CheckEdit chkAddresstype3 = myCard.Controls["chkAddresstype3"] as CheckEdit;
CheckEdit chkAddresstype4 = myCard.Controls["chkAddresstype4"] as CheckEdit;
CheckEdit chkAddresstype5 = myCard.Controls["chkAddresstype5"] as CheckEdit;
CheckEdit chkAddresstype6 = myCard.Controls["chkAddresstype6"] as CheckEdit;
if (chkAddresstype1.Checked)
{
_ZymosisReportEntity.Addresstype = "1";
}
else if (chkAddresstype2.Checked)
{
_ZymosisReportEntity.Addresstype = "2";
}
else if (chkAddresstype3.Checked)
{
_ZymosisReportEntity.Addresstype = "3";
}
else if (chkAddresstype4.Checked)
{
_ZymosisReportEntity.Addresstype = "4";
}
else if (chkAddresstype5.Checked)
{
_ZymosisReportEntity.Addresstype = "5";
}
else if (chkAddresstype6.Checked)
{
_ZymosisReportEntity.Addresstype = "6";
}
//详细地址 【村，街道，门牌号】
TextEdit txtaddress = myCard.Controls["txtAddress"] as TextEdit;
string address = txtaddress.EditValue.ToString();
_ZymosisReportEntity.Address = address;
//职业代码
CheckEdit chkJobid1 = myCard.Controls["chkJobid1"] as CheckEdit;
CheckEdit chkJobid2 = myCard.Controls["chkJobid2"] as CheckEdit;
CheckEdit chkJobid3 = myCard.Controls["chkJobid3"] as CheckEdit;
CheckEdit chkJobid4 = myCard.Controls["chkJobid4"] as CheckEdit;
CheckEdit chkJobid5 = myCard.Controls["chkJobid5"] as CheckEdit;
CheckEdit chkJobid6 = myCard.Controls["chkJobid6"] as CheckEdit;
CheckEdit chkJobid7 = myCard.Controls["chkJobid7"] as CheckEdit;
CheckEdit chkJobid8 = myCard.Controls["chkJobid8"] as CheckEdit;
CheckEdit chkJobid9 = myCard.Controls["chkJobid9"] as CheckEdit;
CheckEdit chkJobid10 = myCard.Controls["chkJobid10"] as CheckEdit;
CheckEdit chkJobid11 = myCard.Controls["chkJobid11"] as CheckEdit;
CheckEdit chkJobid12 = myCard.Controls["chkJobid12"] as CheckEdit;
CheckEdit chkJobid13 = myCard.Controls["chkJobid13"] as CheckEdit;
CheckEdit chkJobid14 = myCard.Controls["chkJobid14"] as CheckEdit;
CheckEdit chkJobid15 = myCard.Controls["chkJobid15"] as CheckEdit;
CheckEdit chkJobid16 = myCard.Controls["chkJobid16"] as CheckEdit;
CheckEdit chkJobid17 = myCard.Controls["chkJobid17"] as CheckEdit;
CheckEdit chkJobid18 = myCard.Controls["chkJobid18"] as CheckEdit;
if (chkJobid1.Checked)
{
_ZymosisReportEntity.Jobid = "1";
}
else if (chkJobid2.Checked)
{
_ZymosisReportEntity.Jobid = "2";
}
else if (chkJobid3.Checked)
{
_ZymosisReportEntity.Jobid = "3";
}
else if (chkJobid4.Checked)
{
_ZymosisReportEntity.Jobid = "4";
}
else if (chkJobid5.Checked)
{
_ZymosisReportEntity.Jobid = "5";
}
else if (chkJobid6.Checked)
{
_ZymosisReportEntity.Jobid = "6";
}
else if (chkJobid7.Checked)
{
_ZymosisReportEntity.Jobid = "7";
}
else if (chkJobid8.Checked)
{
_ZymosisReportEntity.Jobid = "8";
}
else if (chkJobid9.Checked)
{
_ZymosisReportEntity.Jobid = "9";
}
else if (chkJobid10.Checked)
{
_ZymosisReportEntity.Jobid = "10";
}
else if (chkJobid11.Checked)
{
_ZymosisReportEntity.Jobid = "11";
}
else if (chkJobid12.Checked)
{
_ZymosisReportEntity.Jobid = "12";
}
else if (chkJobid13.Checked)
{
_ZymosisReportEntity.Jobid = "13";
}
else if (chkJobid14.Checked)
{
_ZymosisReportEntity.Jobid = "14";
}
else if (chkJobid15.Checked)
{
_ZymosisReportEntity.Jobid = "15";
}
else if (chkJobid16.Checked)
{
_ZymosisReportEntity.Jobid = "16";
}
else if (chkJobid17.Checked)
{
_ZymosisReportEntity.Jobid = "17";
}
else if (chkJobid18.Checked)
{
_ZymosisReportEntity.Jobid = "18";
}
//病历分类 1、疑似病历 2、临床诊断病历 3、实验室确诊病历
CheckEdit chkRecordtype11 = myCard.Controls["chkRecordtype11"] as CheckEdit;
CheckEdit chkRecordtype12 = myCard.Controls["chkRecordtype12"] as CheckEdit;
CheckEdit chkRecordtype13 = myCard.Controls["chkRecordtype13"] as CheckEdit;
if (chkRecordtype11.Checked)
{
_ZymosisReportEntity.Recordtype1 = "1";
}
else if (chkRecordtype12.Checked)
{
_ZymosisReportEntity.Recordtype1 = "2";
}
else if (chkRecordtype13.Checked)
{
_ZymosisReportEntity.Recordtype1 = "3";
}
//病历分类（乙型肝炎、血吸虫病填写） 1、急性 2、慢性
CheckEdit chkRecordtype21 = myCard.Controls["chkRecordtype21"] as CheckEdit;
CheckEdit chkRecordtype22 = myCard.Controls["chkRecordtype22"] as CheckEdit;
CheckEdit chkRecordtype23 = myCard.Controls["chkRecordtype23"] as CheckEdit;
if (chkRecordtype21.Checked)
{
_ZymosisReportEntity.Recordtype2 = "1";
}
else if (chkRecordtype22.Checked)
{
_ZymosisReportEntity.Recordtype2 = "2";
}
else if (chkRecordtype23.Checked)
{
_ZymosisReportEntity.Recordtype2 = "3";
}
//发病日期（病原携带者填初检日期或就诊日期）
DateEdit dateAttackdate = myCard.Controls["dateAttackdate"] as DateEdit;
if (!(dateAttackdate.DateTime.CompareTo(DateTime.MinValue) == 0))
{
_ZymosisReportEntity.Attackdate = dateAttackdate.DateTime.ToString("yyyy-MM-dd");
}
//诊断日期
DateEdit dateDiagdate = myCard.Controls["dateDiagdate"] as DateEdit;
TimeEdit timeDiagdate = myCard.Controls["timeDiagdate"] as TimeEdit;
if (!(dateDiagdate.DateTime.CompareTo(DateTime.MinValue) == 0))
{
_ZymosisReportEntity.Diagdate = dateDiagdate.DateTime.ToString("yyyy-MM-dd") + " " + timeDiagdate.Time.ToString("HH:mm:ss");
}
//死亡日期
DateEdit Diedate = myCard.Controls["Diedate"] as DateEdit;
if (!(Diedate.DateTime.CompareTo(DateTime.MinValue) == 0))
{
_ZymosisReportEntity.Diedate = Diedate.DateTime.ToString("yyyy-MM-dd");
}
//传染病病种(对应传染病诊断库)
LookUpEditor lookUpEditorZymosis = myCard.Controls["lookUpEditorZymosis"] as LookUpEditor;
_ZymosisReportEntity.Diagicd10 = lookUpEditorZymosis.CodeValue;
//传染病病种名称
_ZymosisReportEntity.Diagname = lookUpEditorZymosis.DisplayValue;
//订正病名
TextEdit textCorrectName = myCard.Controls["textCorrectName"] as TextEdit;
string textcorrectName = textCorrectName.EditValue.ToString();
_ZymosisReportEntity.CorrectName = textcorrectName;
//退卡原因
TextEdit txtCancelReason = myCard.Controls["txtCancelReason"] as TextEdit;
string txtcancelReason = txtCancelReason.EditValue.ToString();
_ZymosisReportEntity.CancelReason = txtcancelReason;
//报告科室编号
LookUpEditor lookUpEditorDept = myCard.Controls["lookUpEditorDept"] as LookUpEditor;
_ZymosisReportEntity.Reportdeptcode = lookUpEditorDept.CodeValue;
//报告科室名称
_ZymosisReportEntity.Reportdeptname = lookUpEditorDept.DisplayValue;
//_ZymosisReportEntity.Reportdeptname = lookUpEditorDept.SelectedText;
//报告医生联系电话
TextEdit txtDoctortel = myCard.Controls["txtDoctortel"] as TextEdit;
string txtdoctortel = txtDoctortel.EditValue.ToString();
_ZymosisReportEntity.Doctortel = txtdoctortel;
//报告医生编号
LookUpEditor lookUpEditorDoc = myCard.Controls["lookUpEditorDoc"] as LookUpEditor;
_ZymosisReportEntity.Reportdoccode = lookUpEditorDoc.CodeValue;
//报告医生姓名
_ZymosisReportEntity.Reportdocname = lookUpEditorDoc.DisplayValue;
//填卡时间
DateEdit dateReportDate = myCard.Controls["dateReportDate"] as DateEdit;
if (!(dateReportDate.DateTime.CompareTo(DateTime.MinValue) == 0))
{
_ZymosisReportEntity.ReportDate = dateReportDate.DateTime.ToString("yyyy-MM-dd");
}
//备注
MemoEdit memoMemo = myCard.Controls["memoMemo"] as MemoEdit;
_ZymosisReportEntity.Memo = memoMemo.Text;
//其他法定管理以及重点监测传染病：
MemoEdit memoOtherDiag = myCard.Controls["memoOtherDiag"] as MemoEdit;
_ZymosisReportEntity.OtherDiag = memoOtherDiag.Text;
//修改时间
_ZymosisReportEntity.ModifyDate = DateTime.Now.ToString("yyyy-MM-dd HH:m:ss");
//修改人科室编号
_ZymosisReportEntity.ModifyDeptcode = m_App.User.CurrentDeptId;
//修改人科室名称
_ZymosisReportEntity.ModifyDeptname = m_App.User.CurrentDeptName;
//修改人编号
_ZymosisReportEntity.ModifyUsercode = m_App.User.Id;
//修改人姓名
_ZymosisReportEntity.ModifyUsername = m_App.User.Name;
#endregion
#endregion
return(_ZymosisReportEntity);
}
private static Drawingform GetDrawingform(ZymosisReportEntity m_ZymosisReportEntitys)
{
Drawingform drawingform = new Drawingform(m_ZymosisReportEntitys);
return(drawingform);
}
/// <summary>
/// 根据传染病报告卡编号获取传染病报告卡实体
/// </summary>
/// <param name="zymosisID"></param>
/// <returns></returns>
public ZymosisReportEntity GetZymosisReportEntity(string zymosisID)
{
ZymosisReportEntity _ZymosisReportEntity = new ZymosisReportEntity();
SqlParameter[] sqlParam = new SqlParameter[]
{
new SqlParameter("@EditType", SqlDbType.VarChar),
new SqlParameter("@Report_ID", SqlDbType.Int)
};
sqlParam[0].Value = "4";
sqlParam[1].Value = zymosisID;
DataTable dt = m_IDataAccess.ExecuteDataTable("Emr_Zymosis_Report.usp_EditZymosis_Report", sqlParam, CommandType.StoredProcedure);
if (dt.Rows.Count == 0)
{
return(null);
}
foreach (DataRow dr in dt.Rows)
{
_ZymosisReportEntity.ReportId = Convert.ToInt32(dr["Report_ID"]);
_ZymosisReportEntity.ReportNo = dr["Report_NO"].ToString();
_ZymosisReportEntity.ReportType = dr["Report_Type"].ToString();
_ZymosisReportEntity.Noofinpat = dr["Noofinpat"].ToString();
_ZymosisReportEntity.Patid = dr["PatID"].ToString();
_ZymosisReportEntity.Name = dr["Name"].ToString();
_ZymosisReportEntity.Parentname = dr["ParentName"].ToString();
_ZymosisReportEntity.Idno = dr["IDNO"].ToString();
_ZymosisReportEntity.Sex = dr["Sex"].ToString();
_ZymosisReportEntity.Birth = dr["Birth"].ToString();
_ZymosisReportEntity.Age = dr["Age"].ToString();
_ZymosisReportEntity.AgeUnit = dr["Age_Unit"].ToString();
_ZymosisReportEntity.Organization = dr["Organization"].ToString();
_ZymosisReportEntity.Officeplace = dr["OfficePlace"].ToString();
_ZymosisReportEntity.Officetel = dr["OfficeTel"].ToString();
_ZymosisReportEntity.Addresstype = dr["AddressType"].ToString();
_ZymosisReportEntity.Hometown = dr["HomeTown"].ToString();
_ZymosisReportEntity.Address = dr["Address"].ToString();
_ZymosisReportEntity.Jobid = dr["JobId"].ToString();
_ZymosisReportEntity.Recordtype1 = dr["RecordType1"].ToString();
_ZymosisReportEntity.Recordtype2 = dr["RecordType2"].ToString();
_ZymosisReportEntity.Attackdate = dr["AttackDate"].ToString();
_ZymosisReportEntity.Diagdate = dr["DiagDate"].ToString();
_ZymosisReportEntity.Diedate = dr["DieDate"].ToString();
_ZymosisReportEntity.Diagicd10 = dr["DiagICD10"].ToString();
_ZymosisReportEntity.Diagname = dr["DiagName"].ToString();
_ZymosisReportEntity.InfectotherFlag = dr["infectother_flag"].ToString();
_ZymosisReportEntity.Memo = dr["Memo"].ToString();
_ZymosisReportEntity.CorrectFlag = dr["Correct_Flag"].ToString();
_ZymosisReportEntity.CorrectName = dr["Correct_Name"].ToString();
_ZymosisReportEntity.CancelReason = dr["Cancel_Reason"].ToString();
_ZymosisReportEntity.Reportdeptcode = dr["ReportDeptCode"].ToString();
_ZymosisReportEntity.Reportdeptname = dr["ReportDeptName"].ToString();
_ZymosisReportEntity.Reportdoccode = dr["ReportDocCode"].ToString();
_ZymosisReportEntity.Reportdocname = dr["ReportDocName"].ToString();
_ZymosisReportEntity.Doctortel = dr["DoctorTEL"].ToString();
_ZymosisReportEntity.ReportDate = dr["Report_Date"].ToString();
_ZymosisReportEntity.State = dr["State"].ToString();
_ZymosisReportEntity.CreateDate = dr["create_date"].ToString();
_ZymosisReportEntity.CreateUsercode = dr["create_UserCode"].ToString();
_ZymosisReportEntity.CreateUsername = dr["create_UserName"].ToString();
_ZymosisReportEntity.CreateDeptcode = dr["create_deptCode"].ToString();
_ZymosisReportEntity.CreateDeptname = dr["create_deptName"].ToString();
_ZymosisReportEntity.ModifyDate = dr["Modify_date"].ToString();
_ZymosisReportEntity.ModifyUsercode = dr["Modify_UserCode"].ToString();
_ZymosisReportEntity.ModifyUsername = dr["Modify_UserName"].ToString();
_ZymosisReportEntity.ModifyDeptcode = dr["Modify_deptCode"].ToString();
_ZymosisReportEntity.ModifyDeptname = dr["Modify_deptName"].ToString();
_ZymosisReportEntity.AuditDate = dr["Audit_date"].ToString();
_ZymosisReportEntity.AuditUsercode = dr["Audit_UserCode"].ToString();
_ZymosisReportEntity.AuditUsername = dr["Audit_UserName"].ToString();
_ZymosisReportEntity.AuditDeptcode = dr["Audit_deptCode"].ToString();
_ZymosisReportEntity.AuditDeptname = dr["Audit_deptName"].ToString();
_ZymosisReportEntity.OtherDiag = dr["OtherDiag"].ToString();
}
return(_ZymosisReportEntity);
}
/// <summary>
/// 作废传染病报告卡
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public string CancelZymosisReport(ZymosisReportEntity info)
{
SqlParameter[] sqlParam = GetSqlParameter(info, "3", "作废");
return(m_IDataAccess.ExecuteDataSet("Emr_Zymosis_Report.usp_EditZymosis_Report", sqlParam, CommandType.StoredProcedure).Tables[0].Rows[0][0].ToString());
}
/// <summary>
/// 根据传入的ZymosisReportEntity实体返回调用存储过程参数数组
/// </summary>
/// <param name="info"></param>
/// <param name="editType"></param>
/// <param name="stateName">操作类型 例：新增，</param>
private SqlParameter[] GetSqlParameter(ZymosisReportEntity info, string editType, string stateName)
{
#region
SqlParameter[] sqlParam = new SqlParameter[]
{
new SqlParameter("@EditType", SqlDbType.VarChar),
new SqlParameter("@Report_ID", SqlDbType.Int),
new SqlParameter("@Report_NO", SqlDbType.VarChar),
new SqlParameter("@Report_Type", SqlDbType.VarChar),
new SqlParameter("@Noofinpat", SqlDbType.VarChar),
new SqlParameter("@PatID", SqlDbType.VarChar),
new SqlParameter("@Name", SqlDbType.VarChar),
new SqlParameter("@ParentName", SqlDbType.VarChar),
new SqlParameter("@IDNO", SqlDbType.VarChar),
new SqlParameter("@Sex", SqlDbType.VarChar),
new SqlParameter("@Birth", SqlDbType.VarChar),
new SqlParameter("@Age", SqlDbType.VarChar),
new SqlParameter("@AgeUnit", SqlDbType.VarChar),
new SqlParameter("@Organization", SqlDbType.VarChar),
new SqlParameter("@OfficePlace", SqlDbType.VarChar),
new SqlParameter("@OfficeTEL", SqlDbType.VarChar),
new SqlParameter("@AddressType", SqlDbType.VarChar),
new SqlParameter("@HomeTown", SqlDbType.VarChar),
new SqlParameter("@Address", SqlDbType.VarChar),
new SqlParameter("@JobID", SqlDbType.VarChar),
new SqlParameter("@RecordType1", SqlDbType.VarChar),
new SqlParameter("@RecordType2", SqlDbType.VarChar),
new SqlParameter("@AttackDate", SqlDbType.VarChar),
new SqlParameter("@DiagDate", SqlDbType.VarChar),
new SqlParameter("@DieDate", SqlDbType.VarChar),
new SqlParameter("@DiagICD10", SqlDbType.VarChar),
new SqlParameter("@DiagName", SqlDbType.VarChar),
new SqlParameter("@INFECTOTHER_FLAG", SqlDbType.VarChar),
new SqlParameter("@Memo", SqlDbType.VarChar),
new SqlParameter("@Correct_flag", SqlDbType.VarChar),
new SqlParameter("@Correct_Name", SqlDbType.VarChar),
new SqlParameter("@Cancel_Reason", SqlDbType.VarChar),
new SqlParameter("@ReportDeptCode", SqlDbType.VarChar),
new SqlParameter("@ReportDeptName", SqlDbType.VarChar),
new SqlParameter("@ReportDocCode", SqlDbType.VarChar),
new SqlParameter("@ReportDocName", SqlDbType.VarChar),
new SqlParameter("@DoctorTEL", SqlDbType.VarChar),
new SqlParameter("@Report_Date", SqlDbType.VarChar),
new SqlParameter("@State", SqlDbType.VarChar),
new SqlParameter("@StateName", SqlDbType.VarChar),
new SqlParameter("@create_date", SqlDbType.VarChar),
new SqlParameter("@create_UserCode", SqlDbType.VarChar),
new SqlParameter("@create_UserName", SqlDbType.VarChar),
new SqlParameter("@create_deptCode", SqlDbType.VarChar),
new SqlParameter("@create_deptName", SqlDbType.VarChar),
new SqlParameter("@Modify_date", SqlDbType.VarChar),
new SqlParameter("@Modify_UserCode", SqlDbType.VarChar),
new SqlParameter("@Modify_UserName", SqlDbType.VarChar),
new SqlParameter("@Modify_deptCode", SqlDbType.VarChar),
new SqlParameter("@Modify_deptName", SqlDbType.VarChar),
new SqlParameter("@Audit_date", SqlDbType.VarChar),
new SqlParameter("@Audit_UserCode", SqlDbType.VarChar),
new SqlParameter("@Audit_UserName", SqlDbType.VarChar),
new SqlParameter("@Audit_deptCode", SqlDbType.VarChar),
new SqlParameter("@Audit_deptName", SqlDbType.VarChar),
new SqlParameter("@OtherDiag", SqlDbType.VarChar)
};
sqlParam[0].Value = editType;
sqlParam[1].Value = info.ReportId;
sqlParam[2].Value = info.ReportNo;
sqlParam[3].Value = info.ReportType;
sqlParam[4].Value = info.Noofinpat;
sqlParam[5].Value = info.Patid;
sqlParam[6].Value = info.Name;
sqlParam[7].Value = info.Parentname;
sqlParam[8].Value = info.Idno;
sqlParam[9].Value = info.Sex;
sqlParam[10].Value = info.Birth;
sqlParam[11].Value = info.Age;
sqlParam[12].Value = info.AgeUnit;
sqlParam[13].Value = info.Organization;
sqlParam[14].Value = info.Officeplace;
sqlParam[15].Value = info.Officetel;
sqlParam[16].Value = info.Addresstype;
sqlParam[17].Value = info.Hometown;
sqlParam[18].Value = info.Address;
sqlParam[19].Value = info.Jobid;
sqlParam[20].Value = info.Recordtype1;
sqlParam[21].Value = info.Recordtype2;
sqlParam[22].Value = info.Attackdate;
sqlParam[23].Value = info.Diagdate;
sqlParam[24].Value = info.Diedate;
sqlParam[25].Value = info.Diagicd10;
sqlParam[26].Value = info.Diagname;
sqlParam[27].Value = info.InfectotherFlag;
sqlParam[28].Value = info.Memo;
sqlParam[29].Value = info.CorrectFlag;
sqlParam[30].Value = info.CorrectName;
sqlParam[31].Value = info.CancelReason;
sqlParam[32].Value = info.Reportdeptcode;
sqlParam[33].Value = info.Reportdeptname;
sqlParam[34].Value = info.Reportdoccode;
sqlParam[35].Value = info.Reportdocname;
sqlParam[36].Value = info.Doctortel;
sqlParam[37].Value = info.ReportDate;
sqlParam[38].Value = info.State;
sqlParam[39].Value = stateName;
sqlParam[40].Value = info.CreateDate;
sqlParam[41].Value = info.CreateUsercode;
sqlParam[42].Value = info.CreateUsername;
sqlParam[43].Value = info.CreateDeptcode;
sqlParam[44].Value = info.CreateDeptname;
sqlParam[45].Value = info.ModifyDate;
sqlParam[46].Value = info.ModifyUsercode;
sqlParam[47].Value = info.ModifyUsername;
sqlParam[48].Value = info.ModifyDeptcode;
sqlParam[49].Value = info.ModifyDeptname;
sqlParam[50].Value = info.AuditDate;
sqlParam[51].Value = info.AuditUsercode;
sqlParam[52].Value = info.AuditUsername;
sqlParam[53].Value = info.AuditDeptcode;
sqlParam[54].Value = info.AuditDeptname;
sqlParam[55].Value = info.OtherDiag;
return(sqlParam);
#endregion
}
