public void EditType(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>pms_merchantsType</table> <where> <field name='MerchantsTypeCode' cp='equal'></field> </where> </settings>"); var service = new pms_merchantsService(); var result = service.Edit(null, listWrapper, data); }
public void Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>sys_user</table> <where> <field name='UserCode' cp='equal'></field> </where> </settings>"); var service = new sys_userService(); var result = service.Edit(null, listWrapper, data); }
public void Edit(dynamic data) { var service = new mms_drainpipeductService(); var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>mms_drainpipeduct</table> <where> <field name='BillNo' cp='equal'></field> </where> </settings>"); var result = service.Edit(formWrapper, null, data); }
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 Edit(dynamic data) { var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> WMS_BN_BillMain </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>WMS_BN_BillDetail</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); var service = new WMS_BN_BillMainService(); if (data.form["BillCode"] == "系统生成") { if (string.IsNullOrEmpty(WMS_BN_BillMainController.uc.Value)) { return; } string documentNo = MmsHelper.GetOrderNumber("WMS_BN_BillMain", "BillCode", WMS_BN_BillMainController.uc.Description, "", ""); data.form["BillCode"] = documentNo; foreach (JToken tab in data["tabs"].Children()) { foreach (JProperty item in tab.Children()) { if (item.Name == "inserted") { foreach (var row in item.Value.Children()) { row["BillCode"] = documentNo; } } } } } var result = service.EditPage(data, formWrapper, tabsWrapper); }
public void Edit(dynamic data) { var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>PMS_BN_ProjectDetail</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); var service = new PMS_BN_ProjectDetailService(); var result = service.EditPage(data, null, tabsWrapper); }
public void Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> sys_systemabnormallog </table> <where> <field name='Object_ID' cp='equal'></field> </where> </settings>"); var service = new sys_systemabnormallogService(); var result = service.Edit(null, listWrapper, data); }
public void GetEdit(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> ImageGrabbing </table> <where> <field name='ID' cp='equal'></field> </where> </settings>"); //var service = new ImageGrabbingService(); //var result = service.Edit(null, listWrapper, data); }
public void Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> QMS_QualityReportDoc </table> <where> <field name='ID' cp='equal'></field> </where> </settings>"); var service = new QMS_QualityReportDocService(); var result = service.Edit(null, listWrapper, data); }
public void Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> PMS_BN_ProjectPart </table> <where> <field name='ID' cp='equal'></field> </where> </settings>"); var service = new PMS_BN_ProjectPartService(); var result = service.Edit(null, listWrapper, data); }
public ActionResult GetCommonDialogData() { //获取url中的条件,注意requestData是弹出框中的查询条件,当动态添加的查询条件不在弹出框中时,需要先将requestData中的属性删除 var requestData = new NameValueCollection(Request.QueryString); //获取删选标识字段名 string PrimaryID = requestData["PrimaryID"]; //去掉弹出框中不需要的查询条件 requestData.Remove("xmlName"); // var xmlName = Request.QueryString["xmlName"].ToString(); //var selectID = Request.QueryString["selectID"].ToString(); XElement targetXml = CommonSearchDialog.GetSearchXml(xmlName); var settingsXml = targetXml.Element("settings"); var setting = RequestWrapper.Instance().LoadSettingXmlString(settingsXml.ToString()); if (Request.QueryString["PrimaryID"] != null) { requestData.Remove("PrimaryID"); } if (!string.IsNullOrWhiteSpace(PrimaryID)) { requestData.Remove(PrimaryID); } var query = setting.SetRequestData(requestData).ToParamQuery(); if (!string.IsNullOrWhiteSpace(PrimaryID)) { string NotInList = Request.QueryString[PrimaryID].ToString(); if (!string.IsNullOrEmpty(NotInList)) { query.AndWhere(PrimaryID, NotInList, Cp.NotIn); } } var service = setting.GetService(); var data = service.GetDynamicListWithPaging(query); //if (Request.QueryString["selectID"].ToString() != "") //{ // if (data.Count() > 0) // { // //string sql=string.Format(@"") // data = data.Where(i => !selectID.Contains(i.ID.toString())).ToList(); // } //} var json = JsonConvert.SerializeObject(data); return(Content(json, "application/json")); }
public void GetEdit(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> CamaraInfo </table> <where> <field name='CamaraCode' cp='equal'></field> </where> </settings>"); var service = new CamaraInfoService(); var result = service.Edit(null, listWrapper, data); }
public void Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> minimes_product </table> <where> <field name='InventoryId' cp='equal'></field> </where> </settings>"); var service = new minimes_productService(); var result = service.Edit(null, listWrapper, data); }
public void Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().SetXml(@" <settings> <table> mms_test </table> <where> <c column='ID' symbol='equal'></c> </where> </settings>"); var service = new mms_testService(); var result = service.Edit(null, listWrapper, data); }
public void Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> MES_WorkTicketMate </table> <where> <field name='ID' cp='equal'></field> </where> </settings>"); var service = new MES_WorkTicketMateService(); var result = service.Edit(null, listWrapper, data); }
public void Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> mms_lossReport </table> <where> <field name='BillNo' cp='equal'></field> </where> </settings>"); var service = new mms_lossReportService(); var result = service.Edit(null, listWrapper, data); }
public void Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> EQP_EquipmentMaintenance </table> <where> <field name='ID' cp='equal'></field> </where> </settings>"); var service = new EQP_EquipmentMaintenanceService(); var result = service.Edit(null, listWrapper, data); }
public void Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> APS_DispatchPlanDetail </table> <where> <field name='ID' cp='equal'></field> </where> </settings>"); var service = new APS_DispatchPlanDetailService(); var result = service.Edit(null, listWrapper, data); }
public void Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> (SELECT ID ,[ContractCode] ,[ProductID] ,[UserCode] ,[SaleMan] ,[InventoryCode] ,[InventoryName] ,[Model] ,[MaterialCode] ,[Quantity] ,[ArrivalQuantity] ,[SupplierCode] ,[PurchaseCode] ,[SigningTime] ,[InvoiceAmount] ,[InvoiceTime] ,[PlanArrivelDate] ,[PrchaseDate] ,[PickMaterialDate] ,[FinishDate] ,[ActualFinishDate] ,[CurrentState] ,[UnqualityQuantity] ,[RectificationNumber] ,[Remark] ,[IsEnable] ,[CreatePerson] ,[CreateTime] ,[ModifyPerson] ,[ModifyTime] ,PickMaterialState ,ActualFinishState ,InvoiceState ,UnqualityQuantityState ,RectificationState FROM [HBHC_Mes].[dbo].[Mes_PurchaseProcess]) as t </table> <where> <field name='ID' cp='equal'></field> </where> </settings>"); var service = new Mes_PurchaseProcessService(); var result = service.Edit(null, listWrapper, data); }
public dynamic Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> minimes_restdate </table> <where> <field name='ID' cp='equal'></field> </where> </settings>"); try { if (data.list.inserted.Count > 0) { foreach (var item in data.list.inserted) { item.CreatePerson = SysHelper.GetUserName(); item.TenantID = SysHelper.GetTenantId(); } } if (data.list.updated.Count > 0) { foreach (var item in data.list.updated) { item.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); item.CreatePerson = SysHelper.GetUserName(); item.TenantID = SysHelper.GetTenantId(); } } var service = new minimes_restdateService(); var result = service.Edit(null, listWrapper, data); if (result > 0) { return new { status = true, message = "保存成功" } } ; else { return new { status = false, message = "保存失败" } }; } catch (Exception ex) { return(new { status = false, message = ex.Message }); } }
public void Edit_TopList(dynamic data) { var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> MES_BN_ProductProcessRoute </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); var service = new MES_BN_ProductProcessRouteService(); var result = service.Edit(null, formWrapper, data); }
public void Edit(dynamic data) { var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> mms_direct </table> <where> <field name='BillNo' cp='equal'></field> </where> </settings>"); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>mms_directDetail</table> <where> <field name='BillNo' cp='equal'></field> <field name='RowId' cp='equal'></field> </where> </settings>")); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>mms_direct</table> <where> <field name='BillNo' cp='equal'></field> </where> </settings>")); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>mms_rentInDetail</table> <where> <field name='BillNo' cp='equal'></field> <field name='RowId' cp='equal'></field> </where> </settings>")); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>mms_merchants</table> <where> <field name='MerchantsCode' cp='equal'></field> </where> </settings>")); var service = new mms_directService(); var result = service.EditPage(data, formWrapper, tabsWrapper); }
public void Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> sys_menu </table> <where> <field name='MenuCode' cp='equal' variable='_Id'></field> </where> </settings>"); var service = new sys_menuService(); var result = service.Edit(null, listWrapper, data); service.Logger("api/mms/send", "菜单数据", "修改", data); }
public void Edit(dynamic data) { var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> QMS_ProcessInspection </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>QMS_ProcessInspectionItem</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); if (data.form["BillCode"] == "系统生成") { string documentNo = MmsHelper.GetOrderNumber("QMS_ProcessInspection", "BillCode", "GCJY", "", ""); data.form["BillCode"] = documentNo; //foreach (JToken tab in data["tabs"].Children()) //{ // foreach (JProperty item in tab.Children()) // { // if (item.Name == "inserted") // { // foreach (var row in item.Value.Children()) // { // row["BillCode"] = documentNo; // } // } // } //} } var service = new QMS_ProcessInspectionService(); var result = service.EditPage(data, formWrapper, tabsWrapper); }
public ActionResult GetCommonDialogData1() { var requestData = new NameValueCollection(Request.QueryString); requestData.Remove("xmlName"); var selectID = Request.QueryString["selectID"].ToString(); var xmlName = Request.QueryString["xmlName"].ToString(); XElement targetXml = CommonSearchDialog.GetSearchXml(xmlName); var settingsXml = targetXml.Element("settings"); var setting = RequestWrapper.Instance().LoadSettingXmlString(settingsXml.ToString()); var query = setting.SetRequestData(requestData).ToParamQuery(); var service = setting.GetService(); var data = service.GetDynamicListWithPaging(query); var json = JsonConvert.SerializeObject(data); return(Content(json, "application/json")); }
public dynamic Edit(dynamic data) { //.SetJson(@"table:'sys_organize',where:[{column:'OrganizeCode',values:'{_OrganizeCode}'}]") var wrapper = RequestWrapper.Instance() .SetXml(@" <settings> <table>sys_organize</table> <where><c column='OrganizeCode' values='{_OrganizeCode}'></c></where> </settings>"); var service = new sys_organizeService(); service.Edit(data, wrapper, null); var result = service.GetModelList(); return(result); }
public dynamic Edit(dynamic data) { var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> sys_organize </table> <where> <field name='OrganizeCode' cp='equal' variable='_OrganizeCode'></field> </where> </settings>"); var service = new sys_organizeService(); service.Edit(formWrapper, null, data); var result = service.GetModelList(); return(result); }
public void Edit(dynamic data) { var id = data.form["ID"].ToString(); var pQuery = ParamQuery.Instance().Select("*").AndWhere("ID", id); var re = new PRS_ProcessRouteModelMainService().GetModelList(pQuery); if (re.Count > 0 && re[0].BillState == 1) { MmsHelper.ThrowHttpExceptionWhen(true, "已审核数据不能修改!"); return; } var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> PRS_ProcessRouteModelMain </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>PRS_ProcessRouteModelDetail</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); var service = new PRS_ProcessRouteModelMainService(); if (data.form["ProcessRouteCode"] == "系统生成") { string documentNo = MmsHelper.GetLSNumber("PRS_ProcessRouteModelMain", "ProcessRouteCode", "GYMX", "", ""); data.form["ProcessRouteCode"] = documentNo; } var result = service.EditPage(data, formWrapper, tabsWrapper); }
public virtual void Edit(dynamic data) { var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>{0}</table> <where><field name='BillNo' cp='equal'></field></where> </settings>", typeof(TMasterModel).Name); var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>{0}</table> <where> <field name='BillNo' cp='equal'></field> <field name='RowId' cp='equal'></field> </where> </settings>", typeof(TDetailModel).Name); var result = masterService.Edit(formWrapper, listWrapper, data); }
public void Edit(dynamic data) { var service = new MES_WorkshopPurchaseMainService(); if (data.form["WorkshopPurchaseCode"] != "系统生成") { var pQuery = ParamQuery.Instance().Select("*").AndWhere("ID", data.form["ID"]); MES_WorkshopPurchaseMain model = service.GetModel(pQuery); if (model.ApproveState != null && model.ApproveState == "2") { MmsHelper.ThrowHttpExceptionWhen(true, "已发布的不能修改!"); return; } } var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> MES_WorkshopPurchaseMain </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>MES_WorkshopPurchaseDetail</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); if (data.form["WorkshopPurchaseCode"] == "系统生成") { string documentNo = MmsHelper.GetOrderNumber("MES_WorkshopPurchaseMain", "WorkshopPurchaseCode", "CJQG", "", ""); data.form["WorkshopPurchaseCode"] = documentNo; } var result = service.EditPage(data, formWrapper, tabsWrapper); }