public string TorqPartToExcelAll(ToExcelModel Model) { string excel = ""; try { AssembleSearchModel model = new AssembleSearchModel(); model.Area = Model.line; model.EndTime = Model.endtime; model.StarTime = Model.starttime; var time = model.StarTime.AddDays(8); if (model.StarTime.AddDays(8) < model.EndTime) { excel = "false"; } else { if (Model.type == "Torq") { List <TorqToExcelDto> list = DapperService.ToExcel.TorqToExcel(Model); if (list.Count != 0) { JavaScriptSerializer json = new JavaScriptSerializer(); json.MaxJsonLength = Int32.MaxValue; excel = json.Serialize(list); } } if (Model.type == "Part") { List <PartToExcelDto> list = DapperService.ToExcel.PartToExcel(Model).Where(p => p.cartype != null & p.QualityStatus != null && p.NutID != null && p.PART_figure_no != null).ToList(); if (list.Count != 0) { JavaScriptSerializer json = new JavaScriptSerializer(); json.MaxJsonLength = Int32.MaxValue; excel = json.Serialize(list); } } } } catch (Exception ex) { } return(excel); }
public string TorqPartToExcelAll(ToExcelModel Model) { var Successed = true; var Message = ""; string excel = ""; try { AssembleSearchModel model = new AssembleSearchModel(); model.Area = Model.line; model.EndTime = Model.endtime; model.StarTime = Model.starttime; if (Model.type == "Torq") { List <TorqToExcelDto> list = DapperService.SqlHelp.TorqByDataToExcel(model); if (list.Count != 0) { Message = "成功!"; JavaScriptSerializer json = new JavaScriptSerializer(); json.MaxJsonLength = Int32.MaxValue; excel = json.Serialize(list); //Dictionary<string, string> dic = new Dictionary<string, string>(); //dic.Add("ProductLine", "生产线"); //dic.Add("SN", "总成条码"); //dic.Add("OnLineTime", "上线时间"); //dic.Add("UpLineTime", "下线时间"); //dic.Add("ClampNumber", "夹具信息"); //dic.Add("QualityStatus", "质量状态"); //dic.Add("NutID", "扭矩编号"); //dic.Add("Torque", "扭矩"); //dic.Add("Nutname", "螺栓名称"); //dic.Add("Station", "工位"); //dic.Add("Angle", "角度"); //dic.Add("PartInstallTime", "部件安装时间"); //dic.Add("Factory", "所属工厂"); //ExExcel(list, dic, "扭矩参数追溯信息表"); } } else if (Model.type == "Part") { List <PartToExcelDto> list = DapperService.SqlHelp.PartyByDataToExcel(model); if (list.Count != 0) { Message = "成功!"; JavaScriptSerializer json = new JavaScriptSerializer(); json.MaxJsonLength = Int32.MaxValue; excel = json.Serialize(list); //Dictionary<string, string> dic = new Dictionary<string, string>(); //dic.Add("ProductLine", "生产线"); //dic.Add("SN", "总成条码"); //dic.Add("OnLineTime", "上线时间"); //dic.Add("UpLineTime", "下线时间"); //dic.Add("ClampNumber", "夹具信息"); //dic.Add("QualityStatus", "质量状态"); //dic.Add("NutID", "部件编号"); //dic.Add("RealPart", "实装部件"); //dic.Add("ShouldPart", "应装部件"); //dic.Add("PartInstallTime", "部件安装时间"); //dic.Add("Factory", "所属工厂"); //ExExcel(list, dic, "部件参数追溯信息表"); } } } catch (Exception ex) { Successed = false; Message = "失败!"; } return(excel); }