public ActionResult Index(string BarcodeStr, string Area)
{
try
{
ByCodeModel model = new ByCodeModel();
model.BarCode = BarcodeStr.Trim();
ViewBag.title = CommonHelp.list.Where(p => p.Area.Equals(Area)).FirstOrDefault().DesCribe;
model.Area = Area;
model.Station = "All";
string keyTorq = BarcodeStr + model.Area + "Torq";
string keyPart = BarcodeStr + model.Area + "Part";
CommonHelp.keyPart = keyPart;
CommonHelp.keyTorq = keyTorq;
if (CommonBuffer.Exist(keyTorq) && CommonBuffer.Exist(keyPart))
{
ViewBag.Torq = CommonBuffer.Get <List <ByCodeDto> >(keyTorq);
ViewBag.Part = CommonBuffer.Get <List <ByCodeDto> >(keyPart);
}
else
{
ViewBag.Torq = CommonBuffer.FindT(keyTorq, SelectByCodeInfo, model);
ViewBag.Part = CommonBuffer.FindT(keyPart, SelectCodePart, model);
}
}
catch (Exception ex)
{
}
return(View());
}
/// <summary>
/// 根据条码查询部件
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public List <ByCodeDto> SelectCodePart(ByCodeModel model)
{
List <ByCodeDto> list = new List <ByCodeDto>();
if (model.BarCode != null)
{
list = DapperService.SqlHelp.PartByCode(model).OrderBy(p => p.ProdDateTime).ToList();
}
return(list);
}
/// <summary>
/// 根据条码查询扭矩
/// </summary>
public List <ByCodeDto> SelectByCodeInfo(ByCodeModel model)
{
List <ByCodeDto> list = new List <ByCodeDto>();
if (model.BarCode != null)
{
list = DapperService.SqlHelp.TorqByCode(model);
}
return(list);
}
public List <PartDetailToExcelDto> SelectCodePart(ByCodeModel model)
{
List <PartDetailToExcelDto> list = new List <PartDetailToExcelDto>();
if (model.BarCode != null)
{
list = DapperService.SqlHelp.PartToExcel(model);
}
return(list);
}
/// <summary>
/// 根据条码查询扭矩原始数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static List <ByCodeDto> TorqByCode(ByCodeModel model)
{
List <ByCodeDto> dataTable;
using (IDbConnection conn = MySqlConnection())
{
var p = new DynamicParameters();
p.Add("@_Barcode_zc", model.BarCode);
p.Add("@_Station", model.Station);
p.Add("@_Area", model.Area);
dataTable = conn.Query <ByCodeDto>("SP_DataTorq_QueryByBarcodeZC", p,
commandType: CommandType.StoredProcedure).ToList();
}
return(dataTable);
}
