// 地址:GET api/mms/deal/getdetail public override dynamic GetDetail(string id) { var query = RequestWrapper .InstanceRequest() .SetValue("BillNo", id) .SetXml(@" <settings> <select> A.*,B.MerchantsName as ExpendCompanyName </select> <from> mms_dealDetail A left join mms_merchants B on B.MerchantsCode = A.ExpendCompany </from> <where> <c column='BillNo' symbol='equal'></c> </where> <orderby>RowId</orderby> </settings>"); var pQuery = query.ToParamQuery(); var result = detailService.GetDynamicListWithPaging(pQuery); return(result); }
// 地址:GET api/mms/rentout/getdetail public override dynamic GetDetail(string id) { var query = RequestWrapper .InstanceRequest() .SetValue("BillNo", id) .SetXml(@" <settings> <select> A.*, B.MaterialName,B.Model,B.Material ,C.RemainNum,C.RowId as SrcRowId,C.BillNo as SrcBillNo </select> <from> mms_rentOutDetail A left join mms_material B on B.MaterialCode = A.MaterialCode left join mms_rentInDetail C ON C.BillNo=A.SrcBillNo AND C.RowId=A.SrcRowId </from> <where> <c column='A.BillNo' symbol='equal'></c> </where> <orderby>MaterialCode</orderby> </settings>"); var pQuery = query.ToParamQuery(); var result = masterService.GetDynamicListWithPaging(pQuery); return(result); }
public override dynamic GetDetail(string id) { var query = RequestWrapper .InstanceRequest() .SetValue("BillNo", id) .SetXml(@" <settings> <select> A.*, B.MaterialName,B.Model,B.Material,C.MerchantsName as UseUnitName </select> <from> mms_rentInDetail A left join mms_material B on B.MaterialCode = A.MaterialCode left join mms_merchants C on C.MerchantsCode = A.UseUnit </from> <where> <c column='BillNo' symbol='equal'></c> </where> <orderby>MaterialCode</orderby> </settings>"); var pQuery = query.ToParamQuery(); var result = masterService.GetDynamicListWithPaging(pQuery); return(result); }
// 地址:GET api/mms/deal/getdetail public override dynamic GetDetail(string id) { var query = RequestWrapper .InstanceRequest() .SetValue("BillNo", id) .SetXml(@" <settings> <select> A.*, C.MaterialName,C.Model,C.Material,D.Num as StockNum,D.UnitPrice as StockUnitPrice </select> <from> mms_LossReportDetail A left join mms_LossReport B on B.BillNo = A.BillNo left join mms_material C on C.MaterialCode = A.MaterialCode left join mms_warehouseStock D on D.WarehouseCode = B.WarehouseCode and D.MaterialCode = A.MaterialCode </from> <where> <c column='A.BillNo' symbol='equal'></c> </where> <orderby>RowId</orderby> </settings>"); var pQuery = query.ToParamQuery(); var result = detailService.GetDynamicListWithPaging(pQuery); return(result); }
//弹出材料选择窗口数据 public dynamic GetMaterialType() { var service = new mms_materialTypeService(); var requst = RequestWrapper.InstanceRequest() .SetXml(@" <settings> <select>MaterialTypeName as text,MaterialType as id,ParentCode as pid</select> <from>mms_materialType</from> <orderby>MaterialType</orderby> </settings>"); var pQuery = requst.ToParamQuery(); return(service.GetDynamicList(pQuery)); }
// 查询明细表 GET api/trade/send/getdetail public virtual dynamic GetDetail(string id) { var query = RequestWrapper .InstanceRequest() .SetValue("Jobno", id) .SetXml(string.Format(@" <settings> <select>A.*, B.*</select> <from>{0} A left join trade_scheduler B on B.jobo = A.jobno</from> <where><c column='Jobno' symbol='equal'></c></where> <orderby>Jobno</orderby> </settings>", typeof(TDetailModel).Name)); var pQuery = query.ToParamQuery(); var result = masterService.GetDynamicListWithPaging(pQuery); return(result); }
// 查询明细表 GET api/mms/send/getdetail public virtual dynamic GetDetail(string id) { var query = RequestWrapper .InstanceRequest() .SetValue("BillNo", id) .SetXml(string.Format(@" <settings> <select>A.*, B.MaterialName,B.Model,B.Material</select> <from>{0} A left join mms_material B on B.MaterialCode = A.MaterialCode</from> <where><c column='BillNo' symbol='equal'></c></where> <orderby>MaterialCode</orderby> </settings>", typeof(TDetailModel).Name)); var pQuery = query.ToParamQuery(); var result = masterService.GetDynamicListWithPaging(pQuery); return(result); }
// 地址:GET api/mms/repair/getdetail public override dynamic GetDetail(string id) { var query = RequestWrapper .InstanceRequest() .SetValue("BillNo", id) .SetXml(@" <settings> <select>*</select> <from>mms_repairDetail </from> <where><c column='BillNo' symbol='equal'></c></where> <orderby>RepairNo</orderby> </settings>"); var pQuery = query.ToParamQuery(); var result = detailService.GetDynamicListWithPaging(pQuery); return(result); }
public ActionResult GetLookupData(string index) { var type = Request.QueryString["_lookupType"].Split('.'); var xmlPath = string.Empty; if (type.Length > 1) { xmlPath = string.Format("~/Areas/{0}/Views/Shared/Xml/{1}.xml", type); } else { xmlPath = string.Format("~/Views/Shared/Xml/{0}.xml", type[type.Length - 1]); } var wrapper = RequestWrapper.InstanceRequest().LoadXmlFile(xmlPath); var pQuery = wrapper.ToParamQuery(); var data = wrapper.GetService().GetDynamicListWithPaging(pQuery); var json = JsonConvert.SerializeObject(data); return(Content(json, "application/json")); }
// 地址:GET api/mms/deal/getdetail public override dynamic GetDetail(string id) { var sfrom = @" select 'receive' as SrcBillType ,A.BillNo as SrcBillNo ,A.RowId as SrcRowId ,B.ReceiveDate as SrcDate ,B.WarehouseCode ,B.ProjectCode ,A.RemainNum ,A.UnitPrice as SrcUnitPrice ,C.* from mms_receiveDetail as A left join mms_receive as B ON A.BillNo=B.BillNo left join mms_material as C ON A.MaterialCode=C.MaterialCode union select 'refund' as SrcBillType ,A.BillNo as SrcBillNo ,A.RowId as SrcRowId ,B.RefundDate as SrcDate ,B.WarehouseCode ,B.ProjectCode ,A.RemainNum ,A.UnitPrice as SrcUnitPrice ,C.* from mms_refundDetail as A left join mms_refund as B ON A.BillNo=B.BillNo left join mms_material as C ON A.MaterialCode=C.MaterialCode union select 'adjust' as SrcBillType ,A.BillNo as SrcBillNo ,A.RowId as SrcRowId ,B.EffectDate as SrcDate ,B.WarehouseCode ,B.ProjectCode ,A.RemainNum ,A.UnitPrice as SrcUnitPrice ,C.* from mms_stockAdjustDetail as A left join mms_stockAdjust as B ON A.BillNo=B.BillNo left join mms_material as C ON A.MaterialCode=C.MaterialCode "; var query = RequestWrapper .InstanceRequest() .SetValue("BillNo", id) .SetXml(string.Format(@" <settings> <select> A.*, C.MaterialName,C.Model,C.Material,D.Num as StockNum,D.UnitPrice as StockUnitPrice,T.RemainNum,T.SrcUnitPrice </select> <from> mms_transferDetail A left join mms_transfer B on B.BillNo = A.BillNo left join mms_material C on C.MaterialCode = A.MaterialCode left join mms_warehouseStock D on D.WarehouseCode = B.WarehouseCode and D.MaterialCode = A.MaterialCode left join ({0}) T on T.SrcBillType=A.SrcBillType and T.SrcBillNo=A.SrcBillNo and T.SrcRowId = A.SrcRowId </from> <where> <c column='A.BillNo' symbol='equal'></c> </where> <orderby>RowId</orderby> </settings>", sfrom)); var pQuery = query.ToParamQuery(); var result = detailService.GetDynamicListWithPaging(pQuery); return(result); }