public DataSet GetMaxList(string strWhere, string conn)
{
StringBuilder builder = new StringBuilder();
builder.Append("SELECT Mild,Faint,Yang,Yin,PhlegmDamp,Muggy,BloodStasis,QIconStraint,Characteristic, ");
builder.Append("MildScore,FaintScore,YangsCore,YinScore,PhlegmdampScore,MuggyScore,BloodStasisScore, ");
builder.Append("QiConstraintScore,CharacteristicScore,MildAdvising,FaintAdvising,YangAdvising,YinAdvising, ");
builder.Append("PhlegmdampAdvising,MuggyAdvising,BloodStasisAdvising,QiconstraintAdvising,CharacteristicAdvising, ");
builder.Append("MildAdvisingEx,FaintAdvisingEx,YangadvisingEx,YinAdvisingEx,PhlegmdampAdvisingEx,MuggyAdvisingEx, ");
builder.Append("BloodStasisAdvisingEx,QiconstraintAdvisingEx,CharacteristicAdvisingEx, ");
builder.Append("Medicinecn.RecordDate,Medicinecn.IDCardNo, ");
builder.Append("Energy,Tired,Breath,Voice,Emotion,Spirit,Alone,Fear,Weight,Eye,FootHand,Stomach,Cold,Influenza,Nasal, ");
builder.Append("Snore,Allergy,Urticaria,Skin,Scratch,Mouth,Arms,Greasy,Spot,Eczema,Thirsty,Smell,Abdomen,Coolfood, ");
builder.Append("Defecate,Defecatedry,Tongue,Vein ");
builder.Append("FROM OLD_MEDICINE_CN Medicinecn ");
builder.Append("LEFT JOIN OLD_MEDICINE_RESULT Result ");
builder.Append("ON Result.IDCardNo=Medicinecn.IDCardNo ");
builder.Append("AND Result.RecordDate=Medicinecn.RecordDate ");
if (strWhere.Trim() != "")
{
builder.Append(" WHERE 1=1 " + strWhere);
}
builder.Append(" GROUP BY Medicinecn.IDCardNo,DATE(Medicinecn.RecordDate) ");
return(YcSqliteHelper.Query(builder.ToString(), conn));
}
/// <summary>
/// 取得对应条件的五官科资料
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public DataSet GetList(string strWhere, string conn = "")
{
StringBuilder sbQuery = new StringBuilder();
sbQuery.Append(@"
SELECT
ID
,IDCardNo
,RecordDate
,Lips
,ToothResides
,MissingTeeth AS HypodontiaEx
,Caries AS SaprodontiaEx
,Denture AS DentureEx
,Pharyngeal
,Listen
,LeftView
,RightView
,LeftEyecorrect
,RightEyecorrect
FROM
tbl_Mouth ");
if (strWhere.Trim() != "")
{
sbQuery.Append(" WHERE 1=1 " + strWhere);
}
return(YcSqliteHelper.Query(sbQuery.ToString(), conn));
}
public DataSet GetMaxList(string strWhere, string conn = "")
{
StringBuilder builder = new StringBuilder();
string table = "SELECT COUNT(0) FROM sqlite_master WHERE TYPE='table' AND NAME = 'OLDER_SELFCAREABILITY' ";
object single = YcSqliteHelper.GetSingle(table, conn);
int count = 0;
if (single != null)
{
count = int.Parse(single.ToString());
}
if (count == 0)
{
return(null);
}
builder.Append("SELECT * FROM OLDER_SELFCAREABILITY Medicinecn ");
if (strWhere.Trim() != "")
{
builder.Append(" WHERE 1=1 " + strWhere);
}
builder.Append(" GROUP BY IDCardNo,date(RecordDate) ");
return(YcSqliteHelper.Query(builder.ToString(), conn));
}
public void Update(string failedInfo, string conn = "") //更新minipad 血压,尿仪,体温体重
{
StringBuilder builder = new StringBuilder();
builder.Append(@"Update DeviceInfo set
IsUpload='Y'");
builder.Append(failedInfo);
YcSqliteHelper.ExecuteSqlConnect(builder.ToString(), conn);
}
/// <summary>
/// 判断某表是否存在
/// </summary>
/// <param name="TableName"></param>
/// <param name="conn"></param>
/// <returns></returns>
public bool ExistTable(string TableName, string conn = "")
{
StringBuilder bulider = new StringBuilder();
bulider.Append(" SELECT COUNT(*) FROM sqlite_master WHERE TYPE = 'table' AND NAME = '");
bulider.Append(TableName);
bulider.Append("'");
return(YcSqliteHelper.Exists(bulider.ToString(), conn));
}
public DataSet GetList(string strWhere)
{
StringBuilder builder = new StringBuilder();
builder.Append("select ID,Mild,Faint,Yang,Yin,PhlegmDamp,Muggy,BloodStasis,QIconStraint,Characteristic,MildScore,FaintScore,YangsCore,YinScore,PhlegmdampScore,MuggyScore,BloodStasisScore,QiConstraintScore,CharacteristicScore,MildAdvising,FaintAdvising,YangAdvising,YinAdvising,PhlegmdampAdvising,MuggyAdvising,BloodStasisAdvising,QiconstraintAdvising,CharacteristicAdvising,MildAdvisingEx,FaintAdvisingEx,YangadvisingEx,YinAdvisingEx,PhlegmdampAdvisingEx,MuggyAdvisingEx,BloodStasisAdvisingEx,QiconstraintAdvisingEx,CharacteristicAdvisingEx,IDCardNo,EffectAssess,Satisfy,RecordDate ");
builder.Append(" FROM OLD_MEDICINE_RESULT ");
if (strWhere.Trim() != "")
{
builder.Append(" where " + strWhere);
}
return(YcSqliteHelper.Query(builder.ToString()));
}
public DataSet GetList(string strWhere)
{
StringBuilder builder = new StringBuilder();
builder.Append("select ID,IDCardNo,Dine,Groming,Dressing,Tolet,Activity,TotalScore,RecordDate ");
builder.Append(" FROM OLDER_SELFCAREABILITY ");
if (strWhere.Trim() != "")
{
builder.Append(" where " + strWhere);
}
return(YcSqliteHelper.Query(builder.ToString()));
}
public DataSet GetMaxList(string strWhere)
{
StringBuilder builder = new StringBuilder();
builder.Append("select id,medicinalname,useage,usenum,pilldependence,starttime,drugtype,outkey ");
builder.Append(" FROM ARCHIVE_MEDICATION ");
if (strWhere.Trim() != "")
{
builder.Append(" where 1=1 " + strWhere);
}
//builder.Append(" GROUP BY IDCardNo,date(RecordDate) ");
return(YcSqliteHelper.Query(builder.ToString()));
}
public DataSet GetList(string strWhere, string conn = "")
{
StringBuilder builder = new StringBuilder();
builder.Append("SELECT *,DATE(UpdateData) CheckDate ");
builder.Append("FROM DeviceInfo ");
if (strWhere.Trim() != "")
{
builder.Append(" WHERE 1=1 " + strWhere);
}
return(YcSqliteHelper.Query(builder.ToString(), conn));
}
public DataSet GetList(string strWhere, string conn = "")
{
StringBuilder builder = new StringBuilder();
builder.Append("select * ");
builder.Append(" FROM ARCHIVE_MEDICATION ");
if (strWhere.Trim() != "")
{
builder.Append(" where 1=1 " + strWhere);
}
return(YcSqliteHelper.Query(builder.ToString(), conn));
}
public DataSet GetList(string strWhere)
{
StringBuilder builder = new StringBuilder();
builder.Append("select ID,IDCardNo,Energy,Tired,Breath,Voice,Emotion,");
builder.Append("Spirit,Alone,Fear,Weight,Eye,FootHand,Stomach,Cold,Influenza,Nasal,Snore,Allergy,Urticaria,");
builder.Append("Skin,Scratch,Mouth,Arms,Greasy,Spot,Eczema,Thirsty,Smell,Abdomen,Coolfood,Defecate,Defecatedry,");
builder.Append("Tongue,Vein,RecordDate");
builder.Append(" FROM OLD_MEDICINE_CN ");
if (strWhere.Trim() != "")
{
builder.Append(" where 1=1 " + strWhere);
}
return(YcSqliteHelper.Query(builder.ToString()));
}
/// <summary>
/// 心电
/// </summary>
/// <param name="strWhere"></param>
/// <param name="conn"></param>
/// <returns></returns>
public DataSet GetECGList(string strWhere, string conn = "")
{
StringBuilder builder = new StringBuilder();
builder.Append("SELECT * FROM QRCodeInfo WHERE ECGDate IS NOT NULL ");
if (strWhere.Trim() != "")
{
builder.Append(strWhere);
}
builder.Append(" GROUP BY IDCard,DATE(ECGDate) ");
return(YcSqliteHelper.Query(builder.ToString(), conn));
}
/// <summary>
/// 一代心电
/// </summary>
/// <param name="strWhere"></param>
/// <param name="conn"></param>
/// <returns></returns>
public DataSet GetFirstECGList(string strWhere, string conn = "")
{
StringBuilder builder = new StringBuilder();
builder.Append("SELECT * FROM apply WHERE createTime IS NOT NULL ");
if (strWhere.Trim() != "")
{
builder.Append(strWhere);
}
builder.Append(" GROUP BY cardNumber,DATE(createTime) ");
return(YcSqliteHelper.Query(builder.ToString(), conn));
}
public DataSet GetMaxList(string strWhere, string conn = "")
{
StringBuilder builder = new StringBuilder();
builder.Append("SELECT ID,IDCardNo,Dine,Groming,Dressing,Tolet,Activity,TotalScore,RecordDate ");
builder.Append(" FROM OLDER_SELFCAREABILITY Medicinecn ");
if (strWhere.Trim() != "")
{
builder.Append(" WHERE 1=1 " + strWhere);
}
builder.Append(" GROUP BY IDCardNo,date(RecordDate) ");
return(YcSqliteHelper.Query(builder.ToString(), conn));
}
public DataSet GetMaxList(string strWhere, string conn = "")
{
StringBuilder builder = new StringBuilder();
builder.Append("SELECT * ");
builder.Append(" FROM tbl_recordscustomerinfo ");
if (strWhere.Trim() != "")
{
builder.Append(" WHERE 1=1 " + strWhere);
}
builder.Append(" GROUP BY IDCardNo,DATE(RecordDate) ");
return(YcSqliteHelper.Query(builder.ToString(), conn));
}
/// <summary>
/// 获取智力评估表
/// </summary>
/// <param name="strWhere"></param>
/// <param name="conn"></param>
/// <returns></returns>
public DataSet GetOldIntelligence(string strWhere, string conn = "")
{
StringBuilder bulider = new StringBuilder();
bulider.Append(" SELECT * FROM tbl_oldintelligence ");
bulider.Append(" WHERE 1=1 ");
if (!string.IsNullOrEmpty(strWhere))
{
bulider.Append(strWhere);
}
bulider.Append("ORDER BY DATE(RecordDate) ");
return(YcSqliteHelper.Query(bulider.ToString(), conn));
}
public DataSet GetMaxList(string strWhere, string conn = "")
{
StringBuilder builder = new StringBuilder();
builder.Append("SELECT date(UpdateData) CheckDate,ID,DeviceType,DeviceName,Value1,Value2,Value3,Value4,Value5,Value6,Value7,Value8,Value9,Value10,Value11,Value12,Value13,IsUpload,IDCardNo,ID ");
builder.Append(" FROM DeviceInfo ");
if (strWhere.Trim() != "")
{
builder.Append(" WHERE 1=1 " + strWhere);
}
builder.Append(" ORDER BY ID");
//builder.Append(" GROUP BY IDCardNo,DeviceType,date(UpdateData),Type ");
return(YcSqliteHelper.Query(builder.ToString(), conn));
}
public int GetRecordCount(string strWhere)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(1) FROM ARCHIVE_MEDICATION ");
if (strWhere.Trim() != "")
{
builder.Append(" where " + strWhere);
}
object single = YcSqliteHelper.GetSingle(builder.ToString());
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
/// <summary>
/// 取得对应条件的内科资料
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public DataSet GetInternalMedicineList(string strWhere, string conn = "")
{
StringBuilder sbQuery = new StringBuilder();
sbQuery.Append(@"
SELECT
ID
,IDCardNo
,RecordDate
,EyeRound
,EyeRoundEx
,BarrelChest
,BreathSounds
,BreathSoundsEx
,Rale
,RaleEx
,HeartRate
,HeartRhythm
,Noise
,NoiseEx
,Anus
,AnusEx
,Breast
,BreastEx
,Vulva
,VulvaEx
,V****a
,VaginaEx
,CervixUteri
,CervixUteriEx
,Corpus
,CorpusEx
,Attach
,AttachEx
FROM
tbl_InternalMedicine ");
if (strWhere.Trim() != "")
{
sbQuery.Append(" WHERE 1=1 " + strWhere);
}
return(YcSqliteHelper.Query(sbQuery.ToString(), conn));
}
/// <summary>
/// 取得住院史及接种史
/// </summary>
/// <param name="strWhere"></param>
/// <param name="conn"></param>
/// <returns></returns>
public DataSet GetHistoryList(string strWhere, string conn = "")
{
StringBuilder builder = new StringBuilder();
// 判断分离式中是否有住院史及接种史的表
builder.Append("SELECT COUNT(0) FROM sqlite_master WHERE TYPE='table' AND NAME='tbl_RecordsHistory'");
object single = YcSqliteHelper.GetSingle(builder.ToString(), conn);
if (single != null && Convert.ToInt32(single) > 0)
{
builder.Clear();
builder.Append(@"SELECT
ID
,IDCardNo
,Type
,RecordDate
,InDate
,Reason
,IllcaseNum
,Name
,OutDate
,InoculationHistory
,OutKey
FROM tbl_RecordsHistory
WHERE EXISTS
(
SELECT ID FROM tbl_recordscustomerinfo
WHERE ID = OutKey ");
if (strWhere.Trim() != "")
{
builder.Append(strWhere);
}
builder.Append(" GROUP BY IDCardNo,DATE(RecordDate)) ");
return(YcSqliteHelper.Query(builder.ToString(), conn));
}
return(new DataSet());
}
/// <summary>
/// 获取体检问询用药资料内容
/// </summary>
/// <param name="strWhere"></param>
/// <param name="conn"></param>
/// <returns></returns>
public DataSet GetList(string strWhere, string conn = "")
{
StringBuilder builder = new StringBuilder();
// 体检问询用药
builder.Append(@"SELECT * FROM ARCHIVE_MEDICATION WHERE EXISTS
(
SELECT ID FROM tbl_recordscustomerinfo
WHERE ID = OutKey ");
if (strWhere.Trim() != "")
{
builder.Append(strWhere);
}
builder.Append(" GROUP BY IDCardNo,DATE(RecordDate)");
builder.Append(")");
return(YcSqliteHelper.Query(builder.ToString(), conn));
}
/// <summary>
/// 取得对应条件的外科资料
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public DataSet GetSurgicalList(string strWhere, string conn = "")
{
StringBuilder sbQuery = new StringBuilder();
sbQuery.Append(@"
SELECT
ID
,IDCardNo
,RecordDate
,SportFunction
,Skin
,SkinEx
,Sclera AS Sclere
,ScleraEx AS SclereEx
,Lymph
,LymphEx
,PressPain
,PressPainEx
,EnclosedMass
,EnclosedMassEx
,Liver
,LiverEx
,Spleen
,SpleenEx
,Voiced
,VoicedEx
,Edema
,FootBack
,ElseDis
,ElseOther
,Other
FROM
tbl_Surgical ");
if (strWhere.Trim() != "")
{
sbQuery.Append(" WHERE 1=1 " + strWhere);
}
return(YcSqliteHelper.Query(sbQuery.ToString(), conn));
}
/// <summary>
/// 取得对应条件的X光资料
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public DataSet GetChestXList(string strWhere, string conn = "")
{
StringBuilder sbQuery = new StringBuilder();
sbQuery.Append(@"
SELECT
ID
,IDCardNo
,RecordDate
,CHESTX
,CHESTXEx
FROM
tbl_RecordsChestX ");
if (strWhere.Trim() != "")
{
sbQuery.Append(" WHERE 1=1 " + strWhere);
}
return(YcSqliteHelper.Query(sbQuery.ToString(), conn));
}
public bool ISconnectOpen()
{
return(YcSqliteHelper.ISconnectOpen());
}
