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