public void Edit(dynamic data)
{
var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>
SYS_BOM
</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>");
var service = new SYS_BOMService();
var result = service.Edit(null, listWrapper, data);
}
public void Audit(string id, JObject data)
{
var pUpdate = ParamUpdate.Instance()
.Update("SYS_BOM")
.Column("ApproveState", data["status"])
.Column("ApproveRemark", data["comment"])
.Column("ApprovePerson", FormsAuth.GetUserData().UserName)
.Column("ApproveDate", DateTime.Now)
.AndWhere("ID", id);
var service = new SYS_BOMService();
var rowsAffected = service.Update(pUpdate);
MmsHelper.ThrowHttpExceptionWhen(rowsAffected < 0, "单据审核失败[BillNo={0}]，请重试或联系管理员！", id);
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>SYS_BOM</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='PartCode' cp='equal'></field>
</where>
</settings>");
var service = new SYS_BOMService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
public dynamic GetPageData(string id)
{
var masterService = new SYS_BOMService();
var pQuery = ParamQuery.Instance().AndWhere("ID", id);
var data = masterService.GetModel(pQuery);
var pQuery2 = ParamQuery.Instance().AndWhere("InventoryName", data.PartName);
var result = new
{
//主表数据
form = data,
scrollKeys = masterService.ScrollKeys("ID", id),
//明细数据
tab0 = new SYS_PartService().GetDynamicList(pQuery2)
};
return(result);
}
public List <dynamic> GetBom(string pCode, string cCode, int pID)
{
var list = new SYS_BOMService().GetBom2(pCode, cCode, pID);
list = (from p in list
group p by p.PartCode into g
select new
{
PartCode = g.Key,
PartFigureCode = g.Max(m => m.PartFigureCode),
IsSelfMade = g.Max(m => m.IsSelfMade),
PartName = g.Max(m => m.PartName),
TotalStock = g.Max(m => m.TotalStock),
PartQuantityAll = g.Sum(m => m.PartQuantityAll ?? 0),
ParentCode = g.Max(m => m.ParentCode),
ParentName = g.Max(m => m.ParentName)
}).ToList <dynamic>();
return(list);
}
