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