////using Bro.Process.Common.Helper;
|
//using Bro.Common.Helper;
|
//using Bro.Process.Model;
|
//using Bro.Process.Model.Model;
|
//using System;
|
//using System.Collections;
|
//using System.Collections.Generic;
|
//using System.Configuration;
|
//using System.Data;
|
//using System.Data.Common;
|
//using System.Data.SQLite;
|
//using System.Diagnostics;
|
//using System.Linq;
|
//using System.Text;
|
//using System.Threading.Tasks;
|
|
//namespace Bro.M071.Process.DBManager
|
//{
|
// public class ProductionDetectionImageRecordsManager : ModelManager<ProductionDetectionImageRecords>
|
// {
|
// DbProviderFactory Dbfactory = SQLiteFactory.Instance;
|
// protected override void ActionBeforeNewModel(DBModel context, ProductionDetectionImageRecords config)
|
// {
|
// CheckProductionCodeDuplicate(context, config);
|
// }
|
|
// protected override void ActionBeforeUpdateModel(DBModel context, ProductionDetectionImageRecords config)
|
// {
|
// CheckProductionCodeDuplicate(context, config);
|
// }
|
|
// private void CheckProductionCodeDuplicate(DBModel context, ProductionDetectionImageRecords config)
|
// {
|
// //if (context.ProductionDetectionImageRecords.Any(u => u.IS_DELETED == 0
|
// // && u.ID != config.ID
|
// // && u.PRODUCTION_CODE == config.PRODUCTION_CODE))
|
// {
|
// //throw new ProcessException("新增或修改的产品配置信息的产品代码不能重复", null);
|
// }
|
// }
|
|
// public List<ProductionDetectionImageRecords> GetProductionDetectionImageRecords(string productionBatchNO, string pid)
|
// {
|
// using (DBModel context = new DBModel())
|
// {
|
// var list = context.ProductionDetectionImageRecords.Where(u => u.IS_DELETED == 0);
|
|
// if (!string.IsNullOrWhiteSpace(productionBatchNO))
|
// {
|
// list = list.Where(u => u.ProductionBatchNO.Contains(productionBatchNO));
|
// }
|
// if (!string.IsNullOrWhiteSpace(pid))
|
// {
|
// list = list.Where(u => u.PId.Contains(pid));
|
// }
|
|
// var resultList = list.ToList();
|
// return resultList;
|
// }
|
// }
|
// //public List<ProductionStatistics_Dto> GetOperationRecordsList(OperationRecordsRequest request)
|
// //{
|
// // using (DBModel context = new DBModel())
|
// // {
|
// // var oList = context.OperationRecords.Where(u => u.IS_DELETED == 0);
|
// // var pList = context.ProductionDetectionRecords.Where(u => u.IS_DELETED == 0);
|
// // if (!string.IsNullOrWhiteSpace(request.ProductionBatchNO))
|
// // {
|
// // oList = oList.Where(u => u.ProductionBatchNO.Contains(request.ProductionBatchNO));
|
// // }
|
// // if (!string.IsNullOrWhiteSpace(request.UserNO))
|
// // {
|
// // oList = oList.Where(u => u.UserNO.Contains(request.UserNO));
|
// // }
|
// // if (request.StartTime != null)
|
// // {
|
// // oList = oList.Where(u => u.OperationStartTime >= request.StartTime);
|
// // }
|
// // if (request.EndTime != null)
|
// // {
|
// // oList = oList.Where(u => u.OperationStartTime <= request.EndTime);
|
// // }
|
|
// // var query = from operationRecords in oList
|
// // join productionDetectionRecords in pList
|
// // on operationRecords.ID equals productionDetectionRecords.OperationRecordsId
|
// // into opList
|
// // select new ProductionStatistics_Dto
|
// // {
|
// // OperationRecordsRowData = operationRecords,
|
// // BatchProductionTotalCount = opList.Where(u => u.ProductionBatchNO == operationRecords.ProductionBatchNO).Count(),
|
// // BatchProductionOKCount = opList.Where(u => u.ProductionBatchNO == operationRecords.ProductionBatchNO && u.Result == "OK").Count(),
|
// // BatchProductionNGCount = opList.Where(u => u.ProductionBatchNO == operationRecords.ProductionBatchNO && u.Result == "NG").Count(),
|
// // BatchProductionTBDCount = opList.Where(u => u.ProductionBatchNO == operationRecords.ProductionBatchNO && u.Result == "TBD").Count(),
|
// // IsSelected = false,
|
// // };
|
// // var pageList = query.OrderBy(u => u.OperationRecordsRowData.OperationStartTime).ToPagedList(request);
|
// // request.TotalNum = oList.Count();
|
// // return pageList;
|
// // }
|
// //}
|
// public List<ProductionDetectionImageRecords_Dto> GetProductionDetectionImageRecordsPagedList(ProductionDetectionImageRecordsRequest request)
|
// {
|
// using (DBModel context = new DBModel())
|
// {
|
// var imageRecordsList = context.ProductionDetectionImageRecords.Where(u => u.IS_DELETED == 0);
|
// var detectionRecordsList = context.ProductionDetectionRecordsDetail.Where(u => u.IS_DELETED == 0);
|
// var manualDetectionRecordsList = context.ManualDetectionRecords.Where(u => u.IS_DELETED == 0);
|
// if (!string.IsNullOrWhiteSpace(request.ProductionBatchNO))
|
// {
|
// imageRecordsList = imageRecordsList.Where(u => u.ProductionBatchNO.Contains(request.ProductionBatchNO));
|
// }
|
// if (!string.IsNullOrWhiteSpace(request.PId))
|
// {
|
// imageRecordsList = imageRecordsList.Where(u => u.PId.Contains(request.PId));
|
// }
|
// if (!string.IsNullOrWhiteSpace(request.Detection))
|
// {
|
// imageRecordsList = imageRecordsList.Where(u => u.Detection.Contains(request.Detection));
|
// }
|
// if (!string.IsNullOrWhiteSpace(request.DefectName))
|
// {
|
// imageRecordsList = imageRecordsList.Where(u => u.DefectNameList.Contains(request.DefectName));
|
// }
|
// if (!string.IsNullOrWhiteSpace(request.ManualDefectName))
|
// {
|
// imageRecordsList = imageRecordsList.Where(u => u.ManualDefectNameList.Contains(request.ManualDefectName));
|
// }
|
// if (!string.IsNullOrWhiteSpace(request.Result))
|
// {
|
// imageRecordsList = imageRecordsList.Where(u => u.Result == request.Result);
|
// }
|
// if (!string.IsNullOrWhiteSpace(request.ManualResult))
|
// {
|
// manualDetectionRecordsList = manualDetectionRecordsList.Where(u => u.ManualResult == request.ManualResult);
|
// }
|
// if (request.StartTime != null)
|
// {
|
// imageRecordsList = imageRecordsList.Where(u => u.Time >= request.StartTime);
|
// }
|
// if (request.EndTime != null)
|
// {
|
// imageRecordsList = imageRecordsList.Where(u => u.Time <= request.EndTime);
|
// }
|
|
// var query = from imageRecord in imageRecordsList
|
// join manualDetectionRecords in manualDetectionRecordsList on imageRecord.OriginalImgPath equals manualDetectionRecords.OriginalImgPath
|
// join detectionRecords in detectionRecordsList on imageRecord.ID equals detectionRecords.ImageRecordId
|
// into imageDetectionRecord
|
|
// select new ProductionDetectionImageRecords_Dto
|
// {
|
// ProductionDetectionImageRecordsRowData = imageRecord,
|
// ManualDetectionRecords = manualDetectionRecords,
|
// ProductionDetectionRecordsDetailList = detectionRecordsList.Where(u => u.ImageRecordId == imageRecord.ID)
|
// };
|
// var pageList = query.OrderBy(u => u.ProductionDetectionImageRecordsRowData.CREATE_TIME).ToPagedList(request);
|
// request.TotalNum = imageRecordsList.Count();
|
|
// return pageList;
|
// }
|
// }
|
|
// public ProductionDetectionImageRecords GetConfigByProductionCode(string productionCode)
|
// {
|
// using (DBModel context = new DBModel())
|
// {
|
// //ProductionDetectionImageRecords RR= context.ProductionDetectionImageRecords.FirstOrDefault(u => u.IS_DELETED == 0 && u.PRODUCTION_CODE == productionCode);
|
// //return RR;
|
// return new ProductionDetectionImageRecords();
|
// }
|
// }
|
// public void ADOBatchAdd(List<ProductionDetectionImageRecords> records)
|
// {
|
// Hashtable SQLStringList = new Hashtable();
|
// try
|
// {
|
// var idList = records.Select(u => u.ID).ToList();
|
// var disIdList = idList.Distinct().ToList();
|
// if (idList.Count != disIdList.Count)//有重复id
|
// {
|
// throw new ProcessException("异常：有重复id:" + idList.ToString(), null);
|
// }
|
// //foreach (var record in records)
|
// //{
|
// // if (IsExistId(record.ID))
|
// // {
|
// // throw new ProcessException("异常：有重复id:" + record.ID, null);
|
// // }
|
// // StringBuilder strSql = new StringBuilder();
|
// // strSql.Append("insert into ProductionDetectionImageRecords (");
|
// // strSql.Append("ID,ProductionBatchNO,PId,Result,Time,Detection,DefectName,Probability,Uncertainty,DefectX,DefectY,DefectWidth,DefectHeight, RawImgPath,DefectImgPath,ImageTime,PreElapsed,DefectElapsed,AfterElapsed,TotalElapsed,PreTreatedFlag,DetectionType, SpecStandard, SpecActualValue,IS_DISABLED,IS_DELETED,CREATE_USER,CREATE_TIME, UPDATE_USER,UPDATE_TIME");
|
// // strSql.Append(")values (");
|
// // strSql.Append("@ID,@ProductionBatchNO,@PId,@Result,@Time,@Detection,@DefectName,@Probability,@Uncertainty,@DefectX,@DefectY,@DefectWidth,@DefectHeight,@RawImgPath,@DefectImgPath,@ImageTime,@PreElapsed,@DefectElapsed,@AfterElapsed,@TotalElapsed,@PreTreatedFlag,@DetectionType,@SpecStandard,@SpecActualValue,@IS_DISABLED,@IS_DELETED,@CREATE_USER,@CREATE_TIME,@UPDATE_USER,@UPDATE_TIME)");
|
// // List<SQLiteParameter> parameters = new List<SQLiteParameter>();
|
// // parameters.Add(new SQLiteParameter("@ID", record.ID));
|
// // parameters.Add(new SQLiteParameter("@ProductionBatchNO", record.ProductionBatchNO));
|
// // parameters.Add(new SQLiteParameter("@PId", record.PId));
|
// // parameters.Add(new SQLiteParameter("@Result", record.Result));
|
// // parameters.Add(new SQLiteParameter("@Time", record.Time));
|
// // parameters.Add(new SQLiteParameter("@Detection", record.Detection));
|
// // parameters.Add(new SQLiteParameter("@DefectName", record.DefectName));
|
// // parameters.Add(new SQLiteParameter("@Probability", record.Probability));
|
// // parameters.Add(new SQLiteParameter("@Uncertainty", record.Uncertainty));
|
// // parameters.Add(new SQLiteParameter("@DefectX", record.DefectX));
|
// // parameters.Add(new SQLiteParameter("@DefectY", record.DefectY));
|
// // parameters.Add(new SQLiteParameter("@DefectWidth", record.DefectWidth));
|
// // parameters.Add(new SQLiteParameter("@DefectHeight", record.DefectHeight));
|
// // parameters.Add(new SQLiteParameter("@RawImgPath", record.RawImgPath));
|
// // parameters.Add(new SQLiteParameter("@DefectImgPath", record.DefectImgPath));
|
// // parameters.Add(new SQLiteParameter("@ImageTime", record.ImageTime));
|
// // parameters.Add(new SQLiteParameter("@PreElapsed", record.PreElapsed));
|
// // parameters.Add(new SQLiteParameter("@DefectElapsed", record.DefectElapsed));
|
// // parameters.Add(new SQLiteParameter("@AfterElapsed", record.AfterElapsed));
|
// // parameters.Add(new SQLiteParameter("@TotalElapsed", record.TotalElapsed));
|
// // parameters.Add(new SQLiteParameter("@PreTreatedFlag", record.PreTreatedFlag));
|
// // parameters.Add(new SQLiteParameter("@DetectionType", record.DetectionType));
|
// // parameters.Add(new SQLiteParameter("@SpecStandard", record.SpecStandard));
|
// // parameters.Add(new SQLiteParameter("@SpecActualValue", record.SpecActualValue));
|
// // parameters.Add(new SQLiteParameter("@IS_DISABLED", record.IS_DISABLED));
|
// // parameters.Add(new SQLiteParameter("@IS_DELETED", record.IS_DELETED));
|
// // parameters.Add(new SQLiteParameter("@CREATE_USER", record.CREATE_USER));
|
// // parameters.Add(new SQLiteParameter("@CREATE_TIME", record.CREATE_TIME));
|
// // parameters.Add(new SQLiteParameter("@UPDATE_USER", record.UPDATE_USER));
|
// // parameters.Add(new SQLiteParameter("@UPDATE_TIME", record.UPDATE_TIME));
|
|
// // SQLStringList.Add(strSql, parameters.ToArray());
|
// //}
|
// SQLiteHelper.ExecuteSqlTran(SQLStringList); //使用数据库事务
|
// }
|
// catch (Exception ex)
|
// {
|
// throw new ProcessException(SQLStringList.ToString() + ex.Message, null);
|
// }
|
// }
|
|
// public void InserPatch(List<ProductionDetectionImageRecords> records)
|
// {
|
// try
|
// {
|
// using (SQLiteConnection conn = new SQLiteConnection(ConnectionString))
|
// {
|
// using (SQLiteCommand insertRngCmd = (SQLiteCommand)conn.CreateCommand())
|
// {
|
// StringBuilder strSql = new StringBuilder();
|
// strSql.Append("insert into ProductionDetectionImageRecords (");
|
// strSql.Append("ID,ProductionBatchNO,PId,ManualResult,Result,Time,DetectionSource,Detection,DefectNameList,ManualDefectNameList,RawImgPath,DefectImgPath,ImageTime,PreElapsed,DefectElapsed,AfterElapsed,TotalElapsed,PreTreatedFlag,OriginalImgPath,IS_DISABLED,IS_DELETED,CREATE_USER,CREATE_TIME, UPDATE_USER,UPDATE_TIME");
|
// strSql.Append(")values (");
|
// strSql.Append("@ID,@ProductionBatchNO,@PId,@ManualResult,@Result,@Time,@DetectionSource,@Detection,@DefectNameList,@ManualDefectNameList,@RawImgPath,@DefectImgPath,@ImageTime,@PreElapsed,@DefectElapsed,@AfterElapsed,@TotalElapsed,@PreTreatedFlag,@OriginalImgPath,@IS_DISABLED,@IS_DELETED,@CREATE_USER,@CREATE_TIME,@UPDATE_USER,@UPDATE_TIME)");
|
|
// insertRngCmd.CommandText = strSql.ToString();
|
// conn.Open();
|
// var transaction = conn.BeginTransaction();
|
|
// foreach (var record in records)
|
// {
|
// insertRngCmd.Parameters.AddWithValue("@ID", record.ID);
|
// insertRngCmd.Parameters.AddWithValue("@ProductionBatchNO", record.ProductionBatchNO);
|
// insertRngCmd.Parameters.AddWithValue("@PId", record.PId);
|
// insertRngCmd.Parameters.AddWithValue("@ManualResult", record.ManualResult);
|
// insertRngCmd.Parameters.AddWithValue("@Result", record.Result);
|
// insertRngCmd.Parameters.AddWithValue("@Time", record.Time);
|
// insertRngCmd.Parameters.AddWithValue("@DetectionSource", record.DetectionSource);
|
// insertRngCmd.Parameters.AddWithValue("@Detection", record.Detection);
|
// insertRngCmd.Parameters.AddWithValue("@DefectNameList", record.DefectNameList);
|
// insertRngCmd.Parameters.AddWithValue("@ManualDefectNameList", record.ManualDefectNameList);
|
// insertRngCmd.Parameters.AddWithValue("@RawImgPath", record.RawImgPath);
|
// insertRngCmd.Parameters.AddWithValue("@DefectImgPath", record.DefectImgPath);
|
// insertRngCmd.Parameters.AddWithValue("@ImageTime", record.ImageTime);
|
// insertRngCmd.Parameters.AddWithValue("@PreElapsed", record.PreElapsed);
|
// insertRngCmd.Parameters.AddWithValue("@DefectElapsed", record.DefectElapsed);
|
// insertRngCmd.Parameters.AddWithValue("@AfterElapsed", record.AfterElapsed);
|
// insertRngCmd.Parameters.AddWithValue("@TotalElapsed", record.TotalElapsed);
|
// insertRngCmd.Parameters.AddWithValue("@PreTreatedFlag", record.PreTreatedFlag);
|
// insertRngCmd.Parameters.AddWithValue("@OriginalImgPath", record.OriginalImgPath);
|
// insertRngCmd.Parameters.AddWithValue("@IS_DISABLED", record.IS_DISABLED);
|
// insertRngCmd.Parameters.AddWithValue("@IS_DELETED", record.IS_DELETED);
|
// insertRngCmd.Parameters.AddWithValue("@CREATE_USER", record.CREATE_USER);
|
// insertRngCmd.Parameters.AddWithValue("@CREATE_TIME", record.CREATE_TIME);
|
// insertRngCmd.Parameters.AddWithValue("@UPDATE_USER", record.UPDATE_USER);
|
// insertRngCmd.Parameters.AddWithValue("@UPDATE_TIME", record.UPDATE_TIME);
|
// insertRngCmd.ExecuteNonQuery();
|
// }
|
// transaction.Commit();
|
// }
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// throw new ProcessException(ex.Message, null);
|
// }
|
// }
|
|
// public bool IsExistId(string id)
|
// {
|
// using (DBModel context = new DBModel())
|
// {
|
// ProductionDetectionImageRecords RR = context.ProductionDetectionImageRecords.FirstOrDefault(u => u.ID == id);
|
// return RR != null;
|
// }
|
// }
|
// }
|
//}
|
