public bool Update(HealthHouseEcgModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update HEALTHHOUSE_ECG_RESULT set ");
builder.Append("PID=@PID,");
builder.Append("MID=@MID,");
builder.Append("IDCardNo=@IDCardNo,");
builder.Append("Name=@Name,");
builder.Append("Conclusion=@Conclusion,");
builder.Append("CreateTime=@CreateTime,");
builder.Append("ECG=@ECG,");
builder.Append("ECGEx=@ECGEx,");
builder.Append("ImgPath=@ImgPath ");
builder.Append("where ID=@ID");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@PID", MySqlDbType.Int32, 11),
new MySqlParameter("@MID", MySqlDbType.String, 20),
new MySqlParameter("@IDCardNo", MySqlDbType.String, 18),
new MySqlParameter("@Name", MySqlDbType.String, 100),
new MySqlParameter("@Conclusion", MySqlDbType.String, 9999),
new MySqlParameter("@CreateTime", MySqlDbType.Date),
new MySqlParameter("@ECG", MySqlDbType.String, 1),
new MySqlParameter("@ECGEx", MySqlDbType.String, 100),
new MySqlParameter("@ImgPath", MySqlDbType.String, 100),
new MySqlParameter("@ID", MySqlDbType.Int32, 11),
};
cmdParms[0].Value = model.PID;
cmdParms[1].Value = model.MID;
cmdParms[2].Value = model.IDCardNo;
cmdParms[3].Value = model.Name;
cmdParms[4].Value = model.Conclusion;
cmdParms[5].Value = model.CreateTime;
cmdParms[6].Value = model.ECG;
cmdParms[7].Value = model.ECGEx;
cmdParms[8].Value = model.ImgPath;
cmdParms[9].Value = model.ID;
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public void InitEveryThing()
{
this.EcgModel = this.EcgBLL.GetModel(HealthHouseFactory.ID);
if (this.EcgModel == null)
{
this.EcgModel = new HealthHouseEcgModel();
this.EcgModel.IDCardNo = this.Model.IDCardNo;
}
CSingleItem item = new CSingleItem
{
Name = "心电",
Usual = this.radXDZC,
Unusual = this.radXDYC,
Info = this.txtXDYC
};
this.xindian = item;
this.xindian.TransInfo(this.EcgModel.ECG, this.EcgModel.ECGEx);
if (!string.IsNullOrEmpty(this.EcgModel.ImgPath) && File.Exists(this.EcgModel.ImgPath))
{
//读取文件流
System.IO.FileStream fs = new System.IO.FileStream(this.EcgModel.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 int Add(HealthHouseEcgModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into HEALTHHOUSE_ECG_RESULT(");
builder.Append("PID,MID,IDCardNo,Name,Conclusion,CreateTime,ECG,ECGEx,ImgPath) ");
builder.Append("values( ");
builder.Append("@PID,@MID,@IDCardNo,@Name,@Conclusion,@CreateTime,@ECG,@ECGEx,@ImgPath) ");
builder.Append(";select @@IDENTITY");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@PID", MySqlDbType.Int32, 11),
new MySqlParameter("@MID", MySqlDbType.String, 20),
new MySqlParameter("@IDCardNo", MySqlDbType.String, 18),
new MySqlParameter("@Name", MySqlDbType.String, 100),
new MySqlParameter("@Conclusion", MySqlDbType.String, 9999),
new MySqlParameter("@CreateTime", MySqlDbType.Date),
new MySqlParameter("@ECG", MySqlDbType.String, 1),
new MySqlParameter("@ECGEx", MySqlDbType.String, 100),
new MySqlParameter("@ImgPath", MySqlDbType.String, 100)
};
cmdParms[0].Value = model.PID;
cmdParms[1].Value = model.MID;
cmdParms[2].Value = model.IDCardNo;
cmdParms[3].Value = model.Name;
cmdParms[4].Value = model.Conclusion;
cmdParms[5].Value = model.CreateTime;
cmdParms[6].Value = model.ECG;
cmdParms[7].Value = model.ECGEx;
cmdParms[8].Value = model.ImgPath;
object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
public bool Update(HealthHouseEcgModel model)
{
return(this.dal.Update(model));
}
public int Add(HealthHouseEcgModel model)
{
return(this.dal.Add(model));
}
