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