public void InitEveryThing()
{
this.HHMediphy = this.MediPyBLL.GetModel(HealthHouseFactory.ID);
if (this.HHMediphy == null)
{
this.HHMediphy = new HealthHouseMediPhyModel();
this.HHMediphy.IDCardNo = this.Model.IDCardNo;
}
else
{
this.HHMediCn = this.MediCnBll.GetModel(this.HHMediphy.MedicineID);
this.HHMediRes = this.MediResBLL.GetModel(this.HHMediphy.MedicineResultID);
}
this.HealthModel = new HealthHouseBLL().GetDataByID(HealthHouseFactory.ID);
if (this.HealthModel == null)
{
this.HealthModel = new HealthHouseModel();
}
this.pinghezhi = new Physique(this.radshipinghe, this.radjibenpinghe, this.HHMediphy.Mild);
this.qixuzhi = new Physique(this.radshiqixu, this.radqingqixu, this.HHMediphy.Faint);
this.yangxuzhi = new Physique(this.radshiyangxu, this.radqingyangxu, this.HHMediphy.Yang);
this.yinxuzhi = new Physique(this.radshiyinxu, this.radqingyinxu, this.HHMediphy.Yin);
this.tanshizhi = new Physique(this.radshitanshi, this.radqingtanshi, this.HHMediphy.PhlegmDamp);
this.shirezhi = new Physique(this.radshishire, this.radqingshire, this.HHMediphy.Muggy);
this.xueyuzhi = new Physique(this.radshixueyu, this.radqingxueyu, this.HHMediphy.BloodStasis);
this.qiyuzhi = new Physique(this.radshiqiyu, this.radqingqiyu, this.HHMediphy.QiConstraint);
this.tejianzhi = new Physique(this.radshitejian, this.radqingtejian, this.HHMediphy.Characteristic);
this.EveryThingIsOk = true;
}
public bool Update(HealthHouseMediPhyModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update HEALTHHOUSE_MEDIPHYDIST set ");
builder.Append("IDCardNo=@IDCardNo,");
builder.Append("Mild=@Mild,");
builder.Append("Faint=@Faint,");
builder.Append("Yang=@Yang,");
builder.Append("Yin=@Yin,");
builder.Append("PhlegmDamp=@PhlegmDamp,");
builder.Append("Muggy=@Muggy,");
builder.Append("BloodStasis=@BloodStasis,");
builder.Append("QiConstraint=@QiConstraint,");
builder.Append("Characteristic=@Characteristic,");
builder.Append("MedicineID=@MedicineID,");
builder.Append("MedicineResultID=@MedicineResultID ");
builder.Append(" where PID=@PID");
MySqlParameter[] cmdParms = new MySqlParameter[]
{
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@Mild", MySqlDbType.String, 1),
new MySqlParameter("@Faint", MySqlDbType.String, 1),
new MySqlParameter("@Yang", MySqlDbType.String, 1),
new MySqlParameter("@Yin", MySqlDbType.String, 1),
new MySqlParameter("@PhlegmDamp", MySqlDbType.String, 1),
new MySqlParameter("@Muggy", MySqlDbType.String, 1),
new MySqlParameter("@BloodStasis", MySqlDbType.String, 1),
new MySqlParameter("@QiConstraint", MySqlDbType.String, 1),
new MySqlParameter("@Characteristic", MySqlDbType.String, 1),
new MySqlParameter("@MedicineID", MySqlDbType.Int32, 4),
new MySqlParameter("@MedicineResultID", MySqlDbType.Int32, 4),
new MySqlParameter("@PID", MySqlDbType.Int32, 8)
};
cmdParms[0].Value = model.IDCardNo;
cmdParms[1].Value = model.Mild;
cmdParms[2].Value = model.Faint;
cmdParms[3].Value = model.Yang;
cmdParms[4].Value = model.Yin;
cmdParms[5].Value = model.PhlegmDamp;
cmdParms[6].Value = model.Muggy;
cmdParms[7].Value = model.BloodStasis;
cmdParms[8].Value = model.QiConstraint;
cmdParms[9].Value = model.Characteristic;
cmdParms[10].Value = model.MedicineID;
cmdParms[11].Value = model.MedicineResultID;
cmdParms[12].Value = model.PID;
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool SaveModelToDB()
{
if (this.HHMediphy == null)
{
return(false);
}
this.HHMediphy.PID = HealthHouseFactory.ID;
HealthHouseMediPhyModel MediPhyTem = this.MediPyBLL.GetModel(HealthHouseFactory.ID);
if (MediPhyTem == null)//新增
{
if (this.HHMediCn != null)
{
this.HHMediphy.MedicineID = this.MediCnBll.Add(this.HHMediCn);
}
this.MediPyBLL.Add(this.HHMediphy);
}
else
{
if (this.HHMediCn != null)
{
if (this.HHMediphy.MedicineID == 0)//中医体质中，无体质辨识问卷
{
this.HHMediphy.MedicineID = this.MediCnBll.Add(this.HHMediCn);
}
else //中医体质中，有体质辨识问卷
{
this.HHMediCn.ID = MediPhyTem.MedicineID;
this.HHMediphy.MedicineID = MediPhyTem.MedicineID;
this.MediCnBll.Update(this.HHMediCn);
}
}
if (this.HHMediRes != null)
{
if (this.HHMediphy.MedicineResultID == 0)//中医体质中，无体质辨识问卷
{
this.HHMediphy.MedicineResultID = this.MediResBLL.Add(this.HHMediRes);
}
else //中医体质中，有体质辨识问卷
{
this.HHMediRes.ID = MediPhyTem.MedicineResultID;
this.HHMediphy.MedicineResultID = MediPhyTem.MedicineResultID;
this.MediResBLL.Update(this.HHMediRes);
}
}
this.MediPyBLL.Update(this.HHMediphy);
}
return(true);
}
public int Add(HealthHouseMediPhyModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into HEALTHHOUSE_MEDIPHYDIST(");
builder.Append("IDCardNo,Mild,Faint,Yang,Yin,PhlegmDamp,Muggy,BloodStasis,QiConstraint,Characteristic,PID,MedicineID,MedicineResultID)");
builder.Append(" values (");
builder.Append("@IDCardNo,@Mild,@Faint,@Yang,@Yin,@PhlegmDamp,@Muggy,@BloodStasis,@QiConstraint,@Characteristic,@PID,@MedicineID,@MedicineResultID)");
builder.Append(";select @@IDENTITY");
MySqlParameter[] cmdParms = new MySqlParameter[]
{
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@Mild", MySqlDbType.String, 1),
new MySqlParameter("@Faint", MySqlDbType.String, 1),
new MySqlParameter("@Yang", MySqlDbType.String, 1),
new MySqlParameter("@Yin", MySqlDbType.String, 1),
new MySqlParameter("@PhlegmDamp", MySqlDbType.String, 1),
new MySqlParameter("@Muggy", MySqlDbType.String, 1),
new MySqlParameter("@BloodStasis", MySqlDbType.String, 1),
new MySqlParameter("@QiConstraint", MySqlDbType.String, 1),
new MySqlParameter("@Characteristic", MySqlDbType.String, 1),
new MySqlParameter("@PID", MySqlDbType.Int32, 4),
new MySqlParameter("@MedicineID", MySqlDbType.Int32, 4),
new MySqlParameter("@MedicineResultID", MySqlDbType.Int32, 4)
};
cmdParms[0].Value = model.IDCardNo;
cmdParms[1].Value = model.Mild;
cmdParms[2].Value = model.Faint;
cmdParms[3].Value = model.Yang;
cmdParms[4].Value = model.Yin;
cmdParms[5].Value = model.PhlegmDamp;
cmdParms[6].Value = model.Muggy;
cmdParms[7].Value = model.BloodStasis;
cmdParms[8].Value = model.QiConstraint;
cmdParms[9].Value = model.Characteristic;
cmdParms[10].Value = model.PID;
cmdParms[11].Value = model.MedicineID;
cmdParms[12].Value = model.MedicineResultID;
object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
public HealthHouseMediPhyModel DataRowToModel(DataRow row)
{
HealthHouseMediPhyModel HHMediPhysDistModel = new HealthHouseMediPhyModel();
if (row != null)
{
if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != ""))
{
HHMediPhysDistModel.ID = int.Parse(row["ID"].ToString());
}
if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value))
{
HHMediPhysDistModel.IDCardNo = row["IDCardNo"].ToString();
}
if ((row["Mild"] != null) && (row["Mild"] != DBNull.Value))
{
HHMediPhysDistModel.Mild = row["Mild"].ToString();
}
if ((row["Faint"] != null) && (row["Faint"] != DBNull.Value))
{
HHMediPhysDistModel.Faint = row["Faint"].ToString();
}
if ((row["Yang"] != null) && (row["Yang"] != DBNull.Value))
{
HHMediPhysDistModel.Yang = row["Yang"].ToString();
}
if ((row["Yin"] != null) && (row["Yin"] != DBNull.Value))
{
HHMediPhysDistModel.Yin = row["Yin"].ToString();
}
if ((row["PhlegmDamp"] != null) && (row["PhlegmDamp"] != DBNull.Value))
{
HHMediPhysDistModel.PhlegmDamp = row["PhlegmDamp"].ToString();
}
if ((row["Muggy"] != null) && (row["Muggy"] != DBNull.Value))
{
HHMediPhysDistModel.Muggy = row["Muggy"].ToString();
}
if ((row["BloodStasis"] != null) && (row["BloodStasis"] != DBNull.Value))
{
HHMediPhysDistModel.BloodStasis = row["BloodStasis"].ToString();
}
if ((row["QiConstraint"] != null) && (row["QiConstraint"] != DBNull.Value))
{
HHMediPhysDistModel.QiConstraint = row["QiConstraint"].ToString();
}
if ((row["Characteristic"] != null) && (row["Characteristic"] != DBNull.Value))
{
HHMediPhysDistModel.Characteristic = row["Characteristic"].ToString();
}
if (((row["MedicineID"] != null) && (row["MedicineID"] != DBNull.Value)) && (row["MedicineID"].ToString() != ""))
{
HHMediPhysDistModel.MedicineID = int.Parse(row["MedicineID"].ToString());
}
if (((row["MedicineResultID"] != null) && (row["MedicineResultID"] != DBNull.Value)) && (row["MedicineResultID"].ToString() != ""))
{
HHMediPhysDistModel.MedicineResultID = int.Parse(row["MedicineResultID"].ToString());
}
}
return(HHMediPhysDistModel);
}
public bool Update(HealthHouseMediPhyModel model)
{
return(this.dal.Update(model));
}
public int Add(HealthHouseMediPhyModel model)
{
return(this.dal.Add(model));
}
