public ExcelFormatHeader SaveExcelFormat(ExcelFormatHeader Header)
{
DB.BeginTran();
try
{
if (Header.Id <= 0)
{
Header.Id = DB.Insertable <ExcelFormatHeader>(Header).IgnoreColumns(o => o.Id).ExecuteReturnIdentity();
AttachStandardBomDetails(Header);
}
else
{
bool change = DB.Updateable <ExcelFormatHeader>(Header)
.IgnoreColumns(o => o.Id)
.Where(o => o.Id == Header.Id)
.ExecuteCommandHasChange();
}
DB.CommitTran();
}
catch (Exception ex)
{
DB.RollbackTran();
throw ex;
}
return(Header);
}
/// <summary>
/// 附加默认的明细
/// </summary>
public void AttachStandardBomDetails(ExcelFormatHeader NewingHeader)
{
var d1 = new BomFormatDetail()
{
diy_type = "3", cell_type = "SYS", field_no = "prd_no", cell_index = 1, field_name = "物料编码", check_exist = "PRDT.PRD_NO"
};
var d2 = new BomFormatDetail()
{
diy_type = "3", cell_type = "SYS", field_no = "name", cell_index = 1, field_name = "物料名称", check_exist = ""
};
var d3 = new BomFormatDetail()
{
diy_type = "3", cell_type = "SYS", field_no = "qty", cell_index = 1, field_name = "标准用量", check_exist = ""
};
var d4 = new BomFormatDetail()
{
diy_type = "1", cell_type = "SYS", field_no = "dep", cell_index = 1, field_name = "部门编码", check_exist = "DEPT.DEP"
};
var d5 = new BomFormatDetail()
{
diy_type = "1", cell_type = "SHOW", field_no = "dep_name", cell_index = 1, field_name = "部门名称"
};
var d6 = new BomFormatDetail()
{
diy_type = "3", cell_type = "SYS", field_no = "rem", cell_index = 1, field_name = "备注"
};
d1.excel_id = d2.excel_id = d3.excel_id = d4.excel_id = d5.excel_id = d6.excel_id = NewingHeader.Id;
DB.Insertable <BomFormatDetail>(d1).IgnoreColumns(o => o.Id).ExecuteCommand();
DB.Insertable <BomFormatDetail>(d2).IgnoreColumns(o => o.Id).ExecuteCommand();
DB.Insertable <BomFormatDetail>(d3).IgnoreColumns(o => o.Id).ExecuteCommand();
DB.Insertable <BomFormatDetail>(d4).IgnoreColumns(o => o.Id).ExecuteCommand();
DB.Insertable <BomFormatDetail>(d5).IgnoreColumns(o => o.Id).ExecuteCommand();
DB.Insertable <BomFormatDetail>(d6).IgnoreColumns(o => o.Id).ExecuteCommand();
// 模版编码 "标准样式"
// 配方号 * -1 BOM_NO
// 物料编码 * 3 PRD_NO 检查存在 PRDT.PRD_NO
// 物料名称 * 4 PRD_NAME
// 标准用量 * 5 QTY
// 部门编码 * 7 DEP_NO 检查存在 DEPT.DEP_NO
//部门名称 6 DEP_NAME 外(2)
// Z_颜色 8 Z_COLOR 系统自定义(1)
// Z_机头型号 9 Z_MA_NUMBER 系统自定义(1)
// 备注 10 REM
}
public ExcelFormatHeader FetchExcelFormat(string FormatNo)
{
var q = DB.Queryable <ExcelFormatHeader>();
q.Where(o => o.FormatNo == FormatNo);
ExcelFormatHeader excelHeader = q.First();
if (excelHeader != null)
{
excelHeader.Details = DB.Queryable <BomFormatDetail>()
.Where(o => o.excel_id == excelHeader.Id).OrderBy(o => o.diy_type)
.ToList();
}
return(excelHeader);
}
public ExcelFormatHeader SaveExcelFormat([FromBody] ExcelFormatHeader Header)
{
var result = Service.SaveExcelFormat(Header);
return(result);
}
