/// <summary> /// 修改 /// </summary> /// <param name="income"></param> /// <returns></returns> public String Update(Income income) { try { income.UpdateBy = CurrentUser.Id; income.UpdateTime = DateTime.Now; int result = new BLIncome().Update(income); 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="income"></param> /// <returns></returns> public String Add(Income income) { try { income.Id = Guid.NewGuid().ToString(); income.CreateBy = CurrentUser.Id; income.CreateTime = DateTime.Now; int result = new BLIncome().Add(income); 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> /// <returns></returns> public String SelectByPage(int limit, int start, Boolean?isMark, Boolean?family) { var tuple = GetParam(isMark, family); int total; List <VIncome> incomes = new BLIncome().Select(limit, start, tuple.Item1, out total, tuple.Item2); return(JsonConvert.JavaScriptSerializer(new ExtGridRecord(incomes, total))); }
/// <summary> /// 批量修改自定义分组信息 /// </summary> /// <param name="ids"></param> /// <param name="value"></param> /// <returns></returns> public String ModifyCusGroup(String ids, String value) { int num = new BLIncome().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 BLIncome().Delete(ids); return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = true, msg = "成功删除" + num + "条数据" })); }
/// <summary> /// 获得收入总金额 /// </summary> /// <returns></returns> public String GetTotalPrice(Boolean?isMark, Boolean?family) { try { var tuple = GetParam(isMark, family); var total = new BLIncome().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="bank"></param> /// <returns></returns> public String InsertIncome(String income) { try { List <Income> list = JsonConvert.JSONStringToList <Income>(income); bool result = new BLIncome().Save(list); return(JsonConvert.JavaScriptSerializer(new ExtResult() { msg = "成功保存" + list.Count + "条数据", success = true, data = result })); } catch (Exception ex) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { msg = ex.Message, success = false, data = null })); } }
/// <summary> /// 分页查询存收入信息 /// </summary> /// <param name="pageSize"></param> /// <param name="start"></param> /// <returns></returns> public String GetIncome(int pageSize, int start, String createBy) { try { int total; var list = new BLIncome().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> /// 查询所有的自定义分组名称 /// </summary> /// <returns></returns> public String GetAllCusGroup() { var list = new BLIncome().GetAllCusGroup(); return(JsonConvert.JavaScriptSerializer(list)); }