public Boolean insertSocialTax(enSocialTax enSocialTax)
{
try
{
str = "INSERT INTO socialTax (";
str += "personalID,";
str += "socialTaxIDCard,";
str += "hospitalCode,";
str += "hospital";
str += ")VALUES(";
str += "@personalID,";
str += "@socialTaxIDCard,";
str += "@hospitalCode,";
str += "@hospital";
str += ");";
Dbcmd = db.GetSqlStringCommand(str);
db.AddInParameter(Dbcmd, "@personalID", DbType.Int32, enSocialTax.personalID);
db.AddInParameter(Dbcmd, "@socialTaxIDCard", DbType.String, enSocialTax.socialTaxIDCard);
db.AddInParameter(Dbcmd, "@hospitalCode", DbType.String, enSocialTax.hospitalCode);
db.AddInParameter(Dbcmd, "@hospital", DbType.String, enSocialTax.hospital);
db.ExecuteNonQuery(Dbcmd);
return true;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public Boolean updateSocialTax(enSocialTax enSocialTax)
{
try
{
str = "UPDATE socialTax SET ";
str += "personalID=@personalID,";
str += "socialTaxIDCard=@socialTaxIDCard,";
str += "hospitalCode=@hospitalCode,";
str += "hospital=@hospital";
str += " WHERE socialTaxID=@socialTaxID;";
Dbcmd = db.GetSqlStringCommand(str);
db.AddInParameter(Dbcmd, "@personalID", DbType.Int32, enSocialTax.personalID);
db.AddInParameter(Dbcmd, "@socialTaxIDCard", DbType.String, enSocialTax.socialTaxIDCard);
db.AddInParameter(Dbcmd, "@hospitalCode", DbType.String, enSocialTax.hospitalCode);
db.AddInParameter(Dbcmd, "@hospital", DbType.String, enSocialTax.hospital);
db.AddInParameter(Dbcmd, "@socialTaxID", DbType.Int32, enSocialTax.socialTaxID);
db.ExecuteNonQuery(Dbcmd);
return true;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}