/// <summary> /// 数据导出 /// </summary> public void ExportExcel([DefaultValue(-1)] int Stuts, string keywords, string Number, string ProvinceId, string CityId, string CountyId) { Am_AmmeterBll bll = new Am_AmmeterBll(); var ListData = bll.GetPageList(keywords, Number, Stuts, ProvinceId, CityId, CountyId); var newlist = new List <Am_AmmeterNew>(); foreach (var item in ListData) { var model = new Am_AmmeterNew(); model.Address = item.Address; model.AmmeterMoney = item.AmmeterMoney.Value.ToString("0.00"); model.AmmeterType_Name = item.AmmeterType_Name; model.AM_Code = item.AM_Code; model.Cell = item.Cell; model.City = item.City; model.Collector_Code = item.Collector_Code; model.County = item.County; model.CreateTime = item.CreateTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); model.FirstAlarm = item.FirstAlarm.ToString(); model.Floor = item.Floor; model.Money = item.Money.Value.ToString("0.00"); model.Province = item.Province; model.Room = item.Room; model.StatusStr = item.StatusStr; model.UserName = item.UserName; model.UY_Name = item.UY_Name; model.UY_UserName = item.UY_UserName; model.U_Name = item.U_Name; newlist.Add(model); } string[] columns = new string[] { "电表号:AM_Code", "电表类型:AmmeterType_Name", "价格:AmmeterMoney_Name", "采集器编号:Collector_Code", "租户帐号:UserName", "租户姓名:U_Name", "省:Province", "市:City", "区:County", "单元:Cell", "楼层:Floor", "房号:Room", "地址:Address", "状态:StatusStr", "安装时间:CreateTime", "一级预警:FirstAlarm", "电表余额:Money", "业主帐号:UY_UserName", "业主姓名:UY_Name" }; DeriveExcel.ListToExcel <Am_AmmeterNew>(newlist, columns, "电表数据" + DateTime.Now.ToString("yyyyMMddHHmmss")); }
/// <summary> /// 搜索 /// </summary> /// <returns></returns> public ActionResult GridPageListJson(JqGridParam jqgridparam, string Number, string keywords, [DefaultValue(-1)] int Stuts, string ProvinceId, string CityId, string CountyId) { try { Stopwatch watch = CommonHelper.TimerStart(); Am_AmmeterBll bll = new Am_AmmeterBll(); var ListData = bll.GetPageList(ref jqgridparam, Number, keywords, Stuts, ProvinceId, CityId, CountyId); var JsonData = new { total = jqgridparam.total, page = jqgridparam.page, records = jqgridparam.records, costtime = CommonHelper.TimerEnd(watch), rows = ListData }; return(Content(JsonData.ToJson())); } catch (Exception ex) { Base_SysLogBll.Instance.WriteLog("", OperationType.Query, "-1", "异常错误:" + ex.Message); return(null); } }