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