Ejemplo n.º 1
0
 public bool ThemDong(DOLuong luong)
 {
     bool Kq = false;
     try
     {
         DatabaseFB db = HelpDB.getDatabase();
         string InsertSql = "insert into BANG_LUONG(ID,NV_ID,THANG_NAM,TONG_THU_NHAP,TAM_UNG,IS_CHOT,DA_THANH_TOAN,TT_CON_LAI) values(@ID,@NV_ID,@THANG_NAM,@TONG_THU_NHAP,@TAM_UNG,'N',0,@TT_CON_LAI)";
         DbCommand insert = db.GetSQLStringCommand(InsertSql);
         db.AddInParameter(insert, "@ID", DbType.Int32, luong.ID);
         db.AddInParameter(insert, "@NV_ID", DbType.Int32, luong.NV_ID);
         db.AddInParameter(insert, "@THANG_NAM", DbType.String, luong.THANG_NAM);
         db.AddInParameter(insert, "@TONG_THU_NHAP", DbType.Decimal, luong.TONG_THU_NHAP);
         db.AddInParameter(insert, "@TAM_UNG", DbType.Decimal, luong.TAM_UNG);
         db.AddInParameter(insert, "@TT_CON_LAI", DbType.Decimal, luong.TONG_THU_NHAP-luong.TAM_UNG-0);
         if (db.ExecuteNonQuery(insert) > 0)
             Kq = true;
     }
     catch (Exception ex)
     {
         PLException.AddException(ex);
     }
     return Kq;
 }
Ejemplo n.º 2
0
 public bool SuaDong(DOLuong luong)
 {
     DatabaseFB db = HelpDB.getDatabase();
     string cautruyvan = @"update BANG_LUONG set TONG_THU_NHAP=@TONG_THU_NHAP,TAM_UNG=@TAM_UNG,TT_CON_LAI = @TT_CON_LAI - DA_THANH_TOAN WHERE ID=@ID ";
     DbCommand update = db.GetSQLStringCommand(cautruyvan);
     db.AddInParameter(update, "@ID", DbType.Int32, luong.ID);
     db.AddInParameter(update, "@TONG_THU_NHAP", DbType.Decimal, luong.TONG_THU_NHAP);
     db.AddInParameter(update, "@TAM_UNG", DbType.Decimal, luong.TAM_UNG);
     db.AddInParameter(update, "@TT_CON_LAI", DbType.Decimal, luong.TONG_THU_NHAP-luong.TAM_UNG);
     if (db.ExecuteNonQuery(update) > 0)
         return true;
     return false;
 }