public dynamic GetPageData(string id) { var masterService = new MES_MaterialPickMainService(); var pQuery = ParamQuery.Instance().AndWhere("ID", id); var mainData = masterService.GetModel(pQuery); if (mainData != null) { var pQuery2 = ParamQuery.Instance().AndWhere("MainID", mainData.ID).AndWhere("IsEnable", 1); var result = new { //主表数据 form = mainData, scrollKeys = masterService.ScrollKeys("ID", id), //明细数据 tab0 = new MES_MaterialPickDetailService().GetDynamicList(pQuery2) }; return(result); } else { var result = new { //主表数据 form = mainData, scrollKeys = masterService.ScrollKeys("ID", id), //明细数据 tab0 = "" }; return(result); } }
public void Edit(dynamic data) { var service = new MES_MaterialPickMainService(); if (data.form["BillCode"] != "系统生成") { var pQuery = ParamQuery.Instance().Select("*").AndWhere("ID", data.form["ID"]); MES_MaterialPickMain model = service.GetModel(pQuery); if (model.BillState != null && model.BillState == 2) { MmsHelper.ThrowHttpExceptionWhen(true, "已发布的不能修改!"); return; } } var ids = "("; foreach (JToken tab in data["tabs"].Children()) { foreach (JProperty item in tab.Children()) { if (item.Name == "deleted") { foreach (var row in item.Value.Children()) { ids += "'" + row["ID"] + "',"; } item.Value = "[]"; } } } if (ids != "(") { ids = ids.Remove(ids.Length - 1, 1); ids += ")"; using (var db = Db.Context("Mms")) { string sql1 = string.Format("update MES_MaterialPickDetail set IsEnable=0 where ID in {0} ", ids); db.Sql(sql1).Execute(); } } var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> MES_MaterialPickMain </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>MES_MaterialPickDetail</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); if (data.form["BillCode"] == "系统生成") { string documentNo = MmsHelper.GetOrderNumber("MES_MaterialPickMain", "BillCode", "CJLL", "", ""); data.form["BillCode"] = documentNo; } var result = service.EditPage(data, formWrapper, tabsWrapper); }