Ejemplo n.º 1
0
    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));
    }
Ejemplo n.º 2
0
    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));
    }