コード例 #1
0
        public ContentResult GetContractHistoryData([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, string searchprm)
        {
            ContractSearchpara ObjPara = JsonConvert.DeserializeObject <ContractSearchpara>(searchprm,
                                                                                            new JsonSerializerSettings
            {
                NullValueHandling = NullValueHandling.Ignore
            });
            //T_CMS_Master_ContractCollection collection = T_CMS_Master_ContractManager.Search(SearchKey);

            DataTable dt          = T_CMS_Master_ContractManager.CMS_ContractHistoryReport(int.Parse(ObjPara.EntityId), SystemConfig.CurrentDate, true);
            int       TotalRecord = 0;

            if (dt.Rows.Count > 0)
            {
                TotalRecord = dt.Rows.Count;
            }
            //{{Class}Collection data = {{Class}}Manager.GetAll(CurrentUser.CompanyID);
            IEnumerable <DataRow> rows = dt.AsEnumerable().ToList();
            object temp = new object();

            foreach (var item in rows)
            {
                temp = item.Table;
            }
            return(Content(JsonConvert.SerializeObject(new DataTablesResponseExtend(requestModel.Draw, temp, TotalRecord, TotalRecord)), "application/json"));
        }
コード例 #2
0
        public void CMSHistory(string searchprm)
        {
            ContractSearchpara ObjPara = JsonConvert.DeserializeObject <ContractSearchpara>(searchprm,
                                                                                            new JsonSerializerSettings
            {
                NullValueHandling = NullValueHandling.Ignore
            });
            DataTable dt = new DataTable();

            try
            {
                bool isActive = false;
                if (ObjPara.IsActive != null && ObjPara.IsActive.ToLower() == "on")
                {
                    isActive = true;
                }
                dt = T_CMS_Master_ContractManager.CMS_ContractHistoryReport(int.Parse(ObjPara.EntityId), null, isActive);
            }
            catch
            {
            }
            FileInputHelper.ExportExcel(dt, "CMS_History_" + SystemConfig.CurrentDate.ToShortDateString(), "Contract History List", false);
        }