public ActionResult GetReportData(List <I.MES.Models.WhereCondition> whereList, string page) { try { ReportOP op = new ReportOP(); //总记录数 int intRowTotal = 0; //获取当前页码 int intPage = string.IsNullOrWhiteSpace(page) ? 1 : int.Parse(page); DataSet ds = op.GetReportData(whereList, intPage, ConstInfo.PAGE_SIZE, out intRowTotal); var strReportJson = ToJson(ds.Tables[1]); //JsonHelper.ToJson(ds.Tables[1]); return(Json(new ReturnResult { Result = 1, Message = intRowTotal.ToString(), Data = strReportJson })); } catch (Exception ex) { return(Json(new ReturnResult { Result = 0, Message = ex.Message, Data = "" })); } }
/// <summary> /// 根据产品分类,产品层级和零件号获取层级 /// </summary> /// <param name="categoryCode"></param> /// <param name="produceLevel"></param> /// <param name="partNo"></param> /// <returns></returns> public ActionResult GetPartVersionListByCategoryAndLevelAndPart(string categoryCode, string produceLevel, string partNo) { var partVersionSet = new ReportOP().GetAllForReport("MFG_PartVersion", " and exists (select 1 from MFG_Part where PartVersion = MFG_PartVersion.PartVersion and ProduceLevel = '" + produceLevel + "' and ProduceCategory = '" + categoryCode + "' and PartNo ='" + partNo + "')"); //var partVersionList = null;// ModelHelper.DataSetToIList<MFG_PartVersion>(partVersionSet); return(Json("")); }
/// <summary> ///根据产品分类获取层级 /// </summary> /// <param name="categoryCode"></param> /// <returns></returns> public ActionResult GetPartProduceLevelListByCategory(string categoryCode) { var produceLevelSet = new ReportOP().GetAllForReport("MFG_ProduceLevel", " and exists(select 1 from MFG_Part p where p.ProduceLevel = MFG_ProduceLevel.ProduceLevelCode and p.ProduceCategory = '" + categoryCode + "')"); var produceLevelList = ModelHelper.DataSetToIList <MFG_ProduceLevel>(produceLevelSet); return(Json(produceLevelList)); }
public ActionResult GetReportDataProc(List <I.MES.Models.WhereCondition> whereList, string page) { try { ReportOP op = new ReportOP(); //总记录数 int intRowTotal = 0; //获取当前页码 int intPage = string.IsNullOrWhiteSpace(page) ? 1 : int.Parse(page); DataSet ds = op.GetAllReportDataProc(whereList); DataTable dt = Processing(ds); var strReportJson = ToJson(dt); //JsonHelper.ToJson(ds.Tables[1]); return(Json(new ReturnResult { Result = 1, Message = ds.Tables[0].Rows.Count.ToString(), Data = strReportJson })); } catch (Exception ex) { return(Json(new ReturnResult { Result = 0, Message = ex.Message, Data = "" })); } }
public ActionResult Edit(int id) { string whereStr = "and ID = " + id; DataSet vehicleModeDataSet = new ReportOP().GetAllForReport("MFG_VehicleMode", whereStr); var vehicleMode = ModelHelper.DataSetToIList <MFG_VehicleMode>(vehicleModeDataSet).FirstOrDefault(); return(View(vehicleMode)); }
public ActionResult GetVehicleModeList(string vehicleMode, string vehicleName) { ReportOP op = new ReportOP(); int total = 0; int page = int.Parse(Request["page"]); #region 查询条件 List <I.MES.Models.WhereCondition> whereList = new List <I.MES.Models.WhereCondition>(); whereList.Add(new MES.Models.WhereCondition { Key = "ViewName", Value = "MFG_VehicleMode" }); whereList.Add(new MES.Models.WhereCondition { Key = "SortColumn", Value = "VehicleMode" }); whereList.Add(new MES.Models.WhereCondition { Key = "SortDirection", Value = "Asc" }); whereList.Add(new MES.Models.WhereCondition { Key = "VehicleMode", ColumnName = "VehicleMode", Operator = "", Value = vehicleMode }); whereList.Add(new MES.Models.WhereCondition { Key = "VehicleName", ColumnName = "VehicleName", Operator = "", Value = vehicleName }); #endregion DataSet ds = op.GetReportData(whereList, page, ConstInfo.PAGE_SIZE, out total); var data = ModelHelper.DataSetToIList <MFG_VehicleMode>(ds, 1); ViewBag.TotalRecords = total; Hashtable ht = new Hashtable(); ht.Add("rows", data); ht.Add("total", total); return(Json(ht, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 根据产品分类和产品层级获取零件 /// </summary> /// <param name="categoryCode"></param> /// <param name="produceLevel"></param> /// <returns></returns> public ActionResult GetPartListByCategoryAndLevel(string categoryCode, string produceLevel) { var partSet = new ReportOP().GetAllForReport("MFG_Part", " and ProduceLevel = '" + produceLevel + "' and ProduceCategory = '" + categoryCode + "'"); var partList = ModelHelper.DataSetToIList <MFG_Part>(partSet); var q = from p in partList group p by new { PartNo = p.PartNo, Description = p.PartLevel } into g select new { g.Key.PartNo, g.Key.Description }; return(Json(q)); }
public ActionResult GetPageDataProc(List <I.MES.Models.WhereCondition> whereList, string page) { try { ReportOP op = new ReportOP(); //总记录数 int intRowTotal = 0; //获取当前页码 int intPage = string.IsNullOrWhiteSpace(page) ? 1 : int.Parse(page); whereList.Add(new MES.Models.WhereCondition { Key = "page", ColumnName = "page", Operator = "", Value = page }); whereList.Add(new MES.Models.WhereCondition { Key = "pagesize", ColumnName = "pagesize", Operator = "", Value = ConstInfo.PAGE_SIZE.ToString() }); DataSet ds = op.GetAllReportDataProc(whereList); if (ds.Tables[0].Rows.Count == 0) { DataRow row = ds.Tables[0].NewRow(); ds.Tables[0].Rows.Add(row); } var strReportJson = ToJson(ds.Tables[1]); //JsonHelper.ToJson(ds.Tables[1]); return(Json(new ReturnResult { Result = 1, Message = ds.Tables[0].Rows[0][0].ToString(), Data = strReportJson })); } catch (Exception ex) { return(Json(new ReturnResult { Result = 0, Message = ex.Message, Data = "" })); } }
public string GetReportDetail() { try { ReportOP op = new ReportOP(); List <I.MES.Models.WhereCondition> whereList = new List <WhereCondition>(); int intTotal = Request.QueryString.AllKeys.Count(); string strKey = ""; string strValue = ""; for (int i = 0; i < intTotal; i++) { strKey = Request.QueryString.AllKeys[i]; strValue = Request.QueryString[strKey]; if (string.IsNullOrWhiteSpace(strKey)) { continue; } whereList.Add(new WhereCondition() { ColumnName = strKey, Key = strKey, Operator = "=", Value = strValue }); } DataSet ds = op.GetAllReportData(whereList); /* 视图字段被修改?? 导致添加统计行报错*/ DataRow drr = ds.Tables[0].NewRow(); try { drr["PartDesc"] = "总合计"; drr["ReturnQty"] = ds.Tables[0].Compute("sum(ReturnQty)", "TRUE"); drr["RecQty"] = ds.Tables[0].Compute("sum(RecQty)", "TRUE"); } catch { } ds.Tables[0].Rows.Add(drr); var strReportJson = ToJson(ds.Tables[0]); return(JsonHelper.ToJson(ds.Tables[0])); } catch (Exception ex) { return(ex.Message); } }
public void Export(string type, string pd) { string ret = ""; try { ReportOP op = new ReportOP(); DataSet dsExport = null; string strJson = Server.UrlDecode(Request["w"]); //string strjson2 = Server.UrlDecode(pd); List <I.MES.Models.WhereCondition> whereList; List <I.MES.Models.ExportCell> whereList2; if (!string.IsNullOrWhiteSpace(strJson)) { whereList = strJson.ToEntities <List <I.MES.Models.WhereCondition> >(); whereList2 = pd.ToEntities <List <ExportCell> >(); dsExport = op.GetAllReport(whereList, whereList2, type); } Workbook workbook = AsposeExcelTools.DataTableToExcel2(dsExport.Tables[1]); if (workbook != null) { this.DeleteDownLoadTempFile(); //直接导出 Stream outputStream = Response.OutputStream; string filename = "/DownLoad/" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx"; workbook.Save(Server.MapPath(filename), SaveFormat.Xlsx); ret = filename; } } catch (Exception ex) { throw ex; } // Response.Buffer = false; Response.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx"); Response.ContentEncoding = System.Text.Encoding.UTF8; Response.ContentType = "application/vnd.ms-excel"; Response.Write(ret); Response.Flush(); Response.End(); }
public ActionResult Create(MFG_VehicleMode vMode) { try { string whereStr = "and VehicleMode = '" + vMode.VehicleMode + "'"; DataSet existVehicleModeDataSet = new ReportOP().GetAllForReport("MFG_VehicleMode", whereStr); var existVehicleMode = ModelHelper.DataSetToIList <MFG_VehicleMode>(existVehicleModeDataSet).FirstOrDefault(); if (existVehicleMode != null) { throw new Exception("Model code already exists"); } ReportOP reportOp = new ReportOP(); PrepareModel(vMode, true); reportOp.CreateForReport("MFG_VehicleMode", JsonHelper.ToJson(vMode)); return(Json(new { state = "success", message = "Model added successfully" })); } catch (Exception ex) { return(Json(new { state = "error", message = ex.Message })); } }