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