public Boolean insertSalary(enSalary enSalary)
{
try
{
str = "INSERT INTO salary (";
str += "personalID,";
str += "bank,";
str += "accountNumber,";
str += "calculateType,";
str += "salary,";
str += "shiftSalary,";
str += "calTax,";
str += "calSocialTax,";
str += "lateDeduct,";
str += "leaveDeduct";
str += ")VALUES(";
str += "@personalID,";
str += "@bank,";
str += "@accountNumber,";
str += "@calculateType,";
str += "@salary,";
str += "@shiftSalary,";
str += "@calTax,";
str += "@calSocialTax,";
str += "@lateDeduct,";
str += "@leaveDeduct";
str += ");";
Dbcmd = db.GetSqlStringCommand(str);
db.AddInParameter(Dbcmd, "@personalID", DbType.Int32, enSalary.personalID);
db.AddInParameter(Dbcmd, "@bank", DbType.String, enSalary.bank);
db.AddInParameter(Dbcmd, "@accountNumber", DbType.String, enSalary.accountNumber);
db.AddInParameter(Dbcmd, "@calculateType", DbType.Int32, enSalary.calculateType);
db.AddInParameter(Dbcmd, "@salary", DbType.Double, enSalary.salary);
db.AddInParameter(Dbcmd, "@shiftSalary", DbType.Double, enSalary.shiftSalary);
db.AddInParameter(Dbcmd, "@calTax", DbType.String, enSalary.calTax);
db.AddInParameter(Dbcmd, "@calSocialTax", DbType.String, enSalary.calSocialTax);
db.AddInParameter(Dbcmd, "@lateDeduct", DbType.Int32, enSalary.lateDeduct);
db.AddInParameter(Dbcmd, "@leaveDeduct", DbType.Int32, enSalary.leaveDeduct);
db.ExecuteNonQuery(Dbcmd);
return true;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public Boolean updateSalary(enSalary enSalary)
{
try
{
str = "UPDATE salary SET ";
str += "personalID=@personalID,";
str += "bank=@bank,";
str += "accountNumber=@accountNumber,";
str += "calculateType=@calculateType,";
str += "salary=@salary,";
str += "shiftSalary=@shiftSalary,";
str += "calTax=@calTax,";
str += "calSocialTax=@calSocialTax,";
str += "lateDeduct=@lateDeduct,";
str += "leaveDeduct=@leaveDeduct";
str += " WHERE salaryID=@salaryID;";
Dbcmd = db.GetSqlStringCommand(str);
db.AddInParameter(Dbcmd, "@personalID", DbType.Int32, enSalary.personalID);
db.AddInParameter(Dbcmd, "@bank", DbType.String, enSalary.bank);
db.AddInParameter(Dbcmd, "@accountNumber", DbType.String, enSalary.accountNumber);
db.AddInParameter(Dbcmd, "@calculateType", DbType.Int32, enSalary.calculateType);
db.AddInParameter(Dbcmd, "@salary", DbType.Double, enSalary.salary);
db.AddInParameter(Dbcmd, "@shiftSalary", DbType.Double, enSalary.shiftSalary);
db.AddInParameter(Dbcmd, "@calTax", DbType.String, enSalary.calTax);
db.AddInParameter(Dbcmd, "@calSocialTax", DbType.String, enSalary.calSocialTax);
db.AddInParameter(Dbcmd, "@lateDeduct", DbType.Int32, enSalary.lateDeduct);
db.AddInParameter(Dbcmd, "@leaveDeduct", DbType.Int32, enSalary.leaveDeduct);
db.AddInParameter(Dbcmd, "@salaryID", DbType.Int32, enSalary.salaryID);
db.ExecuteNonQuery(Dbcmd);
return true;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}