/// <summary> /// 将临时表中的数据复制到订单中 /// </summary> /// <param name="orderId"></param> /// <returns></returns> public static int copyCurrentToOrder(int orderId) { using (var context = new AnnonContext()) { try { //先删除已有orderId的订单 deleteOrder(orderId); var unitOrders = context.UnitCurrentValues .Where(s => s.OrderId == orderId); //将临时表中的数据复制到订单表中 foreach (var unitOrder in unitOrders) { context.UnitOrders.Add(new UnitOrder { PropertyName = unitOrder.PropertyName, Value = unitOrder.Value, OrderId = unitOrder.OrderId, }); } ////删除临时表中的数据 //foreach (var uo in unitOrders) //{ // context.UnitCurrentValues.Remove(uo); //} return context.SaveChanges(); } catch (Exception e) { return -1; } } }
//复制详细订单信息; public static int CopyOrderDetail(int OrderDtIfID,int newOrderID) { using (var context = new AnnonContext()) { try { var od1 = context.orderDetailInfoes .Where(s => s.orderDetailInfoID == OrderDtIfID) .First(); orderDetailInfo od2 = new orderDetailInfo { OrderInfoId = od1.OrderInfoId, OrderDetailNo = newOrderID, Qty = od1.Qty, custPrice = od1.custPrice, listPrice = od1.listPrice, RepPrice = od1.RepPrice, tag = od1.tag, ProDes = od1.ProDes, OrderInfoType=od1.OrderInfoType, OdDetlNum=ReturnLastNum()+1, DeviceId=od1.DeviceId }; context.orderDetailInfoes.Add(od2); return context.SaveChanges(); } catch (System.Exception ex) { return -1; } } }
//复制一条订单; public static int CopyOrder(int orderID) { using (var context = new AnnonContext()) { try { var ois = context.ordersinfoes .Where(s => s.ordersinfoID == orderID) .First(); ordersinfo oi = new ordersinfo { OrderNo=ReturnLastNum()+1, JobNum = ois.JobNum, JobName = ois.JobName, JobDes = ois.JobDes, Site = ois.Site, Customer = ois.Customer, Activity = ois.Activity, AAonCon = ois.AAonCon, }; context.ordersinfoes.Add(oi); return context.SaveChanges(); } catch (Exception e) { return -1; } } }
/// <summary> /// 拷贝订单 /// </summary> /// <param name="orderId"></param> /// <returns></returns> public static int copyOrder(int orderId) { using (var context = new AnnonContext()) { try { int newOrderId = 1; var currentOrder = context.UnitOrders .Select(s => s.OrderId); if (currentOrder.Count() != 0) newOrderId = currentOrder.Max() + 1; var catlogOrders = context.UnitOrders .Where(s => s.OrderId == orderId); foreach (var catlog in catlogOrders) { context.UnitOrders.Add(new UnitOrder { PropertyName = catlog.PropertyName, OrderId = newOrderId, Value = catlog.Value }); } context.SaveChanges(); return newOrderId; } catch (Exception e) { return -1; } } }
/// <summary> /// 将临时表复制到订单表中,在最终需要到订单时保存时需要 /// </summary> /// <param name="orderId"></param> /// <returns></returns> public static int copyCurrentToOrder(int orderId) { using (var context = new AnnonContext()) { try { //先要删除对应orderId的订单 deleteOrder(orderId); var contentCurrentValues = context.ContentCurrentValues .Where(s => s.OrderID == orderId); //将临时表数据复制到订单中 foreach (var ccv in contentCurrentValues) { context.ContentOrders.Add(new ContentOrder { ModuleTag = ccv.ModuleTag, PropertyName = ccv.PropertyName, Value = ccv.Value, ImageName = ccv.ImageName, CoolingPower = ccv.CoolingPower, OrderID = ccv.OrderID, Guid=ccv.Guid, Price=ccv.Price, Items=ccv.Items }); } return context.SaveChanges(); } catch (Exception e) { return -1; } } }
/// <summary> /// 删除制定订单 /// </summary> /// <param name="accessoryId"></param> /// <returns></returns> public static int deleteOrder(int accessoryId) { using (var context = new AnnonContext()) { try { var accessoryOrder = context.AccessoryOrders .Where(s => s.AccessoryOrderID == accessoryId) .First(); context.AccessoryOrders.Remove(accessoryOrder); return context.SaveChanges(); } catch (Exception e) { return -1; } } }
/// <summary> /// 删除约束中的所有内容 /// 可用 /// </summary> /// <returns></returns> public static int DeleteAll() { using (var context = new AnnonContext()) { try { var propertyConstraints = context.PropertyConstraints; foreach (var propertyConstraint in propertyConstraints) { context.PropertyConstraints.Remove(propertyConstraint); } return context.SaveChanges(); } catch (Exception e) { return -1; } } }
public static void DeleteAllCurrentDevices(int orderId, int deviceId) { using (var context = new AnnonContext()) { try { var currentDevices = context.CurrentDevices .Where(s => s.DeviceID == deviceId && s.OrderDetailID == orderId); foreach (var currentDevice in currentDevices) { context.CurrentDevices.Remove(currentDevice); } context.SaveChanges(); } catch (Exception e) { } } }
/// <summary> /// 删除数据库中所有的图块信息 /// </summary> /// <returns></returns> public static int DeleteAll() { using (var context = new AnnonContext()) { try { var imageBlocks = context.ImageBlocks; foreach (var imageBlock in imageBlocks) { context.ImageBlocks.Remove(imageBlock); } return context.SaveChanges(); } catch (Exception e) { return -1; } } }
//删除所有订单数据; public static int DeleteAllOrder() { using (var context = new AnnonContext()) { try { var ois = context.ordersinfoes; foreach (var os in ois) { context.ordersinfoes.Remove(os); } //context.ordersinfoes.Remove(ois); return context.SaveChanges(); } catch (Exception e) { return -1; } } }
//删除所有详细订单信息; public static int DeleteAllOrderDetail() { using (var context = new AnnonContext()) { try { var od = context.orderDetailInfoes; foreach (var odd in od) { context.orderDetailInfoes.Remove(odd); } return context.SaveChanges(); } catch (System.Exception ex) { return -1; } } }
/// <summary> /// 拷贝订单 /// </summary> /// <param name="orderId"></param> /// <param name="newOrderId"></param> /// <returns></returns> public static int copyOrder(int orderId, int newOrderId) { using (var context = new AnnonContext()) { try { var imageModels = context.ImageModels .Where(s => s.OrderId == orderId); foreach (var imageModel in imageModels) { context.ImageModels.Add(new ImageModel { Name=imageModel.Name, X=imageModel.X, Y=imageModel.Y, Width=imageModel.Width, Height=imageModel.Height, Url=imageModel.Url, Type=imageModel.Type, Text=imageModel.Text, coolingType=imageModel.coolingType, FirstDance=imageModel.FirstDance, SecondDance=imageModel.SecondDance, ModuleTag=imageModel.ModuleTag, OrderId=newOrderId, IsSelected=imageModel.IsSelected, ParentName=imageModel.ParentName, Guid=imageModel.Guid }); } return context.SaveChanges(); } catch (Exception e) { return -1; } } }
/// <summary> /// 添加当前设备 /// </summary> /// <param name="deviceId">设备ID</param> /// <param name="propertyId">属性ID</param> /// <param name="propertyValueArray">属性值列表</param> /// <param name="orderDetailId">订单ID</param> /// <param name="propertyValueId">属性当前取值</param> public static void InsertIntoCurrentDevice(int deviceId,int propertyId,string propertyValueArray,int orderDetailId,int propertyValueId) { var currentDevice = new CurrentDevice { DeviceID = deviceId, PropertyID = propertyId, PropertyValueArray = propertyValueArray, OrderDetailID = orderDetailId, PropertyValueId = propertyValueId }; using (var context = new AnnonContext()) { try { context.CurrentDevices.Add(currentDevice); context.SaveChanges(); } catch (Exception e) { } } }
/// <summary> /// 删除所有数据 /// </summary> /// <returns></returns> public static int deleteAll() { using (var context = new AnnonContext()) { try { var accessories = context.Accessories; if (accessories != null && accessories.Count() != 0) { foreach (var accessory in accessories) { context.Accessories.Remove(accessory); } return context.SaveChanges(); } return 0; } catch (Exception e) { return -1; } } }
/// <summary> /// 删除某个订单号的订单 /// </summary> /// <param name="orderId"></param> /// <returns></returns> public static int deleteOrder(int orderId) { using (var context = new AnnonContext()) { try { var imageModels = context.ImageModels .Where(s => s.OrderId == orderId); if (imageModels != null && imageModels.Count() != 0) { foreach (var imageModel in imageModels) { context.ImageModels.Remove(imageModel); } return context.SaveChanges(); } return 0; } catch (Exception e) { return -1; } } }
/// <summary> /// 删除所有图块内容 /// </summary> /// <returns></returns> public static int DeleteAll() { using (var context = new AnnonContext()) { try { var contentPtyValues = context.ContentPropertyValues; foreach (var contentptyValue in contentPtyValues) { context.ContentPropertyValues.Remove(contentptyValue); } return context.SaveChanges(); } catch (Exception e) { return -1; } } }
/// <summary> /// 从datatable将数据导入 /// </summary> /// <param name="dataTable"></param> /// <returns></returns> public static int InsertIntoPropertyFromExcel(DataTable dataTable) { using (var context = new AnnonContext()) { try { foreach (DataRow dataRow in dataTable.Rows) { var imageBlock = new ImageBlock { CoolingPower = Convert.ToInt32(dataRow["CoolingPower"]), ParentName = dataRow["ParentName"].ToString(), ImageName = dataRow["ImageName"].ToString(), ImageLength = float.Parse(dataRow["ImageLength"].ToString()), ImageWidth = float.Parse(dataRow["ImageWidth"].ToString()), ImageHeight = float.Parse(dataRow["ImageHeight"].ToString()), Text = dataRow["Text"].ToString(), FirstDistance = Convert.ToDouble(dataRow["FirstDistance"].ToString()), SecondDistance = Convert.ToDouble(dataRow["SecondDistance"].ToString()), ThirdDistance = Convert.ToDouble(dataRow["ThirdDistance"].ToString()), TopViewFirstDistance = Convert.ToDouble(dataRow["TopViewFirstDistance"].ToString()), TopViewSecondDistance = Convert.ToDouble(dataRow["TopViewSecondDistance"].ToString()) }; context.ImageBlocks.Add(imageBlock); } return context.SaveChanges(); } catch (Exception e) { return -1; } } }
/// <summary> /// 删除临时表 /// </summary> /// <param name="orderId"></param> /// <returns></returns> private static int deleteCurrentValues(int orderId) { using (var context = new AnnonContext()) { try { var unitCurrentValues = context.UnitCurrentValues .Where(s => s.OrderId == orderId); if (unitCurrentValues != null && unitCurrentValues.Count() != 0) { foreach (var ucv in unitCurrentValues) { context.UnitCurrentValues.Remove(ucv); } return context.SaveChanges(); } return 0; } catch (Exception e) { return -1; } } }
/// <summary> /// 保存订单 /// </summary> /// <param name="orderId"></param> /// <param name="propertyName"></param> /// <param name="value"></param> /// <returns></returns> public static int saveOrder(int orderId, string propertyName, string value) { using (var context = new AnnonContext()) { try { var currentUnit = context.UnitCurrentValues .Where(s => s.OrderId == orderId && s.PropertyName == propertyName) .First(); currentUnit.Value = value; return context.SaveChanges(); } catch (Exception e) { return -1; } } }
/// <summary> /// 拷贝订单 /// </summary> /// <param name="orderId"></param> /// <param name="newOrderId"></param> /// <returns></returns> public static int copyOrder(int orderId,int newOrderId) { using (var context = new AnnonContext()) { try { var catlogOrders = context.ContentOrders .Where(s => s.OrderID == orderId); foreach (var catlog in catlogOrders) { context.ContentOrders.Add(new ContentOrder { PropertyName = catlog.PropertyName, OrderID=newOrderId, Value = catlog.Value, ModuleTag=catlog.ModuleTag, ImageName=catlog.ImageName, CoolingPower=catlog.CoolingPower, Price=catlog.Price, Guid=catlog.Guid, Items=catlog.Items }); } return context.SaveChanges(); } catch (Exception e) { return -1; } } }
/// <summary> /// 删除某个orderId的订单 /// </summary> /// <param name="orderId"></param> /// <returns></returns> public static int DeleteCurrentValues(int orderId) { using (var context = new AnnonContext()) { try { var currentValues = context.ContentCurrentValues .Where(s => s.OrderID==orderId); foreach (var cv in currentValues) { context.ContentCurrentValues.Remove(cv); } return context.SaveChanges(); } catch (Exception e) { return -1; } } }
/// <summary> /// 删除所有约束 /// </summary> /// <returns></returns> public static int DeleteAllUnitConstraints() { using (var context = new AnnonContext()) { try { var unitConstraints = context.UnitConstraints; if (unitConstraints != null && unitConstraints.Count() != 0) { foreach (var uc in unitConstraints) { context.UnitConstraints.Remove(uc); } return context.SaveChanges(); } return 0; } catch (Exception e) { return -1; } } }
/// <summary> /// 删除某个orderId的订单 /// </summary> /// <param name="orderId"></param> /// <returns></returns> public static int deleteOrder(int orderId) { using (var context = new AnnonContext()) { try { var unitOrders = context.ContentOrders .Where(s => s.OrderID == orderId); foreach (var unitOrder in unitOrders) { context.ContentOrders.Remove(unitOrder); } return context.SaveChanges(); } catch (Exception e) { return -1; } } }
/// <summary> /// 从excel导数据进来 /// </summary> /// <param name="dataTable"></param> /// <returns></returns> public static int InsertFromExcel(DataTable dataTable) { using (var context = new AnnonContext()) { try { foreach (DataRow dataRow in dataTable.Rows) { var propertyValue = new ContentPropertyValue { CoolingPower = Convert.ToInt32(dataRow["CoolingPower"].ToString()), ImageName = dataRow["ImageName"].ToString(), PropertyName = dataRow["PropertyName"].ToString(), ValueCodeID = Convert.ToInt32(dataRow["ValueCodeID"].ToString()), Value = dataRow["Value"].ToString(), ValueDescription = dataRow["Value"].ToString() + "=" + dataRow["ValueDescription"].ToString(), Price = Convert.ToDecimal(dataRow["Price"].ToString()), Type = dataRow["Type"].ToString(), Default = dataRow["Default"].ToString(), IsReadOnly = dataRow["IsReadOnly"].ToString() }; context.ContentPropertyValues.Add(propertyValue); } return context.SaveChanges(); } catch (Exception e) { return -1; } } }
/// <summary> /// 初始化一个图块的订单,每次初始化都要先删除相同orderID的已存在的记录, /// 每次初始化如果已经存在,则更新moudleTag, 如果不存在则增加订单 /// </summary> /// <param name="guid"></param> /// <param name="coolingPower"></param> /// <param name="imageName"></param> /// <param name="orderId"></param> /// <param name="moduleTag"></param> /// <returns></returns> public static int InitialImageOrder(string guid, int coolingPower, string imageName, int orderId,string moduleTag) { using (var context = new AnnonContext()) { try { var imageOrders = context.ContentCurrentValues .Where(s => s.Guid == guid &&s.CoolingPower==coolingPower &&s.ImageName==imageName &&s.OrderID==orderId); //如果存在此订单,则更新moduleTag,如果不存在则增加 if(imageOrders.Count()!=0) { foreach (var io in imageOrders) { io.ModuleTag = moduleTag; } return context.SaveChanges(); } //如果不存在则新增 var contentPropertyValues = context.ContentPropertyValues .Where(s => s.CoolingPower == coolingPower && s.ImageName == imageName) .Select(s => new { PropertyName = s.PropertyName, Default = s.Default, Value = s.Value }); //得到所有选项 string options = string.Empty; Hashtable hashTable = new Hashtable(); foreach (var cpv in contentPropertyValues) { if (hashTable.Contains(cpv.PropertyName)) hashTable[cpv.PropertyName] += cpv.Value + ","; else hashTable[cpv.PropertyName] = cpv.Value + ","; } //options = options.Substring(0, options.Length - 1); var cotentPtyValues = contentPropertyValues .Select(s => new { PropertyName = s.PropertyName, Default = s.Default }) .Distinct(); foreach (var cpv in cotentPtyValues) { var contentCurrentValue = new ContentCurrentValue { Guid = guid, PropertyName = cpv.PropertyName, //当前选中为默认值 Value = cpv.Default, ImageName = imageName, CoolingPower = coolingPower, OrderID = orderId, Items=hashTable[cpv.PropertyName].ToString(), ModuleTag=moduleTag }; context.ContentCurrentValues.Add(contentCurrentValue); } return context.SaveChanges(); } catch (Exception e) { return -1; } } }
/// <summary> /// 初始化新订单, /// </summary> /// <returns></returns> public static int initialNewOrder() { using (var context = new AnnonContext()) { try { int currentOrderId=1; //得到当前orderId var orderId = context.UnitCurrentValues .Select(s => s.OrderId); if (orderId.Count()!=0) currentOrderId = orderId.Max() + 1; var tempUnitModels = context.UnitModels .Select(s => new { PropertyName = s.Property, Default = s.Default }) .Distinct(); foreach (var unitModel in tempUnitModels) { var orderModel = new UnitCurrentValue { PropertyName=unitModel.PropertyName, Value=unitModel.Default, OrderId = currentOrderId }; context.UnitCurrentValues.Add(orderModel); } context.SaveChanges(); return currentOrderId; } catch (Exception e) { return -1; } } }
/// <summary> /// 图块内容保存订单,此时moudletag不会在变 /// </summary> /// <param name="guid"></param> /// <param name="coolingPower"></param> /// <param name="imageName"></param> /// <param name="orderId"></param> /// <param name="propertyName"></param> /// <param name="value"></param> /// <returns></returns> public static int SaveImageOrder(string guid, int coolingPower, string imageName, int orderId, string propertyName, string value) { using (var context = new AnnonContext()) { try { var contentCurrentValue = context.ContentCurrentValues .Where(s => s.Guid==guid && s.CoolingPower == coolingPower && s.ImageName == imageName && s.OrderID == orderId && s.PropertyName == propertyName) .First(); contentCurrentValue.Value = value; return context.SaveChanges(); } catch (Exception e) { return -1; } } }
/// <summary> /// 从excel导入 /// </summary> /// <param name="dataTable"></param> /// <returns></returns> public static int InsertFromExcel(DataTable dataTable) { using (var context = new AnnonContext()) { try { foreach (DataRow dataRow in dataTable.Rows) { var unitModel = new UnitModel { Property = dataRow["Property"].ToString(), Value = dataRow["Value"].ToString(), ValueDescription = dataRow["Value"].ToString() + "=" + dataRow["ValueDescription"].ToString(), Condition = dataRow["Condition"].ToString(), Default=dataRow["Default"].ToString(), IsReadOnly = dataRow["IsReadOnly"].ToString() }; context.UnitModels.Add(unitModel); } return context.SaveChanges(); } catch (Exception e) { return -1; } } }
/// <summary> /// 保存选项 /// </summary> /// <param name="propertyName"></param> /// <param name="orderId"></param> /// <param name="coolingPower"></param> /// <param name="imageName"></param> /// <param name="guid"></param> /// <param name="options"></param> /// <returns></returns> private static int saveOptions(string propertyName, int orderId, int coolingPower, string imageName, string guid,string options) { using (var context = new AnnonContext()) { try { var contentCurrentValue = context.ContentCurrentValues .Where(s => s.OrderID == orderId && s.ImageName == imageName && s.PropertyName == propertyName && s.Guid == guid) .First(); if (!options.Split(',').Contains(contentCurrentValue.Value)) contentCurrentValue.Value = options.Split(',').First(); contentCurrentValue.Items = options; return context.SaveChanges(); } catch (Exception e) { return -1; } } }
/// <summary> /// 导入unitmodel /// </summary> /// <param name="dataTable"></param> /// <returns></returns> public static int InsertUnitConstraintFromExcel(DataTable dataTable) { using (var context = new AnnonContext()) { try { foreach (DataRow dataRow in dataTable.Rows) { var unitConstraint = new UnitConstraint { PropertyName = dataRow["PropertyName"].ToString(), InfluencedPropertyName = dataRow["InfluencedPropertyName"].ToString() }; context.UnitConstraints.Add(unitConstraint); } return context.SaveChanges(); } catch (Exception e) { return -1; } } }