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 }));
}
