public int Add(HealthHouseBCHAOModel model) { StringBuilder builder = new StringBuilder(); builder.Append(@"INSERT INTO HEALTHHOUSE_ULTRASONICB_RESULT ( ID ,PID ,IDCardNo ,BCHAO ,BCHAOEx ,BCHAOther ,BCHAOtherEx ,ImgPath ) VALUES ( @ID ,@PID ,@IDCardNo ,@BCHAO ,@BCHAOEx ,@BCHAOther ,@BCHAOtherEx ,@ImgPath ) "); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@ID", MySqlDbType.String, 32), new MySqlParameter("@PID", MySqlDbType.String, 32), new MySqlParameter("@IDCardNo", MySqlDbType.String, 50), new MySqlParameter("@BCHAO", MySqlDbType.String, 255), new MySqlParameter("@BCHAOEx", MySqlDbType.String, 100), new MySqlParameter("@BCHAOther", MySqlDbType.Int32), new MySqlParameter("@BCHAOtherEx", MySqlDbType.String, 32), new MySqlParameter("@ImgPath", MySqlDbType.DateTime), }; cmdParms[0].Value = model.ID; cmdParms[1].Value = model.PID; cmdParms[2].Value = model.IDCardNo; cmdParms[3].Value = model.BCHAO; cmdParms[4].Value = model.BCHAOEx; cmdParms[5].Value = model.BCHAOther; cmdParms[6].Value = model.BCHAOtherEx; cmdParms[7].Value = model.ImgPath; object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms); if (single == null) { return(0); } return(Convert.ToInt32(single)); }
public void InitEveryThing() { this.BchaoModel = this.BchaoBLL.GetModel(HealthHouseFactory.ID); if (this.BchaoModel == null) { this.BchaoModel = new HealthHouseBCHAOModel(); this.BchaoModel.IDCardNo = this.Model.IDCardNo; } CSingleItem item1 = new CSingleItem { Name = "B超", Usual = this.radbczc, Unusual = this.radbcyc, Info = this.txtbcyc }; this.BCHAO = item1; this.BCHAO.TransInfo(this.BchaoModel.BCHAO, this.BchaoModel.BCHAOEx); CSingleItem item2 = new CSingleItem { Name = "B超其他", Usual = this.radbcqtzc, Unusual = this.radbcqtyc, Info = this.txtbcqtyc }; this.BCHAOther = item2; this.BCHAOther.TransInfo(this.BchaoModel.BCHAOther, this.BchaoModel.BCHAOtherEx); if (!string.IsNullOrEmpty(this.BchaoModel.ImgPath) && File.Exists(this.BchaoModel.ImgPath)) { //读取文件流 System.IO.FileStream fs = new System.IO.FileStream(this.BchaoModel.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; } else { btnPrint.Visible = false; } this.EveryThingIsOk = true; }
public bool Update(HealthHouseBCHAOModel model) { StringBuilder builder = new StringBuilder(); builder.Append(@"UPDATE HEALTHHOUSE_ULTRASONICB_RESULT SET PID = @PID ,IDCardNo = @IDCardNo ,BCHAO = @BCHAO ,BCHAOEx = @BCHAOEx ,BCHAOther = @BCHAOther ,BCHAOtherEx = @BCHAOtherEx ,ImgPath = @ImgPath WHERE ID = @ID "); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@ID", MySqlDbType.Int32), new MySqlParameter("@PID", MySqlDbType.String, 32), new MySqlParameter("@IDCardNo", MySqlDbType.String, 50), new MySqlParameter("@BCHAO", MySqlDbType.String, 255), new MySqlParameter("@BCHAOEx", MySqlDbType.String, 100), new MySqlParameter("@BCHAOther", MySqlDbType.Int32), new MySqlParameter("@BCHAOtherEx", MySqlDbType.String, 32), new MySqlParameter("@ImgPath", MySqlDbType.String), }; cmdParms[0].Value = model.ID; cmdParms[1].Value = model.PID; cmdParms[2].Value = model.IDCardNo; cmdParms[3].Value = model.BCHAO; cmdParms[4].Value = model.BCHAOEx; cmdParms[5].Value = model.BCHAOther; cmdParms[6].Value = model.BCHAOtherEx; cmdParms[7].Value = model.ImgPath; return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public bool Update(HealthHouseBCHAOModel model) { return(this.dal.Update(model)); }
public int Add(HealthHouseBCHAOModel model) { return(this.dal.Add(model)); }