public int Add(EcgDataModel model) { StringBuilder builder = new StringBuilder(); builder.Append("INSERT INTO ARCHIVE_ECG("); builder.Append("MID,IDCardNo,Name,Conclusion,CreateTime)"); builder.Append(" VALUES ("); builder.Append("@MID,@IDCardNo,@Name,@Conclusion,@CreateTime)"); builder.Append(";SELECT @@IDENTITY"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@MID", MySqlDbType.String), new MySqlParameter("@IDCardNo", MySqlDbType.String), new MySqlParameter("@Name", MySqlDbType.String), new MySqlParameter("@Conclusion", MySqlDbType.String), new MySqlParameter("@CreateTime", MySqlDbType.Date) }; cmdParms[0].Value = model.MID; cmdParms[1].Value = model.IDCard; cmdParms[2].Value = model.Name; cmdParms[3].Value = model.Conclusion; cmdParms[4].Value = model.CreateTime; object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms); if (single == null) { return(0); } return(Convert.ToInt32(single)); }
public EcgDataModel DataRowToModel(DataRow row) { EcgDataModel ecg_data = new EcgDataModel(); if (row != null) { if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != "")) { ecg_data.ID = int.Parse(row["ID"].ToString()); } if ((row["RecordID"] != null) && (row["RecordID"] != DBNull.Value)) { ecg_data.RecordID = row["RecordID"].ToString(); } if ((row["CustomerID"] != null) && (row["CustomerID"] != DBNull.Value)) { ecg_data.CustomerID = row["CustomerID"].ToString(); } if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value)) { ecg_data.IDCardNo = row["IDCardNo"].ToString(); } if (((row["ECG"] != null) && (row["ECG"] != DBNull.Value)) && (row["ECG"].ToString() != "")) { ecg_data.ECG = (byte[])row["ECG"]; } } return(ecg_data); }
public bool Update(EcgDataModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update ECG_DATA set "); builder.Append("RecordID=@RecordID,"); builder.Append("CustomerID=@CustomerID,"); builder.Append("IDCardNo=@IDCardNo,"); builder.Append("ECG=@ECG"); builder.Append(" where ID=@ID"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@RecordID", MySqlDbType.String, 17), new MySqlParameter("@CustomerID", MySqlDbType.String, 32), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21), new MySqlParameter("@ECG", MySqlDbType.Binary), new MySqlParameter("@ID", MySqlDbType.Int32, 8) }; cmdParms[0].Value = model.RecordID; cmdParms[1].Value = model.CustomerID; cmdParms[2].Value = model.IDCardNo; cmdParms[3].Value = model.ECG; cmdParms[4].Value = model.ID; return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public int Add(EcgDataModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into ECG_DATA("); builder.Append("RecordID,CustomerID,IDCardNo,ECG)"); builder.Append(" values ("); builder.Append("@RecordID,@CustomerID,@IDCardNo,@ECG)"); builder.Append(";select @@IDENTITY"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@RecordID", MySqlDbType.String, 17), new MySqlParameter("@CustomerID", MySqlDbType.String, 32), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21), new MySqlParameter("@ECG", MySqlDbType.Binary) }; cmdParms[0].Value = model.RecordID; cmdParms[1].Value = model.CustomerID; cmdParms[2].Value = model.IDCardNo; cmdParms[3].Value = model.ECG; object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms); if (single == null) { return(0); } return(Convert.ToInt32(single)); }
public void Delete(EcgDataModel model) { StringBuilder builder = new StringBuilder(); builder.Append("DELETE FROM ARCHIVE_ECG "); builder.Append(" WHERE MID=@MID AND IDCardNo=@IDCardNo"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@MID", model.MID), new MySqlParameter("@IDCardNo", model.IDCard) }; MySQLHelper.ExecuteSql(builder.ToString(), cmdParms); }
public List <EcgDataModel> DataTableToList(DataTable dt) { List <EcgDataModel> list = new List <EcgDataModel>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { EcgDataModel item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public void Delete(EcgDataModel model) { dal.Delete(model); }
public int Add(EcgDataModel model) { return(dal.Add(model)); }
public bool Update(EcgDataModel model) { return(this.dal.Update(model)); }