public void Edit(dynamic data)
{
var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>
PRS_BarCreateMate
</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>");
var service = new PRS_BarCreateMateService();
var result = service.Edit(null, listWrapper, data);
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>a.*,b.FigureCode</select>
<from>PRS_BarCreateMate a left join SYS_Part b on a.InventoryCode=b.InventoryCode</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true'>
<field name='ContractCode' cp='equal'></field>
</where>
</settings>");
var service = new PRS_BarCreateMateService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
public void PostCreateProductRequest(dynamic data)
{
var list = data.list;
foreach (dynamic item in list)
{
string ContractCode = item["ContractCode"];
string CreateType = item["CreateType"];
var BoardOrBarData = new List <dynamic>();
switch (CreateType)
{
case "板材":
BoardOrBarData = new PRS_BoardCreateMateService().GetDynamicList(ParamQuery.Instance().AndWhere("ContractCode", ContractCode));
break;
case "棒材":
BoardOrBarData = new PRS_BarCreateMateService().GetDynamicList(ParamQuery.Instance().AndWhere("ContractCode", ContractCode));
break;
case "车间":
int MainID = item["ID"];
BoardOrBarData = new MES_WorkshopPurchaseDetailService().GetDynamicList
(
ParamQuery
.Instance()
.Select("InventoryCode,PurchaseQuantity as InventoryNum,Remark")
.From("MES_WorkshopPurchaseDetail")
.AndWhere("MainID", MainID)
);
break;
default:
break;
}
using (var db = Db.Context("Mms"))
{
db.UseTransaction(true);
try
{
int MainID = new APS_ProductPurchaseMainService().GetModelList().Count > 0 ?
new APS_ProductPurchaseMainService().GetModelList().Max(a => a.ID) + 1 : 1;
db.Insert("APS_ProductPurchaseMain")
.Column("ID", MainID)
.Column("PurchaseDocumentCode", MmsHelper.GetOrderNumber("APS_ProductPurchaseMain", "PurchaseDocumentCode", "SCQG", "", ""))
.Column("ContractCode", ContractCode)
.Column("DepartmentCode", "0202")
.Column("PurchaseDate", DateTime.Now)
.Column("IsEnable", 1)
.Column("BillState", 1)
.Column("PurchaseType", CreateType.Equals("板材") ? 2 : CreateType.Equals("棒材") ? 3 : CreateType.Equals("车间") ? 4 : 1)
.Column("CreateTime", DateTime.Now)
.Column("CreatePerson", MmsHelper.GetUserName()).Execute();
foreach (var item_board in BoardOrBarData)
{
double PurchaseQuantity = Convert.ToDouble(item_board.InventoryNum);
string InventoryCode = item_board.New_InventoryCode;
string Remark = item_board.Remark;
string unit = "";
if (CreateType != "车间")
{
unit = item_board.Unit;
}
db.Insert("APS_ProductPurchaseDetail")
.Column("MainID", MainID)
//.Column("InventoryCode", InventoryCode)
.Column("InventoryCode", InventoryCode)
.Column("TotalRequestQuantity", Convert.ToInt32(PurchaseQuantity))
.Column("PurchaseQuantity", PurchaseQuantity)
.Column("StockQuantity", 0)
.Column("PurchaseState", 0)
.Column("DepartmentCode", "0202")
.Column("DepartmentName", "供应")
.Column("IsEnable", 1)
.Column("CreateTime", DateTime.Now)
.Column("Remark", Remark)
.Column("Unit", unit)
.Column("CreatePerson", MmsHelper.GetUserName()).ExecuteReturnLastId <int>();
}
db.Commit();
}
catch (Exception ex)
{
db.Rollback();
break;
}
}
}
}
/// <summary>
///
/// </summary>
/// <param name="bomList"></param>
/// <returns></returns>
public bool GetIsSum(string bomList)
{
bool IsCheck = new PRS_BarCreateMateService().GetIsSum2(bomList).Select(a => Convert.ToString(a.New_InventoryCode)).Distinct().Count() > 1 ? false : true;
return(IsCheck);
}
