/// <summary> /// 修改肺功能资料 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(HHLungModel model) { StringBuilder builder = new StringBuilder(); builder.Append(@"UPDATE HEALTHHOUSE_LUNG_FUNCTION 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.LungModel = LungBLL.GetData(this.Model.IDCardNo, HealthHouseFactory.ID); if (this.LungModel == null) { this.LungModel = new HHLungModel(); this.LungModel.IDCardNo = this.Model.IDCardNo; } CSingleItem item = new CSingleItem { Name = "肺功能", Usual = this.rdLung, Unusual = this.rdLungEx, Info = this.txtLResultEx }; this.Lung = item; this.Lung.TransInfo(this.LungModel.Result, this.LungModel.ResultEx); if (!string.IsNullOrEmpty(this.LungModel.ImgPath) && File.Exists(this.LungModel.ImgPath)) { //读取文件流 System.IO.FileStream fs = new System.IO.FileStream(this.LungModel.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)); //Image img = System.Drawing.Image.FromFile(this.LungModel.ImgPath); //Image bmp = new System.Drawing.Bitmap(img); //img.Dispose(); pboxBShow.Image = image; } else { btnPrint.Visible = false; } this.EveryThingIsOk = true; }
/// <summary> /// 新增肺功能资料 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(HHLungModel model) { StringBuilder builder = new StringBuilder(); builder.Append(@"INSERT INTO HEALTHHOUSE_LUNG_FUNCTION ( 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 HHLungModel DataRowToModel(DataRow row) { HHLungModel LungModel = new HHLungModel(); if (row != null) { if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != "")) { LungModel.ID = int.Parse(row["ID"].ToString()); } if (((row["PID"] != null) && (row["PID"] != DBNull.Value)) && (row["PID"].ToString() != "")) { LungModel.PID = int.Parse(row["PID"].ToString()); } if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value)) { LungModel.IDCardNo = row["IDCardNo"].ToString(); } if ((row["ResultEx"] != null) && (row["ResultEx"] != DBNull.Value)) { LungModel.ResultEx = row["ResultEx"].ToString(); } if ((row["Result"] != null) && (row["Result"] != DBNull.Value)) { LungModel.Result = row["Result"].ToString(); } if ((row["ImgPath"] != null) && (row["ImgPath"] != DBNull.Value)) { LungModel.ImgPath = row["ImgPath"].ToString(); } if (((row["CheckDate"] != null) && (row["CheckDate"] != DBNull.Value)) && (row["CheckDate"].ToString() != "")) { LungModel.CheckDate = new DateTime?(DateTime.Parse(row["CheckDate"].ToString())); } } return(LungModel); }
/// <summary> /// 修改肺功能资料 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(HHLungModel model) { return(dal.Update(model)); }
/// <summary> /// 新增肺功能资料 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(HHLungModel model) { return(dal.Insert(model)); }