public static bool capNhatBaoCao(DTO.DTO_BaoCaoDoanhSo bc) { String sql = String.Format(@"UPDATE BAO_CAO_DOANH_SO SET THANG='{1}', TONG_DOANH_THU={2} WHERE MA_BAO_CAO='{0}'", bc.MA_BAO_CAO, bc.THANG, bc.TONG_DOANH_THU); if (DatabaseHelper.ExcuteSql(sql) > 0) { return(true); } return(false); }
private void UpdateBC() { string ma = lbMaBaoCao.Text.Trim(); int Tong = int.Parse(lbTongDoanhthu.Text.ToString()); DTO.DTO_BaoCaoDoanhSo s = new DTO.DTO_BaoCaoDoanhSo(); s.MA_BAO_CAO = ma; s.THANG = numNam.Value.ToString() + "-" + numThang.Value.ToString(); s.TONG_DOANH_THU = Tong; BUS.BUS_BaoCaoThang.capNhatBaoCao(s); CapNhatChiTiet(); }
public static bool themBaoCao(DTO.DTO_BaoCaoDoanhSo bc) { String sql = String.Format(@"INSERT INTO BAO_CAO_DOANH_SO (MA_BAO_CAO, THANG, TONG_DOANH_THU) VALUES ('{0}','{1}',{2})", bc.MA_BAO_CAO, bc.THANG, bc.TONG_DOANH_THU); Console.WriteLine(sql); if (DatabaseHelper.ExcuteSql(sql) > 0) { return(true); } return(false); }
public static bool capNhatBaoCao(DTO.DTO_BaoCaoDoanhSo s) { return(DAO.DAO_BaoCaoDoanhSo.capNhatBaoCao(s)); }
public static bool themBaoCao(DTO.DTO_BaoCaoDoanhSo s) { return(DAO.DAO_BaoCaoDoanhSo.themBaoCao(s)); }