/// <summary>
/// 绑定表格
/// </summary>
/// <param name="ParameterJson">查询条件</param>
/// <param name="Gridpage">分页条件</param>
/// <returns></returns>
public virtual JsonResult GridPageJson(string ParameterJson, JqGridParam jqgridparam)
{
try
{
Stopwatch watch = CommonHelper.TimerStart();
List <TEntity> ListData = new List <TEntity>();
if (!string.IsNullOrEmpty(ParameterJson))
{
List <DbParameter> parameter = new List <DbParameter>();
IList conditions = ParameterJson.JonsToList <Condition>();
string WhereSql = ConditionBuilder.GetWhereSql(conditions, out parameter);
ListData = repositoryfactory.Repository().FindListPage(WhereSql, parameter.ToArray(), ref jqgridparam);
}
else
{
ListData = repositoryfactory.Repository().FindListPage(ref jqgridparam);
}
var JsonData = new
{
total = jqgridparam.total,
page = jqgridparam.page,
records = jqgridparam.records,
costtime = CommonHelper.TimerEnd(watch),
rows = ListData,
};
return(Json(JsonData, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(null);
}
}
public virtual JsonResult GridPageJson(string parameterJson, JqGridParam jqgridparam)
{
try
{
Stopwatch watch = CommonHelper.TimerStart();
List <TEntity> ListData = new List <TEntity>();
if (!string.IsNullOrEmpty(parameterJson))
{
List <DbParameter> parameter = new List <DbParameter>();
IList conditions = parameterJson.JonsToList <Condition>();
string WhereSql = ConditionBuilder.GetWhereSql(conditions, out parameter);
ListData = Repositoryfactory.Repository().FindListPage(WhereSql, parameter.ToArray(), ref jqgridparam);
}
else
{
ListData = Repositoryfactory.Repository().FindListPage(ref jqgridparam);
}
var JsonData = new
{
total = jqgridparam.total,
page = jqgridparam.page,
records = jqgridparam.records,
costtime = CommonHelper.TimerEnd(watch),
rows = ListData,
};
return(Json(JsonData, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
BaseSysLogBll.Instance.WriteLog("", OperationType.Query, "-1", "异常错误：" + ex.Message + "\r\n条件：" + parameterJson);
return(null);
}
}
/// <summary>
/// 获取数据库表数据
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="ParameterJson">查询条件</param>
/// <param name="jqgridparam">分页参数</param>
/// <returns></returns>
public DataTable GetDataTableList(string tableName, string ParameterJson, ref JqGridParam jqgridparam)
{
StringBuilder strSql = new StringBuilder();
List <DbParameter> parameter = new List <DbParameter>();
strSql.Append("SELECT * FROM " + tableName + " WHERE 1=1");
if (!string.IsNullOrEmpty(ParameterJson) && ParameterJson.Length > 2)
{
strSql.Append(ConditionBuilder.GetWhereSql(ParameterJson.JonsToList <Condition>(), out parameter));
}
int totalRow = jqgridparam.records;
DataTable dt = DataFactory.Database().FindTablePageBySql(strSql.ToString(), parameter.ToArray(), jqgridparam.sidx, jqgridparam.sord, jqgridparam.page, jqgridparam.rows, ref totalRow);
jqgridparam.records = totalRow;
return(dt);
}
public DataTable GetPageList(string keyword, ref JqGridParam jqgridparam, string ParameterJson)
{
StringBuilder strSql = new StringBuilder();
List <DbParameter> parameter = new List <DbParameter>();
strSql.Append(@"select * from fy_objecttracking where 1=1 ");
if (!string.IsNullOrEmpty(keyword))
{
strSql.Append(@" AND (objectdescripe LIKE @keyword
OR objectprogress LIKE @keyword
OR trackingstates LIKE @keyword
)");
parameter.Add(DbFactory.CreateDbParameter("@keyword", '%' + keyword + '%'));
}
if (!string.IsNullOrEmpty(ParameterJson) && ParameterJson.Length > 2)
{
strSql.Append(ConditionBuilder.GetWhereSql(ParameterJson.JonsToList <Condition>(), out parameter));
}
return(Repository().FindTablePageBySql(strSql.ToString(), parameter.ToArray(), ref jqgridparam));
}
/// <summary>
/// 绑定表格
/// </summary>
/// <param name="ParameterJson">查询条件</param>
/// <param name="Gridpage">排序条件</param>
/// <returns></returns>
public virtual JsonResult GridJson(string ParameterJson, JqGridParam jqgridparam)
{
try
{
List <TEntity> ListData = new List <TEntity>();
if (!string.IsNullOrEmpty(ParameterJson))
{
List <DbParameter> parameter = new List <DbParameter>();
IList conditions = ParameterJson.JonsToList <Condition>();
string WhereSql = ConditionBuilder.GetWhereSql(conditions, out parameter, jqgridparam.sidx, jqgridparam.sord);
ListData = repositoryfactory.Repository().FindList(WhereSql, parameter.ToArray());
}
else
{
ListData = repositoryfactory.Repository().FindList();
}
return(Json(ListData, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(null);
}
}
public virtual JsonResult GridJson(string ParameterJson, JqGridParam jqgridparam)
{
try
{
List <TEntity> ListData = new List <TEntity>();
if (!string.IsNullOrEmpty(ParameterJson))
{
List <DbParameter> parameter = new List <DbParameter>();
IList conditions = ParameterJson.JonsToList <Condition>();
string WhereSql = ConditionBuilder.GetWhereSql(conditions, out parameter, jqgridparam.sidx, jqgridparam.sord);
ListData = repositoryfactory.Repository().FindList(WhereSql, parameter.ToArray());
}
else
{
ListData = repositoryfactory.Repository().FindList();
}
return(Json(ListData, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
Base_SysLogBll.Instance.WriteLog("", OperationType.Query, "-1", "异常错误：" + ex.Message + "\r\n条件：" + ParameterJson);
return(null);
}
}
public DataTable GetPageList(string keyword, ref JqGridParam jqgridparam, string ParameterJson, string MyTask)
{
StringBuilder strSql = new StringBuilder();
List <DbParameter> parameter = new List <DbParameter>();
strSql.Append(@"select * from RapidList_New where 1=1 ");
if (!string.IsNullOrEmpty(keyword))
{
strSql.Append(@" AND (realname LIKE @keyword
OR FullName LIKE @keyword
OR res_ms LIKE @keyword
)");
parameter.Add(DbFactory.CreateDbParameter("@keyword", '%' + keyword + '%'));
}
if (!string.IsNullOrEmpty(ParameterJson) && ParameterJson.Length > 2)
{
strSql.Append(ConditionBuilder.GetWhereSql(ParameterJson.JonsToList <Condition>(), out parameter));
}
if (MyTask == "yes")
{
strSql.AppendFormat(" and RapidState!='已完成' and RealName like '{0}' ", ManageProvider.Provider.Current().UserName);
}
return(Repository().FindTablePageBySql(strSql.ToString(), parameter.ToArray(), ref jqgridparam));
}
