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);
}
