/// <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;
}
}
}
