Ejemplo n.º 1
0
        public DynamicProjectReportViewModel GetDynamicProjectGroupItemReport(int page, int size, int projectId, int stockTypeId,
                                                                              int categoryId, string stockCode, string stockName, string action, int supplierId, string fd, string td)
        {
            var model   = new DynamicProjectReportViewModel();
            var paramss = new DynamicParameters();

            paramss.Add("page", page);
            paramss.Add("size", size);
            paramss.Add("projectId", projectId);
            paramss.Add("stockTypeId", stockTypeId);
            paramss.Add("categoryId", categoryId);
            paramss.Add("stockCode", stockCode);
            paramss.Add("stockName", stockName);
            paramss.Add("action", action);
            paramss.Add("supplierId", supplierId);
            paramss.Add("fd", fd);
            paramss.Add("td", td);
            paramss.Add("out", dbType: DbType.Int32, direction: ParameterDirection.Output);

            using (var sql = GetSqlConnection())
            {
                var data = sql.Query <XDynamicProjectGroupItemReport>("XGetDynamicProjectGroupItemReport", paramss, commandType: CommandType.StoredProcedure);
                sql.Close();
                model.DynamicProjectGroupItemReports = data.ToList();
                var total = paramss.Get <int>("out");
                model.TotalRecords = total;
                var totalTemp = Convert.ToDecimal(total) / Convert.ToDecimal(size);
                model.TotalPages = Convert.ToInt32(Math.Ceiling(totalTemp));
            }
            return(model);
        }
Ejemplo n.º 2
0
 public ActionResult DynamicProject()
 {
     var model = new DynamicProjectReportViewModel();
     var projects = _systemService.ProjectList();
     model.ProjectIds = projects;
     model.ProjectNames = projects;
     model.Suppliers = _systemService.SupplierList();
     model.StockTypes = _systemService.TypeStockList();
     model.StockCategories = _systemService.CategoryStockList(0);
     return View(model);
 }
        public ActionResult DynamicProject()
        {
            var model    = new DynamicProjectReportViewModel();
            var projects = _systemService.ProjectList();

            model.ProjectIds      = projects;
            model.ProjectNames    = projects;
            model.Suppliers       = _systemService.SupplierList();
            model.StockTypes      = _systemService.TypeStockList();
            model.StockCategories = _systemService.CategoryStockList(0);
            return(View(model));
        }
Ejemplo n.º 4
0
        public DynamicProjectReportViewModel GetDynamicProjectReport(int page, int size, int projectId, int stockTypeId,
            int categoryId, string stockCode, string stockName, string action, int supplierId, string fd, string td)
        {
            var model = new DynamicProjectReportViewModel();
            var paramss = new DynamicParameters();
            paramss.Add("page", page);
            paramss.Add("size", size);
            paramss.Add("projectId", projectId);
            paramss.Add("stockTypeId", stockTypeId);
            paramss.Add("categoryId", categoryId);
            paramss.Add("stockCode", stockCode);
            paramss.Add("stockName", stockName);
            paramss.Add("action", action);
            paramss.Add("supplierId", supplierId);
            paramss.Add("fd", fd);
            paramss.Add("td", td);
            paramss.Add("out", dbType: DbType.Int32, direction: ParameterDirection.Output);

            using (var sql = GetSqlConnection())
            {
                var data = sql.Query<XDynamicProjectReport>("XGetDynamicProjectReport", paramss, commandType: CommandType.StoredProcedure);
                sql.Close();
                model.DynamicProjectReports = data.ToList();
                var total = paramss.Get<int>("out");
                model.TotalRecords = total;
                var totalTemp = Convert.ToDecimal(total) / Convert.ToDecimal(size);
                model.TotalPages = Convert.ToInt32(Math.Ceiling(totalTemp));
            }
            return model;
        }