public ChronicDrugConditionModel DataRowToModel(DataRow row)
{
ChronicDrugConditionModel cd_drugcondition = new ChronicDrugConditionModel();
if (row != null)
{
if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != ""))
{
cd_drugcondition.ID = int.Parse(row["ID"].ToString());
}
if (((row["OUTKey"] != null) && (row["OUTKey"] != DBNull.Value)) && (row["OUTKey"].ToString() != ""))
{
cd_drugcondition.OUTKey = int.Parse(row["OUTKey"].ToString());
}
if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value))
{
cd_drugcondition.IDCardNo = row["IDCardNo"].ToString();
}
if ((row["Type"] != null) && (row["Type"] != DBNull.Value))
{
cd_drugcondition.Type = row["Type"].ToString();
}
if ((row["Name"] != null) && (row["Name"] != DBNull.Value))
{
cd_drugcondition.Name = row["Name"].ToString();
}
if (((row["DailyTime"] != null) && (row["DailyTime"] != DBNull.Value)) && (row["DailyTime"].ToString() != ""))
{
cd_drugcondition.DailyTime = new decimal?(decimal.Parse(row["DailyTime"].ToString()));
}
if ((row["EveryTimeMg"] != null) && (row["EveryTimeMg"] != DBNull.Value))
{
cd_drugcondition.EveryTimeMg = row["EveryTimeMg"].ToString();
}
if ((row["drugtype"] != null) && (row["drugtype"] != DBNull.Value))
{
cd_drugcondition.drugtype = row["drugtype"].ToString();
}
if ((row["factory"] != null) && (row["factory"] != DBNull.Value))
{
cd_drugcondition.factory = row["factory"].ToString();
}
if ((row["DosAge"] != null) && (row["DosAge"] != DBNull.Value))
{
cd_drugcondition.DosAge = row["DosAge"].ToString();
}
}
return(cd_drugcondition);
}
public List <ChronicDrugConditionModel> DataTableToList(DataTable dt)
{
List <ChronicDrugConditionModel> list = new List <ChronicDrugConditionModel>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
ChronicDrugConditionModel item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public int Add(ChronicDrugConditionModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("INSERT INTO CD_DRUGCONDITION(");
builder.Append("IDCardNo,Type,Name,DailyTime,EveryTimeMg,drugtype,factory,OutKey )");
builder.Append(" VALUES (");
builder.Append("@IDCardNo,@Type,@Name,@DailyTime,@EveryTimeMg,@drugtype,@factory,@OutKey )");
builder.Append(";SELECT @@IDENTITY");
MySqlParameter[] cmdParms = new MySqlParameter[]
{
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@Type", MySqlDbType.String, 1),
new MySqlParameter("@Name", MySqlDbType.String, 100),
new MySqlParameter("@DailyTime", MySqlDbType.String, 100),
new MySqlParameter("@EveryTimeMg", MySqlDbType.String),
new MySqlParameter("@drugtype", MySqlDbType.String, 100),
new MySqlParameter("@factory", MySqlDbType.String, 100),
new MySqlParameter("@OutKey", MySqlDbType.Int32, 11)
};
cmdParms[0].Value = model.IDCardNo;
cmdParms[1].Value = model.Type;
cmdParms[2].Value = model.Name;
cmdParms[3].Value = model.DailyTime;
cmdParms[4].Value = model.EveryTimeMg;
cmdParms[5].Value = model.DrugType;
cmdParms[6].Value = model.Factory;
cmdParms[7].Value = model.OutKey;
object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
public bool Update(ChronicDrugConditionModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update CD_DRUGCONDITION set ");
builder.Append("IDCardNo=@IDCardNo,");
builder.Append("Type=@TYPE,");
builder.Append("Name=@NAME,");
builder.Append("DailyTime=@DAILYTIME,");
builder.Append("EveryTimeMg=@EVERYTIMEMG,");
builder.Append("drugtype = @drugtype,");
builder.Append("factory = @factory,");
builder.Append("DosAge = @DosAge, ");
builder.Append("OUTKey = @OUTKey ");
builder.Append(" where ID=@ID ");
MySqlParameter[] cmdParms = new MySqlParameter[]
{ new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@TYPE", MySqlDbType.String, 1),
new MySqlParameter("@NAME", MySqlDbType.String, 100),
new MySqlParameter("@DAILYTIME", MySqlDbType.Decimal),
new MySqlParameter("@EVERYTIMEMG", MySqlDbType.String, 100),
new MySqlParameter("@drugtype", MySqlDbType.String, 100),
new MySqlParameter("@factory", MySqlDbType.String, 100),
new MySqlParameter("@DosAge", MySqlDbType.String, 100),
new MySqlParameter("@OUTKey", MySqlDbType.Int32, 8),
new MySqlParameter("@ID", MySqlDbType.Int32, 8) };
cmdParms[0].Value = model.IDCardNo;
cmdParms[1].Value = model.Type;
cmdParms[2].Value = model.Name;
cmdParms[3].Value = model.DailyTime;
cmdParms[4].Value = model.EveryTimeMg;
cmdParms[5].Value = model.drugtype;
cmdParms[6].Value = model.factory;
cmdParms[7].Value = model.DosAge;
cmdParms[8].Value = model.OUTKey;
cmdParms[9].Value = model.ID;
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public int Add(ChronicDrugConditionModel model)
{
return(this.dal.Add(model));
}
public bool UpdateOUTKey(ChronicDrugConditionModel model)
{
return(this.dal.UpdateOUTKey(model));
}
/// <summary>
/// 存储用药
/// </summary>
/// <param name="IDCardNo"></param>
/// <param name="type">1.高血压 2.糖尿病</param>
/// <param name="outKeyN">新增随访Key</param>
public void SaveMedication(string IDCardNo, string type, int outKeyN)
{
// 预设体检用药
List <RecordsMedicationModel> medicationModel = new RecordsMedicationBLL().GetModelList(string.Format("IDCardNo='{0}' ", IDCardNo));
if (medicationModel == null)
{
medicationModel = new List <RecordsMedicationModel>();
}
// 用于存储需存档的体检数据
List <ChronicDrugConditionModel> conditionModel = new List <ChronicDrugConditionModel>();
for (int i = 0; i < medicationModel.Count; i++)
{
if (type == "2" && i > 2)
{
break;
}
else if (type == "1" && i > 3)
{
break;
}
ChronicDrugConditionModel drugConditionModel = new ChronicDrugConditionModel();
drugConditionModel.IDCardNo = medicationModel[i].IDCardNo;
drugConditionModel.Type = type;
drugConditionModel.OutKey = outKeyN;
drugConditionModel.Name = medicationModel[i].MedicinalName;
if (medicationModel[i].Frequency == "2" || medicationModel[i].Frequency == "每日一次") // 每日一次
{
drugConditionModel.DailyTime = "1";
}
else if (medicationModel[i].Frequency == "3" || medicationModel[i].Frequency == "每日两次") // 每日两次
{
drugConditionModel.DailyTime = "2";
}
else if (medicationModel[i].Frequency == "4" || medicationModel[i].Frequency == "每日三次") // 每日三次
{
drugConditionModel.DailyTime = "3";
}
else if (medicationModel[i].Frequency == "5" || medicationModel[i].Frequency == "每日四次") // 每日四次
{
drugConditionModel.DailyTime = "4";
}
drugConditionModel.DrugType = medicationModel[i].DrugType;
drugConditionModel.EveryTimeMg = medicationModel[i].UseNum;
if (medicationModel[i].UseDay == "2") // 克
{
drugConditionModel.EveryTimeMg += "克";
}
else if (medicationModel[i].UseDay == "3") // 毫克
{
drugConditionModel.EveryTimeMg += "毫克";
}
else if (medicationModel[i].UseDay == "4") // 毫升
{
drugConditionModel.EveryTimeMg += "毫升";
}
else if (medicationModel[i].UseDay == "5") // 国际单位
{
drugConditionModel.EveryTimeMg += "国际单位";
}
else if (medicationModel[i].UseDay == "6") // 片
{
drugConditionModel.EveryTimeMg += "片";
}
else if (medicationModel[i].UseDay == "7") // 粒
{
drugConditionModel.EveryTimeMg += "粒";
}
else if (medicationModel[i].UseDay == "8") // 滴
{
drugConditionModel.EveryTimeMg += "滴";
}
else if (medicationModel[i].UseDay == "9") // 包
{
drugConditionModel.EveryTimeMg += "包";
}
else if (medicationModel[i].UseDay == "10") // 支
{
drugConditionModel.EveryTimeMg += "支";
}
DrugConditionGuideBLL.Add(drugConditionModel);
}
}
