// JObject here is very very important...
public ActionResult <string> Post([FromBody] JObject entityObj)
{
ORDER_LIST_DETAIL postedEntity = entityObj.ToObject <ORDER_LIST_DETAIL>();
// 校验主键
if (String.IsNullOrEmpty(postedEntity.ORDER_NO))
{
return("");
}
var orderListEntity = myContext.ORDER_LIST_DETAIL
.Where(d => d.ORDER_NO.Equals(postedEntity.ORDER_NO) && d.BUMP_ID.Equals(postedEntity.BUMP_ID));
if (orderListEntity.Count() == 0)
{
// INSERT
// MAKE BUMP ID
postedEntity.BUMP_ID = postedEntity.BUMP_TYPE + "_" + postedEntity.MATERIAL;
myContext.ORDER_LIST_DETAIL.Add(postedEntity);
myContext.SaveChanges();
return("");
}
else
{
orderListEntity.First().BUMP_NM = postedEntity.BUMP_NM;
orderListEntity.First().STATION = postedEntity.STATION;
orderListEntity.First().BUMP_TYPE = postedEntity.BUMP_TYPE;
orderListEntity.First().NUMBER = postedEntity.NUMBER;
orderListEntity.First().FLOW = postedEntity.FLOW;
orderListEntity.First().LIFT = postedEntity.LIFT;
orderListEntity.First().MATERIAL = postedEntity.MATERIAL;
orderListEntity.First().SEAL = postedEntity.SEAL;
orderListEntity.First().STATUS = postedEntity.STATUS;
orderListEntity.First().REMARK = postedEntity.REMARK;
myContext.SaveChanges();
return("");
}
}
// JObject here is very very important...
public ActionResult <string> Post([FromBody] JObject entityObj)
{
ORDER_LIST_DETAIL_DICT_NAME postedEntity = entityObj.ToObject <ORDER_LIST_DETAIL_DICT_NAME>();
// 校验主键
if (String.IsNullOrEmpty(postedEntity.ORDER_NO))
{
return("");
}
var orderListEntity = myContext.ORDER_LIST_DETAIL
.Where(d => d.ORDER_NO.Equals(postedEntity.ORDER_NO) && d.BUMP_ID.Equals(postedEntity.BUMP_ID));
if (orderListEntity.Count() == 0)
{
// INSERT
ORDER_LIST_DETAIL postedEntity1 = new ORDER_LIST_DETAIL();
postedEntity1.ORDER_NO = postedEntity.ORDER_NO;
// MAKE BUMP ID
postedEntity1.BUMP_ID = postedEntity.BUMP_TYPE + "_" + postedEntity.MATERIAL_BUMP;
postedEntity1.BUMP_NM = postedEntity.BUMP_NM;
postedEntity1.BUMP_TYPE = postedEntity.BUMP_TYPE;
postedEntity1.NUMBER = postedEntity.NUMBER;
postedEntity1.UNIT = postedEntity.UNIT;
postedEntity1.PRICE = postedEntity.PRICE;
postedEntity1.AMOUNT = postedEntity.AMOUNT;
postedEntity1.BUMP_SERIAL_NO = postedEntity.BUMP_SERIAL_NO;
postedEntity1.FLOW = postedEntity.FLOW;
postedEntity1.LIFT = postedEntity.LIFT;
postedEntity1.MATERIAL_BUMP = postedEntity.MATERIAL_BUMP;
postedEntity1.MATERIAL_FAN = postedEntity.MATERIAL_FAN;
postedEntity1.MATERIAL_ROLLER = postedEntity.MATERIAL_ROLLER;
postedEntity1.MOTOR_BRAND = postedEntity.MOTOR_BRAND;
postedEntity1.MOTOR_DEMAND = postedEntity.MOTOR_DEMAND;
postedEntity1.SEAL_FORM = postedEntity.SEAL_FORM;
postedEntity1.SEAL_BRAND = postedEntity.SEAL_BRAND;
postedEntity1.ROLLER_BRAND = postedEntity.ROLLER_BRAND;
postedEntity1.COUPLING = postedEntity.COUPLING;
postedEntity1.SEAL_COOLER = postedEntity.SEAL_COOLER;
postedEntity1.CAVITATION_ALLOWANCE = postedEntity.CAVITATION_ALLOWANCE;
postedEntity1.ACTUAL_BUMP_SPEED = postedEntity.ACTUAL_BUMP_SPEED;
postedEntity1.STATION = postedEntity.STATION;
postedEntity1.TEMPERATURE = postedEntity.TEMPERATURE;
postedEntity1.DENSITY = postedEntity.DENSITY;
postedEntity1.IN_PRESSURE = postedEntity.IN_PRESSURE;
postedEntity1.MEDIUM = postedEntity.MEDIUM;
postedEntity1.VISCOSITY = postedEntity.VISCOSITY;
postedEntity1.PARTICULATES = postedEntity.PARTICULATES;
postedEntity1.WORKING_PRESSURE = postedEntity.WORKING_PRESSURE;
postedEntity1.FLANGES_STANDARD = postedEntity.FLANGES_STANDARD;
postedEntity1.FLANGES_LEVEL = postedEntity.FLANGES_LEVEL;
postedEntity1.BASE = postedEntity.BASE;
postedEntity1.COUPLING_HOOD = postedEntity.COUPLING_HOOD;
postedEntity1.ANCHOR_BOLT = postedEntity.ANCHOR_BOLT;
postedEntity1.PAINT = postedEntity.PAINT;
postedEntity1.SURFACE_TREATMENT = postedEntity.SURFACE_TREATMENT;
postedEntity1.PACKAGE = postedEntity.PACKAGE;
postedEntity1.TRANSPORT = postedEntity.TRANSPORT;
postedEntity1.SEAL_BRAND_MANUAL = String.IsNullOrEmpty(postedEntity.SEAL_BRAND_MANUAL) ? "" : postedEntity.SEAL_BRAND_MANUAL;
myContext.ORDER_LIST_DETAIL.Add(postedEntity1);
myContext.SaveChanges();
return("");
}
else
{
orderListEntity.First().BUMP_NM = postedEntity.BUMP_NM;
orderListEntity.First().BUMP_TYPE = postedEntity.BUMP_TYPE;
orderListEntity.First().NUMBER = postedEntity.NUMBER;
orderListEntity.First().UNIT = postedEntity.UNIT;
orderListEntity.First().PRICE = postedEntity.PRICE;
orderListEntity.First().AMOUNT = postedEntity.AMOUNT;
orderListEntity.First().BUMP_SERIAL_NO = postedEntity.BUMP_SERIAL_NO;
orderListEntity.First().FLOW = postedEntity.FLOW;
orderListEntity.First().LIFT = postedEntity.LIFT;
orderListEntity.First().MATERIAL_BUMP = postedEntity.MATERIAL_BUMP;
orderListEntity.First().MATERIAL_FAN = postedEntity.MATERIAL_FAN;
orderListEntity.First().MATERIAL_ROLLER = postedEntity.MATERIAL_ROLLER;
orderListEntity.First().MOTOR_BRAND = postedEntity.MOTOR_BRAND;
orderListEntity.First().MOTOR_DEMAND = postedEntity.MOTOR_DEMAND;
orderListEntity.First().SEAL_FORM = postedEntity.SEAL_FORM;
orderListEntity.First().SEAL_BRAND = postedEntity.SEAL_BRAND;
orderListEntity.First().ROLLER_BRAND = postedEntity.ROLLER_BRAND;
orderListEntity.First().COUPLING = postedEntity.COUPLING;
orderListEntity.First().SEAL_COOLER = postedEntity.SEAL_COOLER;
orderListEntity.First().CAVITATION_ALLOWANCE = postedEntity.CAVITATION_ALLOWANCE;
orderListEntity.First().ACTUAL_BUMP_SPEED = postedEntity.ACTUAL_BUMP_SPEED;
orderListEntity.First().STATION = postedEntity.STATION;
orderListEntity.First().TEMPERATURE = postedEntity.TEMPERATURE;
orderListEntity.First().TEMPERATURE = postedEntity.TEMPERATURE;
orderListEntity.First().IN_PRESSURE = postedEntity.IN_PRESSURE;
orderListEntity.First().MEDIUM = postedEntity.MEDIUM;
orderListEntity.First().VISCOSITY = postedEntity.VISCOSITY;
orderListEntity.First().PARTICULATES = postedEntity.PARTICULATES;
orderListEntity.First().WORKING_PRESSURE = postedEntity.WORKING_PRESSURE;
orderListEntity.First().FLANGES_STANDARD = postedEntity.FLANGES_STANDARD;
orderListEntity.First().FLANGES_LEVEL = postedEntity.FLANGES_LEVEL;
orderListEntity.First().BASE = postedEntity.BASE;
orderListEntity.First().COUPLING_HOOD = postedEntity.COUPLING_HOOD;
orderListEntity.First().ANCHOR_BOLT = postedEntity.ANCHOR_BOLT;
orderListEntity.First().PAINT = postedEntity.PAINT;
orderListEntity.First().SURFACE_TREATMENT = postedEntity.SURFACE_TREATMENT;
orderListEntity.First().PACKAGE = postedEntity.PACKAGE;
orderListEntity.First().TRANSPORT = postedEntity.TRANSPORT;
orderListEntity.First().SEAL_BRAND_MANUAL = String.IsNullOrEmpty(postedEntity.SEAL_BRAND_MANUAL) ? "" : postedEntity.SEAL_BRAND_MANUAL;
myContext.SaveChanges();
return("");
}
}
public ActionResult <string> Delete(string BUMP_INFO)
{
Boolean isSuccess = true;
string data = "Delete success";
if (!String.IsNullOrEmpty(BUMP_INFO))
{
string[] ORDER_NO_AND_BUMP_IDS = BUMP_INFO.Replace("|SLASH|", "/").Split("|DASH|");
string[] BUMP_ID_LIST = { };
string ORDER_NO_T = String.Empty;
if (ORDER_NO_AND_BUMP_IDS.Length > 1)
{
ORDER_NO_T = ORDER_NO_AND_BUMP_IDS[0];
BUMP_ID_LIST = ORDER_NO_AND_BUMP_IDS[1].Split(",");
}
else
{
isSuccess = false;
data = "Need more arguments.";
}
foreach (string BUMP_ID_T in BUMP_ID_LIST)
{
ORDER_LIST_DETAIL delEntity = new ORDER_LIST_DETAIL()
{
BUMP_ID = BUMP_ID_T, ORDER_NO = ORDER_NO_T
};
if (delEntity.Equals(null))
{
isSuccess = false;
data = "No such data.";
break;
}
else
{
// FIND DB ITEM
myContext.ORDER_LIST_DETAIL.Attach(delEntity);
// DELETE DB ITEM
var delRes = myContext.ORDER_LIST_DETAIL.Remove(delEntity);
if (delRes.State == EntityState.Deleted)
{
// SAVE CHANGES AND DO NOT RETURN
myContext.SaveChanges();
}
else
{
isSuccess = false;
data = "No such data.";
break;
}
}
}
}
else
{
isSuccess = false;
data = "No such data.";
}
JsonRes res = new JsonRes();
res.isSuccess = isSuccess;
res.data = data;
return(JsonConvert.SerializeObject(res));
}
public ActionResult <string> UploadFile()
{
try
{
var file = Request.Form.Files[0];
string folderName = "UploadExcel";
string contentRootPath = _hostingEnvironment.ContentRootPath;
string newPath = Path.Combine(contentRootPath, folderName);
if (!Directory.Exists(newPath))
{
Directory.CreateDirectory(newPath);
}
if (file.Length > 0)
{
string fileName = ContentDispositionHeaderValue.Parse(file.ContentDisposition).FileName.Trim('"');
string fullPath = Path.Combine(newPath, fileName);
using (FileStream stream = new FileStream(fullPath, FileMode.Create))
{
file.CopyTo(stream);
IWorkbook workbook = WorkbookFactory.Create(stream);
ISheet sheet = workbook.GetSheetAt(0);
if (sheet != null)
{
/*
* 订单信息
*/
// 订单编号
String ORDER_NO = getCellValue(sheet, "C3", CELL_TYP_STRING);
if (String.IsNullOrEmpty(ORDER_NO))
{
// 订单号（主键）为空时，直接返回
return("OrderNo is empty.");
}
// 合同编号
String CONTRACT_NO = getCellValue(sheet, "C4", CELL_TYP_STRING);
// 项目名称
String PROJECT_NM = getCellValue(sheet, "C5", CELL_TYP_STRING);
// 销售部门/销售员
String SALES_PERSON = getCellValue(sheet, "C6", CELL_TYP_STRING);
// 订货单位
String ORDER_UNIT = getCellValue(sheet, "C7", CELL_TYP_STRING);
// 应用工程师
String APPLICATION_ENGINEER = getCellValue(sheet, "F3", CELL_TYP_STRING);
// 下发日期
String DEPARTURE_DATE_STR = getCellValue(sheet, "F4", CELL_TYP_DATE);
// 交货日期
String DELIVERY_DATE_STR = getCellValue(sheet, "F5", CELL_TYP_DATE);
// 此订单页数
String BUMP_DETAIL_NUM = getCellValue(sheet, "F6", CELL_TYP_NUMBER);
// 构造JObject，并保存订单信息至数据库中
JObject entityObjForOrder = new JObject();
entityObjForOrder.Add("ORDER_NO", ORDER_NO);
entityObjForOrder.Add("CONTRACT_NO", CONTRACT_NO);
entityObjForOrder.Add("PROJECT_NM", PROJECT_NM);
entityObjForOrder.Add("SALES_PERSON", SALES_PERSON);
entityObjForOrder.Add("ORDER_UNIT", ORDER_UNIT);
entityObjForOrder.Add("APPLICATION_ENGINEER", APPLICATION_ENGINEER);
entityObjForOrder.Add("DEPARTURE_DATE", Convert.ToDateTime(DEPARTURE_DATE_STR));
entityObjForOrder.Add("DELIVERY_DATE", Convert.ToDateTime(DELIVERY_DATE_STR));
ORDER_LIST_MST excelOrderListMstEntity = entityObjForOrder.ToObject <ORDER_LIST_MST>();
var orderListMstEntity = myContext.ORDER_LIST_MST.Where(d => d.ORDER_NO.Equals(excelOrderListMstEntity.ORDER_NO));
if (orderListMstEntity.Count() == 0)
{
// INSERT
myContext.ORDER_LIST_MST.Add(excelOrderListMstEntity);
// 以后有可能做一个FLG，到水泵信息保存完成后再保存更改
myContext.SaveChanges();
}
else
{
orderListMstEntity.First().CONTRACT_NO = excelOrderListMstEntity.CONTRACT_NO;
orderListMstEntity.First().PROJECT_NM = excelOrderListMstEntity.PROJECT_NM;
orderListMstEntity.First().ORDER_UNIT = excelOrderListMstEntity.ORDER_UNIT;
orderListMstEntity.First().SALES_PERSON = excelOrderListMstEntity.SALES_PERSON;
orderListMstEntity.First().DEPARTURE_DATE = excelOrderListMstEntity.DEPARTURE_DATE.ToLocalTime();
orderListMstEntity.First().DELIVERY_DATE = excelOrderListMstEntity.DELIVERY_DATE.ToLocalTime();
orderListMstEntity.First().REMARK = excelOrderListMstEntity.REMARK;
orderListMstEntity.First().APPLICATION_ENGINEER = excelOrderListMstEntity.APPLICATION_ENGINEER;
myContext.SaveChanges();
}
/*
* 水泵信息
*/
for (int i = 0; i < Convert.ToInt32(BUMP_DETAIL_NUM); i++)
{
// 序号（校验用）
String NO = getCellValue(sheet, "A" + (BUMP_OFFSET + i), CELL_TYP_STRING);
// 序号校验（还应考虑不是数字Convert失败的情况，未写）
if (Convert.ToInt32(NO) != i + 1)
{
return("");
}
// 泵名称
String BUMP_NM = getCellValue(sheet, "B" + (BUMP_OFFSET + i), CELL_TYP_STRING);
// 工位
String STATION = getCellValue(sheet, "C" + (BUMP_OFFSET + i), CELL_TYP_STRING);
// 型号
String BUMP_TYPE = getCellValue(sheet, "D" + (BUMP_OFFSET + i), CELL_TYP_STRING);
// 数量
String NUMBER = getCellValue(sheet, "F" + (BUMP_OFFSET + i), CELL_TYP_NUMBER);
// 流量
String FLOW = getCellValue(sheet, "G" + (BUMP_OFFSET + i), CELL_TYP_NUMBER);
// 扬程
String LIFT = getCellValue(sheet, "H" + (BUMP_OFFSET + i), CELL_TYP_NUMBER);
// 材质
String MATERIAL = getCellValue(sheet, "I" + (BUMP_OFFSET + i), CELL_TYP_STRING);
// 机封
String SEAL = getCellValue(sheet, "J" + (BUMP_OFFSET + i), CELL_TYP_STRING);
// 序列号
String BUMP_SERIAL_NO = getCellValue(sheet, "K" + (BUMP_OFFSET + i), CELL_TYP_STRING);
// 备注
String REMARK = getCellValue(sheet, "L" + (BUMP_OFFSET + i), CELL_TYP_STRING);
// 构造水泵ID
String BUMP_ID = "";
if (String.IsNullOrEmpty(BUMP_TYPE) || String.IsNullOrEmpty(MATERIAL))
{
return("BumpType or material is empty.");
}
else
{
BUMP_ID = BUMP_TYPE + "_" + MATERIAL;
}
// 构造JObject，并保存水泵信息至数据库中
JObject entityObjForBump = new JObject();
entityObjForBump.Add("ORDER_NO", ORDER_NO);
entityObjForBump.Add("BUMP_ID", BUMP_ID);
entityObjForBump.Add("BUMP_NM", BUMP_NM);
entityObjForBump.Add("STATION", STATION);
entityObjForBump.Add("BUMP_TYPE", BUMP_TYPE);
entityObjForBump.Add("NUMBER", Convert.ToInt32(NUMBER));
entityObjForBump.Add("FLOW", Convert.ToInt32(FLOW));
entityObjForBump.Add("LIFT", Convert.ToInt32(LIFT));
entityObjForBump.Add("MATERIAL", MATERIAL);
entityObjForBump.Add("SEAL", SEAL);
entityObjForBump.Add("BUMP_SERIAL_NO", BUMP_SERIAL_NO);
entityObjForBump.Add("REMARK", REMARK);
ORDER_LIST_DETAIL excelOrderListDetailEntity = entityObjForBump.ToObject <ORDER_LIST_DETAIL>();
var orderListDetailEntity =
myContext.ORDER_LIST_DETAIL
.Where(d => d.ORDER_NO.Equals(excelOrderListDetailEntity.ORDER_NO))
.Where(d => d.BUMP_ID.Equals(excelOrderListDetailEntity.BUMP_ID));
if (orderListDetailEntity.Count() == 0)
{
// INSERT
myContext.ORDER_LIST_DETAIL.Add(excelOrderListDetailEntity);
// 以后有可能做一个FLG，到水泵信息保存完成后再保存更改
myContext.SaveChanges();
}
else
{
orderListDetailEntity.First().BUMP_NM = excelOrderListDetailEntity.BUMP_NM;
orderListDetailEntity.First().STATION = excelOrderListDetailEntity.STATION;
orderListDetailEntity.First().BUMP_TYPE = excelOrderListDetailEntity.BUMP_TYPE;
orderListDetailEntity.First().NUMBER = excelOrderListDetailEntity.NUMBER;
orderListDetailEntity.First().FLOW = excelOrderListDetailEntity.FLOW;
orderListDetailEntity.First().LIFT = excelOrderListDetailEntity.LIFT;
orderListDetailEntity.First().MATERIAL = excelOrderListDetailEntity.MATERIAL;
orderListDetailEntity.First().SEAL = excelOrderListDetailEntity.SEAL;
orderListDetailEntity.First().BUMP_SERIAL_NO = excelOrderListDetailEntity.BUMP_SERIAL_NO;
orderListDetailEntity.First().REMARK = excelOrderListDetailEntity.REMARK;
myContext.SaveChanges();
}
}
}
}
}
return(String.Empty);
}
catch (System.Exception ex)
{
return("Upload Failed: " + ex.Message);
}
}
public ActionResult <string> UploadFile()
{
try
{
var file = Request.Form.Files[0];
string folderName = "UploadExcel";
string contentRootPath = _hostingEnvironment.ContentRootPath;
string newPath = Path.Combine(contentRootPath, folderName);
if (!Directory.Exists(newPath))
{
Directory.CreateDirectory(newPath);
}
if (file.Length > 0)
{
string fileName = ContentDispositionHeaderValue.Parse(file.ContentDisposition).FileName.Trim('"');
string fullPath = Path.Combine(newPath, fileName);
using (FileStream stream = new FileStream(fullPath, FileMode.Create))
{
file.CopyTo(stream);
IWorkbook workbook = WorkbookFactory.Create(stream);
ISheet sheet = workbook.GetSheetAt(0);
if (sheet != null)
{
/*
* 订单信息
*/
// 订单编号
String ORDER_NO = getCellValue(sheet, ColumnIndex.C, 3, CELL_TYP_STRING);
if (String.IsNullOrEmpty(ORDER_NO))
{
// 订单号（主键）为空时，直接返回
return("OrderNo is empty.");
}
// 合同编号
String CONTRACT_NO = getCellValue(sheet, ColumnIndex.C, 4, CELL_TYP_STRING);
// 项目名称
String PROJECT_NM = getCellValue(sheet, ColumnIndex.C, 5, CELL_TYP_STRING);
// 销售部门/销售员
String SALES_PERSON = getCellValue(sheet, ColumnIndex.C, 6, CELL_TYP_STRING);
// 付款方式
String PAYMENT = getCellValue(sheet, ColumnIndex.C, 7, CELL_TYP_STRING);
// 订货单位
String ORDER_UNIT = getCellValue(sheet, ColumnIndex.C, 8, CELL_TYP_STRING);
// 应用工程师
String APPLICATION_ENGINEER = getCellValue(sheet, ColumnIndex.F, 3, CELL_TYP_STRING);
// 下发日期
String DEPARTURE_DATE_STR = getCellValue(sheet, ColumnIndex.F, 4, CELL_TYP_DATE);
// 交货日期
String DELIVERY_DATE_STR = getCellValue(sheet, ColumnIndex.F, 5, CELL_TYP_DATE);
// 交货期
String GUARANTEE_DATE = getCellValue(sheet, ColumnIndex.F, 6, CELL_TYP_DATE);
// 调试
String DEBUG = getCellValue(sheet, ColumnIndex.I, 3, CELL_TYP_STRING);
var Dict_DEBUG = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(DEBUG)).Where(e => e.TYPE.Equals("01"));
DEBUG = Dict_DEBUG.Count() == 0 ? "" : Dict_DEBUG.First().DICT_ID;
// 总数量
String TOTAL_QTY = getCellValue(sheet, ColumnIndex.I, 4, CELL_TYP_NUMBER);
int iTOTAL_QTY = int.TryParse(TOTAL_QTY, out iTOTAL_QTY) == true ? iTOTAL_QTY : 0;
// 税率
String TEX_RATE = getCellValue(sheet, ColumnIndex.I, 5, CELL_TYP_NUMBER);
var Dict_TEX_RATE = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(TEX_RATE)).Where(e => e.TYPE.Equals("02"));
TEX_RATE = Dict_TEX_RATE.Count() == 0 ? "" : Dict_TEX_RATE.First().DICT_ID;
// 合同总额
String TOTAL_AMT = getCellValue(sheet, ColumnIndex.I, 6, CELL_TYP_NUMBER);
int iTOTAL_AMT = int.TryParse(TOTAL_AMT, out iTOTAL_AMT) == true ? iTOTAL_AMT : 0;
// 目标价
String TARGET_PRICE = getCellValue(sheet, ColumnIndex.I, 7, CELL_TYP_NUMBER);
int iTARGET_PRICE = int.TryParse(TARGET_PRICE, out iTARGET_PRICE) == true ? iTARGET_PRICE : 0;
// 折扣
String DISCOUNT = getCellValue(sheet, ColumnIndex.I, 8, CELL_TYP_NUMBER);
int iDISCOUNT = int.TryParse(DISCOUNT, out iDISCOUNT) == true ? iDISCOUNT : 0;
// 构造JObject，并保存订单信息至数据库中
JObject entityObjForOrder = new JObject();
entityObjForOrder.Add("ORDER_NO", ORDER_NO);
entityObjForOrder.Add("CONTRACT_NO", CONTRACT_NO);
entityObjForOrder.Add("PROJECT_NM", PROJECT_NM);
entityObjForOrder.Add("SALES_PERSON", SALES_PERSON);
entityObjForOrder.Add("PAYMENT", PAYMENT);
entityObjForOrder.Add("ORDER_UNIT", ORDER_UNIT);
entityObjForOrder.Add("APPLICATION_ENGINEER", APPLICATION_ENGINEER);
entityObjForOrder.Add("DEPARTURE_DATE", Convert.ToDateTime(DEPARTURE_DATE_STR));
entityObjForOrder.Add("DELIVERY_DATE", Convert.ToDateTime(DELIVERY_DATE_STR));
entityObjForOrder.Add("GUARANTEE_DATE", Convert.ToDateTime(GUARANTEE_DATE));
entityObjForOrder.Add("DEBUG", DEBUG);
entityObjForOrder.Add("TOTAL_QTY", iTOTAL_QTY);
entityObjForOrder.Add("TEX_RATE", TEX_RATE);
entityObjForOrder.Add("TOTAL_AMT", iTOTAL_AMT);
entityObjForOrder.Add("TARGET_PRICE", iTARGET_PRICE);
entityObjForOrder.Add("DISCOUNT", iDISCOUNT);
ORDER_LIST_MST excelOrderListMstEntity = entityObjForOrder.ToObject <ORDER_LIST_MST>();
var orderListMstEntity = myContext.ORDER_LIST_MST.Where(d => d.ORDER_NO.Equals(excelOrderListMstEntity.ORDER_NO));
if (orderListMstEntity.Count() == 0)
{
// INSERT
myContext.ORDER_LIST_MST.Add(excelOrderListMstEntity);
// 以后有可能做一个FLG，到水泵信息保存完成后再保存更改
myContext.SaveChanges();
}
else
{
orderListMstEntity.First().CONTRACT_NO = excelOrderListMstEntity.CONTRACT_NO;
orderListMstEntity.First().PROJECT_NM = excelOrderListMstEntity.PROJECT_NM;
orderListMstEntity.First().ORDER_UNIT = excelOrderListMstEntity.ORDER_UNIT;
orderListMstEntity.First().SALES_PERSON = excelOrderListMstEntity.SALES_PERSON;
orderListMstEntity.First().DEPARTURE_DATE = excelOrderListMstEntity.DEPARTURE_DATE.ToLocalTime();
orderListMstEntity.First().DELIVERY_DATE = excelOrderListMstEntity.DELIVERY_DATE.ToLocalTime();
orderListMstEntity.First().REMARK = excelOrderListMstEntity.REMARK;
orderListMstEntity.First().APPLICATION_ENGINEER = excelOrderListMstEntity.APPLICATION_ENGINEER;
orderListMstEntity.First().DEBUG = excelOrderListMstEntity.DEBUG;
orderListMstEntity.First().TOTAL_QTY = excelOrderListMstEntity.TOTAL_QTY;
orderListMstEntity.First().TEX_RATE = excelOrderListMstEntity.TEX_RATE;
orderListMstEntity.First().GUARANTEE_DATE = excelOrderListMstEntity.GUARANTEE_DATE.ToLocalTime();
orderListMstEntity.First().TOTAL_AMT = excelOrderListMstEntity.TOTAL_AMT;
orderListMstEntity.First().PAYMENT = excelOrderListMstEntity.PAYMENT;
orderListMstEntity.First().TARGET_PRICE = excelOrderListMstEntity.TARGET_PRICE;
orderListMstEntity.First().DISCOUNT = excelOrderListMstEntity.DISCOUNT;
orderListMstEntity.First().CHANGE_HIS1 = excelOrderListMstEntity.CHANGE_HIS1;
orderListMstEntity.First().CHANGE_HIS2 = excelOrderListMstEntity.CHANGE_HIS2;
myContext.SaveChanges();
}
/*
* 随货资料
*/
// 合格证
String QUALIFICATION = getCellValue(sheet, ColumnIndex.A, 13, CELL_TYP_STRING);
var Dict_QUALIFICATION = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(QUALIFICATION)).Where(e => e.TYPE.Equals("18"));
QUALIFICATION = Dict_QUALIFICATION.Count() == 0 ? "" : Dict_QUALIFICATION.First().DICT_ID;
// 说明书
String IDENTIFICATION = getCellValue(sheet, ColumnIndex.B, 13, CELL_TYP_STRING);
var Dict_IDENTIFICATION = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(IDENTIFICATION)).Where(e => e.TYPE.Equals("19"));
IDENTIFICATION = Dict_IDENTIFICATION.Count() == 0 ? "" : Dict_IDENTIFICATION.First().DICT_ID;
// 产品样本
String PRODUCT_SAMPLE = getCellValue(sheet, ColumnIndex.C, 13, CELL_TYP_STRING);
var Dict_PRODUCT_SAMPLE = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(PRODUCT_SAMPLE)).Where(e => e.TYPE.Equals("20"));
PRODUCT_SAMPLE = Dict_PRODUCT_SAMPLE.Count() == 0 ? "" : Dict_PRODUCT_SAMPLE.First().DICT_ID;
// 动平衡报告
String DYNAMIC_REPORT = getCellValue(sheet, ColumnIndex.D, 13, CELL_TYP_STRING);
var Dict_DYNAMIC_REPORT = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(DYNAMIC_REPORT)).Where(e => e.TYPE.Equals("21"));
DYNAMIC_REPORT = Dict_DYNAMIC_REPORT.Count() == 0 ? "" : Dict_DYNAMIC_REPORT.First().DICT_ID;
// 静压试验报告
String STATIC_REPORT = getCellValue(sheet, ColumnIndex.E, 13, CELL_TYP_STRING);
var Dict_STATIC_REPORT = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(STATIC_REPORT)).Where(e => e.TYPE.Equals("22"));
STATIC_REPORT = Dict_STATIC_REPORT.Count() == 0 ? "" : Dict_STATIC_REPORT.First().DICT_ID;
// 性能试验报告
String PERFORMANCE_REPORT = getCellValue(sheet, ColumnIndex.F, 13, CELL_TYP_STRING);
var Dict_PERFORMANCE_REPORT = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(PERFORMANCE_REPORT)).Where(e => e.TYPE.Equals("23"));
PERFORMANCE_REPORT = Dict_PERFORMANCE_REPORT.Count() == 0 ? "" : Dict_PERFORMANCE_REPORT.First().DICT_ID;
// 图纸
String BLUEPRINT = getCellValue(sheet, ColumnIndex.G, 13, CELL_TYP_STRING);
var Dict_BLUEPRINT = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(BLUEPRINT)).Where(e => e.TYPE.Equals("24"));
BLUEPRINT = Dict_BLUEPRINT.Count() == 0 ? "" : Dict_BLUEPRINT.First().DICT_ID;
// 性能曲线
String PERFORMANCE_CURVE = getCellValue(sheet, ColumnIndex.H, 13, CELL_TYP_STRING);
var Dict_PERFORMANCE_CURVE = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(PERFORMANCE_CURVE)).Where(e => e.TYPE.Equals("25"));
PERFORMANCE_CURVE = Dict_PERFORMANCE_CURVE.Count() == 0 ? "" : Dict_PERFORMANCE_CURVE.First().DICT_ID;
// 其它可手动添加
String OTHER = getCellValue(sheet, ColumnIndex.I, 13, CELL_TYP_STRING);
// 构造JObject，并保存订单信息至数据库中
JObject entityObjForAttach = new JObject();
entityObjForAttach.Add("ORDER_NO", ORDER_NO);
entityObjForAttach.Add("QUALIFICATION", QUALIFICATION);
entityObjForAttach.Add("IDENTIFICATION", IDENTIFICATION);
entityObjForAttach.Add("PRODUCT_SAMPLE", PRODUCT_SAMPLE);
entityObjForAttach.Add("DYNAMIC_REPORT", DYNAMIC_REPORT);
entityObjForAttach.Add("STATIC_REPORT", STATIC_REPORT);
entityObjForAttach.Add("PERFORMANCE_REPORT", PERFORMANCE_REPORT);
entityObjForAttach.Add("BLUEPRINT", BLUEPRINT);
entityObjForAttach.Add("PERFORMANCE_CURVE", PERFORMANCE_CURVE);
entityObjForAttach.Add("OTHER", OTHER);
ORDER_LIST_ATTACHMENT excelOrderListAttchmentEntity = entityObjForAttach.ToObject <ORDER_LIST_ATTACHMENT>();
var orderListAttachmentEntity = myContext.ORDER_LIST_ATTACHMENT.Where(d => d.ORDER_NO.Equals(excelOrderListAttchmentEntity.ORDER_NO));
if (orderListAttachmentEntity.Count() == 0)
{
// INSERT
myContext.ORDER_LIST_ATTACHMENT.Add(excelOrderListAttchmentEntity);
// 以后有可能做一个FLG，到水泵信息保存完成后再保存更改
myContext.SaveChanges();
}
else
{
orderListAttachmentEntity.First().QUALIFICATION = excelOrderListAttchmentEntity.QUALIFICATION;
orderListAttachmentEntity.First().IDENTIFICATION = excelOrderListAttchmentEntity.IDENTIFICATION;
orderListAttachmentEntity.First().PRODUCT_SAMPLE = excelOrderListAttchmentEntity.PRODUCT_SAMPLE;
orderListAttachmentEntity.First().DYNAMIC_REPORT = excelOrderListAttchmentEntity.DYNAMIC_REPORT;
orderListAttachmentEntity.First().STATIC_REPORT = excelOrderListAttchmentEntity.STATIC_REPORT;
orderListAttachmentEntity.First().PERFORMANCE_REPORT = excelOrderListAttchmentEntity.PERFORMANCE_REPORT;
orderListAttachmentEntity.First().BLUEPRINT = excelOrderListAttchmentEntity.BLUEPRINT;
orderListAttachmentEntity.First().PERFORMANCE_CURVE = excelOrderListAttchmentEntity.PERFORMANCE_CURVE;
orderListAttachmentEntity.First().OTHER = excelOrderListAttchmentEntity.OTHER;
myContext.SaveChanges();
}
/*
* 水泵信息
*/
int i = 0;
while (true)
{
// 序号（校验用）
String NO = getCellValue(sheet, ColumnIndex.A, (BUMP_OFFSET + i), CELL_TYP_STRING);
// 序号校验（还应考虑不是数字Convert失败的情况，未写）
if (NO.ToString().Trim().Equals("合计"))
{
break;
}
if (Convert.ToInt32(NO) != i + 1)
{
return("");
}
// 泵名称
String BUMP_NM = getCellValue(sheet, ColumnIndex.B, (BUMP_OFFSET + i), CELL_TYP_STRING);
// 型号
String BUMP_TYPE = getCellValue(sheet, ColumnIndex.C, (BUMP_OFFSET + i), CELL_TYP_STRING);
// 数量
String NUMBER = getCellValue(sheet, ColumnIndex.D, (BUMP_OFFSET + i), CELL_TYP_NUMBER);
int iNUMBER = int.TryParse(NUMBER, out iNUMBER) == true ? iNUMBER : 0;
// 单位
String UNIT = getCellValue(sheet, ColumnIndex.E, (BUMP_OFFSET + i), CELL_TYP_STRING);
// 单价
String PRICE = getCellValue(sheet, ColumnIndex.F, (BUMP_OFFSET + i), CELL_TYP_NUMBER);
int iPRICE = int.TryParse(PRICE, out iPRICE) == true ? iPRICE : 0;
// 金额
String AMOUNT = getCellValue(sheet, ColumnIndex.G, (BUMP_OFFSET + i), CELL_TYP_NUMBER);
int iAMOUNT = int.TryParse(AMOUNT, out iAMOUNT) == true ? iAMOUNT : 0;
// 序列号
String BUMP_SERIAL_NO = getCellValue(sheet, ColumnIndex.H, (BUMP_OFFSET + i), CELL_TYP_STRING);
// 流量
String FLOW = getCellValue(sheet, ColumnIndex.I, (BUMP_OFFSET + i), CELL_TYP_NUMBER);
int iFLOW = int.TryParse(FLOW, out iFLOW) == true ? iFLOW : 0;
// 扬程
String LIFT = getCellValue(sheet, ColumnIndex.J, (BUMP_OFFSET + i), CELL_TYP_NUMBER);
int iLIFT = int.TryParse(LIFT, out iLIFT) == true ? iLIFT : 0;
// 材质 泵体
String MATERIAL_BUMP = getCellValue(sheet, ColumnIndex.K, (BUMP_OFFSET + i), CELL_TYP_STRING);
// 材质 叶轮
String MATERIAL_FAN = getCellValue(sheet, ColumnIndex.L, (BUMP_OFFSET + i), CELL_TYP_STRING);
// 材质 轴
String MATERIAL_ROLLER = getCellValue(sheet, ColumnIndex.M, (BUMP_OFFSET + i), CELL_TYP_STRING);
// 电机 品牌
String MOTOR_BRAND = getCellValue(sheet, ColumnIndex.N, (BUMP_OFFSET + i), CELL_TYP_STRING);
var Dict_MOTOR_BRAND = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(MOTOR_BRAND)).Where(e => e.TYPE.Equals("03"));
MOTOR_BRAND = Dict_MOTOR_BRAND.Count() == 0 ? "" : Dict_MOTOR_BRAND.First().DICT_ID;
// 电机 要求
String MOTOR_DEMAND = getCellValue(sheet, ColumnIndex.O, (BUMP_OFFSET + i), CELL_TYP_STRING);
// 密封/液下深度（BY&SBY） 形式
String SEAL_FORM = getCellValue(sheet, ColumnIndex.P, (BUMP_OFFSET + i), CELL_TYP_STRING);
var Dict_SEAL_FORM = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(SEAL_FORM)).Where(e => e.TYPE.Equals("04"));
SEAL_FORM = Dict_SEAL_FORM.Count() == 0 ? "" : Dict_SEAL_FORM.First().DICT_ID;
// 密封/液下深度（BY&SBY） 品牌/其它
String SEAL_BRAND = getCellValue(sheet, ColumnIndex.Q, (BUMP_OFFSET + i), CELL_TYP_STRING);
var Dict_SEAL_BRAND = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(SEAL_BRAND)).Where(e => e.TYPE.Equals("05"));
SEAL_BRAND = Dict_SEAL_BRAND.Count() == 0 ? "" : Dict_SEAL_BRAND.First().DICT_ID;
// 轴承品牌
String ROLLER_BRAND = getCellValue(sheet, ColumnIndex.R, (BUMP_OFFSET + i), CELL_TYP_STRING);
var Dict_ROLLER_BRAND = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(ROLLER_BRAND)).Where(e => e.TYPE.Equals("06"));
ROLLER_BRAND = Dict_ROLLER_BRAND.Count() == 0 ? "" : Dict_ROLLER_BRAND.First().DICT_ID;
// 联轴器
String COUPLING = getCellValue(sheet, ColumnIndex.S, (BUMP_OFFSET + i), CELL_TYP_STRING);
var Dict_COUPLING = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(COUPLING)).Where(e => e.TYPE.Equals("07"));
COUPLING = Dict_COUPLING.Count() == 0 ? "" : Dict_COUPLING.First().DICT_ID;
// 机封冷却器
String SEAL_COOLER = getCellValue(sheet, ColumnIndex.T, (BUMP_OFFSET + i), CELL_TYP_STRING);
var Dict_SEAL_COOLER = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(SEAL_COOLER)).Where(e => e.TYPE.Equals("03"));
SEAL_COOLER = Dict_SEAL_COOLER.Count() == 0 ? "" : Dict_SEAL_COOLER.First().DICT_ID;
// 装置汽蚀余量
String CAVITATION_ALLOWANCE = getCellValue(sheet, ColumnIndex.U, (BUMP_OFFSET + i), CELL_TYP_STRING);
int iCAVITATION_ALLOWANCE = int.TryParse(CAVITATION_ALLOWANCE, out iCAVITATION_ALLOWANCE) == true ? iCAVITATION_ALLOWANCE : 0;
// 泵实际转速
String ACTUAL_BUMP_SPEED = getCellValue(sheet, ColumnIndex.V, (BUMP_OFFSET + i), CELL_TYP_NUMBER);
int iACTUAL_BUMP_SPEED = int.TryParse(ACTUAL_BUMP_SPEED, out iACTUAL_BUMP_SPEED) == true ? iACTUAL_BUMP_SPEED : 0;
// 工位
String STATION = getCellValue(sheet, ColumnIndex.W, (BUMP_OFFSET + i), CELL_TYP_STRING);
// 温度
String TEMPERATURE = getCellValue(sheet, ColumnIndex.X, (BUMP_OFFSET + i), CELL_TYP_NUMBER);
int iTEMPERATURE = int.TryParse(TEMPERATURE, out iTEMPERATURE) == true ? iTEMPERATURE : 0;
// 密度
String DENSITY = getCellValue(sheet, ColumnIndex.Y, (BUMP_OFFSET + i), CELL_TYP_STRING);
// 入口压力
String IN_PRESSURE = getCellValue(sheet, ColumnIndex.Z, (BUMP_OFFSET + i), CELL_TYP_NUMBER);
int iIN_PRESSURE = int.TryParse(IN_PRESSURE, out iIN_PRESSURE) == true ? iIN_PRESSURE : 0;
// 介质
String MEDIUM = getCellValue(sheet, ColumnIndex.AA, (BUMP_OFFSET + i), CELL_TYP_STRING);
// 粘度
String VISCOSITY = getCellValue(sheet, ColumnIndex.AB, (BUMP_OFFSET + i), CELL_TYP_NUMBER);
int iVISCOSITY = int.TryParse(VISCOSITY, out iVISCOSITY) == true ? iVISCOSITY : 0;
// 含颗粒情况
String PARTICULATES = getCellValue(sheet, ColumnIndex.AC, (BUMP_OFFSET + i), CELL_TYP_STRING);
// 工作压力(bar)
String WORKING_PRESSURE = getCellValue(sheet, ColumnIndex.AD, (BUMP_OFFSET + i), CELL_TYP_NUMBER);
int iWORKING_PRESSURE = int.TryParse(WORKING_PRESSURE, out iWORKING_PRESSURE) == true ? iWORKING_PRESSURE : 0;
// 法兰标准
String FLANGES_STANDARD = getCellValue(sheet, ColumnIndex.AE, (BUMP_OFFSET + i), CELL_TYP_STRING);
var Dict_FLANGES_STANDARD = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(FLANGES_STANDARD)).Where(e => e.TYPE.Equals("03"));
FLANGES_STANDARD = Dict_FLANGES_STANDARD.Count() == 0 ? "" : Dict_FLANGES_STANDARD.First().DICT_ID;
// 法兰等级（MPH/MPE)
String FLANGES_LEVEL = getCellValue(sheet, ColumnIndex.AF, (BUMP_OFFSET + i), CELL_TYP_STRING);
var Dict_FLANGES_LEVEL = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(FLANGES_LEVEL)).Where(e => e.TYPE.Equals("03"));
FLANGES_LEVEL = Dict_FLANGES_LEVEL.Count() == 0 ? "" : Dict_FLANGES_LEVEL.First().DICT_ID;
// 底座
String BASE = getCellValue(sheet, ColumnIndex.AG, (BUMP_OFFSET + i), CELL_TYP_STRING);
var Dict_BASE = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(BASE)).Where(e => e.TYPE.Equals("03"));
BASE = Dict_BASE.Count() == 0 ? "" : Dict_BASE.First().DICT_ID;
// 联轴器罩
String COUPLING_HOOD = getCellValue(sheet, ColumnIndex.AH, (BUMP_OFFSET + i), CELL_TYP_STRING);
var Dict_COUPLING_HOOD = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(COUPLING_HOOD)).Where(e => e.TYPE.Equals("03"));
COUPLING_HOOD = Dict_COUPLING_HOOD.Count() == 0 ? "" : Dict_COUPLING_HOOD.First().DICT_ID;
// 地脚螺栓
String ANCHOR_BOLT = getCellValue(sheet, ColumnIndex.AI, (BUMP_OFFSET + i), CELL_TYP_STRING);
var Dict_ANCHOR_BOLT = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(ANCHOR_BOLT)).Where(e => e.TYPE.Equals("03"));
ANCHOR_BOLT = Dict_ANCHOR_BOLT.Count() == 0 ? "" : Dict_ANCHOR_BOLT.First().DICT_ID;
// 油漆
String PAINT = getCellValue(sheet, ColumnIndex.AJ, (BUMP_OFFSET + i), CELL_TYP_STRING);
var Dict_PAINT = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(PAINT)).Where(e => e.TYPE.Equals("03"));
PAINT = Dict_PAINT.Count() == 0 ? "" : Dict_PAINT.First().DICT_ID;
// 表面特殊处理
String SURFACE_TREATMENT = getCellValue(sheet, ColumnIndex.AK, (BUMP_OFFSET + i), CELL_TYP_STRING);
var Dict_SURFACE_TREATMENT = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(SURFACE_TREATMENT)).Where(e => e.TYPE.Equals("03"));
SURFACE_TREATMENT = Dict_SURFACE_TREATMENT.Count() == 0 ? "" : Dict_SURFACE_TREATMENT.First().DICT_ID;
// 包装
String PACKAGE = getCellValue(sheet, ColumnIndex.AL, (BUMP_OFFSET + i), CELL_TYP_STRING);
var Dict_PACKAGE = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(PACKAGE)).Where(e => e.TYPE.Equals("03"));
PACKAGE = Dict_PACKAGE.Count() == 0 ? "" : Dict_PACKAGE.First().DICT_ID;
// 运输
String TRANSPORT = getCellValue(sheet, ColumnIndex.AM, (BUMP_OFFSET + i), CELL_TYP_STRING);
var Dict_TRANSPORT = myContext.M_DICT.Where(d => d.DICT_NAME.Equals(TRANSPORT)).Where(e => e.TYPE.Equals("03"));
TRANSPORT = Dict_TRANSPORT.Count() == 0 ? "" : Dict_TRANSPORT.First().DICT_ID;
// 构造水泵ID
String BUMP_ID = "";
if (String.IsNullOrEmpty(BUMP_TYPE) || String.IsNullOrEmpty(MATERIAL_BUMP))
{
return("BumpType or material is empty.");
}
else
{
BUMP_ID = BUMP_TYPE + "_" + MATERIAL_BUMP;
}
// 构造JObject，并保存水泵信息至数据库中
JObject entityObjForBump = new JObject();
entityObjForBump.Add("ORDER_NO", ORDER_NO);
entityObjForBump.Add("BUMP_ID", BUMP_ID);
entityObjForBump.Add("BUMP_NM", BUMP_NM);
entityObjForBump.Add("BUMP_TYPE", BUMP_TYPE);
entityObjForBump.Add("NUMBER", iNUMBER);
entityObjForBump.Add("UNIT", UNIT);
entityObjForBump.Add("PRICE", iPRICE);
entityObjForBump.Add("AMOUNT", iAMOUNT);
entityObjForBump.Add("BUMP_SERIAL_NO", BUMP_SERIAL_NO);
entityObjForBump.Add("FLOW", iFLOW);
entityObjForBump.Add("LIFT", iLIFT);
entityObjForBump.Add("MATERIAL_BUMP", MATERIAL_BUMP);
entityObjForBump.Add("MATERIAL_FAN", MATERIAL_FAN);
entityObjForBump.Add("MATERIAL_ROLLER", MATERIAL_ROLLER);
entityObjForBump.Add("MOTOR_BRAND", MOTOR_BRAND);
entityObjForBump.Add("MOTOR_DEMAND", MOTOR_DEMAND);
entityObjForBump.Add("SEAL_FORM", SEAL_FORM);
entityObjForBump.Add("SEAL_BRAND", SEAL_BRAND);
entityObjForBump.Add("ROLLER_BRAND", ROLLER_BRAND);
entityObjForBump.Add("COUPLING", COUPLING);
entityObjForBump.Add("SEAL_COOLER", SEAL_COOLER);
entityObjForBump.Add("CAVITATION_ALLOWANCE", iCAVITATION_ALLOWANCE);
entityObjForBump.Add("ACTUAL_BUMP_SPEED", iACTUAL_BUMP_SPEED);
entityObjForBump.Add("STATION", STATION);
entityObjForBump.Add("TEMPERATURE", iTEMPERATURE);
entityObjForBump.Add("DENSITY", DENSITY);
entityObjForBump.Add("IN_PRESSURE", iIN_PRESSURE);
entityObjForBump.Add("MEDIUM", MEDIUM);
entityObjForBump.Add("VISCOSITY", iVISCOSITY);
entityObjForBump.Add("PARTICULATES", PARTICULATES);
entityObjForBump.Add("WORKING_PRESSURE", iWORKING_PRESSURE);
entityObjForBump.Add("FLANGES_STANDARD", FLANGES_STANDARD);
entityObjForBump.Add("FLANGES_LEVEL", FLANGES_LEVEL);
entityObjForBump.Add("BASE", BASE);
entityObjForBump.Add("COUPLING_HOOD", COUPLING_HOOD);
entityObjForBump.Add("ANCHOR_BOLT", ANCHOR_BOLT);
entityObjForBump.Add("PAINT", PAINT);
entityObjForBump.Add("SURFACE_TREATMENT", SURFACE_TREATMENT);
entityObjForBump.Add("PACKAGE", PACKAGE);
entityObjForBump.Add("TRANSPORT", TRANSPORT);
ORDER_LIST_DETAIL excelOrderListDetailEntity = entityObjForBump.ToObject <ORDER_LIST_DETAIL>();
var orderListDetailEntity =
myContext.ORDER_LIST_DETAIL
.Where(d => d.ORDER_NO.Equals(excelOrderListDetailEntity.ORDER_NO))
.Where(d => d.BUMP_ID.Equals(excelOrderListDetailEntity.BUMP_ID));
if (orderListDetailEntity.Count() == 0)
{
// INSERT
myContext.ORDER_LIST_DETAIL.Add(excelOrderListDetailEntity);
// 以后有可能做一个FLG，到水泵信息保存完成后再保存更改
myContext.SaveChanges();
}
else
{
orderListDetailEntity.First().BUMP_NM = excelOrderListDetailEntity.BUMP_NM;
orderListDetailEntity.First().BUMP_TYPE = excelOrderListDetailEntity.BUMP_TYPE;
orderListDetailEntity.First().NUMBER = excelOrderListDetailEntity.NUMBER;
orderListDetailEntity.First().UNIT = excelOrderListDetailEntity.UNIT;
orderListDetailEntity.First().PRICE = excelOrderListDetailEntity.PRICE;
orderListDetailEntity.First().AMOUNT = excelOrderListDetailEntity.AMOUNT;
orderListDetailEntity.First().BUMP_SERIAL_NO = excelOrderListDetailEntity.BUMP_SERIAL_NO;
orderListDetailEntity.First().FLOW = excelOrderListDetailEntity.FLOW;
orderListDetailEntity.First().LIFT = excelOrderListDetailEntity.LIFT;
orderListDetailEntity.First().MATERIAL_BUMP = excelOrderListDetailEntity.MATERIAL_BUMP;
orderListDetailEntity.First().MATERIAL_FAN = excelOrderListDetailEntity.MATERIAL_FAN;
orderListDetailEntity.First().MATERIAL_ROLLER = excelOrderListDetailEntity.MATERIAL_ROLLER;
orderListDetailEntity.First().MOTOR_BRAND = excelOrderListDetailEntity.MOTOR_BRAND;
orderListDetailEntity.First().MOTOR_DEMAND = excelOrderListDetailEntity.MOTOR_DEMAND;
orderListDetailEntity.First().SEAL_FORM = excelOrderListDetailEntity.SEAL_FORM;
orderListDetailEntity.First().SEAL_BRAND = excelOrderListDetailEntity.SEAL_BRAND;
orderListDetailEntity.First().ROLLER_BRAND = excelOrderListDetailEntity.ROLLER_BRAND;
orderListDetailEntity.First().COUPLING = excelOrderListDetailEntity.COUPLING;
orderListDetailEntity.First().SEAL_COOLER = excelOrderListDetailEntity.SEAL_COOLER;
orderListDetailEntity.First().CAVITATION_ALLOWANCE = excelOrderListDetailEntity.CAVITATION_ALLOWANCE;
orderListDetailEntity.First().ACTUAL_BUMP_SPEED = excelOrderListDetailEntity.ACTUAL_BUMP_SPEED;
orderListDetailEntity.First().STATION = excelOrderListDetailEntity.STATION;
orderListDetailEntity.First().TEMPERATURE = excelOrderListDetailEntity.TEMPERATURE;
orderListDetailEntity.First().DENSITY = excelOrderListDetailEntity.DENSITY;
orderListDetailEntity.First().IN_PRESSURE = excelOrderListDetailEntity.IN_PRESSURE;
orderListDetailEntity.First().MEDIUM = excelOrderListDetailEntity.MEDIUM;
orderListDetailEntity.First().VISCOSITY = excelOrderListDetailEntity.VISCOSITY;
orderListDetailEntity.First().PARTICULATES = excelOrderListDetailEntity.PARTICULATES;
orderListDetailEntity.First().WORKING_PRESSURE = excelOrderListDetailEntity.WORKING_PRESSURE;
orderListDetailEntity.First().FLANGES_STANDARD = excelOrderListDetailEntity.FLANGES_STANDARD;
orderListDetailEntity.First().FLANGES_LEVEL = excelOrderListDetailEntity.FLANGES_LEVEL;
orderListDetailEntity.First().BASE = excelOrderListDetailEntity.BASE;
orderListDetailEntity.First().COUPLING_HOOD = excelOrderListDetailEntity.COUPLING_HOOD;
orderListDetailEntity.First().ANCHOR_BOLT = excelOrderListDetailEntity.ANCHOR_BOLT;
orderListDetailEntity.First().PAINT = excelOrderListDetailEntity.PAINT;
orderListDetailEntity.First().SURFACE_TREATMENT = excelOrderListDetailEntity.SURFACE_TREATMENT;
orderListDetailEntity.First().PACKAGE = excelOrderListDetailEntity.PACKAGE;
orderListDetailEntity.First().TRANSPORT = excelOrderListDetailEntity.TRANSPORT;
myContext.SaveChanges();
}
i++;
}
}
}
}
return(String.Empty);
}
catch (System.Exception ex)
{
return("Upload Failed: " + ex.Message);
}
}
public ActionResult <string> Post([FromBody] JObject postObj)
{
// FROM WEB PAGE
ORDER_LIST_DETAIL orderListDetailPostEntity = postObj.GetValue("orderListDetailTableModel").ToObject <ORDER_LIST_DETAIL>();
INNER_ORDER_BASIC_SEAL_MST innerOrderBasicSealPostEntity = postObj.GetValue("basicAndSealModel").ToObject <INNER_ORDER_BASIC_SEAL_MST>();
INNER_ORDER_OTHER_COMPONENT_MST innerOrderOtherComponentPostEntity = postObj.GetValue("otherComponentModel").ToObject <INNER_ORDER_OTHER_COMPONENT_MST>();
IList innerOrderBOMItemStandard = new ArrayList();
IList innerOrderBOMItemBase = new ArrayList();
if (postObj.GetValue("componentListTableData") != null)
{
innerOrderBOMItemStandard = postObj.GetValue("componentListTableData").ToList();
}
if (postObj.GetValue("basicPartListTableData") != null)
{
innerOrderBOMItemBase = postObj.GetValue("basicPartListTableData").ToList();
}
// 校验主键
if (String.IsNullOrEmpty(orderListDetailPostEntity.ORDER_NO) || String.IsNullOrEmpty(orderListDetailPostEntity.BUMP_ID))
{
return("");
}
// FROM DB
// 登录BOM的GRID部分，先用SQL删除对应ID项目，之后批量插入
myContext.Database.ExecuteSqlCommand("DELETE FROM \"INNER_ORDER_BOM_ITEM_BASE\" WHERE \"ORDER_NO\" = @ORDER_NO AND \"BUMP_ID\" = @BUMP_ID",
new NpgsqlParameter("@ORDER_NO", orderListDetailPostEntity.ORDER_NO), new NpgsqlParameter("@BUMP_ID", orderListDetailPostEntity.BUMP_ID));
myContext.Database.ExecuteSqlCommand("DELETE FROM \"INNER_ORDER_BOM_ITEM_STANDARD\" WHERE \"ORDER_NO\" = @ORDER_NO AND \"BUMP_ID\" = @BUMP_ID",
new NpgsqlParameter("@ORDER_NO", orderListDetailPostEntity.ORDER_NO), new NpgsqlParameter("@BUMP_ID", orderListDetailPostEntity.BUMP_ID));
foreach (JObject item in innerOrderBOMItemStandard)
{
INNER_ORDER_BOM_ITEM_STANDARD itemEntity = item.ToObject <INNER_ORDER_BOM_ITEM_STANDARD>();
itemEntity.ORDER_NO = orderListDetailPostEntity.ORDER_NO;
itemEntity.BUMP_ID = orderListDetailPostEntity.BUMP_ID;
myContext.INNER_ORDER_BOM_ITEM_STANDARD.AddAsync(itemEntity);
}
foreach (JObject item in innerOrderBOMItemBase)
{
INNER_ORDER_BOM_ITEM_BASE itemEntity = item.ToObject <INNER_ORDER_BOM_ITEM_BASE>();
itemEntity.ORDER_NO = orderListDetailPostEntity.ORDER_NO;
itemEntity.BUMP_ID = orderListDetailPostEntity.BUMP_ID;
myContext.INNER_ORDER_BOM_ITEM_BASE.AddAsync(itemEntity);
}
myContext.SaveChanges();
var innerOrderbBasicSealMstEntity = myContext.INNER_ORDER_BASIC_SEAL_MST
.Where(d => d.ORDER_NO.Equals(orderListDetailPostEntity.ORDER_NO) && d.BUMP_ID.Equals(orderListDetailPostEntity.BUMP_ID));
var innerOrderOtherComponentMstEntity = myContext.INNER_ORDER_OTHER_COMPONENT_MST
.Where(d => d.ORDER_NO.Equals(orderListDetailPostEntity.ORDER_NO) && d.BUMP_ID.Equals(orderListDetailPostEntity.BUMP_ID));
if (innerOrderbBasicSealMstEntity.Count() == 0 && innerOrderOtherComponentMstEntity.Count() == 0)
{
// 补充项目
innerOrderBasicSealPostEntity.ORDER_NO = orderListDetailPostEntity.ORDER_NO;
innerOrderBasicSealPostEntity.BUMP_ID = orderListDetailPostEntity.BUMP_ID;
innerOrderBasicSealPostEntity.BUMP_TYPE = orderListDetailPostEntity.BUMP_TYPE;
innerOrderBasicSealPostEntity.BUMP_SERIAL_NO = orderListDetailPostEntity.BUMP_SERIAL_NO;
innerOrderBasicSealPostEntity.NUMBER = orderListDetailPostEntity.NUMBER;
innerOrderBasicSealPostEntity.FLOW = orderListDetailPostEntity.FLOW;
innerOrderBasicSealPostEntity.LIFT = orderListDetailPostEntity.LIFT;
innerOrderBasicSealPostEntity.STATION = orderListDetailPostEntity.STATION;
innerOrderOtherComponentPostEntity.ORDER_NO = orderListDetailPostEntity.ORDER_NO;
innerOrderOtherComponentPostEntity.BUMP_ID = orderListDetailPostEntity.BUMP_ID;
// TODO
myContext.INNER_ORDER_OTHER_COMPONENT_MST.Add(innerOrderOtherComponentPostEntity);
myContext.INNER_ORDER_BASIC_SEAL_MST.Add(innerOrderBasicSealPostEntity);
myContext.SaveChanges();
return("");
}
else
{
// 补充项目
innerOrderbBasicSealMstEntity.First().BUMP_TYPE = orderListDetailPostEntity.BUMP_TYPE;
innerOrderbBasicSealMstEntity.First().BUMP_SERIAL_NO = orderListDetailPostEntity.BUMP_SERIAL_NO;
innerOrderbBasicSealMstEntity.First().NUMBER = orderListDetailPostEntity.NUMBER;
innerOrderbBasicSealMstEntity.First().FLOW = orderListDetailPostEntity.FLOW;
innerOrderbBasicSealMstEntity.First().LIFT = orderListDetailPostEntity.LIFT;
innerOrderbBasicSealMstEntity.First().STATION = orderListDetailPostEntity.STATION;
// 其他项目
innerOrderbBasicSealMstEntity.First().WORKING_PRESSURE = innerOrderBasicSealPostEntity.WORKING_PRESSURE;
innerOrderbBasicSealMstEntity.First().TEST_PRESSURE = innerOrderBasicSealPostEntity.TEST_PRESSURE;
innerOrderbBasicSealMstEntity.First().SUPPRESS_PRESSURE = innerOrderBasicSealPostEntity.SUPPRESS_PRESSURE;
innerOrderbBasicSealMstEntity.First().FLANGE_STANDARD = innerOrderBasicSealPostEntity.FLANGE_STANDARD;
innerOrderbBasicSealMstEntity.First().NPSH = innerOrderBasicSealPostEntity.NPSH;
innerOrderbBasicSealMstEntity.First().BUMP_SPEED = innerOrderBasicSealPostEntity.BUMP_SPEED;
innerOrderbBasicSealMstEntity.First().MEDIA = innerOrderBasicSealPostEntity.MEDIA;
innerOrderbBasicSealMstEntity.First().TEMPERATURE = innerOrderBasicSealPostEntity.TEMPERATURE;
innerOrderbBasicSealMstEntity.First().VISCOSITY = innerOrderBasicSealPostEntity.VISCOSITY;
innerOrderbBasicSealMstEntity.First().INLET_PRESSURE = innerOrderBasicSealPostEntity.INLET_PRESSURE;
innerOrderbBasicSealMstEntity.First().PARTICULATES = innerOrderBasicSealPostEntity.PARTICULATES;
innerOrderbBasicSealMstEntity.First().SEAL_TYPE = innerOrderBasicSealPostEntity.SEAL_TYPE;
innerOrderbBasicSealMstEntity.First().SEAL_MODEL = innerOrderBasicSealPostEntity.SEAL_MODEL;
innerOrderbBasicSealMstEntity.First().SEAL_MATERIAL = innerOrderBasicSealPostEntity.SEAL_MATERIAL;
innerOrderbBasicSealMstEntity.First().ABD_SEAL_INFO = innerOrderBasicSealPostEntity.ABD_SEAL_INFO;
innerOrderbBasicSealMstEntity.First().OTHER_SEAL_PROVIDER = innerOrderBasicSealPostEntity.OTHER_SEAL_PROVIDER;
innerOrderbBasicSealMstEntity.First().OTHER_SEAL_INFO = innerOrderBasicSealPostEntity.OTHER_SEAL_INFO;
innerOrderbBasicSealMstEntity.First().OTHER_SEAL_MODEL = innerOrderBasicSealPostEntity.OTHER_SEAL_MODEL;
innerOrderbBasicSealMstEntity.First().NEED_SEAL_COOLER_FLG = innerOrderBasicSealPostEntity.NEED_SEAL_COOLER_FLG;
innerOrderbBasicSealMstEntity.First().SEAL_COOLER_MODEL = innerOrderBasicSealPostEntity.SEAL_COOLER_MODEL;
innerOrderbBasicSealMstEntity.First().BEARING_BRAND = innerOrderBasicSealPostEntity.BEARING_BRAND;
innerOrderbBasicSealMstEntity.First().BEARING_OTHER_INFO = innerOrderBasicSealPostEntity.BEARING_OTHER_INFO;
innerOrderbBasicSealMstEntity.First().INSTALL_DIRECTION = innerOrderBasicSealPostEntity.INSTALL_DIRECTION;
innerOrderOtherComponentMstEntity.First().BASE_TYPE = innerOrderOtherComponentPostEntity.BASE_TYPE;
innerOrderOtherComponentMstEntity.First().BASE_SPEC = innerOrderOtherComponentPostEntity.BASE_SPEC;
innerOrderOtherComponentMstEntity.First().SPECIAL_BASE_DETAIL = innerOrderOtherComponentPostEntity.SPECIAL_BASE_DETAIL;
innerOrderOtherComponentMstEntity.First().COUPLING_HOOD_TYPE = innerOrderOtherComponentPostEntity.COUPLING_HOOD_TYPE;
innerOrderOtherComponentMstEntity.First().COUPLING_HOOD_SPEC = innerOrderOtherComponentPostEntity.COUPLING_HOOD_SPEC;
innerOrderOtherComponentMstEntity.First().SPECIAL_HOOD_TYPE_DETAIL = innerOrderOtherComponentPostEntity.SPECIAL_HOOD_TYPE_DETAIL;
innerOrderOtherComponentMstEntity.First().ANCHOR_BOLT_TYPE = innerOrderOtherComponentPostEntity.ANCHOR_BOLT_TYPE;
innerOrderOtherComponentMstEntity.First().ANCHOR_BOLT_SPEC = innerOrderOtherComponentPostEntity.ANCHOR_BOLT_SPEC;
innerOrderOtherComponentMstEntity.First().ANCHOR_BOLT_MATERIAL = innerOrderOtherComponentPostEntity.ANCHOR_BOLT_MATERIAL;
innerOrderOtherComponentMstEntity.First().ANCHOR_BOLT_EXTRA_NUT_SPEC = innerOrderOtherComponentPostEntity.ANCHOR_BOLT_EXTRA_NUT_SPEC;
innerOrderOtherComponentMstEntity.First().ANCHOR_BOLT_EXTRA_PAD_SPEC = innerOrderOtherComponentPostEntity.ANCHOR_BOLT_EXTRA_PAD_SPEC;
innerOrderOtherComponentMstEntity.First().ANCHOR_BOLT_NUM = innerOrderOtherComponentPostEntity.ANCHOR_BOLT_NUM;
innerOrderOtherComponentMstEntity.First().COUPLING_TYPE = innerOrderOtherComponentPostEntity.COUPLING_TYPE;
innerOrderOtherComponentMstEntity.First().COUPLING_BUMP_COUPLET = innerOrderOtherComponentPostEntity.COUPLING_BUMP_COUPLET;
innerOrderOtherComponentMstEntity.First().COUPLING_ELECTRIC_COUPLET = innerOrderOtherComponentPostEntity.COUPLING_ELECTRIC_COUPLET;
innerOrderOtherComponentMstEntity.First().COUPLING_PIN = innerOrderOtherComponentPostEntity.COUPLING_PIN;
innerOrderOtherComponentMstEntity.First().COUPLING_JUMP_RING = innerOrderOtherComponentPostEntity.COUPLING_JUMP_RING;
innerOrderOtherComponentMstEntity.First().COUPLING_PROVIDER = innerOrderOtherComponentPostEntity.COUPLING_PROVIDER;
innerOrderOtherComponentMstEntity.First().COUPLING_SPEC = innerOrderOtherComponentPostEntity.COUPLING_SPEC;
innerOrderOtherComponentMstEntity.First().COUPLING_NUM = innerOrderOtherComponentPostEntity.COUPLING_NUM;
innerOrderOtherComponentMstEntity.First().SPECIAL_COUPLING_TYPE_DETAIL = innerOrderOtherComponentPostEntity.SPECIAL_COUPLING_TYPE_DETAIL;
innerOrderOtherComponentMstEntity.First().ELECTRIC_MOTER_TYPE = innerOrderOtherComponentPostEntity.ELECTRIC_MOTER_TYPE;
innerOrderOtherComponentMstEntity.First().ELECTRIC_MOTER_PROVIDER = innerOrderOtherComponentPostEntity.ELECTRIC_MOTER_PROVIDER;
innerOrderOtherComponentMstEntity.First().ELECTRIC_MOTER_POWER = innerOrderOtherComponentPostEntity.ELECTRIC_MOTER_POWER;
innerOrderOtherComponentMstEntity.First().ELECTRIC_MOTER_SPEED = innerOrderOtherComponentPostEntity.ELECTRIC_MOTER_SPEED;
innerOrderOtherComponentMstEntity.First().ELECTRIC_MOTER_PFV = innerOrderOtherComponentPostEntity.ELECTRIC_MOTER_PFV;
innerOrderOtherComponentMstEntity.First().ELECTRIC_MOTER_EXTRA_INFO = innerOrderOtherComponentPostEntity.ELECTRIC_MOTER_EXTRA_INFO;
innerOrderOtherComponentMstEntity.First().COLOR_TYPE = innerOrderOtherComponentPostEntity.COLOR_TYPE;
innerOrderOtherComponentMstEntity.First().SPECIAL_COLOR_DETAIL = innerOrderOtherComponentPostEntity.SPECIAL_COLOR_DETAIL;
innerOrderOtherComponentMstEntity.First().SURFACE_TREAT_TYPE = innerOrderOtherComponentPostEntity.SURFACE_TREAT_TYPE;
innerOrderOtherComponentMstEntity.First().SURFACE_TREAT_EXTRA_INFO = innerOrderOtherComponentPostEntity.SURFACE_TREAT_EXTRA_INFO;
innerOrderOtherComponentMstEntity.First().TRANSPORT_TYPE = innerOrderOtherComponentPostEntity.TRANSPORT_TYPE;
innerOrderOtherComponentMstEntity.First().TRANSPORT_PLACE = innerOrderOtherComponentPostEntity.TRANSPORT_PLACE;
innerOrderOtherComponentMstEntity.First().PACKAGING_TYPE = innerOrderOtherComponentPostEntity.PACKAGING_TYPE;
innerOrderOtherComponentMstEntity.First().SPECIAL_PACK_DETAIL = innerOrderOtherComponentPostEntity.SPECIAL_PACK_DETAIL;
innerOrderOtherComponentMstEntity.First().NEED_FUME_CERTIFICATE = innerOrderOtherComponentPostEntity.NEED_FUME_CERTIFICATE;
innerOrderOtherComponentMstEntity.First().ADDRESS_INFO = innerOrderOtherComponentPostEntity.ADDRESS_INFO;
innerOrderOtherComponentMstEntity.First().REMARK = innerOrderOtherComponentPostEntity.REMARK;
myContext.SaveChanges();
return("");
}
}