public int MakeSureGet(int salaryID)
{
string sql = "update salary set StateID=(select StateID from state where StateName='已确收') where SalaID=" + salaryID;
conn makesuer = new staff();
return(makesuer.ExecuteSql(sql));
}
public int ErrorMoneyReport(int salaryID, float Money)
{
string sql = "update salary set ErrorMoney=?Money where salaID=?salaryID";
MySqlParameter[] insertpar =
{
new MySqlParameter("?Money", MySqlDbType.Float),
new MySqlParameter("?salaryID", MySqlDbType.Int16)
};
conn reportErrorMoney = new staff();
return(reportErrorMoney.ExecuteSql(sql, insertpar));
}