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;
}
}
