// 地址：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);
}
