/// <summary>
/// 根据配置项名称获取配置项值
/// </summary>
/// <param name="strKey">配置项名</param>
/// <returns></returns>
public string GetValueByKey(string strKey)
{
string strSql = "select avalue from t_Config where akey=@akey";
SqlParameter[] arrSp = { new SqlParameter("@akey", strKey) };
object objRel = DataHelper.ExecuteScalar(strSql, arrSp, false);
if (objRel == null)
{
return("");
}
else
{
return(objRel.ToString());
}
}
public static JsonObj ConvertToJsonStr(ListData obj, string sql, string sqlCount, string rowNumName)
{
//获取分页数据结果
string sqlFrame = "select * from ({0}) t where t.{1}>{2} and t.{1}<={3}";
sqlFrame = string.Format(sqlFrame, sql, rowNumName, obj.beg, obj.end);
DataTable dtRel = DataHelper.GetDataTable(sqlFrame);
List <object> rows = dtRel.ToDictionaryList();
//获取总记录数
int total = Convert.ToInt32(DataHelper.ExecuteScalar(sqlCount, null));
JsonObj result = new JsonObj()
{
total = total, rows = rows
};
return(result);
}
