/// <summary>
/// 银行对账表（返回列表JSON）
/// </summary>
/// <param name="keywords">关键字</param>
/// <returns></returns>
public List<BankAnalyze> GetBankAnalyzeList(string filepath, string keywords)
{
FileStream fs = new System.IO.FileStream(filepath, FileMode.Open, System.IO.FileAccess.Read, FileShare.ReadWrite);
StreamReader sr = new StreamReader(fs, Encoding.GetEncoding("gb2312"));//取得这txt文件的编码
int PageSize = 40;
List<BankAnalyze> ListData = new List<BankAnalyze>();
if (!string.IsNullOrEmpty(keywords))
{
//Linq模糊查询
ListData = (from itementity in JsonHelper.JonsToList<BankAnalyze>(sr.ReadToEnd().ToString())
where itementity.Month.Contains(keywords)
|| itementity.Remark.Contains(keywords)
|| itementity.CreateDate.Contains(keywords.ToUpper())
select itementity).Take(PageSize).ToList<BankAnalyze>();
}
else
{
ListData = JsonHelper.JonsToList<BankAnalyze>(sr.ReadToEnd().ToString()).Take(PageSize).ToList<BankAnalyze>();
}
var JsonData = new
{
rows = ListData,
};
return ListData;
}
/// <summary>
/// 【数据库管理】返回列表JONS
/// </summary>
/// <returns></returns>
public ActionResult GridColumnListJson(string tableName)
{
try
{
DataTable ListData = base_databasebll.GetColumnList(tableName);
var JsonData = new
{
rows = ListData,
};
return Content(JsonData.ToJson());
}
catch (Exception ex)
{
Base_SysLogBll.Instance.WriteLog("", OperationType.Query, "-1", "异常错误：" + ex.Message);
return null;
}
}
/// <summary>
/// 【数据库管理】返回列表JONS
/// </summary>
/// <returns></returns>
public ActionResult GridListJson(string tableName)
{
try
{
Stopwatch watch = CommonHelper.TimerStart();
DataTable ListData = base_databasebll.GetList(tableName);
var JsonData = new
{
records = ListData.Rows.Count,
costtime = CommonHelper.TimerEnd(watch),
rows = ListData,
};
string str = JsonData.ToJson();
return Content(JsonData.ToJson());
}
catch (Exception ex)
{
Base_SysLogBll.Instance.WriteLog("", OperationType.Query, "-1", "异常错误：" + ex.Message);
return null;
}
}
/// <summary>
///【备份计划】返回列表JONS
/// </summary>
/// <returns></returns>
public ActionResult DbBackupList()
{
try
{
List<Base_BackupJob> ListData = DataFactory.Database().FindList<Base_BackupJob>("ORDER BY CreateDate DESC");
var JsonData = new
{
rows = ListData,
};
return Content(JsonData.ToJson());
}
catch (Exception ex)
{
Base_SysLogBll.Instance.WriteLog("", OperationType.Query, "-1", "异常错误：" + ex.Message);
return null;
}
}
/// <summary>
/// 查询数据库表数据
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="ParameterJson">查询条件</param>
/// <param name="jqgridparam">分页参数</param>
/// <returns></returns>
public ActionResult GridDataTableListJson(string tableName, string ParameterJson, JqGridParam jqgridparam)
{
try
{
Stopwatch watch = CommonHelper.TimerStart();
DataTable ListData = base_databasebll.GetDataTableList(tableName, ParameterJson, ref jqgridparam);
var JsonData = new
{
total = jqgridparam.total,
page = jqgridparam.page,
records = jqgridparam.records,
costtime = CommonHelper.TimerEnd(watch),
rows = ListData,
};
string str = JsonData.ToJson();
return Content(JsonData.ToJson());
}
catch (Exception ex)
{
Base_SysLogBll.Instance.WriteLog("", OperationType.Query, "-1", "异常错误：" + ex.Message);
return null;
}
}
/// <summary>
/// 资金余额（返回列表JSON）
/// </summary>
/// <param name="keywords">关键字</param>
/// <returns></returns>
public List<MoneyBal> GetMoneyBalList(string filepath, string keywords)
{
FileStream fs = new System.IO.FileStream(filepath, FileMode.Open, System.IO.FileAccess.Read, FileShare.ReadWrite);
StreamReader sr = new StreamReader(fs, Encoding.GetEncoding("gb2312"));//取得这txt文件的编码
List<MoneyBal> ListData = new List<MoneyBal>();
if (!string.IsNullOrEmpty(keywords))
{
//Linq模糊查询
ListData = (from itementity in JsonHelper.JonsToList<MoneyBal>(sr.ReadToEnd().ToString())
where itementity.Year.Contains(keywords)
select itementity).ToList<MoneyBal>();
}
else
{
ListData = JsonHelper.JonsToList<MoneyBal>(sr.ReadToEnd().ToString()).ToList<MoneyBal>();
}
var JsonData = new
{
rows = ListData,
};
return ListData;
}
