public String GetCollectionType(string time, string beginTime, string endTime, bool?isMark, bool?family, string costTypeId) { String costTypeIds = String.Empty; if (isMark == true) { isMark = null; } if (family == true) { family = null; } if (costTypeId != null) { costTypeIds = costTypeId.GetIds(); } if (!String.IsNullOrEmpty(time)) { time = time.GetIds(); } else { time = "''"; } DataTable dt = new BLLifingCost().GetCollectionType(time, beginTime, endTime, isMark, family, costTypeIds, CurrentUser.Id); return(JsonConvert.ToJson(dt)); }
/// <summary> /// 修改 /// </summary> /// <param name="lifingCost"></param> /// <returns></returns> public String Update(LifingCost lifingCost) { try { int result = new BLLifingCost().Update(lifingCost); if (result > 0) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = true, msg = "修改成功" })); } else { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = false, msg = "修改失败" })); } } catch (Exception ex) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = false, msg = "修改失败,失败原因:" + ex.Message })); } }
public String GetCollectionByType(String time) { String sqlWhere = CurrentUser.Id == "-1" ? "" : String.Format(" and create_by='{0}'", CurrentUser.Id); DataTable dt = new BLLifingCost().GetCollectionByType(time, sqlWhere); return(JsonConvert.ToJson(dt)); }
public String GetReasons(String key) { List <LifingCost> list = new BLLifingCost().GetReasons(key); return(JsonConvert.JavaScriptSerializer(new ExtGridRecord(list, list.Count))); //return JsonConvert.JavaScriptSerializer(list); }
/// <summary> /// 新增 /// </summary> /// <param name="lifingCost"></param> /// <returns></returns> public String Add(LifingCost lifingCost) { try { lifingCost.Id = Guid.NewGuid().ToString(); int result = new BLLifingCost().Add(lifingCost); if (result > 0) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = true, msg = "新增成功" })); } else { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = false, msg = "新增失败" })); } } catch (Exception ex) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = false, msg = "新增失败,失败原因:" + ex.Message })); } }
/// <summary> /// 图形汇总信息 /// </summary> /// <param name="beginTime"></param> /// <param name="endTime"></param> /// <returns></returns> public string GetCollection(String beginTime, String endTime) { String sqlWhere = CurrentUser.Id == "-1" ? "" : String.Format(" and create_by='{0}'", CurrentUser.Id); DataTable dt = new BLLifingCost().GetCollection(sqlWhere, beginTime, endTime); return(JsonConvert.ToJson(dt)); }
/// <summary> /// 分页查询 /// </summary> /// <returns></returns> public String SelectByPage(int limit, int start, String startTime, String endTime, String key, String CostTypeId, Boolean?isMark, Boolean?family) { var tuple = GetParam(startTime, endTime, key, CostTypeId, isMark, family); int total; List <VLifingCost> lifingCosts = new BLLifingCost().Select(limit, start, tuple.Item1, out total, tuple.Item2); return(JsonConvert.JavaScriptSerializer(new ExtGridRecord(lifingCosts, total))); }
/// <summary> /// 批量修改自定义分组信息 /// </summary> /// <param name="ids"></param> /// <param name="value"></param> /// <returns></returns> public String ModifyCusGroup(String ids, String value) { int num = new BLLifingCost().ModifyCusGroup(ids, value); return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = true, msg = "成功保存" + num + "条数据" })); }
/// <summary> /// 删除 /// </summary> /// <param name="ids">Id的集合,如1,2,3</param> /// <returns></returns> public String Delete(String ids) { int num = new BLLifingCost().Delete(ids); return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = true, msg = "成功删除" + num + "条数据" })); }
/// <summary> /// 查询所有消费名称 /// </summary> /// <returns></returns> public String GetLifeNames() { List <String> list = new BLLifingCost().GetAllReasons(); String result = JsonConvert.JavaScriptSerializer(new ExtResult() { data = list, success = true }); return(result); }
/// <summary> /// 生活费汇总,列表汇总 /// </summary> /// <param name="beginTime"></param> /// <param name="endTime"></param> /// <param name="isMark"></param> /// <param name="family"></param> /// <param name="costTypeId"></param> /// <returns></returns> public string GetCollectionByMonth(String beginTime, String endTime, Boolean?isMark, Boolean?family, String costTypeId) { String costTypeIds = String.Empty; if (isMark == true) { isMark = null; } if (family == true) { family = null; } if (costTypeId != null) { costTypeIds = costTypeId.GetIds(); } List <CostMonthCol> list = new BLLifingCost().GetCollectionByMonth(beginTime, endTime, isMark, family, costTypeIds, CurrentUser.Id); return(JsonConvert.JavaScriptSerializer(list)); }
/// <summary> /// 保存 /// </summary> /// <param name="lifingCost"></param> /// <returns></returns> public String Save(LifingCost lifingCost) { //判断Request中是否有接收Files文件 if (Request.Files.Count != 0 && !String.IsNullOrEmpty(lifingCost.ImgUrl)) { //HttpPostedFileBase类,提供对用户上载的单独文件的访问 //获取到用户上传的文件 HttpPostedFileBase file = Request.Files[0]; String fileName = this.Upload(file, "/File/Life/"); lifingCost.ImgUrl = fileName; } //创建人和修改者赋值 Users user = Session["user"] as Users; if (string.IsNullOrEmpty(lifingCost.Id)) { lifingCost.CreateTime = DateTime.Now; lifingCost.CreateBy = user.Id; return(Add(lifingCost)); } else { lifingCost.UpdateTime = DateTime.Now; lifingCost.UpdateBy = user.Id; if (String.IsNullOrEmpty(lifingCost.ImgUrl)) { lifingCost.ImgUrl = new BLLifingCost().Select(lifingCost.Id).ImgUrl; } else { var imgUrl = new BLLifingCost().Select(lifingCost.Id).ImgUrl; if (!String.IsNullOrEmpty(imgUrl)) { System.IO.File.Delete(Server.MapPath(imgUrl)); } } return(Update(lifingCost)); } }
/// <summary> /// 查询总金额 /// </summary> /// <param name="startTime"></param> /// <param name="endTime"></param> /// <param name="key"></param> /// <param name="CostTypeId"></param> /// <param name="isMark"></param> /// <param name="family"></param> /// <returns></returns> public String GetTotalPrice(String startTime, String endTime, String key, String CostTypeId, Boolean?isMark, Boolean?family) { try { var tuple = GetParam(startTime, endTime, key, CostTypeId, isMark, family); var total = new BLLifingCost().GetTotalPrice(tuple.Item1, tuple.Item2); return(JsonConvert.JavaScriptSerializer(new ExtResult() { data = total, success = true, msg = "查询成功" })); } catch { return(JsonConvert.JavaScriptSerializer(new ExtResult() { data = null, success = false, msg = "查询失败" })); } }
/// <summary> /// 分页查询生活费信息 /// </summary> /// <param name="pageSize"></param> /// <param name="start"></param> /// <returns></returns> public String GetLifingCost(int pageSize, int start, String createBy) { try { int total; var list = new BLLifingCost().Select(pageSize, start, new HashTableExp("CreateBy", createBy), out total, string.Empty); String result = JsonConvert.GetJsonString(new ExtResult() { data = new ExtGridRecord(list, total), success = true }); return(result); } catch (Exception ex) { LogHelper.Log.Error("获取生活费信息错误pageSize=" + pageSize + ",start=" + start, ex); return(JsonConvert.GetJsonString(new ExtResult() { msg = ex.Message, success = false, data = null })); } }
/// <summary> /// 导入Excel /// </summary> /// <param name="impExcel"></param> /// <returns></returns> public String ImportExcel(String impExcel) { //判断Request中是否有接收Files文件 if (Request.Files.Count != 0 && !String.IsNullOrEmpty(impExcel)) { //HttpPostedFileBase类,提供对用户上载的单独文件的访问 //获取到用户上传的文件 HttpPostedFileBase file = Request.Files[0]; String fileName = Server.MapPath(this.Upload(file, "/File/Import/", "imp.xls")); DataTable dt = Life.Common.ExcelOperations.ImportDataTableFromExcel(fileName, 0, 0); String msg = new BLLifingCost().SaveData(dt, CurrentUser.Id); return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = true, msg = msg })); } return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = false, msg = "请选择文件." })); }
/// <summary> /// 查询所有的自定义分组名称 /// </summary> /// <returns></returns> public String GetAllCusGroup() { var list = new BLLifingCost().GetAllCusGroup(); return(JsonConvert.JavaScriptSerializer(list)); }