////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.DBManager //{ // public class ProductionDetectionRecordsDetailManager : ModelManager // { // DbProviderFactory Dbfactory = SQLiteFactory.Instance; // protected override void ActionBeforeNewModel(DBModel context, ProductionDetectionRecordsDetail config) // { // CheckProductionCodeDuplicate(context, config); // } // protected override void ActionBeforeUpdateModel(DBModel context, ProductionDetectionRecordsDetail config) // { // CheckProductionCodeDuplicate(context, config); // } // private void CheckProductionCodeDuplicate(DBModel context, ProductionDetectionRecordsDetail config) // { // //if (context.ProductionDetectionRecordsDetail.Any(u => u.IS_DELETED == 0 // // && u.ID != config.ID // // && u.PRODUCTION_CODE == config.PRODUCTION_CODE)) // { // //throw new ProcessException("新增或修改的产品配置信息的产品代码不能重复", null); // } // } // public List GetProductionDetectionRecordsDetail(string productionBatchNO, string pid) // { // using (DBModel context = new DBModel()) // { // var list = context.ProductionDetectionRecordsDetail.Where(u => u.IS_DELETED == 0 && u.OfflineDetectionId == null); // 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 GetProductionDetectionRecordsDetailPagedList(ProductionDetectionRecordsDetailRequest request) // { // using (DBModel context = new DBModel()) // { // var list = context.ProductionDetectionRecordsDetail.Where(u => u.IS_DELETED == 0); // if (!string.IsNullOrWhiteSpace(request.ProductionBatchNO)) // { // list = list.Where(u => u.ProductionBatchNO.Contains(request.ProductionBatchNO)); // } // if (!string.IsNullOrWhiteSpace(request.PId)) // { // list = list.Where(u => u.PId.Contains(request.PId)); // } // if (!string.IsNullOrWhiteSpace(request.Detection)) // { // list = list.Where(u => u.Detection.Contains(request.Detection)); // } // if (!string.IsNullOrWhiteSpace(request.DefectName)) // { // list = list.Where(u => u.DefectName.Contains(request.DefectName)); // } // if (!string.IsNullOrWhiteSpace(request.Result)) // { // list = list.Where(u => u.Result == request.Result); // } // if (request.StartTime != null) // { // list = list.Where(u => u.Time >= request.StartTime); // } // if (request.EndTime != null) // { // list = list.Where(u => u.Time <= request.EndTime); // } // var pageList = list.OrderBy(u => u.Time).ToPagedList(request); // request.TotalNum = list.Count(); // return pageList; // } // } // public ProductionDetectionRecordsDetail GetConfigByProductionCode(string productionCode) // { // using (DBModel context = new DBModel()) // { // //ProductionDetectionRecordsDetail RR= context.ProductionDetectionRecordsDetail.FirstOrDefault(u => u.IS_DELETED == 0 && u.PRODUCTION_CODE == productionCode); // //return RR; // return new ProductionDetectionRecordsDetail(); // } // } // public void ADOBatchAdd(List 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 ProductionDetectionRecordsDetail ("); // 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 parameters = new List(); // 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 records) // { // try // { // using (SQLiteConnection conn = new SQLiteConnection(ConnectionString)) // { // using (SQLiteCommand insertRngCmd = (SQLiteCommand)conn.CreateCommand()) // { // StringBuilder strSql = new StringBuilder(); // strSql.Append("insert into ProductionDetectionRecordsDetail ("); // strSql.Append("ID,ProductionBatchNO,PId,Result,Time,DetectionSource,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,ImageRecordId"); // strSql.Append(")values ("); // strSql.Append("@ID,@ProductionBatchNO,@PId,@Result,@Time,@DetectionSource,@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,@ImageRecordId)"); // 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("@Result", record.Result); // insertRngCmd.Parameters.AddWithValue("@Time", record.Time); // insertRngCmd.Parameters.AddWithValue("@DetectionSource", record.DetectionSource); // insertRngCmd.Parameters.AddWithValue("@Detection", record.Detection); // insertRngCmd.Parameters.AddWithValue("@DefectName", record.DefectName); // insertRngCmd.Parameters.AddWithValue("@Probability", record.Probability); // insertRngCmd.Parameters.AddWithValue("@Uncertainty", record.Uncertainty); // insertRngCmd.Parameters.AddWithValue("@DefectX", record.DefectX); // insertRngCmd.Parameters.AddWithValue("@DefectY", record.DefectY); // insertRngCmd.Parameters.AddWithValue("@DefectWidth", record.DefectWidth); // insertRngCmd.Parameters.AddWithValue("@DefectHeight", record.DefectHeight); // 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("@DetectionType", record.DetectionType); // insertRngCmd.Parameters.AddWithValue("@SpecStandard", record.SpecStandard); // insertRngCmd.Parameters.AddWithValue("@SpecActualValue", record.SpecActualValue); // 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.Parameters.AddWithValue("@ImageRecordId", record.ImageRecordId); // insertRngCmd.ExecuteNonQuery(); // } // transaction.Commit(); // } // } // } // catch (Exception ex) // { // throw new ProcessException(ex.Message, null); // } // } // public bool IsExistId(string id) // { // using (DBModel context = new DBModel()) // { // ProductionDetectionRecordsDetail RR = context.ProductionDetectionRecordsDetail.FirstOrDefault(u => u.ID == id); // return RR != null; // } // } // } //}