public bool UpdateServer(RecordsFamilyBedHistoryModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update ARCHIVE_FAMILYBEDHISTORY set "); builder.Append("PhysicalID=@PhysicalID,"); builder.Append("IDCardNo=@IDCardNo,"); builder.Append("HospitalName=@HospitalName,"); builder.Append("InHospitalDate=@InHospitalDate,"); builder.Append("IllcaseNums=@IllcaseNums,"); builder.Append("Reasons=@Reasons,"); builder.Append("OutHospitalDate=@OutHospitalDate"); builder.Append(" where IDCardNo=@IDCardNo"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@PhysicalID", MySqlDbType.String, 8), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21), new MySqlParameter("@HospitalName", MySqlDbType.String, 100), new MySqlParameter("@InHospitalDate", MySqlDbType.Date), new MySqlParameter("@IllcaseNums", MySqlDbType.String, 50), new MySqlParameter("@Reasons", MySqlDbType.String, 100), new MySqlParameter("@OutHospitalDate", MySqlDbType.Date), //new MySqlParameter("@ID", MySqlDbType.Int32, 8) }; cmdParms[0].Value = model.PhysicalID; cmdParms[1].Value = model.IDCardNo; cmdParms[2].Value = model.HospitalName; cmdParms[3].Value = model.InHospitalDate; cmdParms[4].Value = model.IllcaseNums; cmdParms[5].Value = model.Reasons; cmdParms[6].Value = model.OutHospitalDate; //cmdParms[7].Value = model.ID; return(MySQLHelper.ExecuteSqlServer(builder.ToString(), cmdParms) > 0); }
public List <RecordsFamilyBedHistoryModel> DataTableToList(DataTable dt) { List <RecordsFamilyBedHistoryModel> list = new List <RecordsFamilyBedHistoryModel>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { RecordsFamilyBedHistoryModel item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public bool Add(RecordsFamilyBedHistoryModel model) { StringBuilder builder = new StringBuilder(); builder.Append("INSERT INTO ARCHIVE_FAMILYBEDHISTORY("); builder.Append("PhysicalID,IDCardNo,HospitalName,InHospitalDate,IllcaseNums,Reasons,OutHospitalDate,OutKey)"); builder.Append(" VALUES ("); builder.Append("@PhysicalID,@IDCardNo,@HospitalName,@InHospitalDate,@IllcaseNums,@Reasons,@OutHospitalDate,@OutKey)"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@PhysicalID", MySqlDbType.String, 8), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21), new MySqlParameter("@HospitalName", MySqlDbType.String, 100), new MySqlParameter("@InHospitalDate", MySqlDbType.Date), new MySqlParameter("@IllcaseNums", MySqlDbType.String, 50), new MySqlParameter("@Reasons", MySqlDbType.String, 100), new MySqlParameter("@OutHospitalDate", MySqlDbType.Date), new MySqlParameter("@OutKey", MySqlDbType.Int32, 11) }; cmdParms[0].Value = model.PhysicalID; cmdParms[1].Value = model.IDCardNo; cmdParms[2].Value = model.HospitalName; cmdParms[3].Value = model.InHospitalDate; cmdParms[4].Value = model.IllcaseNums; cmdParms[5].Value = model.Reasons; cmdParms[6].Value = model.OutHospitalDate; cmdParms[7].Value = model.OutKey; int rows = MySQLHelper.ExecuteSql(builder.ToString(), cmdParms); if (rows > 0) { return(true); } else { return(false); } }
public RecordsFamilyBedHistoryModel DataRowToModel(DataRow row) { RecordsFamilyBedHistoryModel recordsFamilyBedHistoryModel = new RecordsFamilyBedHistoryModel(); if (row != null) { if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != "")) { recordsFamilyBedHistoryModel.ID = int.Parse(row["ID"].ToString()); } if ((row["PhysicalID"] != null) && (row["PhysicalID"] != DBNull.Value)) { recordsFamilyBedHistoryModel.PhysicalID = row["PhysicalID"].ToString(); } if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value)) { recordsFamilyBedHistoryModel.IDCardNo = row["IDCardNo"].ToString(); } if ((row["HospitalName"] != null) && (row["HospitalName"] != DBNull.Value)) { recordsFamilyBedHistoryModel.HospitalName = row["HospitalName"].ToString(); } if (((row["InHospitalDate"] != null) && (row["InHospitalDate"] != DBNull.Value)) && (row["InHospitalDate"].ToString() != "")) { recordsFamilyBedHistoryModel.InHospitalDate = new DateTime?(DateTime.Parse(row["InHospitalDate"].ToString())); } if ((row["IllcaseNums"] != null) && (row["IllcaseNums"] != DBNull.Value)) { recordsFamilyBedHistoryModel.IllcaseNums = row["IllcaseNums"].ToString(); } if ((row["Reasons"] != null) && (row["Reasons"] != DBNull.Value)) { recordsFamilyBedHistoryModel.Reasons = row["Reasons"].ToString(); } if (((row["OutHospitalDate"] != null) && (row["OutHospitalDate"] != DBNull.Value)) && (row["OutHospitalDate"].ToString() != "")) { recordsFamilyBedHistoryModel.OutHospitalDate = new DateTime?(DateTime.Parse(row["OutHospitalDate"].ToString())); } } return(recordsFamilyBedHistoryModel); }
public void UpdateFam(string idcard) { if (this.famSouce == null) { RecordsFamilyBedHistoryModel recordsFamilyBedHistoryModel = new RecordsFamilyBedHistoryModel { ModelState = RecordsStateModel.NoValue }; this.famSouce = recordsFamilyBedHistoryModel; } this.famSouce.IDCardNo = idcard; if (string.IsNullOrEmpty(this.tbOrgrationName.Text.Trim())) { if (this.famSouce.ModelState == RecordsStateModel.Unchanged) { this.famSouce.ModelState = RecordsStateModel.DeleteInDB; } } else { this.famSouce.Reasons = this.tbReason.Text; this.famSouce.IllcaseNums = this.tbNo.Text; this.famSouce.HospitalName = this.tbOrgrationName.Text; this.famSouce.InHospitalDate = new DateTime?(this.dtpSt.Value.Date); this.famSouce.OutHospitalDate = new DateTime?(this.dtpEd.Value.Date); if (this.famSouce.ModelState == RecordsStateModel.NoValue) { this.famSouce.ModelState = RecordsStateModel.AddToDB; } else { this.famSouce.ModelState = RecordsStateModel.UpdateInDB; } } }
public int AddServer(RecordsFamilyBedHistoryModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into ARCHIVE_FAMILYBEDHISTORY("); builder.Append("PhysicalID,IDCardNo,HospitalName,InHospitalDate,IllcaseNums,Reasons,OutHospitalDate,OutKey)"); builder.Append(" values ("); builder.Append("@PhysicalID,@IDCardNo,@HospitalName,@InHospitalDate,@IllcaseNums,@Reasons,@OutHospitalDate,@OutKey)"); builder.Append(";select @@IDENTITY"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@PhysicalID", MySqlDbType.String, 8), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21), new MySqlParameter("@HospitalName", MySqlDbType.String, 100), new MySqlParameter("@InHospitalDate", MySqlDbType.Date), new MySqlParameter("@IllcaseNums", MySqlDbType.String, 50), new MySqlParameter("@Reasons", MySqlDbType.String, 100), new MySqlParameter("@OutHospitalDate", MySqlDbType.Date), new MySqlParameter("@OutKey", MySqlDbType.Int32, 4) }; cmdParms[0].Value = model.PhysicalID; cmdParms[1].Value = model.IDCardNo; cmdParms[2].Value = model.HospitalName; cmdParms[3].Value = model.InHospitalDate; cmdParms[4].Value = model.IllcaseNums; cmdParms[5].Value = model.Reasons; cmdParms[6].Value = model.OutHospitalDate; cmdParms[7].Value = model.OutKey; object single = MySQLHelper.GetSingleServer(builder.ToString(), cmdParms); if (single == null) { return(0); } return(Convert.ToInt32(single)); }
public bool Add(RecordsFamilyBedHistoryModel model) { return(this.dal.Add(model)); }
public int AddServer(RecordsFamilyBedHistoryModel model) { return(this.dal.AddServer(model)); }
public bool UpdateServer(RecordsFamilyBedHistoryModel model) { return(this.dal.UpdateServer(model)); }