/// <summary> /// 分页查询 /// </summary> /// <returns></returns> public String SelectByPage(int limit, int start, String key, String startTime) { #region 封装查询方法 String sqlWhere = string.Format(" and (Bank_Type_Name like '%{0}%' or Create_Name like '%{0}%' or Save_Name like '%{0}%' or Note like '%{0}%')", key); if (!String.IsNullOrEmpty(startTime)) { sqlWhere += String.Format(" and time >='{0}'", startTime.GetDateTime().ToString("yyyy-MM-dd HH:mm:ss")); } if (!String.IsNullOrEmpty(Request["endTime"])) { sqlWhere += String.Format(" and time <= '{0}'", Request["endTime"].GetDateTime().ToString("yyyy-MM-dd HH:mm:ss")); } if (!String.IsNullOrEmpty(Request["BankType"])) { sqlWhere += String.Format(" and Bank_Type_Name='{0}'", Request["BankType"]); } if (!String.IsNullOrEmpty(Request["SaveType"])) { sqlWhere += String.Format(" and Save_Name='{0}'", Request["SaveType"]); } String yearMonth = Request["yearMonth"];//年月,格式2013-1 HashTableExp hash = new HashTableExp(); if (!String.IsNullOrEmpty(yearMonth)) { hash.Add("YearMonth", yearMonth); } #endregion int total; List <VBankCard> bankCards = new BLBankCard().Select(limit, start, hash, out total, sqlWhere); return(JsonConvert.JavaScriptSerializer(new ExtGridRecord(bankCards, total))); }
/// <summary> /// 修改 /// </summary> /// <param name="bankCard"></param> /// <returns></returns> public String Update(BankCard bankCard) { try { int result = new BLBankCard().Update(bankCard); 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="ids">Id的集合,如1,2,3</param> /// <returns></returns> public String Delete(String ids) { int num = new BLBankCard().Delete(ids); return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = true, msg = "成功删除" + num + "条数据" })); }
public String CalcAllBalance() { bool con = new BLBankCard().CalcAllBalance(); if (con) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = true, msg = "操作成功" })); } else { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = false, msg = "操作失败" })); } }
/// <summary> /// 保存 /// </summary> /// <param name="bankCard"></param> /// <returns></returns> public String Save(BankCard bankCard) { //判断Request中是否有接收Files文件 if (Request.Files.Count != 0 && !String.IsNullOrEmpty(bankCard.ImgUrl)) { //HttpPostedFileBase类,提供对用户上载的单独文件的访问 //获取到用户上传的文件 HttpPostedFileBase file = Request.Files[0]; String fileName = this.Upload(file, "/File/Life/"); bankCard.ImgUrl = fileName; } Users user = Session["user"] as Users; if (string.IsNullOrEmpty(bankCard.Id)) { bankCard.CreateTime = bankCard.UpdateTime = DateTime.Now; bankCard.CreateBy = bankCard.UpdateBy = user.Id; return(Add(bankCard)); } else { bankCard.UpdateTime = DateTime.Now; bankCard.UpdateBy = user.Id; if (String.IsNullOrEmpty(bankCard.ImgUrl)) { bankCard.ImgUrl = new BLBankCard().Select(bankCard.Id).ImgUrl; } else { var imgUrl = new BLBankCard().Select(bankCard.Id).ImgUrl; if (!String.IsNullOrEmpty(imgUrl)) { System.IO.File.Delete(Server.MapPath(imgUrl)); } } return(Update(bankCard)); } }
/// <summary> /// 将手机端的银行卡信息上传并保存到服务器 /// </summary> /// <param name="bank"></param> /// <returns></returns> public String InsertBankCard(String bank) { try { List <BankCard> list = JsonConvert.JSONStringToList <BankCard>(bank); int result = new BLBankCard().Add(list); return(JsonConvert.JavaScriptSerializer(new ExtResult() { msg = "成功保存" + result + "条数据", 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> /// <param name="createBy"></param> /// <returns></returns> public String GetBankCard(int pageSize, int start, String createBy) { try { int total; var list = new BLBankCard().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/", "impBank.xls")); DataTable dt = Life.Common.ExcelOperations.ImportDataTableFromExcel(fileName, 0, 0); String msg = new BLBankCard().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 SelectCalc(String time) { List <VBankCard> list = new BLBankCard().SelectCalc(time); return(JsonConvert.JavaScriptSerializer(new ExtGridRecord(list, 0))); }
/// <summary> /// 根据月份汇总银行卡信息 /// </summary> /// <returns></returns> public String GetCollectionByMonth() { DataTable dt = new BLBankCard().GetCollectionByMonth(); return(JsonConvert.ToJson(dt)); }
/// <summary> /// 新增 /// </summary> /// <param name="bankCard"></param> /// <returns></returns> public String Add(BankCard bankCard) { try { bankCard.Id = Guid.NewGuid().ToString(); int result = new BLBankCard().Add(bankCard); if (bankCard.SaveType == 1000200001 && Request["Income"] == "true") { //纯收入 Income income = new Income() { Id = Guid.NewGuid().ToString(), Time = bankCard.Time, Note = bankCard.Note, Price = bankCard.Price, CreateBy = bankCard.CreateBy, CreateTime = bankCard.CreateTime, IsMark = Request["IsMark"].GetBoolean(), FamilyIncome = Request["FamilyPay"].GetBoolean() }; new BLIncome().Add(income); } if (bankCard.SaveType == 1000200002 && Request["Cost"] == "true") { //消费信息 LifingCost cost = new LifingCost() { Id = Guid.NewGuid().ToString(), Time = bankCard.Time, Reason = bankCard.Note, Price = bankCard.Price, CostTypeId = Request["CostTypeId"].GetDecimal(), Notes = bankCard.Note, CreateBy = bankCard.CreateBy, CreateTime = bankCard.CreateTime, IsMark = Request["IsMark"].GetBoolean(), FamilyPay = Request["FamilyPay"].GetBoolean() }; new BLLifingCost().Add(cost); } 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 })); } }