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