// 查询主表：GET api/mms/send
public override dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings>
<select>
A.*, B.ProjectName, C.MaterialTypeName, D.WarehouseName,E.MerchantsName as PickUnitName
</select>
<from>
mms_send 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
left join mms_merchants E on E.MerchantsCode=A.PickUnit
</from>
<where >
<c column='BillNo' symbol='equal' ignore='empty' ></c>
<c column='ProjectName' symbol='like' ignore='empty' ></c>
<c column='DoPerson' symbol='like' ignore='empty' ></c>
<c column='A.WarehouseCode' symbol='equal' ignore='empty' values='{WarehouseCode}' ></c>
<c column='E.MerchantsName' symbol='equal' ignore='empty' values='{PickUnitName}' ></c>
<c column='SendDate' symbol='daterange' ignore='empty' ></c>
<c column='PriceKind' symbol='equal' ignore='empty' ></c>
</where>
<orderby>BillNo</orderby>
</settings>");
var pQuery = query.ToParamQuery().Where("A.ProjectCode", MmsHelper.GetCurrentProject());
return(masterService.GetDynamicListWithPaging(pQuery));
}
// 查询主表数据列表 GET api/mms/send
public dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings>
<select>
A.*, B.ProjectName, C.MaterialTypeName, D.WarehouseName as WarehouseName, E.MerchantsName AS SupplierName
</select>
<from>
mms_receive 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
left join mms_merchants E on E.MerchantsCode = A.SupplierCode
</from>
<where>
<c column='BillNo' symbol='equal' ignore='empty' ></c>
<c column='DoPerson' symbol='like' ignore='empty' ></c>
<c column='E.MerchantsName' symbol='like' ignore='empty' values='{SupplierName}'></c>
<c column='A.WarehouseCode' symbol='equal' ignore='empty' ></c>
<c column='A.MaterialType' symbol='equal' ignore='empty' ></c>
<c column='ReceiveDate' symbol='daterange' ignore='empty' ></c>
<c column='ContractCode' symbol='like' ignore='empty' ></c>
</where>
<orderby>BillNo</orderby>
</settings>");
var pQuery = query.ToParamQuery().Where("A.ProjectCode", MmsHelper.GetCurrentProject());
var result = masterService.GetDynamicListWithPaging(pQuery);
return(result);
//return base.Get(query);
}
// 查询主表：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 ActionResult Index()
{
var currentProject = MmsHelper.GetCurrentProject();
var model = new
{
urls = MmsHelper.GetIndexUrls("send"),
resx = MmsHelper.GetIndexResx("发料单"),
dataSource = new
{
warehouseItems = new mms_warehouseService().GetWarehouseItems(currentProject),
PriceKind = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Code as value,Text as text").AndWhere("CodeType", "Pricing")),
Purpose = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Code as value,Text as text").AndWhere("CodeType", "MaterialUse"))
},
form = new
{
BillNo = "",
PickUnitName = "",
DoPerson = "",
WarehouseCode = "",
PriceKind = "",
SendDate = ""
}
};
return(View(model));
}
public ActionResult Index()
{
var model = new
{
urls = MmsHelper.GetIndexUrls("receive"),
resx = MmsHelper.GetIndexResx("收料单"),
dataSource = new
{
warehouseItems = new mms_warehouseService().GetWarehouseItems(MmsHelper.GetCurrentProject()),
supplyType = new sys_codeService().GetValueTextListByType("SupplyType")
},
form = new
{
BillNo = "",
//ProjectName = "",
SupplierName = "",
SupplyType = "",
WarehouseCode = "",
ContractCode = "",
//MaterialType = "",
ReceiveDate = ""
}
};
return(View(model));
}
// 地址：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 override dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings>
<select>
A.*, B.ProjectName
</select>
<from>
mms_deal A
left join mms_project B on B.ProjectCode = A.ProjectCode
</from>
<where>
<c column='BillNo' symbol='equal' ignore='empty' ></c>
<c column='ProjectName' symbol='like' ignore='empty' ></c>
<c column='DoPerson' symbol='like' ignore='empty' ></c>
<c column='DealType' symbol='equal' ignore='empty' ></c>
<c column='DealKind' symbol='equal' ignore='empty' ></c>
<c column='ApplyDate' symbol='daterange' ignore='empty' ></c>
</where>
<orderby>BillNo</orderby>
</settings>");
var pQuery = query.ToParamQuery().Where("A.ProjectCode", MmsHelper.GetCurrentProject());
return(masterService.GetDynamicListWithPaging(pQuery));
}
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 ActionResult Index()
{
var codeService = new sys_codeService();
var model = new
{
urls = MmsHelper.GetIndexUrls("return"),
resx = MmsHelper.GetIndexResx("退货单"),
dataSource = new
{
warehouseItems = new mms_warehouseService().GetWarehouseItems(MmsHelper.GetCurrentProject()),
priceKinds = codeService.GetValueTextListByType("Pricing"),
payKinds = codeService.GetValueTextListByType("PayType")
},
form = new
{
BillNo = "",
ReturnUnitName = "",
MerchantsName = "",
WarehouseCode = "",
PriceKind = "",
ReturnDate = ""
}
};
return(View(model));
}
// GET: /Mms/Inspectionwell/
#region 查询页面
public ActionResult Index()
{
var currentProject = MmsHelper.GetCurrentProject();
var model = new
{
dataSource = new
{
warehouseItems = new mms_warehouseService().GetWarehouseItems(currentProject),
Category = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "InspectionWellCategory")),
Type = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "InspectionWellType")),
Form = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "InspectionWellForm")),
AdministrativeArea = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "AdministrativeArea")),
CoverMaterial = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "InspectionWellCoverMaterial")),
CoverSharp = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "InspectionWellCoverSharp")),
WellType = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "InspectionWellwelltype")),
BottomType = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "InspectionWellBottomType")),
AntifallNet = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "AdditionalFacilities")),
AntifallNetStatus = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "AdditionalFacilitiesStatus")),
WellLevel = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "InspectionWellLevel")),
FacilityStatus = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "FacilityStatus"))
},
urls = new
{
query = "/api/mms/inspectionwell",
querycount = "/api/mms/inspectionwell/getcount",
remove = "/api/mms/inspectionwell/",
billno = "/api/mms/inspectionwell/getnewbillno",
audit = "/api/mms/inspectionwell/audit/",
edit = "/mms/inspectionwell/edit/"
},
resx = new
{
detailTitle = "信息维护",
noneSelect = "请先选择条信息！",
deleteConfirm = "确定要删除选中的信息吗？",
deleteSuccess = "删除成功！",
auditSuccess = "信息已审核！"
},
form = new
{
IdentificationCode = "",
Address = "",
AdministrativeArea = "",
Category = "",
Type = "",
Form = ""
}
};
return(View(model));
}
// GET: /Mms/Inspectionwell/
#region 查询页面
public ActionResult Index()
{
var currentProject = MmsHelper.GetCurrentProject();
var model = new
{
dataSource = new
{
warehouseItems = new mms_warehouseService().GetWarehouseItems(currentProject),
Category = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "InspectionWellCategory")),
Material = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "PipeMaterial")),
PressureType = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "PipePressureType")),
AdministrativeArea = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "AdministrativeArea")),
SectionForm = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "drainGrooveSectionForm")),
GrooveType = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "drainGrooveType")),
Type = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "drainpipeductType")),
FacilityStatus = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "FacilityStatus"))
},
urls = new
{
query = "/api/mms/drainpipeduct",
remove = "/api/mms/drainpipeduct/",
billno = "/api/mms/drainpipeduct/getnewbillno",
audit = "/api/mms/drainpipeduct/audit/",
edit = "/mms/drainpipeduct/edit/"
},
resx = new
{
detailTitle = "信息维护",
noneSelect = "请先选择条信息！",
deleteConfirm = "确定要删除选中的信息吗？",
deleteSuccess = "删除成功！",
auditSuccess = "信息已审核！"
},
form = new
{
IdentificationCode = "",
Address = "",
AdministrativeArea = "",
Category = "",
Material = "",
PressureType = "",
OwnershipUnit = "",
GrooveType = "",
SectionForm = "",
Type = "",
Diameter = ""
}
};
return(View(model));
}
public ActionResult Edit(string id)
{
var userName = MmsHelper.GetUserName();
var currentProject = MmsHelper.GetCurrentProject();
var data = new ReceiveApiController().GetEditMaster(id);
var codeService = new sys_codeService();
var model = new
{
form = data.form,
scrollKeys = data.scrollKeys,
urls = MmsHelper.GetEditUrls("receive"),
resx = MmsHelper.GetEditResx("收料单"),
dataSource = new
{
measureUnit = codeService.GetMeasureUnitListByType(),
supplyType = codeService.GetValueTextListByType("SupplyType"),
payKinds = codeService.GetValueTextListByType("PayType"),
warehouseItems = new mms_warehouseService().GetWarehouseItems(currentProject)
},
defaultForm = new mms_receive().Extend(new
{
BillNo = id,
BillDate = DateTime.Now,
DoPerson = userName,
ReceiveDate = DateTime.Now,
SupplyType = codeService.GetDefaultCode("SupplyType"),
PayKind = codeService.GetDefaultCode("PayType"),
}),
defaultRow = new
{
CheckNum = 1,
Num = 1,
UnitPrice = 0,
Money = 0,
PrePay = 0
},
setting = new
{
postFormKeys = new string[] { "BillNo" },
postListFields = new string[] { "BillNo", "RowId", "MaterialCode", "Unit", "CheckNum", "Num", "UnitPrice", "PrePay", "Money", "Remark" }
}
};
return(View(model));
}
public ActionResult Edit(string id)
{
var userName = MmsHelper.GetUserName();
var currentProject = MmsHelper.GetCurrentProject();
var data = new CheckApiController().GetEditMaster(id);
var codeService = new sys_codeService();
var model = new
{
form = data.form,
scrollKeys = data.scrollKeys,
urls = MmsHelper.GetEditUrls("check"),
resx = MmsHelper.GetEditResx("盘点单"),
dataSource = new
{
measureUnit = codeService.GetMeasureUnitListByType(),
warehouseItems = new mms_warehouseService().GetWarehouseItems(currentProject),
yearItems = codeService.GetYearItems(),
monthItems = codeService.GetMonthItems()
},
defaultForm = new mms_check().Extend(new
{
BillNo = id,
BillDate = DateTime.Now,
DoPerson = userName,
Years = DateTime.Now.Year,
Months = DateTime.Now.Month
}),
defaultRow = new
{
BookNum = 0,
BookMoney = 0,
ActualNum = 0,
ActualUnitPrice = 0,
OperateNum = 0,
OperateMoney = 0
},
setting = new
{
postFormKeys = new string[] { "BillNo" },
postListFields = new string[] { "BillNo", "RowId", "MaterialCode", "Unit", "BookNum", "BookMoney", "ActualNum", "ActualUnitPrice", "OperateNum", "OperateMoney", "Remark" }
}
};
return(View(model));
}
// GET: /Mms/RainWaterPort/
#region 查询页面
public ActionResult Index()
{
var currentProject = MmsHelper.GetCurrentProject();
var model = new
{
dataSource = new
{
warehouseItems = new mms_warehouseService().GetWarehouseItems(currentProject),
Form = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "RainWaterPortForm")),
AdministrativeArea = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "AdministrativeArea")),
GarbageInterceptionDevice = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "AdditionalFacilities")),
DeodorizationDevice = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "AdditionalFacilities")),
RainwaterInterceptionDevice = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "AdditionalFacilities")),
RainGrateMaterial = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "RainGrateMaterial")),
FacilityStatus = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "FacilityStatus"))
},
urls = new
{
query = "/api/mms/rainwaterport",
remove = "/api/mms/rainwaterport/",
billno = "/api/mms/rainwaterport/getnewbillno",
audit = "/api/mms/rainwaterport/audit/",
edit = "/mms/rainwaterport/edit/"
},
resx = new
{
detailTitle = "信息维护",
noneSelect = "请先选择条信息！",
deleteConfirm = "确定要删除选中的信息吗？",
deleteSuccess = "删除成功！",
auditSuccess = "信息已审核！"
},
form = new
{
IdentificationCode = "",
Address = "",
AdministrativeArea = "",
Form = "",
GarbageInterceptionDevice = "",
DeodorizationDevice = ""
}
};
return(View(model));
}
public ActionResult Edit(string id = "")
{
var userName = MmsHelper.GetUserName();
var currentProject = MmsHelper.GetCurrentProject();
var data = new DealApiController().GetEditMaster(id);
var codeService = new sys_codeService();
var model = new
{
form = data.form,
scrollKeys = data.scrollKeys,
urls = MmsHelper.GetEditUrls("deal"),
resx = MmsHelper.GetEditResx("处置单"),
dataSource = new
{
measureUnit = codeService.GetMeasureUnitListByType(),
disposalTypes = codeService.GetValueTextListByType("DisposalType"),
disposalWays = codeService.GetValueTextListByType("DisposalWay")
},
defaultForm = new mms_deal().Extend(new
{
BillNo = id,
BillDate = DateTime.Now,
DoPerson = userName,
ApplyDate = DateTime.Now,
DealType = codeService.GetDefaultCode("DisposalType"),
DealKind = codeService.GetDefaultCode("DisposalWay"),
}),
defaultRow = new
{
UnitPrice = 0,
Num = 1,
Money = 0,
DealDate = DateTime.Now
},
setting = new
{
postFormKeys = new string[] { "BillNo" },
postListFields = new string[] { "BillNo", "RowId", "MaterialName", "Model", "Unit", "DealDate", "ExpendCompany", "UnitPrice", "Num", "Money", "Remark" }
}
};
return(View(model));
}
public ActionResult Edit(string id)
{
var userName = MmsHelper.GetUserName();
var currentProject = MmsHelper.GetCurrentProject();
var data = new SendApiController().GetEditMaster(id);
var codeService = new sys_codeService();
var model = new
{
form = data.form,
scrollKeys = data.scrollKeys,
urls = MmsHelper.GetEditUrls("send"),
resx = MmsHelper.GetEditResx("发料单"),
dataSource = new
{
priceKinds = codeService.GetValueTextListByType("Pricing"),
materialUse = codeService.GetValueTextListByType("MaterialUse"),
measureUnit = codeService.GetMeasureUnitListByType(),
warehouseItems = new mms_warehouseService().GetWarehouseItems(currentProject)
},
defaultForm = new mms_send().Extend(new
{
BillNo = id,
BillDate = DateTime.Now,
DoPerson = userName,
SendDate = DateTime.Now,
PriceKind = codeService.GetDefaultCode("Pricing")
}),
defaultRow = new
{
Num = 1,
UnitPrice = 0,
Money = 0
},
setting = new
{
postFormKeys = new string[] { "BillNo" },
postListFields = new string[] { "BillNo", "RowId", "MaterialCode", "Unit", "UnitPrice", "Num", "Money", "Remark", "SrcBillType", "SrcBillNo", "SrcRowId" }
}
};
return(View(model));
}
//
// GET: /Mms/Test/
public ActionResult Index()
{
var currentProject = MmsHelper.GetCurrentProject();
var model = new
{
urls = MmsHelper.GetIndexUrls("test"),
resx = MmsHelper.GetIndexResx("大数据测试单"),
form = new
{
UserCode = "",
UserName = "",
Description = "",
IsEnable = "",
LoginCount = "",
LastLoginDate = ""
}
};
return(View(model));
}
public ActionResult Edit(string id)
{
var userName = MmsHelper.GetUserName();
var currentProject = MmsHelper.GetCurrentProject();
var data = new RentinApiController().GetEditMaster(id);
var codeService = new sys_codeService();
var model = new
{
form = data.form,
scrollKeys = data.scrollKeys,
urls = MmsHelper.GetEditUrls("rentin"),
resx = MmsHelper.GetEditResx("租赁进场单"),
dataSource = new
{
measureUnit = codeService.GetMeasureUnitListByType(),
materialUse = codeService.GetValueTextListByType("MaterialUse"),
billingUnit = codeService.GetValueTextListByType("BillingUnit")
},
defaultForm = new mms_rentIn().Extend(new
{
BillNo = id,
BillDate = DateTime.Now,
DoPerson = userName,
RentInDate = DateTime.Now,
Purpose = codeService.GetDefaultCode("MaterialUse")
}),
defaultRow = new
{
Num = 1,
UnitPrice = 1
},
setting = new
{
postFormKeys = new string[] { "BillNo" },
postListFields = new string[] { "BillNo", "RowId", "MaterialCode", "Unit", "UseUnit", "PriceUnit", "Num", "UnitPrice", "Remark" }
}
};
return(View(model));
}
public ActionResult Edit(string id)
{
var userName = MmsHelper.GetUserName();
var currentProject = MmsHelper.GetCurrentProject();
var data = new RentOffApiController().GetEditMaster(id);
var codeService = new sys_codeService();
var model = new
{
form = data.form,
scrollKeys = data.scrollKeys,
urls = MmsHelper.GetEditUrls("rentOff"),
resx = MmsHelper.GetEditResx("停租单"),
dataSource = new
{
measureUnit = codeService.GetMeasureUnitListByType(),
warehouseItems = new mms_warehouseService().GetWarehouseItems(currentProject)
},
defaultForm = new mms_rentOff().Extend(new
{
BillNo = id,
BillDate = DateTime.Now,
DoPerson = userName,
BeginDate = DateTime.Now
}),
defaultRow = new
{
UnitPrice = 0,
Num = 1,
Day = 1,
PrePay = 0
},
setting = new
{
postFormKeys = new string[] { "BillNo" },
postListFields = new string[] { "BillNo", "RowId", "MaterialCode", "Unit", "UnitPrice", "Num", "Day", "Money", "Remark" }
}
};
return(View(model));
}
public ActionResult Edit(string id = "")
{
var userName = MmsHelper.GetUserName();
var currentProject = MmsHelper.GetCurrentProject();
var data = new RentoutApiController().GetEditMaster(id);
var codeService = new sys_codeService();
var model = new
{
form = data.form,
scrollKeys = data.scrollKeys,
urls = MmsHelper.GetEditUrls("rentout"),
resx = MmsHelper.GetEditResx("租赁出场单"),
dataSource = new
{
measureUnit = codeService.GetMeasureUnitListByType()
},
defaultForm = new mms_rentOut().Extend(new
{
BillNo = id,
BillDate = DateTime.Now,
DoPerson = userName,
RentOutDate = DateTime.Now
}),
defaultRow = new
{
CheckNum = 1,
InStoreNum = 1,
InStoreUnitPrice = 0,
TotalMoney = 0,
PrePay = 0
},
setting = new
{
postFormKeys = new string[] { "BillNo" },
postListFields = new string[] { "BillNo", "RowId", "SrcBillNo", "SrcRowId", "MaterialCode", "Unit", "Num", "Remark" }
}
};
return(View(model));
}
// 查询主表：GET api/mms/send
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='BillNo'>
<select>
A.*
</select>
<from>
mms_drainagehouseholds A
</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='BillNo' cp='equal' ></field>
<field name='Address' cp='like' ></field>
<field name='Name' cp='like' ></field>
</where>
</settings>");
var service = new mms_drainagehouseholdsService();
var pQuery = query.ToParamQuery().AndWhere("A.ProjectCode", MmsHelper.GetCurrentProject());
return(service.GetDynamicListWithPaging(pQuery));
}
// GET: /Mms/Inspectionwell/
#region 查询页面
public ActionResult Index()
{
var currentProject = MmsHelper.GetCurrentProject();
var model = new
{
dataSource = new
{
warehouseItems = new mms_warehouseService().GetWarehouseItems(currentProject),
Category = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "PumpType")),
AdministrativeArea = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "AdministrativeArea")),
FacilityStatus = new sys_codeService().GetDynamicList(ParamQuery.Instance().Select("Value as value,Text as text").AndWhere("CodeType", "FacilityStatus"))
},
urls = new
{
query = "/api/mms/pumpstation",
remove = "/api/mms/pumpstation/",
billno = "/api/mms/pumpstation/getnewbillno",
audit = "/api/mms/pumpstation/audit/",
edit = "/mms/pumpstation/edit/"
},
resx = new
{
detailTitle = "信息维护",
noneSelect = "请先选择条信息！",
deleteConfirm = "确定要删除选中的信息吗？",
deleteSuccess = "删除成功！",
auditSuccess = "信息已审核！"
},
form = new
{
IdentificationCode = "",
Address = "",
AdministrativeArea = "",
Category = "",
Name = ""
}
};
return(View(model));
}
public ActionResult Index()
{
var model = new
{
urls = MmsHelper.GetIndexUrls("lossreport"),
resx = MmsHelper.GetIndexResx("报损单"),
dataSource = new
{
warehouseItems = new mms_warehouseService().GetWarehouseItems(MmsHelper.GetCurrentProject())
},
form = new
{
BillNo = "",
ProjectName = "",
DoPerson = "",
WarehouseCode = "",
MaterialType = "",
LossReportDate = ""
}
};
return(View(model));
}
// 查询主表：GET api/mms/send
public dynamic GetCount(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings >
<select>
COUNT(*) AS OrgWaterDepth
</select>
<from>
MANHOLE A
</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='BillNo' cp='equal' ></field>
<field name='Lane_Way' cp='like' ></field>
<field name='Junc_Type' cp='like' ></field>
<field name='Junc_Style' cp='like' ></field>
<field name='Depth' cp='like' ></field>
</where>
</settings>");
var service = new mms_inspectionwellService();
var pQuery = query.ToParamQuery().AndWhere("A.ProjectCode", MmsHelper.GetCurrentProject()).From("MANHOLE");
return(service.GetDynamicListWithPaging(pQuery));
}
public ActionResult Index()
{
var model = new
{
urls = MmsHelper.GetIndexUrls("rentout"),
resx = MmsHelper.GetIndexResx("租赁出场单"),
dataSource = new
{
warehouseItems = new mms_warehouseService().GetWarehouseItems(MmsHelper.GetCurrentProject())
},
form = new
{
BillNo = "",
ProjectName = "",
MerchantsName = "",
ContractCode = "",
IsTotal = false,
RentOutDate = ""
}
};
return(View(model));
}
public ActionResult Index()
{
var model = new
{
urls = MmsHelper.GetIndexUrls("refund"),
resx = MmsHelper.GetIndexResx("退库单"),
dataSource = new
{
warehouseItems = new mms_warehouseService().GetWarehouseItems(MmsHelper.GetCurrentProject())
},
form = new
{
BillNo = "",
RefundUnitName = "",
RefundPerson = "",
WarehouseCode = "",
MaterialType = "",
RefundDate = ""
}
};
return(View(model));
}
public ActionResult Index()
{
var model = new
{
urls = MmsHelper.GetIndexUrls("rentoff"),
resx = MmsHelper.GetIndexResx("停租单"),
dataSource = new
{
warehouseItems = new mms_warehouseService().GetWarehouseItems(MmsHelper.GetCurrentProject())
},
form = new
{
BillNo = "",
ProjectName = "",
DoPerson = "",
ContractCode = "",
BeginDate = "",
EndDate = ""
}
};
return(View(model));
}
// 查询主表：GET api/mms/send
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='BillNo'>
<select>
A.*,(select SUM (FacilityStatus) from mms_floodarea b where b.BillNo=A.BillNo) as totals
</select>
<from>
mms_floodarea 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='OwnershipUnit' cp='like' ></field>
</where>
</settings>");
var service = new mms_floodareaService();
var pQuery = query.ToParamQuery().AndWhere("A.ProjectCode", MmsHelper.GetCurrentProject());
return(service.GetDynamicListWithPaging(pQuery));
}
public ActionResult Index()
{
var model = new
{
urls = MmsHelper.GetIndexUrls("check"),
resx = MmsHelper.GetIndexResx("盘点单"),
dataSource = new
{
warehouseItems = new mms_warehouseService().GetWarehouseItems(MmsHelper.GetCurrentProject())
},
form = new
{
BillNo = "",
IsShowDiff = false,
DoPerson = "",
WarehouseCode = "",
MaterialType = "",
BillDate = ""
}
};
return(View(model));
}
public ActionResult Index()
{
var model = new
{
urls = MmsHelper.GetIndexUrls("repair"),
resx = MmsHelper.GetIndexResx("维修单"),
dataSource = new
{
warehouseItems = new mms_warehouseService().GetWarehouseItems(MmsHelper.GetCurrentProject())
},
form = new
{
BillNo = "",
ProjectName = "",
DoPerson = "",
RepairUnit = "",
RepairDate = "",
Remark = ""
}
};
return(View(model));
}