/// <summary>
/// 获取充值方式
/// </summary>
/// <param name="httpRequest"></param>
/// <returns></returns>
private string GetCzfs(HttpRequest httpRequest)
{
try
{
IcCardBll icCardBll = new IcCardBll();
DataTable dt = icCardBll.QueryPsysDic("充值方式");
return(ConvertToJson.DataTableToJson("czfs", dt));
}
catch (Exception e)
{
Log.Error(e);
return(ErrorJson);
}
}
/// <summary>
/// 查询充电卡信息
/// </summary>
/// <param name="httpRequest"></param>
/// <returns></returns>
private string QueryInfo(HttpRequest httpRequest)
{
try
{
string cardNum = httpRequest["cardNum"] ?? "",
name = httpRequest["name"] ?? "",
zjmc = httpRequest["zjmc"] ?? "",
zjhm = httpRequest["zjhm"] ?? "",
kzt = httpRequest["kzt"] ?? "",
klx = httpRequest["klx"] ?? "",
dateBegin = httpRequest["dateBegin"],
dateEnd = httpRequest["dateEnd"];
int page = int.Parse(httpRequest["page"] ?? "1"),
rows = int.Parse(httpRequest["rows"] ?? "20");
CardInfo ci = new CardInfo()
{
CardId = cardNum,
Name = name,
Zjmc = zjmc,
Zjhm = zjhm,
Kzt = kzt,
Klx = klx,
};
if (!string.IsNullOrEmpty(dateBegin))
{
ci.DateBegin = DateTime.Parse(dateBegin);
}
if (!string.IsNullOrEmpty(dateEnd))
{
ci.DateEnd = DateTime.Parse(dateEnd);
}
IcCardBll icCardBll = new IcCardBll();
int count = 0;
DataTable dt = icCardBll.QueryCardInfo(ci, page, rows, ref count);
var str = ConvertToJson.DataTableToJson("rows", dt);
str = str.Substring(1, str.Length - 2);
return("{\"total\":\"" + count + "\"," + str + "}");
}
catch (Exception e)
{
Log.Error(e);
return(ErrorJson);
}
}
/// <summary>
/// 获取卡异常结算数据
/// </summary>
/// <param name="httpRequest"></param>
/// <returns></returns>
private string QueryExp(HttpRequest httpRequest)
{
try
{
int page = int.Parse(httpRequest["page"] ?? "1"),
rows = int.Parse(httpRequest["rows"] ?? "20");
IcCardBll icCardBll = new IcCardBll();
int count = 0;
DataTable dt = icCardBll.QueryExp(new CardInfo(), page, rows, ref count);
var str = ConvertToJson.DataTableToJson("rows", dt);
str = str.Substring(1, str.Length - 2);
return("{\"total\":\"" + count + "\"," + str + "}");
}
catch (Exception e)
{
Log.Error(e);
return(ErrorJson);
}
}
/// <summary>
/// 查询充值记录
/// </summary>
/// <param name="httpRequest"></param>
/// <returns></returns>
private string QueryCzjl(HttpRequest httpRequest)
{
try
{
string cardNum = httpRequest["cardNum"] ?? "",
czy = httpRequest["czy"] ?? "",
czwd = httpRequest["czwd"] ?? "",
czfs = httpRequest["czfs"] ?? "",
dateBegin = httpRequest["dateBegin"],
dateEnd = httpRequest["dateEnd"];
int page = int.Parse(httpRequest["page"] ?? "1"),
rows = int.Parse(httpRequest["rows"] ?? "20");
CardInfo ci = new CardInfo()
{
CardId = cardNum,
Czy = czy,
Czwd = czwd,
Czfs = czfs,
};
if (!string.IsNullOrEmpty(dateBegin))
{
ci.DateBegin = DateTime.Parse(dateBegin);
}
if (!string.IsNullOrEmpty(dateEnd))
{
ci.DateEnd = DateTime.Parse(dateEnd);
}
IcCardBll icCardBll = new IcCardBll();
int count = 0;
DataTable dt = icCardBll.QueryCzjl(ci, page, rows, ref count);
var str = ConvertToJson.DataTableToJson("rows", dt);
str = str.Substring(1, str.Length - 2);
return("{\"total\":\"" + count + "\"," + str + "}");
}
catch (Exception e)
{
Log.Error(e);
return(ErrorJson);
}
}