/// <summary>
/// 更新终端资料库中的查体资料--内科,外科
/// </summary>
/// <param name="model"></param>
/// <param name="RecordDate"></param>
/// <returns></returns>
public void InsertByChestX(RecordsAssistCheckModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append(@"
INSERT INTO
ARCHIVE_ASSISTCHECK
(
PhysicalID
,IDCardNo
,CHESTX
,CHESTXEx
,OutKey
)
VALUES
(
@PhysicalID
,@IDCardNo
,@CHESTX
,@CHESTXEx
,@OutKey
) ");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@CHESTX", model.CHESTX),
new MySqlParameter("@CHESTXEx", model.CHESTXEx),
new MySqlParameter("@OutKey", model.OutKey),
new MySqlParameter("@IDCardNo", model.IDCardNo),
new MySqlParameter("@PhysicalID", model.PhysicalID)
};
MySQLHelper.ExecuteSql(builder.ToString(), cmdParms);
}
/// <summary>
/// 血糖同步
/// </summary>
/// <param name="model"></param>
/// <param name="checkDate"></param>
/// <returns></returns>
public bool UpdateByMiniSTPad(RecordsAssistCheckModel model, string checkDate)
{
StringBuilder builder = new StringBuilder();
builder.Append(@"UPDATE
ARCHIVE_ASSISTCHECK D
SET
FPGL=@FPGL
WHERE
EXISTS
(
SELECT
ID
FROM
ARCHIVE_CUSTOMERBASEINFO M
WHERE M.ID = D.OutKey
AND M.IDCardNo = @IDCardNo
AND M.CheckDate = @CheckDate
)
");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@IDCardNo", model.IDCardNo),
new MySqlParameter("@CheckDate", checkDate),
new MySqlParameter("@FPGL", model.FPGL)
};
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
/// <summary>
/// 更新终端资料库中的查体资料--X光
/// </summary>
/// <param name="model"></param>
/// <param name="RecordDate"></param>
/// <returns></returns>
public bool UpdateByChestX(RecordsAssistCheckModel model, string RecordDate)
{
StringBuilder builder = new StringBuilder();
builder.Append(@"
UPDATE
ARCHIVE_ASSISTCHECK D
SET
CHESTX = @CHESTX
,CHESTXEx = @CHESTXEx
WHERE
EXISTS
(
SELECT
D.ID
FROM
ARCHIVE_CUSTOMERBASEINFO M
WHERE
IFNULL(M.IsDel,'')!='Y'
AND M.ID= D.OUTkey
AND M.IDCardNo = @IDCardNo
AND M.CheckDate = @CheckDate
); ");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@CHESTX", model.CHESTX),
new MySqlParameter("@CHESTXEx", model.CHESTXEx),
new MySqlParameter("@IDCardNo", model.IDCardNo),
new MySqlParameter("@CheckDate", RecordDate)
};
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
/// <summary>
/// 尿常规同步
/// </summary>
/// <param name="model"></param>
/// <param name="checkDate"></param>
/// <returns></returns>
public bool UpdateByMiniPad(RecordsAssistCheckModel model, string checkDate)
{
StringBuilder builder = new StringBuilder();
builder.Append(@"UPDATE
ARCHIVE_ASSISTCHECK D
SET
BLD=@BLD
,KET=@KET
,GLU=@GLU
,PRO=@PRO ");
if (!string.IsNullOrEmpty(model.UrineOther))
{
builder.Append(",UrineOther=@UrineOther");
}
else if (!string.IsNullOrEmpty(model.UrineOther) && model.UrineOther.Equals("陕西"))
{
builder.Append(",UrineOther=REPLACE(UrineOther,'未配合检查','')");
}
builder.Append(@" WHERE
EXISTS
(
SELECT
ID
FROM
ARCHIVE_CUSTOMERBASEINFO M
WHERE M.ID = D.OutKey
AND M.IDCardNo = @IDCardNo
AND M.CheckDate = @CheckDate
)
");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@IDCardNo", model.IDCardNo),
new MySqlParameter("@CheckDate", checkDate),
new MySqlParameter("@BLD", model.BLD),
new MySqlParameter("@KET", model.KET),
new MySqlParameter("@GLU", model.GLU),
new MySqlParameter("@PRO", model.PRO),
new MySqlParameter("@UrineOther", model.UrineOther)
};
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
/// <summary>
/// 更新终端资料库中的查体资料--X光
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateByChestX(RecordsAssistCheckModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append(@"
UPDATE
ARCHIVE_ASSISTCHECK
SET
CHESTX = @CHESTX
,CHESTXEx = @CHESTXEx
WHERE
OutKey=@OutKey ");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@CHESTX", model.CHESTX),
new MySqlParameter("@CHESTXEx", model.CHESTXEx),
new MySqlParameter("@IDCardNo", model.IDCardNo),
new MySqlParameter("@OutKey", model.OutKey)
};
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
/// <summary>
/// 更新终端资料库中的查体资料--X光
/// </summary>
/// <param name="model"></param>
/// <param name="RecordDate"></param>
/// <returns></returns>
public bool UpdateByChestX(RecordsAssistCheckModel model, string RecordDate)
{
StringBuilder builder = new StringBuilder();
builder.Append(@"
UPDATE
ARCHIVE_ASSISTCHECK D
SET
CHESTX = @CHESTX
,CHESTXEx = @CHESTXEx
WHERE
D.OUTKEY=
(
SELECT
M.ID
FROM
ARCHIVE_CUSTOMERBASEINFO M
WHERE
IFNULL(M.IsDel,'')!='Y'
AND M.IDCardNo =@IDCardNo
AND LEFT(M.CheckDate,4) = @CheckDate
order by M.CheckDate DESC LIMIT 0,1
); ");
if (Convert.ToString(RecordDate).Length > 3)
{
RecordDate = RecordDate.Substring(0, 4);
}
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@CHESTX", model.CHESTX),
new MySqlParameter("@CHESTXEx", model.CHESTXEx),
new MySqlParameter("@IDCardNo", model.IDCardNo),
new MySqlParameter("@CheckDate", RecordDate)
};
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
/// <summary>
/// 新尿常规同步
/// </summary>
/// <param name="model"></param>
/// <param name="barCode"></param>
/// <returns></returns>
public bool Update(RecordsAssistCheckModel model, string barCode)
{
return(this.dal.Update(model, barCode));
}
public bool UpdateByMiniPad(RecordsAssistCheckModel model, string checkDate)
{
return(this.dal.UpdateByMiniPad(model, checkDate));
}
public int Add(RecordsAssistCheckModel model)
{
return(this.dal.Add(model));
}
/// <summary>
/// B超正常异常信息更新到健康体检中
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateBC(RecordsAssistCheckModel model)
{
return(this.dal.UpdateBC(model));
}
private void btndataupload_Click(object sender, EventArgs e)
{
string strwhere = "";
if (this.ckbcheckdate.Checked)
{
strwhere = string.Format(" CheckDate BETWEEN '{0}' and '{1}' ",
this.dtpstart.Value.Date.ToString("yyyy-MM-dd"), this.dtpend.Value.Date.ToString("yyyy-MM-dd"));
}
DataSet customds = new RecordsCustomerBaseInfoBLL().GetList(strwhere);
int amount = 0;
progressBar1.Visible = true;
progressBar1.Minimum = 0;
progressBar1.Maximum = customds.Tables[0].Rows.Count;
progressBar1.BackColor = Color.Green;
labCountnum.Text = customds.Tables[0].Rows.Count.ToString();
foreach (DataRow row in customds.Tables[0].Rows)
{
int OutKey = Convert.ToInt32(row["ID"].ToString());
if (string.IsNullOrEmpty(row["IDCardNo"].ToString()))
{
continue;
}
// 基本信息
RecordsBaseInfoModel Model = new RecordsBaseInfoBLL().GetModel(row["IDCardNo"].ToString());
if (Model == null)
{
Model = new RecordsBaseInfoModel();
}
// 一般状况
RecordsGeneralConditionModel generalConditionModel = new RecordsGeneralConditionBLL().GetModelByOutKey(OutKey);
if (generalConditionModel == null)
{
generalConditionModel = new RecordsGeneralConditionModel();
}
ChronicDiadetesVisitModel diabetesModel = new ChronicDiadetesVisitModel();
diabetesModel.IDCardNo = row["IDCardNo"].ToString();
diabetesModel.Hypertension = generalConditionModel.RightHeight;
diabetesModel.Hypotension = generalConditionModel.RightPre;
diabetesModel.BMI = generalConditionModel.BMI;
diabetesModel.Weight = generalConditionModel.Weight;
diabetesModel.Hight = generalConditionModel.Height;
if (diabetesModel.BMI != null)
{
if (diabetesModel.BMI >= 24)
{
diabetesModel.TargetWeight = diabetesModel.Weight - 5;
}
}
// 生活方式
RecordsLifeStyleModel lifeModel = new RecordsLifeStyleBLL().GetModelByOutKey(OutKey);
if (lifeModel == null)
{
lifeModel = new RecordsLifeStyleModel();
}
if (lifeModel.SmokeCondition == "3")
{
diabetesModel.DailySmokeNum = lifeModel.SmokeDayNum;
}
else
{
diabetesModel.DailySmokeNum = 0;
}
if (lifeModel.DrinkRate == "2" || lifeModel.DrinkRate == "3" || lifeModel.DrinkRate == "4")
{
diabetesModel.DailyDrinkNum = lifeModel.DayDrinkVolume;
}
else
{
diabetesModel.DailyDrinkNum = 0;
}
diabetesModel.DailySmokeNumTarget = 0;
diabetesModel.DailyDrinkNumTarget = 0;
diabetesModel.SportTimePerWeekTarget = 7;
diabetesModel.SportPerMinuteTimeTarget = 60;
// 辅助检查
RecordsAssistCheckModel AssistCheck = new RecordsAssistCheckBLL().GetModelByOutKey(OutKey);
if (AssistCheck == null)
{
AssistCheck = new RecordsAssistCheckModel();
}
diabetesModel.FPG = AssistCheck.FPGL;
diabetesModel.HbAlc = AssistCheck.HBALC;
new ChronicDiadetesVisitBLL().UpdateDate(diabetesModel);
ChronicHypertensionVisitModel hypertensionModel = new ChronicHypertensionVisitModel();
hypertensionModel.Hypertension = generalConditionModel.RightHeight;
hypertensionModel.Hypotension = generalConditionModel.RightPre;
hypertensionModel.BMI = generalConditionModel.BMI;
hypertensionModel.Weight = generalConditionModel.Weight;
hypertensionModel.Hight = generalConditionModel.Height;
if (hypertensionModel.BMI != null)
{
if (hypertensionModel.BMI >= 24)
{
hypertensionModel.WeightTarGet = hypertensionModel.Weight - 5;
}
}
if (AssistCheck.FPGL != null)
{
hypertensionModel.AssistantExam = $"空腹血糖:{AssistCheck.FPGL}mmol/L";
}
// 查体
RecordsPhysicalExamModel physicalModel = new RecordsPhysicalExamBLL().GetModelByOutKey(OutKey);
if (physicalModel == null)
{
physicalModel = new RecordsPhysicalExamModel();
}
decimal dd = 0;
if (!string.IsNullOrEmpty(physicalModel.HeartRate))
{
if (decimal.TryParse(physicalModel.HeartRate, out dd))
{
hypertensionModel.HeartRate = dd;
}
}
if (lifeModel.SmokeCondition == "3")
{
hypertensionModel.DailySmokeNum = lifeModel.SmokeDayNum;
}
else
{
hypertensionModel.DailySmokeNum = 0;
}
if (lifeModel.DrinkRate == "2" || lifeModel.DrinkRate == "3" || lifeModel.DrinkRate == "4")
{
hypertensionModel.DailyDrinkNum = lifeModel.DayDrinkVolume;
}
else
{
hypertensionModel.DailyDrinkNum = 0;
}
hypertensionModel.DailySmokeNumTarget = 0;
hypertensionModel.DailyDrinkNumTarget = 0;
hypertensionModel.SportTimeSperWeekTarget = 7;
hypertensionModel.SportPerMinutesTimeTarget = 60;
hypertensionModel.IDCardNo = row["IDCardNo"].ToString();
new ChronicHypertensionVisitBLL().UpdateDate(hypertensionModel);
amount++;
labUploadnum.Text = amount.ToString();
progressBar1.Value = amount;
}
MessageBox.Show("成功匹配：" + amount + "条数据！", "提示");
progressBar1.Visible = false;
}
/// <summary>
/// 新增终端资料库中的查体资料--X光
/// </summary>
/// <param name="model"></param>
/// <param name="RecordDate"></param>
/// <returns></returns>
public void InsertByChestX(RecordsAssistCheckModel model)
{
this.dal.InsertByChestX(model);
}
/// <summary>
/// 更新终端资料库中的查体资料--X光
/// </summary>
/// <param name="model"></param>
/// <param name="RecordDate"></param>
/// <returns></returns>
public bool UpdateByChestX(RecordsAssistCheckModel model, string RecordDate)
{
return(this.dal.UpdateByChestX(model, RecordDate));
}
public bool Update(RecordsAssistCheckModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update ARCHIVE_ASSISTCHECK set ");
builder.Append("PhysicalID=@PhysicalID,");
builder.Append("IDCardNo=@IDCardNo,");
builder.Append("HB=@HB,");
builder.Append("WBC=@WBC,");
builder.Append("PLT=@PLT,");
builder.Append("PRO=@PRO,");
builder.Append("GLU=@GLU,");
builder.Append("KET=@KET,");
builder.Append("BLD=@BLD,");
builder.Append("FPGL=@FPGL,");
builder.Append("ECG=@ECG,");
builder.Append("ALBUMIN=@ALBUMIN,");
builder.Append("FOB=@FOB,");
builder.Append("HBALC=@HBALC,");
builder.Append("HBSAG=@HBSAG,");
builder.Append("SGPT=@SGPT,");
builder.Append("GOT=@GOT,");
builder.Append("BP=@BP,");
builder.Append("TBIL=@TBIL,");
builder.Append("CB=@CB,");
builder.Append("SCR=@SCR,");
builder.Append("BUN=@BUN,");
builder.Append("PC=@PC,");
builder.Append("HYPE=@HYPE,");
builder.Append("TC=@TC,");
builder.Append("TG=@TG,");
builder.Append("LowCho=@LowCho,");
builder.Append("HeiCho=@HeiCho,");
builder.Append("CHESTX=@CHESTX,");
builder.Append("BCHAO=@BCHAO,");
builder.Append("BloodOther=@BloodOther,");
builder.Append("UrineOther=@UrineOther,");
builder.Append("Other=@Other,");
builder.Append("CERVIX=@CERVIX,");
builder.Append("GT=@GT,");
builder.Append("ECGEx=@ECGEx,");
builder.Append("CHESTXEx=@CHESTXEx,");
builder.Append("BCHAOEx=@BCHAOEx,");
builder.Append("CERVIXEx=@CERVIXEx,");
builder.Append("FPGDL=@FPGDL,UA=@UA,HCY=@HCY,BCHAOther=@BCHAOther,BCHAOtherEx=@BCHAOtherEx,");
builder.Append("BloodType=@BloodType,");
builder.Append("RH=@RH,");
builder.Append("TP=@TP,");
builder.Append("GLB=@GLB,");
builder.Append("AG=@AG,");
builder.Append("IBIL=@IBIL ");
builder.Append(" where OutKey=@OutKey");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@PhysicalID", MySqlDbType.String, 8),
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@HB", MySqlDbType.Decimal),
new MySqlParameter("@WBC", MySqlDbType.Decimal),
new MySqlParameter("@PLT", MySqlDbType.Decimal),
new MySqlParameter("@PRO", MySqlDbType.String, 10),
new MySqlParameter("@GLU", MySqlDbType.String, 10),
new MySqlParameter("@KET", MySqlDbType.String, 10),
new MySqlParameter("@BLD", MySqlDbType.String, 10),
new MySqlParameter("@FPGL", MySqlDbType.Decimal),
new MySqlParameter("@ECG", MySqlDbType.String, 100),
new MySqlParameter("@ALBUMIN", MySqlDbType.Decimal),
new MySqlParameter("@FOB", MySqlDbType.String, 1),
new MySqlParameter("@HBALC", MySqlDbType.Decimal),
new MySqlParameter("@HBSAG", MySqlDbType.String, 1),
new MySqlParameter("@SGPT", MySqlDbType.Decimal),
new MySqlParameter("@GOT", MySqlDbType.Decimal),
new MySqlParameter("@BP", MySqlDbType.Decimal),
new MySqlParameter("@TBIL", MySqlDbType.Decimal),
new MySqlParameter("@CB", MySqlDbType.Decimal),
new MySqlParameter("@SCR", MySqlDbType.Decimal),
new MySqlParameter("@BUN", MySqlDbType.Decimal),
new MySqlParameter("@PC", MySqlDbType.Decimal),
new MySqlParameter("@HYPE", MySqlDbType.Decimal),
new MySqlParameter("@TC", MySqlDbType.Decimal),
new MySqlParameter("@TG", MySqlDbType.Decimal),
new MySqlParameter("@LowCho", MySqlDbType.Decimal),
new MySqlParameter("@HeiCho", MySqlDbType.Decimal),
new MySqlParameter("@CHESTX", MySqlDbType.String, 1),
new MySqlParameter("@BCHAO", MySqlDbType.String, 1),
new MySqlParameter("@BloodOther", MySqlDbType.String, 50),
new MySqlParameter("@UrineOther", MySqlDbType.String, 50),
new MySqlParameter("@Other", MySqlDbType.String, 50),
new MySqlParameter("@CERVIX", MySqlDbType.String, 1),
new MySqlParameter("@GT", MySqlDbType.Decimal),
new MySqlParameter("@ECGEx", MySqlDbType.String, 500),
new MySqlParameter("@CHESTXEx", MySqlDbType.String, 500),
new MySqlParameter("@BCHAOEx", MySqlDbType.String, 500),
new MySqlParameter("@CERVIXEx", MySqlDbType.String, 500),
new MySqlParameter("@FPGDL", MySqlDbType.Decimal),
new MySqlParameter("@OutKey", MySqlDbType.Int32, 8),
new MySqlParameter("@UA", MySqlDbType.String, 500),
new MySqlParameter("@HCY", MySqlDbType.Decimal),
new MySqlParameter("@BCHAOther", MySqlDbType.String, 500),
new MySqlParameter("@BCHAOtherEx", MySqlDbType.String, 500),
new MySqlParameter("@BloodType", MySqlDbType.String, 1),
new MySqlParameter("@RH", MySqlDbType.String, 1),
new MySqlParameter("@TP", MySqlDbType.Decimal),
new MySqlParameter("@GLB", MySqlDbType.Decimal),
new MySqlParameter("@AG", MySqlDbType.Decimal),
new MySqlParameter("@IBIL", MySqlDbType.Decimal)
};
cmdParms[0].Value = model.PhysicalID;
cmdParms[1].Value = model.IDCardNo;
cmdParms[2].Value = model.HB;
cmdParms[3].Value = model.WBC;
cmdParms[4].Value = model.PLT;
cmdParms[5].Value = model.PRO;
cmdParms[6].Value = model.GLU;
cmdParms[7].Value = model.KET;
cmdParms[8].Value = model.BLD;
cmdParms[9].Value = model.FPGL;
cmdParms[10].Value = model.ECG;
cmdParms[11].Value = model.ALBUMIN;
cmdParms[12].Value = model.FOB;
cmdParms[13].Value = model.HBALC;
cmdParms[14].Value = model.HBSAG;
cmdParms[15].Value = model.SGPT;
cmdParms[16].Value = model.GOT;
cmdParms[17].Value = model.BP;
cmdParms[18].Value = model.TBIL;
cmdParms[19].Value = model.CB;
cmdParms[20].Value = model.SCR;
cmdParms[21].Value = model.BUN;
cmdParms[22].Value = model.PC;
cmdParms[23].Value = model.HYPE;
cmdParms[24].Value = model.TC;
cmdParms[25].Value = model.TG;
cmdParms[26].Value = model.LowCho;
cmdParms[27].Value = model.HeiCho;
cmdParms[28].Value = model.CHESTX;
cmdParms[29].Value = model.BCHAO;
cmdParms[30].Value = model.BloodOther;
cmdParms[31].Value = model.UrineOther;
cmdParms[32].Value = model.Other;
cmdParms[33].Value = model.CERVIX;
cmdParms[34].Value = model.GT;
cmdParms[35].Value = model.ECGEx;
cmdParms[36].Value = model.CHESTXEx;
cmdParms[37].Value = model.BCHAOEx;
cmdParms[38].Value = model.CERVIXEx;
cmdParms[39].Value = model.FPGDL;
cmdParms[40].Value = model.OutKey;
cmdParms[41].Value = model.UA;
//HCY,BCHAOther,BCHAOtherEx
cmdParms[42].Value = model.HCY;
cmdParms[43].Value = model.BCHAOther;
cmdParms[44].Value = model.BCHAOtherEx;
cmdParms[45].Value = model.BloodType;
cmdParms[46].Value = model.RH;
cmdParms[47].Value = model.TP;
cmdParms[48].Value = model.GLB;
cmdParms[49].Value = model.AG;
cmdParms[50].Value = model.IBIL;
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public int Add(RecordsAssistCheckModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into ARCHIVE_ASSISTCHECK(");
builder.Append("PhysicalID,IDCardNo,HB,WBC,PLT,PRO,GLU,KET,BLD,FPGL,ECG,ALBUMIN,FOB,HBALC,HBSAG,SGPT,GOT,BP,TBIL,CB,SCR,BUN,PC,HYPE,TC,TG,LowCho,HeiCho,CHESTX,BCHAO,BloodOther,UrineOther,Other,CERVIX,GT,ECGEx,CHESTXEx,BCHAOEx,CERVIXEx,FPGDL,OutKey,UA,HCY,BCHAOther,BCHAOtherEx,BloodType,RH,TP,GLB,AG,IBIL)");
builder.Append(" values (");
builder.Append("@PhysicalID,@IDCardNo,@HB,@WBC,@PLT,@PRO,@GLU,@KET,@BLD,@FPGL,@ECG,@ALBUMIN,@FOB,@HBALC,@HBSAG,@SGPT,@GOT,@BP,@TBIL,@CB,@SCR,@BUN,@PC,@HYPE,@TC,@TG,@LowCho,@HeiCho,@CHESTX,@BCHAO,@BloodOther,@UrineOther,@Other,@CERVIX,@GT,@ECGEx,@CHESTXEx,@BCHAOEx,@CERVIXEx,@FPGDL,@OutKey,@UA,@HCY,@BCHAOther,@BCHAOtherEx,@BloodType,@RH,@TP,@GLB,@AG,@IBIL)");
builder.Append(";select @@IDENTITY");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@PhysicalID", MySqlDbType.String, 8),
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@HB", MySqlDbType.Decimal),
new MySqlParameter("@WBC", MySqlDbType.Decimal),
new MySqlParameter("@PLT", MySqlDbType.Decimal),
new MySqlParameter("@PRO", MySqlDbType.String, 10),
new MySqlParameter("@GLU", MySqlDbType.String, 10),
new MySqlParameter("@KET", MySqlDbType.String, 10),
new MySqlParameter("@BLD", MySqlDbType.String, 10),
new MySqlParameter("@FPGL", MySqlDbType.Decimal),
new MySqlParameter("@ECG", MySqlDbType.String, 100),
new MySqlParameter("@ALBUMIN", MySqlDbType.Decimal),
new MySqlParameter("@FOB", MySqlDbType.String, 1),
new MySqlParameter("@HBALC", MySqlDbType.Decimal),
new MySqlParameter("@HBSAG", MySqlDbType.String, 1),
new MySqlParameter("@SGPT", MySqlDbType.Decimal),
new MySqlParameter("@GOT", MySqlDbType.Decimal),
new MySqlParameter("@BP", MySqlDbType.Decimal),
new MySqlParameter("@TBIL", MySqlDbType.Decimal),
new MySqlParameter("@CB", MySqlDbType.Decimal),
new MySqlParameter("@SCR", MySqlDbType.Decimal),
new MySqlParameter("@BUN", MySqlDbType.Decimal),
new MySqlParameter("@PC", MySqlDbType.Decimal),
new MySqlParameter("@HYPE", MySqlDbType.Decimal),
new MySqlParameter("@TC", MySqlDbType.Decimal),
new MySqlParameter("@TG", MySqlDbType.Decimal),
new MySqlParameter("@LowCho", MySqlDbType.Decimal),
new MySqlParameter("@HeiCho", MySqlDbType.Decimal),
new MySqlParameter("@CHESTX", MySqlDbType.String, 1),
new MySqlParameter("@BCHAO", MySqlDbType.String, 1),
new MySqlParameter("@BloodOther", MySqlDbType.String, 50),
new MySqlParameter("@UrineOther", MySqlDbType.String, 50),
new MySqlParameter("@Other", MySqlDbType.String, 50),
new MySqlParameter("@CERVIX", MySqlDbType.String, 1),
new MySqlParameter("@GT", MySqlDbType.Decimal),
new MySqlParameter("@ECGEx", MySqlDbType.String, 500),
new MySqlParameter("@CHESTXEx", MySqlDbType.String, 500),
new MySqlParameter("@BCHAOEx", MySqlDbType.String, 500),
new MySqlParameter("@CERVIXEx", MySqlDbType.String, 500),
new MySqlParameter("@FPGDL", MySqlDbType.Decimal),
new MySqlParameter("@OutKey", MySqlDbType.Int32, 4),
new MySqlParameter("@UA", MySqlDbType.String, 500),
new MySqlParameter("@HCY", MySqlDbType.Decimal),
new MySqlParameter("@BCHAOther", MySqlDbType.String, 500),
new MySqlParameter("@BCHAOtherEx", MySqlDbType.String, 500),
new MySqlParameter("@BloodType", MySqlDbType.String, 1),
new MySqlParameter("@RH", MySqlDbType.String, 1),
new MySqlParameter("@TP", MySqlDbType.Decimal),
new MySqlParameter("@GLB", MySqlDbType.Decimal),
new MySqlParameter("@AG", MySqlDbType.Decimal),
new MySqlParameter("@IBIL", MySqlDbType.Decimal)
};
cmdParms[0].Value = model.PhysicalID;
cmdParms[1].Value = model.IDCardNo;
cmdParms[2].Value = model.HB;
cmdParms[3].Value = model.WBC;
cmdParms[4].Value = model.PLT;
cmdParms[5].Value = model.PRO;
cmdParms[6].Value = model.GLU;
cmdParms[7].Value = model.KET;
cmdParms[8].Value = model.BLD;
cmdParms[9].Value = model.FPGL;
cmdParms[10].Value = model.ECG;
cmdParms[11].Value = model.ALBUMIN;
cmdParms[12].Value = model.FOB;
cmdParms[13].Value = model.HBALC;
cmdParms[14].Value = model.HBSAG;
cmdParms[15].Value = model.SGPT;
cmdParms[16].Value = model.GOT;
cmdParms[17].Value = model.BP;
cmdParms[18].Value = model.TBIL;
cmdParms[19].Value = model.CB;
cmdParms[20].Value = model.SCR;
cmdParms[21].Value = model.BUN;
cmdParms[22].Value = model.PC;
cmdParms[23].Value = model.HYPE;
cmdParms[24].Value = model.TC;
cmdParms[25].Value = model.TG;
cmdParms[26].Value = model.LowCho;
cmdParms[27].Value = model.HeiCho;
cmdParms[28].Value = model.CHESTX;
cmdParms[29].Value = model.BCHAO;
cmdParms[30].Value = model.BloodOther;
cmdParms[31].Value = model.UrineOther;
cmdParms[32].Value = model.Other;
cmdParms[33].Value = model.CERVIX;
cmdParms[34].Value = model.GT;
cmdParms[35].Value = model.ECGEx;
cmdParms[36].Value = model.CHESTXEx;
cmdParms[37].Value = model.BCHAOEx;
cmdParms[38].Value = model.CERVIXEx;
cmdParms[39].Value = model.FPGDL;
cmdParms[40].Value = model.OutKey;//UA
cmdParms[41].Value = model.UA;
cmdParms[42].Value = model.HCY;
cmdParms[43].Value = model.BCHAOther;
cmdParms[44].Value = model.BCHAOtherEx;
cmdParms[45].Value = model.BloodType;
cmdParms[46].Value = model.RH;
cmdParms[47].Value = model.TP;
cmdParms[48].Value = model.GLB;
cmdParms[49].Value = model.AG;
cmdParms[50].Value = model.IBIL;
object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
public void SavePhysical(string IDCardNo, DateTime CheckDate, string VersionNo, string barCode = "")
{
try
{
DataTable dsRequire = new RequireBLL().GetList("TabName = '健康体检' ").Tables[0];
DataView dv = dsRequire.DefaultView;
// 获取最后一次体检数据
RecordsCustomerBaseInfoModel customerOldModel = CustomerBaseInfoBLL.GetMaxModel(IDCardNo);
if (customerOldModel == null)
{
customerOldModel = new RecordsCustomerBaseInfoModel();
}
RecordsCustomerBaseInfoModel customerNewModel = new RecordsCustomerBaseInfoModel();
customerNewModel.IDCardNo = IDCardNo;
customerNewModel.CheckDate = CheckDate;
customerNewModel.CustomerID = barCode;
customerNewModel.Doctor = ConfigHelper.GetNode("doctorName");
customerNewModel.CreateBy = ConfigHelper.GetNodeDec("doctor");
customerNewModel.CreateDate = DateTime.Now;
customerNewModel.LastUpdateBy = ConfigHelper.GetNodeDec("doctor");
customerNewModel.LastUpdateDate = DateTime.Now;
#region 一般状况
dv.RowFilter = "Comment='一般状况' AND (IsSetValue='是' OR IsSetValue='预设上次体检') AND OptionName='Symptom' ";
DataTable dt = dv.ToTable();
// 栏位名遍历默认项配置
foreach (DataRow item in dt.Rows)
{
if (item["IsSetValue"].ToString() == "是")
{
customerNewModel.Symptom = item["ItemValue"].ToString();
}
else
{
customerNewModel.Symptom = customerOldModel.Symptom;
customerNewModel.Other = customerOldModel.Other;
}
}
dv.RowFilter = null;
dv.RowFilter = "Comment='一般状况' AND (IsSetValue='是' OR IsSetValue='预设上次体检') AND OptionName<>'Symptom' ";
dt = dv.ToTable();
RecordsGeneralConditionModel gerneralOldModel = GeneralConditionBLL.GetModelByOutKey(customerOldModel.ID);
RecordsGeneralConditionModel gerneralNewModel = new RecordsGeneralConditionModel();
gerneralNewModel = EntityAssignment <RecordsGeneralConditionModel>(gerneralOldModel, gerneralNewModel, dt);
#endregion
#region 生活方式
dv.RowFilter = null;
dv.RowFilter = "Comment='生活方式' AND (IsSetValue='是' OR IsSetValue='预设上次体检') ";
dt = dv.ToTable();
RecordsLifeStyleModel lifeStyleOldModel = LifeStyleBLL.GetModelByOutKey(customerOldModel.ID);
RecordsLifeStyleModel lifeStyleNewModel = new RecordsLifeStyleModel();
if (lifeStyleOldModel == null)
{
lifeStyleOldModel = new RecordsLifeStyleModel();
}
lifeStyleNewModel = EntityAssignment <RecordsLifeStyleModel>(lifeStyleOldModel, lifeStyleNewModel, dt);
#endregion
#region 查体信息
dv.RowFilter = null;
dv.RowFilter = "Comment='查体信息' AND (IsSetValue='是' OR IsSetValue='预设上次体检') ";
dt = dv.ToTable();
RecordsPhysicalExamModel physicalExamOldModel = PhysicalExamBLL.GetModelByOutKey(customerOldModel.ID);
RecordsPhysicalExamModel physicalExamNewModel = new RecordsPhysicalExamModel();
if (physicalExamOldModel == null)
{
physicalExamOldModel = new RecordsPhysicalExamModel();
}
physicalExamNewModel = EntityAssignment <RecordsPhysicalExamModel>(physicalExamOldModel, physicalExamNewModel, dt);
#endregion
#region 辅助检查
dv.RowFilter = null;
dv.RowFilter = "Comment='辅助检查' AND (IsSetValue='是' OR IsSetValue='预设上次体检') ";
dt = dv.ToTable();
RecordsAssistCheckModel assistCheckOldModel = AssistCheckBLL.GetModelByOutKey(customerOldModel.ID);
RecordsAssistCheckModel assistCheckNewModel = new RecordsAssistCheckModel();
if (assistCheckOldModel == null)
{
assistCheckOldModel = new RecordsAssistCheckModel();
}
assistCheckNewModel = EntityAssignment <RecordsAssistCheckModel>(assistCheckOldModel, assistCheckNewModel, dt);
#endregion
#region 脏器功能
dv.RowFilter = null;
dv.RowFilter = "Comment='脏器功能' AND (IsSetValue='是' OR IsSetValue='预设上次体检') ";
dt = dv.ToTable();
RecordsVisceraFunctionModel visceraOldModel = VisceraFunctionBLL.GetModelByOutKey(customerOldModel.ID);
RecordsVisceraFunctionModel visceraNewModel = new RecordsVisceraFunctionModel();
if (visceraOldModel == null)
{
visceraOldModel = new RecordsVisceraFunctionModel();
}
visceraNewModel = EntityAssignment <RecordsVisceraFunctionModel>(visceraOldModel, visceraNewModel, dt);
#endregion
#region 中医体质
RecordsMediPhysDistModel mediPhysDistModel = new RecordsMediPhysDistModel();
#endregion
#region 健康评价
RecordsAssessmentGuideModel assessmentGuideModel = new RecordsAssessmentGuideModel();
#endregion
#region 健康问题
dv.RowFilter = null;
dv.RowFilter = "Comment='健康问题' AND (IsSetValue='是' OR IsSetValue='预设上次体检') ";
dt = dv.ToTable();
RecordsHealthQuestionModel questionOldModel = HealthQuestionBLL.GetModelByOutKey(customerOldModel.ID);
RecordsHealthQuestionModel questionNewModel = new RecordsHealthQuestionModel();
if (questionOldModel == null)
{
questionOldModel = new RecordsHealthQuestionModel();
}
questionNewModel = EntityAssignment <RecordsHealthQuestionModel>(questionOldModel, questionNewModel, dt);
#endregion
#region 住院史、用药情况
dv.RowFilter = null;
dv.RowFilter = "Comment='治疗情况' AND (IsSetValue='是' OR IsSetValue='预设上次体检' OR IsSetValue='预设随访用药') ";
dt = dv.ToTable();
// 获取list model对象，用来获取最后一次体检数据的值
List <RecordsHospitalHistoryModel> hospitalHistoryOld = HospitalHistoryBLL.GetModelList(
string.Format("IDCardNo='{0}' AND OutKey={1}", IDCardNo, customerOldModel.ID));
List <RecordsFamilyBedHistoryModel> familyBedHistoryInfoOld = FamilyBedHistoryBLL.GetModelList(
string.Format("IDCardNo='{0}' AND OutKey={1}", IDCardNo, customerOldModel.ID));
List <RecordsMedicationModel> medicationOld = MedicationBLL.GetModelList(
string.Format("IDCardNo='{0}' AND OutKey={1}", IDCardNo, customerOldModel.ID));
if (hospitalHistoryOld == null)
{
hospitalHistoryOld = new List <RecordsHospitalHistoryModel>();
}
if (familyBedHistoryInfoOld == null)
{
familyBedHistoryInfoOld = new List <RecordsFamilyBedHistoryModel>();
}
if (medicationOld == null)
{
medicationOld = new List <RecordsMedicationModel>();
}
#region 随访用药
List <RecordsMedicationModel> medicationFollowUp = new List <RecordsMedicationModel>();
// 高血压随访
ChronicHypertensionVisitModel HyperModel = new ChronicHypertensionVisitBLL().GetMaxModel(IDCardNo, VersionNo);
if (HyperModel != null)
{
List <ChronicDrugConditionModel> DrugConditions = new ChronicDrugConditionBLL().GetModelList(
string.Format(" IDCardNo='{0}' AND Type='{1}' AND OutKey='{2}' ", IDCardNo, "1", HyperModel.ID));
foreach (ChronicDrugConditionModel drugModel in DrugConditions)
{
RecordsMedicationModel newModel = new RecordsMedicationModel
{
MedicinalName = drugModel.Name,
UseNum = drugModel.DosAge,
IDCardNo = IDCardNo
};
medicationFollowUp.Add(newModel);
}
}
// 糖尿病随访
ChronicDiadetesVisitModel DiaModel = new ChronicDiadetesVisitBLL().GetMaxModel(IDCardNo);
if (DiaModel != null)
{
List <ChronicDrugConditionModel> DiaDrugConditions = new ChronicDrugConditionBLL().GetModelList(
string.Format(" IDCardNo='{0}' AND Type='{1}' AND OutKey='{2}' ", IDCardNo, "2", DiaModel.ID));
foreach (ChronicDrugConditionModel drugModel in DiaDrugConditions)
{
RecordsMedicationModel newModel = new RecordsMedicationModel
{
MedicinalName = drugModel.Name,
UseNum = drugModel.DosAge,
IDCardNo = IDCardNo
};
medicationFollowUp.Add(newModel);
}
}
#endregion
// 用于存储需存档的体检数据
List <RecordsHospitalHistoryModel> hospitalHistoryNew = new List <RecordsHospitalHistoryModel>();
List <RecordsFamilyBedHistoryModel> familyBedHistoryInfoNew = new List <RecordsFamilyBedHistoryModel>();
List <RecordsMedicationModel> medicationNew = new List <RecordsMedicationModel>();
// 临时存储住院史的默认值
RecordsHospitalHistoryModel hModel = new RecordsHospitalHistoryModel();
//通过栏位名，遍历默认项配置
foreach (DataRow item in dt.Rows)
{
switch (item["ChinName"].ToString())
{
case "住院史":
if (item["IsSetValue"].ToString() == "是")
{
if (!string.IsNullOrEmpty(item["ItemValue"].ToString()))
{
string[] resList = item["ItemValue"].ToString().Split(';');
if (resList.Length > 4)
{
hModel.InHospitalDate = Convert.ToDateTime(resList[0].ToString());
hModel.OutHospitalDate = Convert.ToDateTime(resList[1].ToString());
hModel.Reason = resList[2].ToString();
hModel.HospitalName = resList[3].ToString();
hModel.IllcaseNum = resList[4].ToString();
}
else if (resList.Length == 1)
{
hModel.Reason = resList[0].ToString();
}
hospitalHistoryNew.Add(hModel);
}
}
else
{
hospitalHistoryNew = hospitalHistoryOld;
}
break;
case "家庭病床史":
if (item["IsSetValue"].ToString() == "预设上次体检")
{
familyBedHistoryInfoNew = familyBedHistoryInfoOld;
}
break;
case "用药情况":
if (item["IsSetValue"].ToString() == "预设上次体检")
{
medicationNew = medicationOld;
}
else if (item["IsSetValue"].ToString() == "预设随访用药")
{
medicationNew = medicationFollowUp;
}
break;
default:
break;
}
}
#endregion
#region 预防接种史
dv.RowFilter = null;
dv.RowFilter = "Comment='健康评价' AND (IsSetValue='是' OR IsSetValue='预设上次体检') ";
dt = dv.ToTable();
List <RecordsInoculationHistoryModel> inoculationHistoryOld = InoculationHistoryBLL.GetModelList(
string.Format("IDCardNo='{0}' AND OutKey={1}", IDCardNo, customerOldModel.ID));
if (inoculationHistoryOld == null)
{
inoculationHistoryOld = new List <RecordsInoculationHistoryModel>();
}
List <RecordsInoculationHistoryModel> inoculationHistoryNew = new List <RecordsInoculationHistoryModel>();
foreach (DataRow item in dt.Rows)
{
switch (item["ChinName"].ToString())
{
case "非免疫预防接种史":
if (item["IsSetValue"].ToString() == "预设上次体检")
{
inoculationHistoryNew = inoculationHistoryOld;
}
break;
}
}
#endregion
#region 保存默认值
// 体检主档保存
int id = CustomerBaseInfoBLL.Add(customerNewModel);
if (id > 0)
{
// 一般状况
gerneralNewModel.IDCardNo = IDCardNo;
gerneralNewModel.OutKey = id;
GeneralConditionBLL.Add(gerneralNewModel, VersionNo);
// 生活方式
lifeStyleNewModel.IDCardNo = IDCardNo;
lifeStyleNewModel.OutKey = id;
LifeStyleBLL.Add(lifeStyleNewModel);
// 查体信息
physicalExamNewModel.IDCardNo = IDCardNo;
physicalExamNewModel.OutKey = id;
PhysicalExamBLL.Add(physicalExamNewModel);
// 辅助检查
assistCheckNewModel.IDCardNo = IDCardNo;
assistCheckNewModel.OutKey = id;
AssistCheckBLL.Add(assistCheckNewModel);
// 脏器功能
visceraNewModel.IDCardNo = IDCardNo;
visceraNewModel.OutKey = id;
VisceraFunctionBLL.Add(visceraNewModel);
// 中医体质
mediPhysDistModel.IDCardNo = IDCardNo;
mediPhysDistModel.OutKey = id;
MediPhysDistBLL.Add(mediPhysDistModel);
// 健康问题
questionNewModel.IDCardNo = IDCardNo;
questionNewModel.OutKey = id;
HealthQuestionBLL.Add(questionNewModel);
// 健康评价
assessmentGuideModel.IDCardNo = IDCardNo;
assessmentGuideModel.OutKey = id;
AssessmentGuideBLL.Add(assessmentGuideModel);
// 住院史
if (hospitalHistoryNew.Count > 0)
{
foreach (RecordsHospitalHistoryModel recordsInoculationHistoryModel in hospitalHistoryNew)
{
recordsInoculationHistoryModel.OutKey = id;
recordsInoculationHistoryModel.IDCardNo = IDCardNo;
}
HospitalHistoryBLL.AddList(hospitalHistoryNew);
}
// 家庭住院史
if (familyBedHistoryInfoNew.Count > 0)
{
foreach (RecordsFamilyBedHistoryModel model in familyBedHistoryInfoNew)
{
model.OutKey = id;
model.IDCardNo = IDCardNo;
}
FamilyBedHistoryBLL.AddList(familyBedHistoryInfoNew);
}
// 用药
if (medicationNew.Count > 0)
{
foreach (RecordsMedicationModel model in medicationNew)
{
model.OutKey = id;
model.IDCardNo = IDCardNo;
}
MedicationBLL.AddList(medicationNew);
}
// 接种史
if (inoculationHistoryNew.Count > 0)
{
foreach (RecordsInoculationHistoryModel model in inoculationHistoryNew)
{
model.OutKey = id;
model.IDCardNo = IDCardNo;
}
InoculationHistoryBLL.AddList(inoculationHistoryNew);
}
}
#endregion
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.ToString());
throw ex;
}
}