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