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 }