/// <summary> /// Lấy giá sản phẩm cuốn /// </summary> /// <param name="sizeId">ID của bảng KHỔ SẢN PHẨM CUỐN</param> /// <param name="quantityId">ID của bảng SỐ LƯỢNG CUỐN</param> /// <param name="coverId">ID của bảng BÌA</param> /// <param name="bookStyleId">ID của bảng ĐÓNG CUỐN</param> /// <param name="blockId">ID của bảng RUỘT</param> /// <param name="paperId">ID của bảng GIẤY IN CUỐN</param> /// <param name="shipTimeId">ID của bảng THỜI GIAN GIAO</param> /// <returns></returns> public decimal?GetPriceOfBookProduct(string sizeId, string quantityId, string coverId, string bookStyleId, string blockId, string paperId, string shipTimeId) { /** * Kiểm tra chứng thực */ if (!AuthenticateViaAuthorizationHeader()) { return(null); } /** * Tính giá */ var parameters = new Dictionary <string, object>(); parameters.Add("ID_KHO_SAN_PHAM", sizeId); parameters.Add("ID_SO_LUONG_CUON", quantityId); parameters.Add("ID_BIA", coverId); parameters.Add("ID_DONG_CUON", bookStyleId); parameters.Add("ID_RUOT", blockId); parameters.Add("ID_GIAY_IN_RUOT", paperId); parameters.Add("ID_THOI_GIAN_GIAO", shipTimeId); //--Dz- lay SKU SP var sku_SanPham = RestDbExecutor.ExecuteScalar("SELECT SKU_SAN_PHAM FROM BIA_SPC WHERE ID = @ID_BIA", parameters); //--dz-end var GIA_BIA_RAW = RestDbExecutor.ExecuteScalar("SELECT DON_GIA FROM GIA_BIA_SPC WHERE ID_KHO_SAN_PHAM = @ID_KHO_SAN_PHAM AND ID_SO_LUONG_CUON = @ID_SO_LUONG_CUON AND ID_BIA = @ID_BIA", parameters); var GIA_DONG_CUON_RAW = RestDbExecutor.ExecuteScalar("SELECT DON_GIA FROM GIA_DONG_CUON_SPC WHERE ID_KHO_SAN_PHAM = @ID_KHO_SAN_PHAM AND ID_SO_LUONG_CUON = @ID_SO_LUONG_CUON AND ID_DONG_CUON = @ID_DONG_CUON", parameters); var GIA_IN_RUOT_RAW = RestDbExecutor.ExecuteScalar("SELECT DON_GIA FROM GIA_IN_RUOT_SPC WHERE ID_KHO_SAN_PHAM = @ID_KHO_SAN_PHAM AND ID_SO_LUONG_CUON = @ID_SO_LUONG_CUON AND ID_RUOT = @ID_RUOT", parameters); var GIAY_GIAY_RUOT_RAW = RestDbExecutor.ExecuteScalar("SELECT DON_GIA FROM GIA_GIAY_RUOT_SPC WHERE ID_KHO_SAN_PHAM = @ID_KHO_SAN_PHAM AND ID_SO_LUONG_CUON = @ID_SO_LUONG_CUON AND ID_RUOT = @ID_RUOT AND ID_GIAY_IN_RUOT = @ID_GIAY_IN_RUOT", parameters); var PHAN_TRAM_GIA_RAW = RestDbExecutor.ExecuteScalar("SELECT PHAN_TRAM_GIA FROM GIA_THOI_GIAN_GIAO_SPC WHERE ID_KHO_SAN_PHAM = @ID_KHO_SAN_PHAM AND ID_SO_LUONG_CUON = @ID_SO_LUONG_CUON AND ID_THOI_GIAN_GIAO = @ID_THOI_GIAN_GIAO", parameters); var GIA_BIA = GIA_BIA_RAW != DBNull.Value ? Convert.ToDecimal(GIA_BIA_RAW) : 0; var GIA_DONG_CUON = GIA_IN_RUOT_RAW != DBNull.Value ? Convert.ToDecimal(GIA_DONG_CUON_RAW) : 0; var GIA_IN_RUOT = GIA_IN_RUOT_RAW != DBNull.Value ? Convert.ToDecimal(GIA_IN_RUOT_RAW) : 0; var GIAY_GIAY_RUOT = GIAY_GIAY_RUOT_RAW != DBNull.Value ? Convert.ToDecimal(GIAY_GIAY_RUOT_RAW) : 0; var PHAN_TRAM_GIA = PHAN_TRAM_GIA_RAW != DBNull.Value ? Convert.ToDecimal(PHAN_TRAM_GIA_RAW) : 0; //-Dzung-Tinh toan gia. chỉ sửa đoạn này để lồng vô var cauHinhInCuon = new CauHinhTinhGiaCuon((string)sku_SanPham, int.Parse(sizeId), int.Parse(quantityId), int.Parse(blockId), int.Parse(paperId)); var giaInGiayCanMang = TinhToanCuon.GiaIn(cauHinhInCuon) + TinhToanCuon.GiaGiayRuot(cauHinhInCuon) + TinhToanCuon.GiaCanMang(cauHinhInCuon); //--Dzung--end //var GIA_TONG1 = GIA_BIA + GIA_DONG_CUON + GIA_IN_RUOT + GIAY_GIAY_RUOT; var GIA_TONG1 = GIA_BIA + GIA_DONG_CUON + giaInGiayCanMang; var GIA_THOI_GIAN = GIA_TONG1 * (PHAN_TRAM_GIA / 100); var GIA_TONG = GIA_TONG1 + GIA_THOI_GIAN; /** * Hỗ trợ CORS */ AllowCORS(); return(GIA_TONG); }
/// <summary> /// Lấy thông tin chi tiết của sản phẩm phẳng thông qua SKU /// </summary> /// <param name="productSku"></param> /// <returns></returns> public FlatProductDetails GetFlatProductDetails(string productSku) { var parameters = new Dictionary <string, object>(); parameters.Add("SKU_SAN_PHAM", productSku); var productDetails = new FlatProductDetails(); var tblKHO_SAN_PHAM = RestDbExecutor.ExecuteQuery("SELECT * FROM KHO_SAN_PHAM_SPP WHERE SKU_SAN_PHAM = @SKU_SAN_PHAM ORDER BY THU_TU ASC", parameters); var tblSO_LUONG_THANH_PHAM = RestDbExecutor.ExecuteQuery("SELECT * FROM SO_LUONG_THANH_PHAM_SPP WHERE SKU_SAN_PHAM = @SKU_SAN_PHAM ORDER BY THU_TU ASC", parameters); var tblCACH_IN = RestDbExecutor.ExecuteQuery("SELECT * FROM CACH_IN_SPP WHERE SKU_SAN_PHAM = @SKU_SAN_PHAM ORDER BY THU_TU ASC", parameters); var tblGIAY_IN = RestDbExecutor.ExecuteQuery("SELECT * FROM GIAY_IN_SPP WHERE SKU_SAN_PHAM = @SKU_SAN_PHAM ORDER BY THU_TU ASC", parameters); var tblNHOM_THANH_PHAM = RestDbExecutor.ExecuteQuery("SELECT * FROM NHOM_THANH_PHAM_SPP WHERE SKU_SAN_PHAM = @SKU_SAN_PHAM ORDER BY THU_TU ASC", parameters); var tblTHOI_GIAN_GIAO = RestDbExecutor.ExecuteQuery("SELECT * FROM THOI_GIAN_GIAO_SPP WHERE SKU_SAN_PHAM = @SKU_SAN_PHAM ORDER BY THU_TU ASC", parameters); productDetails.DANH_SACH_KHO_SAN_PHAM = new List <KHO_SAN_PHAM_SPP>(); foreach (DataRow row in tblKHO_SAN_PHAM.Rows) { productDetails.DANH_SACH_KHO_SAN_PHAM.Add(new KHO_SAN_PHAM_SPP { ID = (long)row["ID"], TEN_KHO = (string)row["TEN_KHO"], THU_TU = (long)row["THU_TU"], SKU_SAN_PHAM = (string)row["SKU_SAN_PHAM"] }); } productDetails.DANH_SACH_SO_LUONG_THANH_PHAM = new List <SO_LUONG_THANH_PHAM_SPP>(); foreach (DataRow row in tblSO_LUONG_THANH_PHAM.Rows) { productDetails.DANH_SACH_SO_LUONG_THANH_PHAM.Add(new SO_LUONG_THANH_PHAM_SPP { ID = (long)row["ID"], TEN_SO_LUONG = (string)row["TEN_SO_LUONG"], THU_TU = (long)row["THU_TU"], SKU_SAN_PHAM = (string)row["SKU_SAN_PHAM"] }); } productDetails.DANH_SACH_CACH_IN = new List <CACH_IN_SPP>(); foreach (DataRow row in tblCACH_IN.Rows) { productDetails.DANH_SACH_CACH_IN.Add(new CACH_IN_SPP { ID = (long)row["ID"], TEN_CACH_IN = (string)row["TEN_CACH_IN"], THU_TU = (long)row["THU_TU"], SKU_SAN_PHAM = (string)row["SKU_SAN_PHAM"] }); } productDetails.DANH_SACH_GIAY_IN = new List <GIAY_IN_SPP>(); foreach (DataRow row in tblGIAY_IN.Rows) { productDetails.DANH_SACH_GIAY_IN.Add(new GIAY_IN_SPP { ID = (long)row["ID"], TEN_GIAY_IN = (string)row["TEN_GIAY_IN"], THU_TU = (long)row["THU_TU"], SKU_SAN_PHAM = (string)row["SKU_SAN_PHAM"] }); } productDetails.DANH_SACH_NHOM_THANH_PHAM = new List <NHOM_THANH_PHAM_SPP>(); foreach (DataRow row in tblNHOM_THANH_PHAM.Rows) { var NHOM_THANH_PHAM = new NHOM_THANH_PHAM_SPP { ID = (long)row["ID"], TEN_NHOM = (string)row["TEN_NHOM"], THU_TU = (long)row["THU_TU"], SKU_SAN_PHAM = (string)row["SKU_SAN_PHAM"] }; var tblTHANH_PHAM = RestDbExecutor.ExecuteQuery("SELECT * FROM THANH_PHAM_SPP WHERE ID_NHOM_THANH_PHAM = " + NHOM_THANH_PHAM.ID + " ORDER BY THU_TU ASC ", null); NHOM_THANH_PHAM.DANH_SACH_THANH_PHAM = new List <THANH_PHAM_SPP>(); foreach (DataRow rowTHANH_PHAM in tblTHANH_PHAM.Rows) { NHOM_THANH_PHAM.DANH_SACH_THANH_PHAM.Add(new THANH_PHAM_SPP { ID = (long)rowTHANH_PHAM["ID"], TEN_THANH_PHAM = (string)rowTHANH_PHAM["TEN_THANH_PHAM"], THU_TU = (long)rowTHANH_PHAM["THU_TU"], ID_NHOM_THANH_PHAM = (long)rowTHANH_PHAM["ID_NHOM_THANH_PHAM"] }); } productDetails.DANH_SACH_NHOM_THANH_PHAM.Add(NHOM_THANH_PHAM); } productDetails.DANH_SACH_THOI_GIAN_GIAO = new List <THOI_GIAN_GIAO_SPP>(); foreach (DataRow row in tblTHOI_GIAN_GIAO.Rows) { productDetails.DANH_SACH_THOI_GIAN_GIAO.Add(new THOI_GIAN_GIAO_SPP { ID = (long)row["ID"], TEN_THOI_GIAN_GIAO = (string)row["TEN_THOI_GIAN_GIAO"], THU_TU = (long)row["THU_TU"], SKU_SAN_PHAM = (string)row["SKU_SAN_PHAM"] }); } return(productDetails); }
/// <summary> /// Lấy thông tin chi tiết của sản phẩm cuốn thông qua SKU /// </summary> /// <param name="productSku"></param> /// <returns></returns> public BookProductDetails GetBookProductDetails(string productSku) { var parameters = new Dictionary <string, object>(); parameters.Add("SKU_SAN_PHAM", productSku); var productDetails = new BookProductDetails(); var tblKHO_SAN_PHAM = RestDbExecutor.ExecuteQuery("SELECT * FROM KHO_SAN_PHAM_SPC WHERE SKU_SAN_PHAM = @SKU_SAN_PHAM ORDER BY THU_TU ASC", parameters); var tblBIA = RestDbExecutor.ExecuteQuery("SELECT * FROM BIA_SPC WHERE SKU_SAN_PHAM = @SKU_SAN_PHAM ORDER BY THU_TU ASC", parameters); var tblDONG_CUON = RestDbExecutor.ExecuteQuery("SELECT * FROM DONG_CUON_SPC WHERE SKU_SAN_PHAM = @SKU_SAN_PHAM ORDER BY THU_TU ASC", parameters); var tblSO_LUONG_CUON = RestDbExecutor.ExecuteQuery("SELECT * FROM SO_LUONG_CUON_SPC WHERE SKU_SAN_PHAM = @SKU_SAN_PHAM ORDER BY THU_TU ASC", parameters); var tblRUOT = RestDbExecutor.ExecuteQuery("SELECT * FROM RUOT_SPC WHERE SKU_SAN_PHAM = @SKU_SAN_PHAM ORDER BY THU_TU ASC", parameters); var tblGIAY_IN_RUOT = RestDbExecutor.ExecuteQuery("SELECT * FROM GIAY_IN_RUOT_SPC WHERE SKU_SAN_PHAM = @SKU_SAN_PHAM ORDER BY THU_TU ASC", parameters); var tblTHOI_GIAN_GIAO = RestDbExecutor.ExecuteQuery("SELECT * FROM THOI_GIAN_GIAO_SPC WHERE SKU_SAN_PHAM = @SKU_SAN_PHAM ORDER BY THU_TU ASC", parameters); productDetails.DANH_SACH_KHO_SAN_PHAM = new List <KHO_SAN_PHAM_SPC>(); foreach (DataRow row in tblKHO_SAN_PHAM.Rows) { productDetails.DANH_SACH_KHO_SAN_PHAM.Add(new KHO_SAN_PHAM_SPC { ID = (long)row["ID"], TEN_KHO = (string)row["TEN_KHO"], THU_TU = (long)row["THU_TU"], SKU_SAN_PHAM = (string)row["SKU_SAN_PHAM"] }); } productDetails.DANH_SACH_BIA = new List <BIA_SPC>(); foreach (DataRow row in tblBIA.Rows) { productDetails.DANH_SACH_BIA.Add(new BIA_SPC { ID = (long)row["ID"], TEN_BIA = (string)row["TEN_BIA"], THU_TU = (long)row["THU_TU"], SKU_SAN_PHAM = (string)row["SKU_SAN_PHAM"] }); } productDetails.DANH_SACH_DONG_CUON = new List <DONG_CUON_SPC>(); foreach (DataRow row in tblDONG_CUON.Rows) { productDetails.DANH_SACH_DONG_CUON.Add(new DONG_CUON_SPC { ID = (long)row["ID"], TEN_DONG_CUON = (string)row["TEN_DONG_CUON"], THU_TU = (long)row["THU_TU"], SKU_SAN_PHAM = (string)row["SKU_SAN_PHAM"] }); } productDetails.DANH_SACH_SO_LUONG_CUON = new List <SO_LUONG_CUON_SPC>(); foreach (DataRow row in tblSO_LUONG_CUON.Rows) { productDetails.DANH_SACH_SO_LUONG_CUON.Add(new SO_LUONG_CUON_SPC { ID = (long)row["ID"], TEN_SO_LUONG = (string)row["TEN_SO_LUONG"], THU_TU = (long)row["THU_TU"], SKU_SAN_PHAM = (string)row["SKU_SAN_PHAM"] }); } productDetails.DANH_SACH_RUOT = new List <RUOT_SPC>(); foreach (DataRow row in tblRUOT.Rows) { productDetails.DANH_SACH_RUOT.Add(new RUOT_SPC { ID = (long)row["ID"], TEN_RUOT = (string)row["TEN_RUOT"], THU_TU = (long)row["THU_TU"], SKU_SAN_PHAM = (string)row["SKU_SAN_PHAM"] }); } productDetails.DANH_SACH_GIAY_IN_RUOT = new List <GIAY_IN_RUOT_SPC>(); foreach (DataRow row in tblGIAY_IN_RUOT.Rows) { productDetails.DANH_SACH_GIAY_IN_RUOT.Add(new GIAY_IN_RUOT_SPC { ID = (long)row["ID"], TEN_GIAY_IN = (string)row["TEN_GIAY_IN"], THU_TU = (long)row["THU_TU"], SKU_SAN_PHAM = (string)row["SKU_SAN_PHAM"] }); } productDetails.DANH_SACH_THOI_GIAN_GIAO = new List <THOI_GIAN_GIAO_SPC>(); foreach (DataRow row in tblTHOI_GIAN_GIAO.Rows) { productDetails.DANH_SACH_THOI_GIAN_GIAO.Add(new THOI_GIAN_GIAO_SPC { ID = (long)row["ID"], TEN_THOI_GIAN_GIAO = (string)row["TEN_THOI_GIAN_GIAO"], THU_TU = (long)row["THU_TU"], SKU_SAN_PHAM = (string)row["SKU_SAN_PHAM"] }); } return(productDetails); }
/// <summary> /// Lấy giá của sản phẩm phẳng /// </summary> /// <param name="sizeId"></param> /// <param name="quantityId"></param> /// <param name="paperId"></param> /// <param name="printingStyleId"></param> /// <param name="shipTimeId"></param> /// <param name="finishedProductGroupId"></param> /// <param name="finishedProductIds"></param> /// <returns></returns> //public decimal? GetPriceOfFlatProduct(string sizeId, string quantityId, string paperId, string printingStyleId, string shipTimeId, string finishedProductGroupId, string finishedProductIds) //{ // /** // * Kiểm tra chứng thực // */ // if (!AuthenticateViaAuthorizationHeader()) // { // return null; // } // /** // * Tính giá // */ // var parameters = new Dictionary<string, object>(); // parameters.Add("ID_KHO_SAN_PHAM", sizeId); // parameters.Add("ID_SO_LUONG_THANH_PHAM", quantityId); // parameters.Add("ID_GIAY_IN", paperId); // parameters.Add("ID_CACH_IN", printingStyleId); // parameters.Add("ID_THOI_GIAN_GIAO", shipTimeId); // parameters.Add("ID_NHOM_THANH_PHAM", finishedProductGroupId); // parameters.Add("ID_THANH_PHAM", finishedProductIds); // var GIA_GIAY_IN_RAW = RestDbExecutor.ExecuteScalar("SELECT DON_GIA FROM GIA_GIAY_IN_SPP WHERE ID_KHO_SAN_PHAM = @ID_KHO_SAN_PHAM AND ID_SO_LUONG_THANH_PHAM = @ID_SO_LUONG_THANH_PHAM AND ID_GIAY_IN = @ID_GIAY_IN", parameters); // var GIA_CACH_IN_RAW = RestDbExecutor.ExecuteScalar("SELECT DON_GIA FROM GIA_CACH_IN_SPP WHERE ID_KHO_SAN_PHAM = @ID_KHO_SAN_PHAM AND ID_SO_LUONG_THANH_PHAM = @ID_SO_LUONG_THANH_PHAM AND ID_CACH_IN = @ID_CACH_IN", parameters); // var GIA_THANH_PHAM_RAW = RestDbExecutor.ExecuteScalar(string.Format("SELECT SUM(DON_GIA) AS DON_GIA FROM GIA_THANH_PHAM_SPP WHERE ID_KHO_SAN_PHAM = @ID_KHO_SAN_PHAM AND ID_SO_LUONG_THANH_PHAM = @ID_SO_LUONG_THANH_PHAM AND ID_NHOM_THANH_PHAM = @ID_NHOM_THANH_PHAM AND ID_THANH_PHAM IN({0})", parameters["ID_THANH_PHAM"]), parameters); // var PHAN_TRAM_GIA_RAW = RestDbExecutor.ExecuteScalar("SELECT PHAN_TRAM_GIA FROM GIA_THOI_GIAN_GIAO_SPP WHERE ID_KHO_SAN_PHAM = @ID_KHO_SAN_PHAM AND ID_SO_LUONG_THANH_PHAM = @ID_SO_LUONG_THANH_PHAM AND ID_THOI_GIAN_GIAO = @ID_THOI_GIAN_GIAO", parameters); // var GIA_GIAY_IN = GIA_GIAY_IN_RAW != DBNull.Value ? Convert.ToDecimal(GIA_GIAY_IN_RAW) : 0; // var GIA_CACH_IN = GIA_CACH_IN_RAW != DBNull.Value ? Convert.ToDecimal(GIA_CACH_IN_RAW) : 0; // var GIA_THANH_PHAM = GIA_THANH_PHAM_RAW != DBNull.Value ? Convert.ToDecimal(GIA_THANH_PHAM_RAW) : 0; // var PHAN_TRAM_GIA = PHAN_TRAM_GIA_RAW != DBNull.Value ? Convert.ToDecimal(PHAN_TRAM_GIA_RAW) : 0; // var GIA_TONG1 = GIA_GIAY_IN + GIA_CACH_IN + GIA_THANH_PHAM; // var GIA_THOI_GIAN = GIA_TONG1 * (PHAN_TRAM_GIA / 100); // var GIA_TONG = GIA_TONG1 + GIA_THOI_GIAN; // /** // * Hỗ trợ CORS // */ // AllowCORS(); // return GIA_TONG; //} public decimal?GetPriceOfFlatProduct(string sizeId, string quantityId, string paperId, string printingStyleId, string shipTimeId, string finishedProducts) { /** * Kiểm tra chứng thực */ if (!AuthenticateViaAuthorizationHeader()) { return(null); } /** * Tính giá */ var parameters = new Dictionary <string, object>(); parameters.Add("ID_KHO_SAN_PHAM", sizeId); parameters.Add("ID_SO_LUONG_THANH_PHAM", quantityId); parameters.Add("ID_GIAY_IN", paperId); parameters.Add("ID_CACH_IN", printingStyleId); parameters.Add("ID_THOI_GIAN_GIAO", shipTimeId); parameters.Add("ID_NHOM_THANH_PHAM", finishedProducts); parameters.Add("ID_THANH_PHAM", finishedProducts); var GIA_GIAY_IN_RAW = RestDbExecutor.ExecuteScalar("SELECT DON_GIA FROM GIA_GIAY_IN_SPP WHERE ID_KHO_SAN_PHAM = @ID_KHO_SAN_PHAM AND ID_SO_LUONG_THANH_PHAM = @ID_SO_LUONG_THANH_PHAM AND ID_GIAY_IN = @ID_GIAY_IN", parameters); var GIA_CACH_IN_RAW = RestDbExecutor.ExecuteScalar("SELECT DON_GIA FROM GIA_CACH_IN_SPP WHERE ID_KHO_SAN_PHAM = @ID_KHO_SAN_PHAM AND ID_SO_LUONG_THANH_PHAM = @ID_SO_LUONG_THANH_PHAM AND ID_CACH_IN = @ID_CACH_IN", parameters); //--Dz- lay SKU SP var sku_SanPhamP = RestDbExecutor.ExecuteScalar("SELECT SKU_SAN_PHAM FROM KHO_SAN_PHAM_SPP WHERE ID = @ID_KHO_SAN_PHAM", parameters); //--dz-end var GIA_THANH_PHAM = (decimal)0; foreach (var finishedProductPair in finishedProducts.Split(',')) { var pair = finishedProductPair.Split('~'); var ID_NHOM_THANH_PHAM = pair[0]; var ID_THANH_PHAM = pair[1]; parameters["ID_NHOM_THANH_PHAM"] = ID_NHOM_THANH_PHAM; parameters["ID_THANH_PHAM"] = ID_THANH_PHAM; var GIA_THANH_PHAM_RAW = RestDbExecutor.ExecuteScalar("SELECT SUM(DON_GIA) AS DON_GIA FROM GIA_THANH_PHAM_SPP WHERE ID_KHO_SAN_PHAM = @ID_KHO_SAN_PHAM AND ID_SO_LUONG_THANH_PHAM = @ID_SO_LUONG_THANH_PHAM AND ID_NHOM_THANH_PHAM = @ID_NHOM_THANH_PHAM AND ID_THANH_PHAM = @ID_THANH_PHAM", parameters); GIA_THANH_PHAM += GIA_THANH_PHAM_RAW != DBNull.Value ? Convert.ToDecimal(GIA_THANH_PHAM_RAW) : 0; } var PHAN_TRAM_GIA_RAW = RestDbExecutor.ExecuteScalar("SELECT PHAN_TRAM_GIA FROM GIA_THOI_GIAN_GIAO_SPP WHERE ID_KHO_SAN_PHAM = @ID_KHO_SAN_PHAM AND ID_SO_LUONG_THANH_PHAM = @ID_SO_LUONG_THANH_PHAM AND ID_THOI_GIAN_GIAO = @ID_THOI_GIAN_GIAO", parameters); var GIA_GIAY_IN = GIA_GIAY_IN_RAW != DBNull.Value ? Convert.ToDecimal(GIA_GIAY_IN_RAW) : 0; var GIA_CACH_IN = GIA_CACH_IN_RAW != DBNull.Value ? Convert.ToDecimal(GIA_CACH_IN_RAW) : 0; var PHAN_TRAM_GIA = PHAN_TRAM_GIA_RAW != DBNull.Value ? Convert.ToDecimal(PHAN_TRAM_GIA_RAW) : 0; //Dũng tìm CM trong thành phẩm phẳng gắp ra var maCM = ""; foreach (var finishedProductPair in finishedProducts.Split(',')) { var pair = finishedProductPair.Split('~'); //var ID_NHOM_THANH_PHAM = pair[0]; var ID_THANH_PHAM = pair[1]; //parameters["ID_NHOM_THANH_PHAM"] = ID_NHOM_THANH_PHAM; //1). Tìm tất cả ID nếu Id nào có MA_THANH_PHAM = bắt đầu 2 chữ = CM thì ngưng để tính cán màng parameters["ID_THANH_PHAM"] = ID_THANH_PHAM; var maThanhPham = (string)RestDbExecutor.ExecuteScalar("SELECT MA_THANH_PHAM FROM THANH_PHAM_SPP WHERE ID = @ID_THANH_PHAM", parameters); //var GIA_THANH_PHAM_RAW = RestDbExecutor.ExecuteScalar("SELECT SUM(DON_GIA) AS DON_GIA FROM GIA_THANH_PHAM_SPP WHERE ID_KHO_SAN_PHAM = @ID_KHO_SAN_PHAM AND ID_SO_LUONG_THANH_PHAM = @ID_SO_LUONG_THANH_PHAM AND ID_NHOM_THANH_PHAM = @ID_NHOM_THANH_PHAM AND ID_THANH_PHAM = @ID_THANH_PHAM", parameters); if (!string.IsNullOrEmpty(maThanhPham)) { if (maThanhPham.Substring(0, 2) == "CM") { maCM = maThanhPham; //lấy break; //Thoát khỏi foreach } } } if (!string.IsNullOrEmpty(maCM))//có cán màng thì tính tiền cán màng { var cauhinhInPhang = new CauHinhTinhGiaPhang((string)sku_SanPhamP, int.Parse(sizeId), int.Parse(quantityId), int.Parse(paperId), int.Parse(printingStyleId)); var giaCanMang = TinhToanPhang.GiaCanMang(cauhinhInPhang, maCM); GIA_THANH_PHAM += giaCanMang; //thêm vô } //Dzung kết thúc cán màng //-Dzung-Tinh toan gia. chỉ sửa đoạn này để lồng vô CauHinhTinhGiaPhang cauHinhInPhang = null; if (GIA_CACH_IN <= 0 || GIA_GIAY_IN <= 0) { cauHinhInPhang = new CauHinhTinhGiaPhang((string)sku_SanPhamP, int.Parse(sizeId), int.Parse(quantityId), int.Parse(paperId), int.Parse(printingStyleId)); } decimal giaIn = 0; decimal giaGiay = 0; ///A). Tính theo Dzung: xử lý giá in và giá giấy ///Mánh: trường hợp cài -1 thì chỗ dó 0 tính cả theo số lượng sẵn lẫn hàng loạt ///nếu để 0 thì tính số hàng loạt chứ không tính ///Trường hợp >0 thì dùng giá cài dặt int tmpIntCheck = (int)GIA_CACH_IN; switch (tmpIntCheck) { case -1: giaIn = 0; break; case 0: giaIn = TinhToanPhang.GiaIn(cauHinhInPhang); break; default: giaIn = GIA_CACH_IN; break; } //Tiếp giấy dùng tmpGiaCachIn chung tmpIntCheck = (int)GIA_GIAY_IN; switch (tmpIntCheck) { case -1: giaGiay = 0; break; case 0: giaGiay = TinhToanPhang.GiaGiay(cauHinhInPhang); break; default: giaGiay = GIA_GIAY_IN; break; } ///Hết xử lý giá giấy và in thành công ///2. Xử lý cán màng (chưa nghĩ ra) var GIA_TONG1 = giaIn + giaGiay + GIA_THANH_PHAM; //--Dzung--end //var GIA_TONG1 = GIA_GIAY_IN + GIA_CACH_IN + GIA_THANH_PHAM; var GIA_THOI_GIAN = GIA_TONG1 * (PHAN_TRAM_GIA / 100); var GIA_TONG = GIA_TONG1 + GIA_THOI_GIAN; /** * Hỗ trợ CORS */ AllowCORS(); return(GIA_TONG); }