public ActionResult CloneServicePR(int incree, CRM_Contract_Product_Draff normal) { ViewBag.countID = incree; ViewBag.product = normal; return(View("clone/_clone_draff_pr")); }
public ActionResult GetTemplateContract(Int32 Id, bool isView, string Type) { using (IDbConnection dbConn = ERPAPD.Helpers.OrmliteConnection.openConn()) { ViewBag.typeContract = Type; string viewName = "print/_template_export_contract"; var itemdraffansi = dbConn.Select <CRM_Contract_Draff>(@" SELECT condraff.*,cus.CustomerID,cus.CustomerName,cus.CategoryParent as CategoryID, cus.Category as CategorySubID,cus.CustomerType as CustomerType, P.Value AS StatusName FROM CRM_Contract_Draff condraff LEFT JOIN ERPAPD_Customer cus ON cus.CustomerID =condraff.CustomerID LEFT JOIN Parameters P ON P.ParamID=condraff.TrangThai AND P.Type='ContractAPStatus' WHERE condraff.PKContractDraft='" + Id + "'").FirstOrDefault(); itemdraffansi.Dieu2 = ConvertANSIToUTF8.Convert(itemdraffansi.Dieu2); itemdraffansi.DieuKhoan = ConvertANSIToUTF8.Convert(itemdraffansi.DieuKhoan); itemdraffansi.GhiChu = ConvertANSIToUTF8.Convert(itemdraffansi.GhiChu); ViewBag.itemdraff = itemdraffansi; ViewBag.subWiewName = ""; switch (Type) { case "THUONG": ViewBag.subWiewName = "partial/_temp_product_hdt"; ViewBag.product = CRM_Contract_Product_Draff.getProductByPKContract(Id); ViewBag.discount = dbConn.Select <CRM_Contract_Draff_Promotion>(s => s.FKContract == Id); break; case "PHIEUPR": viewName = "print/_template_export_contract_p_pr"; ViewBag.subWiewName = "partial/_temp_product_p_pr"; ViewBag.product = CRM_Contract_Product_Draff.getProductByPKContract(Id); ViewBag.discount = dbConn.Select <CRM_Contract_Draff_Promotion>(s => s.FKContract == Id); break; case "CPM": ViewBag.subWiewName = "partial/_temp_product_cpm"; ViewBag.product = dbConn.Select <CRM_Contract_Product_CPM_Draff>(s => s.FkContract == Id); ViewBag.discount = dbConn.Select <CRM_Contract_Draff_Promotion>(@" SELECT SUM(ChietKhauChung) AS SumDiscount FROM CRM_Contract_Draff_Promotion where FKContract = " + Id).FirstOrDefault(); break; case "GOI": ViewBag.subWiewName = "partial/_temp_product_hdg"; var list = dbConn.Select <CRM_Contract_Product_Packet_Draff>(s => s.FKContract == Id); if (list.Count == 0) { ViewBag.product = dbConn.Select <CRM_Contract_Product_Packet>(@"SELECT A.PKProduct AS PKPacket, A.FKContract, '' AS Code,'GOI' AS 'Type',A.HUONG AS Name, B.DateUp ,B.DateDown, A.Price AS UnitPrice, B.Discount1 AS Discount,B.Money AS Total FROM CRM_Contract_Product_Draff A LEFT JOIN CRM_Contract_Time_Draff B ON A.FKContract=B.FKContract where A.FKContract ={0}", Id); ViewBag.discount = dbConn.Select <CRM_Contract_Draff_Promotion>(@" SELECT TOP 1 1 AS ID, 0 AS SumDiscount FROM CRM_Contract_Draff_Promotion").FirstOrDefault(); } else { ViewBag.product = list; ViewBag.discount = dbConn.Select <CRM_Contract_Draff_Promotion>(@" SELECT 1 AS ID, ISNULL(SUM(ChietKhauChung),0) AS SumDiscount FROM CRM_Contract_Draff_Promotion where FKContract = " + Id).FirstOrDefault(); } break; case "PHIEU": ViewBag.product = CRM_Contract_Product_Draff.getProductByPKContract(Id); ViewBag.discount = dbConn.Select <CRM_Contract_Draff_Promotion>(s => s.FKContract == Id); ViewBag.subWiewName = "partial/_temp_product_pdkqc"; break; case "PHIEUCPM": ViewBag.subWiewName = "partial/_temp_product_p_cpm"; ViewBag.product = dbConn.Select <CRM_Contract_Product_CPM_Draff>(s => s.FkContract == Id); ViewBag.discount = dbConn.Select <CRM_Contract_Draff_Promotion>(@" SELECT SUM(ChietKhauChung) AS SumDiscount FROM CRM_Contract_Draff_Promotion where FKContract = " + Id).FirstOrDefault(); break; } string html = RenderPartialViewToString(viewName); if (isView) { return(View(viewName)); } try { ExportToWord(html, Id, Type); } catch (Exception e) { return(Json(new { success = false, message = e })); } } return(Json(new { success = true })); }