Thêm phần tùy chọn báo cáo tồn quỹ cho cửa hàng shop
- Thứ sáu - 15/09/2017 04:36
- In ra
- Đóng cửa sổ này
Thêm phần tùy chọn báo cáo tồn quỹ cho cửa hàng shop v45
Thêm phần tùy chọn báo cáo tồn quỹ cho cửa hàng shop v45
Phần báo cáo sửa code
FROM TTHUCHI WHERE NGAY BETWEEN @FromDate AND @ToDate
AND (
(CAST(@DLOAIQUYID AS VARCHAR(36)) = '') OR
(CAST(@DLOAIQUYID AS VARCHAR(36)) = '0' AND CHUYENKHOAN = 0) OR
(CAST(@DLOAIQUYID AS VARCHAR(36)) = '2' AND 0 = 1) OR
(CAST(@DLOAIQUYID AS VARCHAR(36)) = '1' AND CHUYENKHOAN = 30 AND (CAST(@DNGANHANGID AS VARCHAR(36)) = '' OR @DNGANHANGID = DTAIKHOANNGANHANGID))
SỬA THÀNH
FROM TTHUCHI WHERE NGAY BETWEEN @FromDate AND @ToDate
AND (CAST(@DCUAHANGID AS VARCHAR(36)) = '' OR DCUAHANGID = @DCUAHANGID)
AND (
(CAST(@DLOAIQUYID AS VARCHAR(36)) = '') OR
(CAST(@DLOAIQUYID AS VARCHAR(36)) = '0' AND CHUYENKHOAN = 0) OR
(CAST(@DLOAIQUYID AS VARCHAR(36)) = '2' AND 0 = 1) OR
(CAST(@DLOAIQUYID AS VARCHAR(36)) = '1' AND CHUYENKHOAN = 30 AND (CAST(@DNGANHANGID AS VARCHAR(36)) = '' OR @DNGANHANGID = DTAIKHOANNGANHANGID))
- Phần code sửa tương tự
string sql = @"SELECT SUM(COALESCE(THU, 0) - COALESCE(CHI, 0))
FROM TTHUCHI WHERE NGAY < @FromDate
AND (CAST(@DCUAHANGID AS VARCHAR(36)) = '' OR DCUAHANGID = @DCUAHANGID)
bổ xung thêm
cmd.Parameters.Add("@DCUAHANGID", FbDbType.VarChar).Value = ConvertTo.String(lstControls["@DCUAHANGID"].EditValue);
Phần báo cáo sửa code
FROM TTHUCHI WHERE NGAY BETWEEN @FromDate AND @ToDate
AND (
(CAST(@DLOAIQUYID AS VARCHAR(36)) = '') OR
(CAST(@DLOAIQUYID AS VARCHAR(36)) = '0' AND CHUYENKHOAN = 0) OR
(CAST(@DLOAIQUYID AS VARCHAR(36)) = '2' AND 0 = 1) OR
(CAST(@DLOAIQUYID AS VARCHAR(36)) = '1' AND CHUYENKHOAN = 30 AND (CAST(@DNGANHANGID AS VARCHAR(36)) = '' OR @DNGANHANGID = DTAIKHOANNGANHANGID))
SỬA THÀNH
FROM TTHUCHI WHERE NGAY BETWEEN @FromDate AND @ToDate
AND (CAST(@DCUAHANGID AS VARCHAR(36)) = '' OR DCUAHANGID = @DCUAHANGID)
AND (
(CAST(@DLOAIQUYID AS VARCHAR(36)) = '') OR
(CAST(@DLOAIQUYID AS VARCHAR(36)) = '0' AND CHUYENKHOAN = 0) OR
(CAST(@DLOAIQUYID AS VARCHAR(36)) = '2' AND 0 = 1) OR
(CAST(@DLOAIQUYID AS VARCHAR(36)) = '1' AND CHUYENKHOAN = 30 AND (CAST(@DNGANHANGID AS VARCHAR(36)) = '' OR @DNGANHANGID = DTAIKHOANNGANHANGID))
- Phần code sửa tương tự
string sql = @"SELECT SUM(COALESCE(THU, 0) - COALESCE(CHI, 0))
FROM TTHUCHI WHERE NGAY < @FromDate
AND (CAST(@DCUAHANGID AS VARCHAR(36)) = '' OR DCUAHANGID = @DCUAHANGID)
bổ xung thêm
cmd.Parameters.Add("@DCUAHANGID", FbDbType.VarChar).Value = ConvertTo.String(lstControls["@DCUAHANGID"].EditValue);