public Boolean CheckData() { try { Control[] controls = new Control[] { ucPalsyDate1 }; foreach (var item in controls) { IZymosisReport iZymosisReport = item as IZymosisReport; XtraUserControl xtraUserControl = item as XtraUserControl; if (iZymosisReport != null && xtraUserControl != null) { if (string.IsNullOrEmpty(iZymosisReport.GetValue())) { MyMessageBox.Show(xtraUserControl.AccessibleName + " 不能为空!请填写完整"); iZymosisReport.SetFocus(); return(false); } } } return(true); } catch (Exception ex) { throw ex; } }
public void InitData() { try { foreach (var item in this.Controls) { IZymosisReport iZymosisReport = item as IZymosisReport; XtraUserControl xtraUserControl = item as XtraUserControl; if (iZymosisReport != null && xtraUserControl != null) { //通过控件tag的名称来匹配数据库字段 string ColName = xtraUserControl.Tag.ToString(); if (m_dataRow != null) { string ValueStr = m_dataRow[ColName].ToString(); iZymosisReport.InitValue(ValueStr); } } } } catch (Exception ex) { throw ex; } }
public Boolean CheckData() { try { Control[] controls = new Control[] { ucMaritalStatus1, ucNation1, ucEducationLevel1, ucContactHistory1, ucXinBingShi1, ucInfactway1, ucSamplesource1, ucDetectionconclusion1, ucAffirmdate1, ucAffirmDept1 }; foreach (var item in controls) { IZymosisReport iZymosisReport = item as IZymosisReport; XtraUserControl xtraUserControl = item as XtraUserControl; if (iZymosisReport != null && xtraUserControl != null) { //if (xtraUserControl.Tag.ToString() != "HOUSEHOLDSCOPE" // && xtraUserControl.Tag.ToString() != "HOUSEHOLDADDRESS" // && xtraUserControl.Tag.ToString() != "ADDRESS" // && xtraUserControl.Tag.ToString() != "REMARK") //{ //测试 //if (xtraUserControl.Tag.ToString() == "CONTACTHISTORY") { } // if (string.IsNullOrEmpty(iZymosisReport.GetValue())) { MyMessageBox.Show(xtraUserControl.AccessibleName + " 不能为空!请填写完整"); iZymosisReport.SetFocus(); return(false); } //} } } return(true); } catch (Exception ex) { throw ex; } }
public Boolean CheckData() { try { Control[] controls = new Control[] { ucCaseType1, ucHospitalStatus1, ucIsCure1, ucIsOverseas1 }; foreach (var item in controls) { IZymosisReport iZymosisReport = item as IZymosisReport; XtraUserControl xtraUserControl = item as XtraUserControl; if (iZymosisReport != null && xtraUserControl != null) { if (xtraUserControl.Tag.ToString() == "HOSPITALSTATUS") { if (iZymosisReport.GetValue().Contains("空")) { MyMessageBox.Show("住院日期 不能为空!请填写完整"); return(false); } } if (string.IsNullOrEmpty(iZymosisReport.GetValue())) { MyMessageBox.Show(xtraUserControl.AccessibleName + " 不能为空!请填写完整"); iZymosisReport.SetFocus(); return(false); } } } return(true); } catch (Exception ex) { throw ex; } }
private void SaveData() { try { #region 定义参数 List <SqlParameter> sps = new List <SqlParameter>(); SqlParameter sqlp1 = new SqlParameter("@H1N1ID", SqlDbType.VarChar); SqlParameter sqlp2 = new SqlParameter("@REPORTID", SqlDbType.Int); SqlParameter sqlp3 = new SqlParameter("@CASETYPE", SqlDbType.VarChar); SqlParameter sqlp4 = new SqlParameter("@HOSPITALSTATUS", SqlDbType.VarChar); SqlParameter sqlp5 = new SqlParameter("@ISCURE", SqlDbType.VarChar); SqlParameter sqlp6 = new SqlParameter("@ISOVERSEAS", SqlDbType.VarChar); SqlParameter sqlp7 = new SqlParameter("@VAILD", SqlDbType.VarChar); SqlParameter sqlp8 = new SqlParameter("@CREATOR", SqlDbType.VarChar); SqlParameter sqlp9 = new SqlParameter("@CREATEDATE", SqlDbType.VarChar); SqlParameter sqlp10 = new SqlParameter("@MENDER", SqlDbType.VarChar); SqlParameter sqlp11 = new SqlParameter("@ALTERDATE", SqlDbType.VarChar); sps.Add(sqlp1); sps.Add(sqlp2); sps.Add(sqlp3); sps.Add(sqlp4); sps.Add(sqlp5); sps.Add(sqlp6); sps.Add(sqlp7); sps.Add(sqlp8); sps.Add(sqlp9); sps.Add(sqlp10); sps.Add(sqlp11); #endregion if (m_dataRow != null && !string.IsNullOrEmpty(m_dataRow["H1N1ID"].ToString())) { sqlp1.Value = m_dataRow["H1N1ID"].ToString(); } else { sqlp1.Value = Guid.NewGuid().ToString(); } sqlp2.Value = m_reportID; sqlp8.Value = DrectSoft.Common.DS_Common.currentUser.DoctorId; sqlp9.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); sqlp10.Value = DrectSoft.Common.DS_Common.currentUser.DoctorId; sqlp11.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); foreach (var item in this.Controls) { IZymosisReport iZymosisReport = item as IZymosisReport; XtraUserControl xtraUserControl = item as XtraUserControl; if (iZymosisReport != null && xtraUserControl != null) { string ColName = "@" + xtraUserControl.Tag.ToString(); foreach (SqlParameter itemsql in sps) { if (itemsql.ParameterName == ColName) { itemsql.Value = iZymosisReport.GetValue(); break; } } } } foreach (var item in sps) { if (item.Value == null && item.SqlDbType == SqlDbType.VarChar) { item.Value = ""; } } //if (sqlp4.Value.ToString().Length<30) //{ // MyMessageBox.Show("住院日期 不能为空!请填写完整"); // return; //} DrectSoft.DSSqlHelper.DS_SqlHelper.ExecuteNonQuery("EMR_ZYMOSIS_REPORT.usp_AddOrModH1N1Report", sps.ToArray(), CommandType.StoredProcedure); } catch (Exception ex) { throw ex; } }
private void SaveData() { try { SqlParameter[] parameters = new SqlParameter[22]; parameters[0] = new SqlParameter("@szdyytid", SqlDbType.VarChar); parameters[1] = new SqlParameter("@reportid", SqlDbType.Int); parameters[2] = new SqlParameter("@reportno", SqlDbType.VarChar); parameters[3] = new SqlParameter("@maritalstatus", SqlDbType.VarChar); parameters[4] = new SqlParameter("@nation", SqlDbType.VarChar); parameters[5] = new SqlParameter("@culturestate", SqlDbType.VarChar); parameters[6] = new SqlParameter("@householdscope", SqlDbType.VarChar); parameters[7] = new SqlParameter("@householdaddress", SqlDbType.VarChar); parameters[8] = new SqlParameter("@address", SqlDbType.VarChar); parameters[9] = new SqlParameter("@syyytgr", SqlDbType.VarChar); parameters[10] = new SqlParameter("@contacthistory", SqlDbType.VarChar); parameters[11] = new SqlParameter("@venerismhistory", SqlDbType.VarChar); parameters[12] = new SqlParameter("@infactway", SqlDbType.VarChar); parameters[13] = new SqlParameter("@samplesource", SqlDbType.VarChar); parameters[14] = new SqlParameter("@detectionconclusion", SqlDbType.VarChar); parameters[15] = new SqlParameter("@affirmdate", SqlDbType.VarChar); parameters[16] = new SqlParameter("@affirmlocal", SqlDbType.VarChar); parameters[17] = new SqlParameter("@vaild", SqlDbType.VarChar); parameters[18] = new SqlParameter("@creator", SqlDbType.VarChar); parameters[19] = new SqlParameter("@createdate", SqlDbType.VarChar); parameters[20] = new SqlParameter("@mender", SqlDbType.VarChar); parameters[21] = new SqlParameter("@alterdate", SqlDbType.VarChar); if (m_dataRow != null && !string.IsNullOrEmpty(m_dataRow["SZDYYT_ID"].ToString())) { parameters[0].Value = m_dataRow["SZDYYT_ID"].ToString(); } else { parameters[0].Value = Guid.NewGuid().ToString(); } parameters[1].Value = m_reportID; parameters[18].Value = DrectSoft.Common.DS_Common.currentUser.DoctorId; parameters[19].Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); parameters[20].Value = DrectSoft.Common.DS_Common.currentUser.DoctorId; parameters[21].Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); foreach (var item in this.Controls) { IZymosisReport iZymosisReport = item as IZymosisReport; XtraUserControl xtraUserControl = item as XtraUserControl; if (iZymosisReport != null && xtraUserControl != null) { string ColName = "@" + xtraUserControl.Tag.ToString().ToLower(); foreach (SqlParameter itemsql in parameters) { if (itemsql.ParameterName == ColName) { itemsql.Value = iZymosisReport.GetValue(); break; } } } } foreach (SqlParameter item in parameters) { if (item.Value == null) { item.Value = DBNull.Value; } } DrectSoft.DSSqlHelper.DS_SqlHelper.ExecuteNonQuery("EMR_ZYMOSIS_REPORT.usp_AddOrModSYYYTReport", parameters, CommandType.StoredProcedure); } catch (Exception ex) { throw ex; } }
private void SaveData() { try { #region 定义参数 List <SqlParameter> sps = new List <SqlParameter>(); SqlParameter sqlp1 = new SqlParameter("@HIVID", SqlDbType.VarChar); SqlParameter sqlp2 = new SqlParameter("@REPORTID", SqlDbType.Int); SqlParameter sqlp3 = new SqlParameter("@REPORTNO", SqlDbType.VarChar); SqlParameter sqlp4 = new SqlParameter("@MARITALSTATUS", SqlDbType.VarChar); SqlParameter sqlp5 = new SqlParameter("@NATION", SqlDbType.VarChar); SqlParameter sqlp6 = new SqlParameter("@CULTURESTATE", SqlDbType.VarChar); SqlParameter sqlp7 = new SqlParameter("@HOUSEHOLDSCOPE", SqlDbType.VarChar); SqlParameter sqlp8 = new SqlParameter("@HOUSEHOLDADDRESS", SqlDbType.VarChar); SqlParameter sqlp9 = new SqlParameter("@ADDRESS", SqlDbType.VarChar); SqlParameter sqlp10 = new SqlParameter("@CONTACTHISTORY", SqlDbType.VarChar); SqlParameter sqlp11 = new SqlParameter("@VENERISMHISTORY", SqlDbType.VarChar); SqlParameter sqlp12 = new SqlParameter("@INFACTWAY", SqlDbType.VarChar); SqlParameter sqlp13 = new SqlParameter("@SAMPLESOURCE", SqlDbType.VarChar); SqlParameter sqlp14 = new SqlParameter("@DETECTIONCONCLUSION", SqlDbType.VarChar); SqlParameter sqlp15 = new SqlParameter("@AFFIRMDATE", SqlDbType.VarChar); SqlParameter sqlp16 = new SqlParameter("@AFFIRMLOCAL", SqlDbType.VarChar); SqlParameter sqlp17 = new SqlParameter("@DIAGNOSEDATE", SqlDbType.VarChar); SqlParameter sqlp18 = new SqlParameter("@DOCTOR", SqlDbType.VarChar); SqlParameter sqlp19 = new SqlParameter("@WRITEDATE", SqlDbType.VarChar); SqlParameter sqlp20 = new SqlParameter("@ALIKESYMBOL", SqlDbType.VarChar); SqlParameter sqlp21 = new SqlParameter("@REMARK", SqlDbType.VarChar); SqlParameter sqlp22 = new SqlParameter("@VAILD", SqlDbType.VarChar); SqlParameter sqlp23 = new SqlParameter("@CREATOR", SqlDbType.VarChar); SqlParameter sqlp24 = new SqlParameter("@CREATEDATE", SqlDbType.VarChar); SqlParameter sqlp25 = new SqlParameter("@MENDER", SqlDbType.VarChar); SqlParameter sqlp26 = new SqlParameter("@ALTERDATE", SqlDbType.VarChar); sps.Add(sqlp1); sps.Add(sqlp2); sps.Add(sqlp3); sps.Add(sqlp4); sps.Add(sqlp5); sps.Add(sqlp6); sps.Add(sqlp7); sps.Add(sqlp8); sps.Add(sqlp9); sps.Add(sqlp10); sps.Add(sqlp11); sps.Add(sqlp12); sps.Add(sqlp13); sps.Add(sqlp14); sps.Add(sqlp15); sps.Add(sqlp16); sps.Add(sqlp17); sps.Add(sqlp18); sps.Add(sqlp19); sps.Add(sqlp20); sps.Add(sqlp21); sps.Add(sqlp22); sps.Add(sqlp23); sps.Add(sqlp24); sps.Add(sqlp25); sps.Add(sqlp26); #endregion if (m_dataRow != null && !string.IsNullOrEmpty(m_dataRow["HIV_ID"].ToString())) { sqlp1.Value = m_dataRow["HIV_ID"].ToString(); } else { sqlp1.Value = Guid.NewGuid().ToString(); } sqlp2.Value = m_reportID; sqlp23.Value = DrectSoft.Common.DS_Common.currentUser.DoctorId; sqlp24.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); sqlp25.Value = DrectSoft.Common.DS_Common.currentUser.DoctorId; sqlp26.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); foreach (var item in this.Controls) { IZymosisReport iZymosisReport = item as IZymosisReport; XtraUserControl xtraUserControl = item as XtraUserControl; if (iZymosisReport != null && xtraUserControl != null) { //测试代码 if (xtraUserControl.Tag.ToString() == "ADDRESS") { } string ColName = "@" + xtraUserControl.Tag.ToString(); foreach (SqlParameter itemsql in sps) { if (itemsql.ParameterName == ColName) { itemsql.Value = iZymosisReport.GetValue(); break; } } } } foreach (var item in sps) { if (item.Value == null && item.SqlDbType == SqlDbType.VarChar) { item.Value = ""; } } DrectSoft.DSSqlHelper.DS_SqlHelper.ExecuteNonQuery("EMR_ZYMOSIS_REPORT.usp_AddOrModHIVReport", sps.ToArray(), CommandType.StoredProcedure); } catch (Exception ex) { throw ex; } }
private void SaveData() { try { #region 定义参数 List <SqlParameter> sps = new List <SqlParameter>(); SqlParameter sqlp1 = new SqlParameter("@HBVID", SqlDbType.VarChar); SqlParameter sqlp2 = new SqlParameter("@REPORTID", SqlDbType.Int); SqlParameter sqlp3 = new SqlParameter("@HBSAGDATE", SqlDbType.VarChar); SqlParameter sqlp4 = new SqlParameter("@FRISTDATE", SqlDbType.VarChar); SqlParameter sqlp5 = new SqlParameter("@ALT", SqlDbType.VarChar); SqlParameter sqlp6 = new SqlParameter("@ANTIHBC", SqlDbType.VarChar); SqlParameter sqlp7 = new SqlParameter("@LIVERBIOPSY", SqlDbType.VarChar); SqlParameter sqlp8 = new SqlParameter("@RECOVERYHBSAG", SqlDbType.VarChar); SqlParameter sqlp9 = new SqlParameter("@VAILD", SqlDbType.VarChar); SqlParameter sqlp10 = new SqlParameter("@CREATOR", SqlDbType.VarChar); SqlParameter sqlp11 = new SqlParameter("@CREATEDATE", SqlDbType.VarChar); SqlParameter sqlp12 = new SqlParameter("@MENDER", SqlDbType.VarChar); SqlParameter sqlp13 = new SqlParameter("@ALTERDATE", SqlDbType.VarChar); sps.Add(sqlp1); sps.Add(sqlp2); sps.Add(sqlp3); sps.Add(sqlp4); sps.Add(sqlp5); sps.Add(sqlp6); sps.Add(sqlp7); sps.Add(sqlp8); sps.Add(sqlp9); sps.Add(sqlp10); sps.Add(sqlp11); sps.Add(sqlp12); sps.Add(sqlp13); #endregion if (m_dataRow != null && !string.IsNullOrEmpty(m_dataRow["HBVID"].ToString())) { sqlp1.Value = m_dataRow["HBVID"].ToString(); } else { sqlp1.Value = Guid.NewGuid().ToString(); } sqlp2.Value = m_reportID; sqlp10.Value = DrectSoft.Common.DS_Common.currentUser.DoctorId; sqlp11.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); sqlp12.Value = DrectSoft.Common.DS_Common.currentUser.DoctorId; sqlp13.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); foreach (var item in this.Controls) { IZymosisReport iZymosisReport = item as IZymosisReport; XtraUserControl xtraUserControl = item as XtraUserControl; if (iZymosisReport != null && xtraUserControl != null) { string ColName = "@" + xtraUserControl.Tag.ToString(); foreach (SqlParameter itemsql in sps) { if (itemsql.ParameterName == ColName) { itemsql.Value = iZymosisReport.GetValue(); break; } } } } foreach (var item in sps) { if (item.Value == null && item.SqlDbType == SqlDbType.VarChar) { item.Value = ""; } } DrectSoft.DSSqlHelper.DS_SqlHelper.ExecuteNonQuery("EMR_ZYMOSIS_REPORT.usp_AddOrModHBVReport", sps.ToArray(), CommandType.StoredProcedure); } catch (Exception ex) { throw ex; } }