public dynamic GetPageData(string id)
{
var masterService = new Mes_BlankingBoardService();
var pQuery = ParamQuery.Instance().AndWhere("ID", id);
var detail = new Mes_BlankingResultService().GetDynamicList(ParamQuery.Instance().AndWhere("MainID", id).AndWhere("IsEnable", 1));
var query = new RequestWrapper();
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>V__Mes_BlankingResult</from>
</settings>");
var result = new
{
//主表数据
form = masterService.GetModel(pQuery),
scrollKeys = masterService.ScrollKeys("ID", id),
//明细数据
tab0 = new Mes_BlankingResultService().GetDynamicListWithPaging(query.ToParamQuery().AndWhere("MainID", id).AndWhere("IsEnable", 1))
//new Mes_BlankingResultService().GetDynamicListWithPaging(query.ToParamQuery().AndWhere("MainID", id).AndWhere("IsEnable",1))
};
return(result);
}
public void Edit(dynamic data)
{
var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>
Mes_BlankingBoard
</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>
");
var tabsWrapper = new List <RequestWrapper>();
tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>Mes_BlankingResult</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>"));
var service = new Mes_BlankingBoardService();
var result = service.EditPage(data, formWrapper, tabsWrapper);
}
public void Edit(dynamic data)
{
var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>
Mes_BlankingBoard
</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>
");
var tabsWrapper = new List <RequestWrapper>();
tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>Mes_BlankingResult</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>"));
var service = new Mes_BlankingBoardService();
foreach (JToken tab in data["tabs"].Children())
{
foreach (JProperty item in tab.Children())
{
int res = 0;
if (item.Name == "inserted")
{
foreach (var row in item.Value.Children())
{
using (var db = Db.Context("Mms"))
{
string mID = row["MainID"].ToString();
string nId = row["ID"].ToString();
res = db.Update("Mes_BlankingResult")
.Column("MainID", mID)
.Column("IsBlanking", 1)
.Where("ID", nId)
.Execute();
}
}
item.Value = "[]";
}
}
}
var result = service.EditPage(data, formWrapper, tabsWrapper);
}
public void Audit(string id, JObject data)
{
var pUpdate = ParamUpdate.Instance()
.Update("Mes_BlankingBoard")
.Column("ApproveState", data["status"])
.Column("ApproveRemark", data["comment"])
.Column("ApprovePerson", FormsAuth.GetUserData().UserName)
.Column("ApproveDate", DateTime.Now)
.AndWhere("ID", id);
var service = new Mes_BlankingBoardService();
var rowsAffected = service.Update(pUpdate);
MmsHelper.ThrowHttpExceptionWhen(rowsAffected < 0, "单据审核失败[BillNo={0}]，请重试或联系管理员！", id);
}
public dynamic GetPageData(string id)
{
var masterService = new Mes_BlankingBoardService();
var pQuery = ParamQuery.Instance().AndWhere("ID", id);
var result = new {
//主表数据
form = masterService.GetModel(pQuery),
scrollKeys = masterService.ScrollKeys("ID", id),
//明细数据
tab0 = new Mes_BlankingResultService().GetDynamicList(pQuery)
};
return(result);
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>(SELECT t1.*,
t2.Model,
t2.BatchCode
FROM dbo.Mes_BlankingBoard t1
INNER JOIN dbo.WMS_BN_RealStock t2
ON t1.BoardInventoryCode = t2.InventoryCode
AND t2.IsEnable = 1) as tmp</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='ContractCode' cp='equal'></field>
<field name='BoardInventoryName' cp='equal'></field>
<field name='IsEnable' cp='equal'></field>
</where>
</settings>");
var service = new Mes_BlankingBoardService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
