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