public void Delete(string id) { var service = new mms_draingrooveService(); var result = service.Delete(ParamDelete.Instance().AndWhere("BillNo", id)); MmsHelper.ThrowHttpExceptionWhen(result <= 0, "信息删除失败[BillNo={0}],请重试或联系管理员!", id); }
// 查询主表:GET api/mms/send public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='BillNo'> <select> A.* </select> <from> mms_draingroove 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='Type' cp='like' ></field> <field name='Material' cp='like' ></field> <field name='Structure' cp='like' ></field> <field name='InterfaceForm' cp='like' ></field> <field name='SectionForm' cp='like' ></field> <field name='OwnershipUnit' cp='like' ></field> <field name='Diameter' cp='like' ></field> </where> </settings>"); var service = new mms_draingrooveService(); var pQuery = query.ToParamQuery().AndWhere("A.ProjectCode", MmsHelper.GetCurrentProject()); return(service.GetDynamicListWithPaging(pQuery)); }
public List <dynamic> GetBillNo(string q) { var service = new mms_draingrooveService(); var pQuery = ParamQuery.Instance().Select("top 10 BillNo").AndWhere("BillNo", q, Cp.StartWith); return(service.GetDynamicList(pQuery)); }
// GET api/mms/send/getdoperson public List <dynamic> GetDoPerson(string q) { var SendService = new mms_draingrooveService(); var pQuery = ParamQuery.Instance().Select("top 10 DoPerson").AndWhere("DoPerson", q, Cp.StartWithPY); return(SendService.GetDynamicList(pQuery)); }
public dynamic GetEditMaster(string id) { var service = new mms_draingrooveService(); return(new { form = service.GetModel(ParamQuery.Instance().AndWhere("BillNo", id)), scrollKeys = service.ScrollKeys("BillNo", id, ParamQuery.Instance().AndWhere("ProjectCode", MmsHelper.GetCurrentProject())) }); }
public void Edit(dynamic data) { var service = new mms_draingrooveService(); var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>mms_draingroove</table> <where> <field name='BillNo' cp='equal'></field> </where> </settings>"); var result = service.Edit(formWrapper, null, data); }
public dynamic GetDetail(string id) { var ReceiveService = new mms_draingrooveService(); var query = RequestWrapper .InstanceFromRequest() .SetRequestData("CustomerId", id) .LoadSettingXmlString(@" <settings defaultOrderBy='UpdateDate desc'> <select> A.* </select> <from> psi_customerContract A </from> <where> <field name='CustomerId' cp='equal'></field> </where> </settings>"); var pQuery1 = query.ToParamQuery(); query.LoadSettingXmlString(@" <settings defaultOrderBy='VisitId desc'> <select> A.* </select> <from> psi_customerVisit A </from> <where> <field name='CustomerId' cp='equal'></field> </where> </settings>"); var pQuery2 = query.ToParamQuery(); var result = ReceiveService.GetDynamicListWithPaging(pQuery2); return(result); }
public string GetNewBillNo() { var service = new mms_draingrooveService(); return(service.GetNewKey("BillNo", "dateplus")); }
public JavaScriptJsonResult Echart(string id) { if (id == "Category") { var name = new List <object>(); name.Add("总长"); name.Add("合流"); name.Add("雨水"); name.Add("污水"); var data_fix = new List <object>() { new { value = 310.415, name = "排水沟(渠)总长" }, new { value = 227.175, name = "合流沟(渠)总长" }, new { value = 82.619, name = "雨水沟(渠)总长" }, new { value = 0.621, name = "污水沟(渠)总长" } }; var chartOptions_fix = new EChartsOption { Title = new Title("排水沟(渠)长度统计(km)") { Left = new AlignValue(Align.center) }, Tooltip = new Tooltip(), Series = new Series[] { new BarSeries { Name = "排水沟(渠)长度统计(km)", Data = data_fix, MarkPoint = new MarkPoint { Data = new List <MarkData> { new MarkData { Type = MarkPointDataTypes.max, Name = "最大值" }, new MarkData { Type = MarkPointDataTypes.min, Name = "最小值" } } }, MarkLine = new MarkLine { Data = new List <MarkData> { } } } }, XAxis = new XAxis[1] { new XAxis { Type = AxisTypes.category, Data = name } }, YAxis = new YAxis[1] { new YAxis { Type = AxisTypes.value } } }; return(this.ToEChartResult(chartOptions_fix)); } string titlename = ""; var countnumber = new List <object>(); var countname = new List <object>(); var codeService = new sys_codeService(); var getChartService = new mms_draingrooveService(); List <dynamic> data = getChartService.GetCountByGroupName(id); foreach (var result in data) { foreach (var item in (IDictionary <string, object>)result) { if (item.Key.Equals(id)) { //codeService.GetTextByCode(item.Value.ToString(), "InspectionWellCategory"); if (id == "Category") { countname.Add(codeService.GetTextByCode(item.Value.ToString(), "InspectionWellCategory")); titlename = "排水渠类型统计图"; } if (id == "AdministrativeArea") { countname.Add(codeService.GetTextByCode(item.Value.ToString(), "AdministrativeArea")); titlename = "排水渠区域分布统计图"; } if (id == "OwnershipUnit") { countname.Add(item.Value.ToString()); titlename = "排水渠权属单位分布统计图"; } } if (item.Key.Equals("countnumber")) { countnumber.Add(item.Value.ToString()); } } } var chartOptions = new EChartsOption { Title = new Title(titlename) { Left = new AlignValue(Align.center) }, Tooltip = new Tooltip(), Series = new Series[] { new BarSeries { Name = titlename, Data = countnumber, MarkPoint = new MarkPoint { Data = new List <MarkData> { new MarkData { Type = MarkPointDataTypes.max, Name = "最大值" }, new MarkData { Type = MarkPointDataTypes.min, Name = "最小值" } } }, MarkLine = new MarkLine { Data = new List <MarkData> { //new MarkData {Type = MarkPointDataTypes.average, Name = "平均值"} } } } }, XAxis = new XAxis[1] { new XAxis { Type = AxisTypes.category, Data = countname } }, YAxis = new YAxis[1] { new YAxis { Type = AxisTypes.value } } }; return(this.ToEChartResult(chartOptions)); }