/// <summary> /// 修改心血管资料 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(HHCardiovascularModel model) { StringBuilder builder = new StringBuilder(); builder.Append(@"UPDATE HEALTHHOUSE_CARDIOVASCULAR SET CheckDate = @CheckDate ,Result = @Result ,ResultEx = @ResultEx WHERE PID=@PID "); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@PID", MySqlDbType.Int32), new MySqlParameter("@CheckDate", MySqlDbType.Date), new MySqlParameter("@Result", MySqlDbType.String, 1), new MySqlParameter("@ResultEx", MySqlDbType.String, 500) }; cmdParms[0].Value = model.PID; cmdParms[1].Value = model.CheckDate; cmdParms[2].Value = model.Result; cmdParms[3].Value = model.ResultEx; object single = MySQLHelper.ExecuteSql(builder.ToString(), cmdParms); if (single == null) { return(0); } return(Convert.ToInt32(single)); }
public void InitEveryThing() { this.vascularModel = vascularBLL.GetData(this.Model.IDCardNo, HealthHouseFactory.ID); if (this.vascularModel == null) { this.vascularModel = new HHCardiovascularModel(); this.vascularModel.IDCardNo = this.Model.IDCardNo; } CSingleItem item2 = new CSingleItem { Name = "心血管", Usual = this.rdCardiovascular, Unusual = this.rdCardiovascularEx, Info = this.txtCResultEx }; this.Cardiovascular = item2; this.Cardiovascular.TransInfo(this.vascularModel.Result, this.vascularModel.ResultEx); if (!string.IsNullOrEmpty(this.vascularModel.ImgPath) && File.Exists(this.vascularModel.ImgPath)) { //读取文件流 System.IO.FileStream fs = new System.IO.FileStream(this.vascularModel.ImgPath, FileMode.Open, FileAccess.Read); int byteLength = (int)fs.Length; byte[] fileBytes = new byte[byteLength]; fs.Read(fileBytes, 0, byteLength); //文件流关閉,文件解除锁定 fs.Close(); Image image = Image.FromStream(new MemoryStream(fileBytes)); pboxBShow.Image = image; //Image img = System.Drawing.Image.FromFile(this.vascularModel.ImgPath); //Image bmp = new System.Drawing.Bitmap(img); //img.Dispose(); //pboxBShow.Image = bmp; } else { btnPrint.Visible = false; } this.EveryThingIsOk = true; }
/// <summary> /// 新增心血管资料 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(HHCardiovascularModel model) { StringBuilder builder = new StringBuilder(); builder.Append(@"INSERT INTO HEALTHHOUSE_CARDIOVASCULAR ( IDCardNo ,CheckDate ,PID ,Result ,ResultEx ) VALUES ( @IDCardNo ,@CheckDate ,@PID ,@Result ,@ResultEx ) "); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@IDCardNo", MySqlDbType.String, 18), new MySqlParameter("@CheckDate", MySqlDbType.Date), new MySqlParameter("@PID", MySqlDbType.Int32), new MySqlParameter("@Result", MySqlDbType.String, 1), new MySqlParameter("@ResultEx", MySqlDbType.String, 500) }; cmdParms[0].Value = model.IDCardNo; cmdParms[1].Value = model.CheckDate; cmdParms[2].Value = model.PID; cmdParms[3].Value = model.Result; cmdParms[4].Value = model.ResultEx; object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms); if (single == null) { return(0); } return(Convert.ToInt32(single)); }
public HHCardiovascularModel DataRowToModel(DataRow row) { HHCardiovascularModel vascularModel = new HHCardiovascularModel(); if (row != null) { if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != "")) { vascularModel.ID = int.Parse(row["ID"].ToString()); } if (((row["PID"] != null) && (row["PID"] != DBNull.Value)) && (row["PID"].ToString() != "")) { vascularModel.PID = int.Parse(row["PID"].ToString()); } if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value)) { vascularModel.IDCardNo = row["IDCardNo"].ToString(); } if ((row["ResultEx"] != null) && (row["ResultEx"] != DBNull.Value)) { vascularModel.ResultEx = row["ResultEx"].ToString(); } if ((row["Result"] != null) && (row["Result"] != DBNull.Value)) { vascularModel.Result = row["Result"].ToString(); } if ((row["ImgPath"] != null) && (row["ImgPath"] != DBNull.Value)) { vascularModel.ImgPath = row["ImgPath"].ToString(); } if (((row["CheckDate"] != null) && (row["CheckDate"] != DBNull.Value)) && (row["CheckDate"].ToString() != "")) { vascularModel.CheckDate = new DateTime?(DateTime.Parse(row["CheckDate"].ToString())); } } return(vascularModel); }
/// <summary> /// 修改心血管资料 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(HHCardiovascularModel model) { return(dal.Update(model)); }
/// <summary> /// 新增心血管资料 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(HHCardiovascularModel model) { return(dal.Insert(model)); }