public string PostStorage(dynamic data)
{
string msg = "";
string BillCode = data["BillCode"];
var result = new QMS_ProcessInspectionItemService().AuditBillCode(data["BillCode"].ToString(), out msg);
//生成物料条码：自制件
var QMS_ProcessInspectionModel = new QMS_ProcessInspectionService().GetModel(ParamQuery.Instance().AndWhere("BillCode", BillCode));
if (QMS_ProcessInspectionModel != null)
{
string InnerFactoryBatch = QMS_ProcessInspectionModel.BatchCode; //厂内批次
string OuterFactoryBatch = QMS_ProcessInspectionModel.OuterFactoryBatch; //厂外批次
string PartCode = QMS_ProcessInspectionModel.PartCode;
string PartName = QMS_ProcessInspectionModel.PartName;
string PartFigureCode = QMS_ProcessInspectionModel.partFigure;
string ContractCode = QMS_ProcessInspectionModel.ContractCode;
string ProductName = QMS_ProcessInspectionModel.ProductName;
int ProductID = new PMS_BN_ProjectDetailService().GetModel(ParamQuery.Instance().AndWhere("ProductName", ProductName)).ID;
var ProcessBomModel = new PRS_Process_BOMService().GetModel(ParamQuery.Instance().AndWhere("PartCode", PartCode));
if (ProcessBomModel != null)
{
string InventoryCode = ProcessBomModel.InventoryCode; //存货编码
string InventoryName = ProcessBomModel.InventoryName; //存货名称
var SYS_MaterialBatchModel = new SYS_MaterialBatchService().GetModel(ParamQuery.Instance()
.AndWhere("PartCode", PartCode)
.AndWhere("InnerFactoryBatch", InnerFactoryBatch)
.AndWhere("OuterFactoryBatch", OuterFactoryBatch));
if (SYS_MaterialBatchModel == null)
{
var model = new SYS_MaterialBatchService();
string MateBarCode = model.CreateMateBarCode(700000000000);
model.Insert(ParamInsert.Instance()
.Insert("SYS_MaterialBatch")
.Column("MateBarCode", MateBarCode)
.Column("InventoryCode", InventoryCode)
.Column("InventoryName", InventoryName)
.Column("PartCode", PartCode)
.Column("PartFigureCode", PartFigureCode)
.Column("PartName", PartName)
.Column("InnerFactoryBatch", InnerFactoryBatch)
.Column("OuterFactoryBatch", OuterFactoryBatch)
.Column("ContractCode", ContractCode)
.Column("ProductID", ProductID));
}
}
}
return(msg);
}
//todo 改成支持多个Tab
// 地址：GET api/mms/@(controller)/getnewrowid 预取得新的明细表的行号
public string GetNewRowId(string type, string key, int qty = 1)
{
switch (type)
{
case "grid0":
var service0 = new QMS_ProcessInspectionItemService();
return(service0.GetNewKey("ID", "maxplus", qty, ParamQuery.Instance().AndWhere("ID", key, Cp.Equal)));
default:
return("");
}
}
