public List <PRS_Process_BOM_Blanking> GetIsSum2(string BomList = "")
{
var PRS_BarCreateMateList = new List <dynamic>();
List <PRS_Process_BOM_Blanking> barDataList = new PRS_Process_BOM_BlankingService().GetModelList(ParamQuery.Instance().AndWhere("ID", BomList, Cp.In));
return(barDataList);
}
public dynamic Get(RequestWrapper query)
{
string MateTypeListId = string.Join(",", MES_BlankingWorkshopSetMateController.MateTypeListId);
/*
* --参考：https://bbs.csdn.net/topics/230028389
*
* SELECT * FROM dbo.PRS_Process_BOM ORDER BY PartFigureCode
*
* SELECT * FROM dbo.PRS_Process_BOM ORDER BY PartFigureCode COLLATE SQL_Latin1_General_CP437_BIN
*
* SELECT * FROM dbo.PRS_Process_BOM ORDER BY replace (PartFigureCode,'-','0')
*/
query.LoadSettingXmlString(@"
<settings defaultOrderBy=' temp.PartFigureCode COLLATE SQL_Latin1_General_CP437_BIN '>
<select>*</select>
<from>
(SELECT ID,PartFigureCode,PartName,MaterialCode,MateType,SetMateName,ContractCode,ProductID,
New_InventoryCode,New_PartName,New_Model,MateParamValue,InPlanceSize,BlankingSize,BlankingNum,SetMateNum
FROM dbo.PRS_Process_BOM_Blanking a WHERE a.MateType IN({0})) as temp
</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true'>
<field name='temp.ContractCode' cp='like'></field>
<field name='temp.ProductID' cp='equal'></field>
</where>
</settings>", MateTypeListId);
var service = new PRS_Process_BOM_BlankingService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
public List <dynamic> GetBomList(string BomList = "")
{
var PRS_BarCreateMateList = new List <dynamic>();
List <PRS_Process_BOM_Blanking> barDataList = new PRS_Process_BOM_BlankingService().GetModelList(ParamQuery.Instance().AndWhere("ID", BomList, Cp.In));
//.AndWhere(Cp.In("ID", BomList)))
if (!string.IsNullOrWhiteSpace(BomList))
{
#region 原SQL
/*
* select a.ContractCode,a.New_InventoryCode InventoryCode,b.InventoryName,b.Model,b.Spec as Specs,b.FigureCode,sum(a.SetMateNum) TotalNum,0 RealNum,sum(a.SetMateNum) NeedNum
* from PRS_Process_BOM a
* left join SYS_Part b on a.New_InventoryCode=b.InventoryCode
* where a.MateType=2 and a.ID in({0}) AND ContractCode NOT IN (SELECT ContractCode FROM PRS_BarCreateMate WHERE a.IsEnable=1)
* group by a.ContractCode,a.New_InventoryCode,b.InventoryName,b.Model,b.Spec,b.FigureCode
*/
#endregion
var query = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings defaultOrderBy='temp.InventoryCode'>
<select>*</select>
<from>(
SELECT a.ContractCode,
a.New_InventoryCode InventoryCode,
b.InventoryName,
b.Model,
b.Spec AS Specs,
b.FigureCode,
SUM(a.SetMateNum) TotalNum,
0 RealNum,
SUM(a.SetMateNum) NeedNum
FROM dbo.PRS_Process_BOM_Blanking a
LEFT JOIN SYS_Part b
ON a.New_InventoryCode = b.InventoryCode
WHERE a.MateType IN (2,3)
AND a.ID IN ( {0} )
AND NOT EXISTS
(
SELECT 1
FROM PRS_BarCreateMate
WHERE a.IsEnable = 1
AND ContractCode = a.ContractCode
AND InventoryCode = a.New_InventoryCode
)
GROUP BY a.ContractCode,
a.New_InventoryCode,
b.InventoryName,
b.Model,
b.Spec,
b.FigureCode
) temp</from>
</settings>", BomList);
var service = new PRS_BarCreateMateService();
PRS_BarCreateMateList = service.GetDynamicList(query.ToParamQuery()).ToList <dynamic>();
}
return(PRS_BarCreateMateList);
}
public dynamic PostIsExistBlankingProcessBomData(dynamic data)
{
string ParentCode = data.ParentCode;
string ContractCode = data.ContractCode;
int ProductID = data.ProductID;
int IsExist = new PRS_Process_BOM_BlankingService().GetModelList(
ParamQuery.Instance()
.AndWhere("ParentCode", ParentCode)
.AndWhere("ContractCode", ContractCode)
.AndWhere("ProductID", ProductID)).Count;
return(IsExist > 0 ? true : false);
}
public void Edit(dynamic data)
{
var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>
PRS_Process_BOM_Blanking
</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>");
var service = new PRS_Process_BOM_BlankingService();
if (data.list.updated.ToString() != "[]")
{
foreach (JToken row in data["list"]["updated"].Children())
{
string SetMateName = row["SetMateName"].ToString();
string New_PartName = row["New_PartName"].ToString();
string New_Model = row["New_Model"].ToString();
//处理同上
//row["New_PartName"] = row["MaterialInventoryName"];//MaterialInventoryName代替InventoryName
//row["New_Model"] = row["MaterialInventoryCode"];//MaterialInventoryCode代替Model
//string inventoryCode = row["New_InventoryCode"].ToString();
//var inventory = service.GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("ID", row["ID"].ToString()));
SYS_Part part = new SYS_PartService().GetModel(ParamQuery.Instance().Select("*").AndWhere("InventoryCode", SetMateName));
bool mEquals = New_Model.Equals(part.Model == null ? "" : part.Model);
bool nEquals = New_PartName.Equals(part.InventoryName == null ? "" : part.InventoryName);
bool res = mEquals && nEquals;
row["MaterialInventoryName"] = part.InventoryName;
row["MaterialInventoryCode"] = part.Model;
row["New_InventoryCode"] = "";
if (res)
{
row["New_InventoryCode"] = row["SetMateName"];
}
/*else
* {
* if (row["New_InventoryCode"].ToString().Equals(row["SetMateName"].ToString()))
* {
* row["New_InventoryCode"] = "";
* }
* else
* {
*
* }
* }*/
////处理同上
//row["New_InventoryCode"] = row["SetMateName"];
//row["New_PartName"] = row["MaterialInventoryName"];//MaterialInventoryName代替InventoryName
//row["New_Model"] = row["MaterialInventoryCode"];//MaterialInventoryCode代替Model
//string inventoryCode = row["New_InventoryCode"].ToString();
//var inventory = service.GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("ID", row["ID"].ToString()));
//var pQuery = ParamQuery.Instance().Select("*").AndWhere("InventoryCode", inventory.SetMateName);
//SYS_Part part = new SYS_PartService().GetModel(pQuery);
//bool mEquals = row["MaterialInventoryCode"].ToString().Equals(part.Model == null ? "" : part.Model);
//bool nEquals = row["MaterialInventoryName"].ToString().Equals(part.InventoryName == null ? "" : part.InventoryName);
//bool res = mEquals && nEquals;
//row["MaterialInventoryName"] = part.InventoryName;
//row["MaterialInventoryCode"] = part.Model;
//if (!res)
//{
// row["New_InventoryCode"] = "";
//}
}
}
var result = service.Edit(null, listWrapper, data);
}
