public dynamic Get(RequestWrapper query) { if (query["PartTypeCode"] != "") { query.LoadSettingXmlString(@" <settings defaultOrderBy='ID'> <select>*</select> <from>(select * from SYS_PartType where PartTypeCode like 'CCC%') as temp</from> </settings>"); var pQuery = query.ToParamQuery(); pQuery.GetData().From = pQuery.GetData().From.Replace("CCC", query["PartTypeCode"].ToString()); var service = new SYS_PartTypeService(); var result = service.GetDynamicListWithPaging(pQuery); return(result); } else { query.LoadSettingXmlString(@" <settings defaultOrderBy='ID'> <select>*</select> <from>SYS_PartType </from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true'> <field name='PartTypeCode' cp='like'></field> </where> </settings>"); var pQuery = query.ToParamQuery(); var service = new SYS_PartTypeService(); var result = service.GetDynamicListWithPaging(pQuery); return(result); } }
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 override dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='BillNo'> <select> A.*, B.ProjectName, C.MerchantsName </select> <from> mms_rentOut A left join mms_project B on B.ProjectCode = A.ProjectCode left join mms_merchants C on C.MerchantsCode = A.SupplierCode </from> <where defaultForAll='false' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='BillNo' cp='equal' ></field> <field name='ProjectName' cp='like' ></field> <field name='C.MerchantsName' cp='like' ></field> <field name='ContractCode' cp='like' ></field> <field name='RentOutDate' cp='daterange' ></field> </where> </settings>"); var pQuery = query.ToParamQuery().AndWhere("IsTotal", query["IsTotal"], x => "true".Equals(x.Value) ? "IsTotal=1" : "isnull(IsTotal,0)<>1"); var result = masterService.GetDynamicListWithPaging(pQuery); return(result); }
public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='BillNo'> <select> A.*,B.Name as WarehouseName,C.Name as CustomerName </select> <from> psi_picking A left join psi_warehouse B on B.Id = A.Warehouse left join psi_customer C on C.Id = A.CustomNo left join psi_customerContract D on D.ContractNo = A.Contract </from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='BillNo' cp='equal' ></field> <field name='Warehouse' cp='equal' ></field> <field name='PickingPerson' cp='like' ></field> <field name='PickingDate' cp='daterange' ></field> <field name='C.Name' cp='like' variable='CustomerName'></field> <field name='Contract' cp='like' ></field> </where> </settings>"); var PickingService = new psi_pickingService(); var pQuery = query.ToParamQuery(); var result = PickingService.GetDynamicListWithPaging(pQuery); return(result); }
public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='BillNo'> <select> A.*,B.Name as SupplierName,case when A.AuditState='passed' then 'true' else 'false' end as IsEffect </select> <from> psi_purchase A left join psi_supplier B on B.Id = A.Supplier </from> <where defaultForAll='false' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='BillNo' cp='equal' ></field> <field name='PurchasePerson' cp='like' ></field> <field name='Contract' cp='like' ></field> <field name='PurchaseDate' cp='daterange' ></field> <field name='C.Name' cp='like' variable='SupplierName'></field> </where> </settings>"); var PurchaseService = new psi_purchaseService(); var pQuery = query.ToParamQuery(); pQuery.AndWhere("AuditState", query["IsEffect"], x => x.Value == "true"?"AuditState='passed'":"isnull(AuditState,'') <> 'passed'"); var result = PurchaseService.GetDynamicListWithPaging(pQuery); return(result); }
public override dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='BillNo'> <select> A.*, B.ProjectName, C.MaterialTypeName, D.WarehouseName </select> <from> mms_check A left join mms_project B on B.ProjectCode = A.ProjectCode left join mms_materialType C on C.MaterialType = A.MaterialType left join mms_warehouse D on D.WarehouseCode = A.WarehouseCode </from> <where defaultForAll='false' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='BillNo' cp='equal' ></field> <field name='ProjectName' cp='like' ></field> <field name='DoPerson' cp='like' ></field> <field name='A.WarehouseCode' cp='equal' variable='WarehouseCode'></field> <field name='A.MaterialType' cp='equal' ></field> <field name='CheckDate' cp='daterange' ></field> </where> </settings>"); //if(query["IsShowDiff"] == "true") // var a =0; var pQuery = query.ToParamQuery().AndWhere("IsShowDiff", query["IsShowDiff"], x => "true".Equals(x.Value) ? "isnull(A.BookMoney,0)<>isnull(A.OperateMoney,0)" : "1=1").AndWhere("A.ProjectCode", MmsHelper.GetCurrentProject()); //.AndWhere("CheckDate", query["CheckDate"], x => x == null ? "1=1" : string.Format("CheckDate", x.Value)); var result = masterService.GetDynamicListWithPaging(pQuery); return(result); }
public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='BillNo'> <select> A.*,B.Name as WarehouseName,C.Name as SupplierName </select> <from> psi_receive A left join psi_warehouse B on B.Id = A.Warehouse left join psi_supplier C on C.Id = A.Supplier </from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='BillNo' cp='equal' ></field> <field name='Warehouse' cp='equal' ></field> <field name='ReceivePerson' cp='like' ></field> <field name='Contract' cp='like' ></field> <field name='ReceiveDate' cp='daterange' ></field> <field name='C.Name' cp='like' variable='SupplierName'></field> </where> </settings>"); var ReceiveService = new psi_receiveService(); var pQuery = query.ToParamQuery(); var result = ReceiveService.GetDynamicListWithPaging(pQuery); return(result); }
public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='BillNo'> <select> A.* </select> <from> psi_return A </from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='BillNo' cp='like' ></field> <field name='PickingBillNo' cp='like' ></field> <field name='ReturnPerson' cp='like' ></field> <field name='Contract' cp='like' ></field> <field name='ReturnDate' cp='daterange' ></field> <field name='CustomNo' cp='like'></field> </where> </settings>"); var ReturnService = new psi_returnService(); var pQuery = query.ToParamQuery(); var result = ReturnService.GetDynamicListWithPaging(pQuery); return(result); }
public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='ID'> <select>*,(select TOP 1 PartFigureCode from PRS_Process_BOM where PartCode=MES_WorkingTicket.PartCode) PartFigureCode</select> <from>MES_WorkingTicket</from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true'> <field name='WorkTicketCode' cp='like'></field> <field name='ApsCode' cp='like'></field> <field name='TeamName' cp='like'></field> <field name='WorkshopName' cp='like'></field> <field name='ProcessName' cp='like'></field> <field name='WorkStepsName' cp='like'></field> <field name='EquipmentName' cp='like'></field> </where> </settings>"); var service = new MES_WorkingTicketService(); //string WorkshopCodeStr = "'nodata'"; //var WorkshopCodeList = new SYS_WorkGroupService() // .GetModelList(ParamQuery.Instance() // .Select("DISTINCT b.DepartID") // .From("SYS_WorkGroupDetail a LEFT JOIN SYS_WorkGroup b ON a.MainID=b.ID") // .AndWhere("a.UserCode", MmsHelper.GetUserCode())); var user = new SYS_BN_UserService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("UserCode", MmsHelper.GetUserCode())); //if (WorkshopCodeList.Count > 0) //{ // WorkshopCodeStr = "'" + string.Join("','", WorkshopCodeList.Select(a => a.DepartID)) + "'"; //} var pQuery = query.ToParamQuery(); //var result = service.GetDynamicListWithPaging(pQuery.AndWhere("WorkshopCode", user.DepartmentCode)); var result = service.GetDynamicListWithPaging(pQuery); return(result); }
public override dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='BillNo'> <select> A.*, B.ProjectName </select> <from> mms_deal A left join mms_project B on B.ProjectCode = A.ProjectCode </from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='BillNo' cp='equal' ></field> <field name='ProjectName' cp='like' ></field> <field name='DoPerson' cp='like' ></field> <field name='DealType' cp='equal' ></field> <field name='DealKind' cp='equal' ></field> <field name='ApplyDate' cp='daterange' ></field> </where> </settings>"); var pQuery = query.ToParamQuery().AndWhere("A.ProjectCode", MmsHelper.GetCurrentProject()); return(masterService.GetDynamicListWithPaging(pQuery)); }
//工单 public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='temp.ID'> <select>*</select> <from>(select * from V_APS_ProjectProduceDetial where ContractCode=(select ContractCode from PMS_BN_ProjectPart where PartCode='xxx') and ProjectDetailID=(select ProjectDetailID from PMS_BN_ProjectPart where PartCode='xxx')) as temp</from> </settings>"); var service = new APS_ProjectProduceDetialService(); var pQuery = query.ToParamQuery(); var c = query["PartCode"].ToString().Length; if (c != 0) { pQuery.GetData().From = pQuery.GetData().From.Replace("xxx", query["PartCode"].ToString()); } else { return(null); } var result = service.GetDynamicListWithPaging(pQuery); return(result); }
// 查询主表:GET api/mms/send public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='BillNo'> <select> A.* </select> <from> mms_drainpipeduct A </from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='BillNo' cp='equal' ></field> <field name='Address' cp='like' ></field> <field name='IdentificationCode' cp='like' ></field> <field name='Category' cp='like' ></field> <field name='Material' cp='like' ></field> <field name='PressureType' cp='like' ></field> <field name='OwnershipUnit' cp='like' ></field> <field name='Diameter' cp='like' ></field> </where> </settings>"); var service = new mms_drainpipeductService(); var pQuery = query.ToParamQuery().AndWhere("A.ProjectCode", MmsHelper.GetCurrentProject()); return(service.GetDynamicListWithPaging(pQuery)); }
/* * public string GetNewKey() * { * return new ImageGrabbingService().GetNewKey("ID", "maxplus"); * } */ public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='ID'> <select>*</select> <from>ImageGrabbing</from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='ID' cp='equal'></field> <field name='Serie' cp='equal'></field> <field name='Type' cp='equal'></field> <field name='Description' cp='equal'></field> <field name='IsEnable' cp='equal'></field> <field name='CreatePerson' cp='equal'></field> <field name='CreateDate' cp='daterange'></field> <field name='UpdatePerson' cp='equal'></field> <field name='UpdateDate' cp='daterange'></field> </where> </settings>"); //var service = new ImageGrabbingService(); var pQuery = query.ToParamQuery(); // var result = service.GetDynamicListWithPaging(pQuery); // return result; return(null); }
public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='CamaraCode'> <select>*</select> <from>CamaraInfo</from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='CamaraCode' cp='equal'></field> <field name='ViaductStakeID' cp='equal'></field> <field name='StartStakeCode' cp='equal'></field> <field name='EndStakeCode' cp='equal'></field> <field name='CamaraIP' cp='equal'></field> <field name='Price' cp='equal'></field> <field name='CamaraTypeID' cp='equal'></field> <field name='Description' cp='equal'></field> <field name='IsEnable' cp='equal'></field> <field name='CreatePerson' cp='equal'></field> <field name='CreateDate' cp='daterange'></field> <field name='UpdatePerson' cp='equal'></field> <field name='UpdateDate' cp='daterange'></field> </where> </settings>"); var service = new CamaraInfoService(); var pQuery = query.ToParamQuery(); var result = service.GetDynamicListWithPaging(pQuery); return(result); }
public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='ID'> <select>DISTINCT *</select> <from>V_APS_ProjectProduceDetial</from> <where defaultForAll='false' defaultCp='equal' defaultIgnoreEmpty='true'> <field name='ID' cp='In'></field> <field name='ContractCode' cp='equal'></field> <field name='ProjectDetailID' cp='equal'></field> <field name='PlanType' cp='equal'></field> <field name='PlanedStartTime' cp='daterange'></field> <field name='PlanedFinishTime' cp='daterange'></field> <field name='WorkshopID' cp='equal'></field> <field name='PlanState' cp='equal'></field> <field name='MonthPlanCode' cp='equal'></field> <field name='RootPartCode' cp='equal'></field> <field name='ProcessModelType' cp='In'></field> </where> </settings>").ToParamQuery(); var service = new APS_ProjectProduceDetialService(); var pQuery = query.ToParamQuery(); var result = service.GetDynamicListWithPaging(pQuery); return(result); }
// 地址:GET api/mms/direct public override dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='BillNo'> <select> A.*, B.ProjectName, C.MaterialTypeName,D.MerchantsName as SupplierName,E.MerchantsName as PickUnitName </select> <from> mms_direct A left join mms_project B on B.ProjectCode = A.ProjectCode left join mms_materialType C on C.MaterialType = A.MaterialType left join mms_merchants D on D.MerchantsCode = A.SupplierCode left join mms_merchants E on E.MerchantsCode = A.PickUnit </from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='BillNo' cp='equal' ></field> <field name='ContractCode' cp='like' ></field> <field name='D.MerchantsName' cp='like' variable='SupplierName' ></field> <field name='E.MerchantsName' cp='like' variable='PickUnitName' ></field> <field name='A.MaterialType' cp='equal' ></field> <field name='ArriveDate' cp='daterange' ></field> <field name='SupplyType' cp='equal' ></field> </where> </settings>"); var pQuery = query.ToParamQuery().AndWhere("A.ProjectCode", MmsHelper.GetCurrentProject()); return(masterService.GetDynamicListWithPaging(pQuery)); }
public IEnumerable <dynamic> Get(RequestWrapper req) { req.LoadSettingXmlString("<settings defaultOrderBy='RoleSeq'></settings>"); var result = new sys_roleService().GetModelList(req.ToParamQuery()); return(result); }
// 查询主表:GET api/mms/send public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='UserCode'> <select> * </select> <from> test_user </from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='UserCode' cp='like' ></field> <field name='UserName' cp='like' ></field> <field name='Description' cp='like' ></field> <field name='IsEnable' cp='equal' ></field> <field name='LoginCount' cp='equal' ></field> <field name='LastLoginDate' cp='daterange' ></field> </where> </settings>"); var pQuery = query.ToParamQuery(); var list = new mms_sendService().GetDynamicListWithPaging(pQuery); return(list); }
public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='ID'> <select>*</select> <from>WMS_BN_RealStock</from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='ID' cp='equal'></field> <field name='InventoryCode' cp='equal'></field> <field name='InventoryName' cp='equal'></field> <field name='Model' cp='equal'></field> <field name='RealStock' cp='equal'></field> <field name='TotalStock' cp='equal'></field> <field name='LockStock' cp='equal'></field> <field name='WarehouseCode' cp='equal'></field> <field name='WarehouseName' cp='equal'></field> <field name='BatchCode' cp='equal'></field> <field name='Unit' cp='equal'></field> <field name='Remark' cp='equal'></field> <field name='CreatePerson' cp='equal'></field> <field name='CreateTime' cp='equal'></field> <field name='ModifyPerson' cp='equal'></field> <field name='ModifyTime' cp='equal'></field> </where> </settings>"); var service = new WMS_BN_RealStockService(); var pQuery = query.ToParamQuery(); var result = service.GetDynamicListWithPaging(pQuery); return(result); }
public dynamic Get(RequestWrapper query) { string MateTypeListId = string.Join(",", MES_BlankingWorkshopSetMateController.MateTypeListId); /* * --参考:https://bbs.csdn.net/topics/230028389 * * SELECT * FROM dbo.PRS_Process_BOM ORDER BY PartFigureCode * * SELECT * FROM dbo.PRS_Process_BOM ORDER BY PartFigureCode COLLATE SQL_Latin1_General_CP437_BIN * * SELECT * FROM dbo.PRS_Process_BOM ORDER BY replace (PartFigureCode,'-','0') */ query.LoadSettingXmlString(@" <settings defaultOrderBy=' temp.PartFigureCode COLLATE SQL_Latin1_General_CP437_BIN '> <select>*</select> <from> (SELECT ID,PartFigureCode,PartName,MaterialCode,MateType,SetMateName,ContractCode,ProductID, New_InventoryCode,New_PartName,New_Model,MateParamValue,InPlanceSize,BlankingSize,BlankingNum,SetMateNum FROM dbo.PRS_Process_BOM_Blanking a WHERE a.MateType IN({0})) as temp </from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true'> <field name='temp.ContractCode' cp='like'></field> <field name='temp.ProductID' cp='equal'></field> </where> </settings>", MateTypeListId); var service = new PRS_Process_BOM_BlankingService(); var pQuery = query.ToParamQuery(); var result = service.GetDynamicListWithPaging(pQuery); return(result); }
public dynamic Get(RequestWrapper query) { //string ContractCode = query["ContractCode"]; query.LoadSettingXmlString(@" <settings defaultOrderBy='a.BatchingCode'> <select>a.ContractCode,c.ProjectName,a.RootPartCode,a.IsEnable, (SELECT TOP 1 PartFigureCode FROM dbo.PRS_Process_BOM WHERE PartCode = a.RootPartCode) RootFigureCode, (SELECT TOP 1 PartName FROM dbo.PRS_Process_BOM WHERE PartCode = a.RootPartCode) RootPartName, (SELECT TOP 1 PartFigureCode FROM dbo.PRS_Process_BOM WHERE PartCode = b.PartCode) PartFigureCode,b.PartCode, (SELECT TOP 1 PartName FROM dbo.PRS_Process_BOM WHERE PartCode = b.PartCode) PartName, (SELECT TOP 1 MaterialCode FROM dbo.PRS_Process_BOM WHERE PartCode = b.PartCode) MaterialCode, a.WorkshopCode,(SELECT TOP 1 DepartmentName FROM dbo.SYS_BN_Department WHERE DepartmentCode=a.WorkshopCode) WorkshopName,b.BatchingNum, b.OutDeptCode,(SELECT WarehouseName FROM SYS_BN_Warehouse WHERE WarehouseCode=b.OutDeptCode) OutDeptName</select> <from>MES_WorkshopBatching a LEFT JOIN MES_WorkshopBatchingDetail b ON a.BatchingCode=b.BatchingCode LEFT JOIN PMS_BN_Project c ON c.ContractCode=a.ContractCode</from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='a.ContractCode' cp='equal'></field> <field name='a.ProductID' cp='equal'></field> <field name='b.PartCode' cp='equal'></field> <field name='a.RootPartCode' cp='equal'></field> </where> </settings>"); var service = new MES_WorkshopBatchingService(); var pQuery = query.ToParamQuery(); var result = service.GetDynamicList(pQuery.AndWhere("a.IsEnable", 1)); return(result); }
public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='temp.RootPartCode'> <select>*</select> <from>(SELECT d.ContractCode,d.ProjectName,c.ProjectDetailID ProductID,c.RootPartCode,a.IsEnable, (SELECT TOP 1 PartFigureCode FROM dbo.PRS_Process_BOM WHERE PartCode = c.RootPartCode) RootFigureCode, (SELECT TOP 1 PartName FROM dbo.PRS_Process_BOM WHERE PartCode = c.RootPartCode) RootPartName, (SELECT TOP 1 PartFigureCode FROM dbo.PRS_Process_BOM WHERE InventoryCode = b.InventoryCode) PartFigureCode,b.InventoryCode, (SELECT TOP 1 PartCode FROM dbo.PRS_Process_BOM WHERE InventoryCode = b.InventoryCode) PartCode, (SELECT TOP 1 PartName FROM dbo.PRS_Process_BOM WHERE InventoryCode = b.InventoryCode) PartName, (SELECT TOP 1 MaterialCode FROM dbo.PRS_Process_BOM WHERE InventoryCode = b.InventoryCode) MaterialCode, a.WorkshopCode,(SELECT TOP 1 DepartmentName FROM dbo.SYS_BN_Department WHERE DepartmentCode=a.WorkshopCode) WorkshopName, a.ProcessName,a.WorkStepsName,ISNULL(b.RequiredQuantity,0) RequiredQuantity FROM MES_WorkingTicket a LEFT JOIN MES_WorkTicketMate b ON a.WorkTicketCode=b.WorkTicketCode LEFT JOIN dbo.APS_ProjectProduceDetial c ON c.ApsCode=a.ApsCode LEFT JOIN PMS_BN_Project d ON d.ContractCode=c.ContractCode WHERE a.IsEnable=1) as temp</from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='temp.ContractCode' cp='equal'></field> <field name='temp.ProductID' cp='equal'></field> <field name='temp.InventoryCode' cp='equal'></field> <field name='temp.RootPartCode' cp='equal'></field> </where> </settings>"); var service = new MES_WorkingTicketService(); var pQuery = query.ToParamQuery(); var result = service.GetDynamicList(pQuery.AndWhere("RequiredQuantity", 0, Cp.NotEqual)); return(result); }
//人员 public dynamic GetPeople(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='temp.ID'> <select>*</select> <from>( select t1.*,t2.TeamCode from SYS_WorkGroupDetail as t1 inner join SYS_WorkGroup as t2 on t1.MainID=t2.ID where t2.TeamCode='xxx') as temp</from> </settings>"); var service = new SYS_WorkGroupDetailService(); var pQuery = query.ToParamQuery(); var c = query["TeamCode"].ToString().Length; if (c != 0) { pQuery.GetData().From = pQuery.GetData().From.Replace("xxx", query["TeamCode"].ToString()); } else { return(null); } var result = service.GetDynamicListWithPaging(pQuery); return(result); }
//设计任务详细查询 public dynamic GetDesignDetailedData(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='ID'> <select>*</select> <from>PMS_DesignTaskDetail</from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true'> <field name='ContractCode' cp='equal'></field> <field name='IsEnable' cp='equal'></field> </where> </settings>"); var service = new PMS_DesignTaskDetailService(); var pQuery = query.ToParamQuery(); var result = service.GetDynamicListWithPaging(pQuery); return(result); //return null; //string where=""; //if(string.IsNullOrEmpty(contractCode)){ // where+=string.Format(" and ContractCode='{0}'",contractCode); //} // if(string.IsNullOrEmpty(productID)){ // where+=string.Format(" and PrductID='{0}'",productID); //} //using (var db = Db.Context("Mms")) //{ // string sql = string.Format(@"select * from PMS_DesignTaskDetail where 1=1 {0}", where); // dynamic res = db.Sql(sql).QueryMany<dynamic>(); // return res; //} }
public dynamic GetPageData(string id) { var query = new RequestWrapper(); query.LoadSettingXmlString(@" <settings defaultOrderBy='ID'> <select>*</select> <from>(SELECT t1.*, t2.SupplierName FROM dbo.Mes_PurchaseProcess t1 LEFT JOIN dbo.SYS_BN_Supplier t2 ON t1.SupplierCode = t2.SupplierCode AND t2.IsEnable = 1) as tmp</from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true'> </where> </settings>"); //var service = new Mes_PurchaseProcessService(); //var pQuery = query.ToParamQuery(); //var result = service.GetModel(pQuery.AndWhere("IsEnable", 1).AndWhere("ID",id)); //return result; var masterService = new Mes_PurchaseProcessService(); var pQuery = query.ToParamQuery().AndWhere("ID", id).AndWhere("IsEnable", 1); var result = new { //主表数据 form = masterService.GetDynamic(pQuery), scrollKeys = masterService.ScrollKeys("ID", id), //明细数据 }; return(result); }
public dynamic Get(RequestWrapper request) { request.LoadSettingXmlString(@" <settings defaultOrderBy='UserSeq'> <where> <field name='UserCode' cp='mapchild' extend='sys_userOrganizeMap,OrganizeCode,sys_organize' variable='OrganizeCode' ignoreEmpty='true'></field> </where> </settings>"); var service = new sys_userService(); var result = service.GetModelListWithPaging(request.ToParamQuery()); return result; }
public dynamic Get(RequestWrapper request) { request.LoadSettingXmlString(@" <settings defaultOrderBy='MaterialCode'> <where> <field name='MaterialType' cp='equal' ignoreEmpty='true'></field> </where> </settings>"); var service = new mms_materialService(); var result = service.GetModelListWithPaging(request.ToParamQuery()); return(result); }
/// <summary> /// 获得供应商级别列表 /// </summary> /// <param name="request"></param> /// <returns></returns> public dynamic GetProvLv(RequestWrapper request) { request.LoadSettingXmlString(@" <settings defaultOrderBy='Code'> <where> <field name='CodeType' cp='equal' ignoreEmpty='true'></field> </where> </settings>"); var service = new sys_codeService(); var result = service.GetModelList(request.ToParamQuery()); return(result); }
public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='temp.ContractCode'> <select>*</select> <from>(SELECT distinct t1.ID, t1.ContractCode,t1.SavantCode, t1.ProjectDetailID, t1.ProductPlanMainID, t1.PartCode, t1.ProcessCode, t1.ProcessLineCode, t1.WorkshopID, t1.WorkshopName, t1.EquipmentID, t1.EquipmentName, t1.WorkGroupID, t1.WorkGroupName, t1.Quantity, t1.ManHour, t1.Unit, t1.EarliestStartTime, t1.LatestStartTime, t1.PlanedStartTime, t1.EarliestFinishTime, t1.LatestFinishTime, t1.PlanedFinishTime, t1.ActualStartTime, t1.ActualFinishTime, t1.FloatingHour, t1.PlanColor, t1.PlanState, t1.PlanType, t1.IsEnable, t1.CreatePerson, t1.CreateTime, t1.ModifyPerson, t1.ModifyTime, t1.ApproveState, t1.ApprovePerson, t1.ApproveDate, t1.ApproveRemark, t1.ApsCode, t1.ProductPlanCode, t1.ProcessName, t1.DesignTaskCode, t1.BomQty, t1.MainID, t2.ProductName, t2.ProductType, t2.Model, t2.Specifications, t3.PartFigureCode, t4.eqpUseTime, t3.MaterialCode, P.PartName, t1.RootPartCode, t1.MonthPlanCode, t1.ProcessModelType FROM dbo.APS_ProjectProduceDetial AS t1 LEFT OUTER JOIN dbo.PMS_BN_ProjectDetail AS t2 ON t1.ProjectDetailID = t2.ID LEFT OUTER JOIN dbo.PRS_Process_BOM AS t3 ON t1.PartCode = t3.PartCode LEFT OUTER JOIN (SELECT EquipmentID, SUM(CASE WHEN DATEDIFF(d, CONVERT(VARCHAR(10), PlanedStartTime, 121), CONVERT(VARCHAR(10), PlanedFinishTime, 121)) > 0 THEN DATEDIFF(mi, PlanedStartTime, (CONVERT(VARCHAR(10), PlanedStartTime, 121) + ' 17:00:00')) ELSE DATEDIFF(mi, PlanedStartTime, PlanedFinishTime) END) AS eqpUseTime, CONVERT(VARCHAR(10), PlanedStartTime, 121) AS PlanedStartTime FROM dbo.APS_ProjectProduceDetial WHERE (EquipmentID IS NOT NULL) GROUP BY EquipmentID, CONVERT(VARCHAR(10), PlanedStartTime, 121)) AS t4 ON t1.EquipmentID = t4.EquipmentID AND CONVERT(VARCHAR(10), t1.PlanedStartTime, 121) = CONVERT(VARCHAR(10), t4.PlanedStartTime, 121) LEFT OUTER JOIN (SELECT DISTINCT PartCode, MAX(PartName) AS PartName FROM dbo.SYS_Part GROUP BY PartCode) AS P ON t1.PartCode = P.PartCode WHERE (t1.IsEnable = 1) AND (t3.IsEnable = 1) AND t1.ProcessModelType='1') as temp</from> <where defaultForAll='false' defaultCp='equal' defaultIgnoreEmpty='true'> <field name='temp.ID' cp='In'></field> <field name='temp.ContractCode' cp='equal'></field> <field name='temp.SavantCode' cp='equal'></field> <field name='temp.ProjectDetailID' cp='equal'></field> <field name='temp.PlanType' cp='equal'></field> <field name='temp.WorkshopID' cp='equal'></field> <field name='temp.PlanState' cp='equal'></field> <field name='temp.MonthPlanCode' cp='equal'></field> <field name='temp.RootPartCode' cp='equal'></field> <field name='temp.ProcessModelType' cp='In'></field> </where> </settings>").ToParamQuery(); var service = new APS_ProjectProduceDetialService(); var pQuery = query.ToParamQuery(); var result = service.GetDynamicListWithPaging(pQuery); return(result); }
public dynamic GetTypes(RequestWrapper request) { request.LoadSettingXmlString(@" <settings defaultOrderBy='MerchantsTypeCode'> <where defaultIgnoreEmpty='true'> <field name='MerchantsTypeCode' cp='equal'></field> <field name='MerchantsTypeName' cp='like' ></field> </where> </settings> "); var result = new pms_merchantsTypeService().GetDynamicListWithPaging(request.ToParamQuery()); return(result); }