public dynamic GetModelType()
{
var service = new APS_BN_DispatchModelMainService();
var pQuery = ParamQuery.Instance().Paging(1, 100).AndWhere("IsEnable", 1);
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
//todo 改成支持多个Tab
// 地址：GET api/mms/@(controller)/getnewrowid 预取得新的明细表的行号
public string GetNewRowId(string type, string key, int qty = 1)
{
switch (type)
{
case "grid0":
var service0 = new APS_BN_DispatchModelMainService();
return(service0.GetNewKey("ID", "maxplus", qty, ParamQuery.Instance().AndWhere("ID", key, Cp.Equal)));
default:
return("");
}
}
public void Audit(string id, JObject data)
{
var pUpdate = ParamUpdate.Instance()
.Update("APS_BN_DispatchModelMain")
.Column("ApproveState", data["status"])
.Column("ApproveRemark", data["comment"])
.Column("ApprovePerson", FormsAuth.GetUserData().UserName)
.Column("ApproveDate", DateTime.Now)
.AndWhere("ID", id);
var service = new APS_BN_DispatchModelMainService();
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>APS_BN_DispatchModelMain</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='Name' cp='like'></field>
</where>
</settings>");
var service = new APS_BN_DispatchModelMainService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
public dynamic GetPageData(string id)
{
var masterService = new APS_BN_DispatchModelMainService();
var pQuery = ParamQuery.Instance().AndWhere("ID", id);
//var result = new
//{
// //主表数据
// form = masterService.GetModel(pQuery),
// scrollKeys = masterService.ScrollKeys("ID", id),
// //明细数据
// tab0 = new APS_BN_DispatchModelDetailService().GetDynamicList(ParamQuery.Instance().AndWhere("MainID", id))
//};
//return result;
var mainData = masterService.GetModel(pQuery);
if (mainData != null)
{
var pQuery2 = ParamQuery.Instance().AndWhere("MainID", mainData.ID);
var result = new
{
//主表数据
form = mainData,
scrollKeys = masterService.ScrollKeys("ID", id),
//明细数据
tab0 = new APS_BN_DispatchModelDetailService().GetDynamicList(pQuery2),
};
return(result);
}
else
{
var result = new
{
//主表数据
form = mainData,
scrollKeys = masterService.ScrollKeys("ID", id),
//明细数据
tab0 = "",
tab1 = ""
};
return(result);
}
}