public List <ByDataDto> SelectrDataPart(ByDataModel model)
{
List <ByDataDto> list = new List <ByDataDto>();
if (model.StartDateTime != null || model.EndDateTime != null)
{
list = DapperService.SqlHelp.PartByData(model);
}
return(list);
}
/// <summary>
/// 根据时间段获取部件原始数据
/// </summary>
public static List <ByDataDto> PartByData(ByDataModel model)
{
List <ByDataDto> list;
using (IDbConnection conn = MySqlConnection())
{
// TimeZone.CurrentTimeZone.ToLocalTime(model.StartDateTime);
var p = new DynamicParameters();
p.Add("@_DateTimeStart", model.StartDateTime);
p.Add("@_DateTimeEnd", model.EndDateTime);
p.Add("@_Station", model.Station);
p.Add("@_Area", model.Area);
list = conn.Query <ByDataDto>("SP_DataPart_QueryByDate", p, commandType: CommandType.StoredProcedure)
.ToList();
}
return(list);
}
/// <summary>
/// 根据时间段查询扭矩原始数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static List <ByDataDto> TorqByData(ByDataModel model)
{
List <ByDataDto> dataTable;
using (IDbConnection conn = MySqlConnection())
{
var p = new DynamicParameters();
p.Add("@_DateTimeStart", model.StartDateTime);
p.Add("@_DateTimeEnd", model.EndDateTime);
p.Add("@_Station", model.Station);
p.Add("@_Area", model.Area);
dataTable = conn
.Query <ByDataDto>("SP_DataTorq_QueryByDate", p, commandType: CommandType.StoredProcedure)
.ToList();
}
return(dataTable);
}
public JsonResult ByDataParyToExcel(ByDataModel model)
{
var Successed = true;
var Message = "";
string s = "";
List <ByDataDto> list = SelectrDataPart(model).ToList();
try
{
if (list.Count != 0)
{
Message = "导出成功！";
JavaScriptSerializer json = new JavaScriptSerializer();
json.MaxJsonLength = Int32.MaxValue;
s = json.Serialize(list);
//Dictionary<string, string> dic = new Dictionary<string, string>();
//dic.Add("ProdDateTime", "开始时间");
//dic.Add("BarCode_zc", "总成条码");
//dic.Add("Station", "站点");
//dic.Add("Barcode_part", "部件条码");
//dic.Add("PartName", "部件名称");
//dic.Add("Part_figure_no", "部件图号");
//dic.Add("cartype", "车型");
//dic.Add("ScanStatus", "扫描状态");
//ExExcel(list, dic, "部件时间查询结果表");
}
}
catch (Exception e)
{
Successed = false;
Message = "导出失败！";
}
return(Json(new ResExportDto()
{
excel = s, mess = Message, success = Successed
}, JsonRequestBehavior.AllowGet));
}
