public bool UpdateServer(RecordsHospitalHistoryModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update ARCHIVE_HOSPITALHISTORY set "); builder.Append("PhysicalID=@PhysicalID,"); builder.Append("IDCardNo=@IDCardNo,"); builder.Append("InHospitalDate=@InHospitalDate,"); builder.Append("Reason=@Reason,"); builder.Append("IllcaseNum=@IllcaseNum,"); builder.Append("HospitalName=@HospitalName,"); 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("@InHospitalDate", MySqlDbType.Date), new MySqlParameter("@Reason", MySqlDbType.String, 100), new MySqlParameter("@IllcaseNum", MySqlDbType.String, 50), new MySqlParameter("@HospitalName", 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.InHospitalDate; cmdParms[3].Value = model.Reason; cmdParms[4].Value = model.IllcaseNum; cmdParms[5].Value = model.HospitalName; cmdParms[6].Value = model.OutHospitalDate; //cmdParms[7].Value = model.ID; return(MySQLHelper.ExecuteSqlServer(builder.ToString(), cmdParms) > 0); }
public int AddServer(RecordsHospitalHistoryModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into ARCHIVE_HOSPITALHISTORY("); builder.Append("PhysicalID,IDCardNo,InHospitalDate,Reason,IllcaseNum,HospitalName,OutHospitalDate,OutKey)"); builder.Append(" values ("); builder.Append("@PhysicalID,@IDCardNo,@InHospitalDate,@Reason,@IllcaseNum,@HospitalName,@OutHospitalDate,@OutKey)"); builder.Append(";select @@IDENTITY"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@PhysicalID", MySqlDbType.String, 8), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21), new MySqlParameter("@InHospitalDate", MySqlDbType.Date), new MySqlParameter("@Reason", MySqlDbType.String, 100), new MySqlParameter("@IllcaseNum", MySqlDbType.String, 50), new MySqlParameter("@HospitalName", 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.InHospitalDate; cmdParms[3].Value = model.Reason; cmdParms[4].Value = model.IllcaseNum; cmdParms[5].Value = model.HospitalName; 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)); }