/// <summary>
/// 获取
/// </summary>
/// <returns></returns>
public JQResult <UC_User_Ext> Get(JQParas Paras)
{
//默认初始化
JQResult <UC_User_Ext> result = new JQResult <UC_User_Ext>();
result.page = Paras.page;
Dictionary <string, object> DbParas = new Dictionary <string, object>();
string SQL_base = "SELECT Id,UserName,LoginName,IsValid,Status,Mobile,Email,CreateUser,DATE_FORMAT(CreateTime,'%Y-%c-%d %h:%i:%s') AS CreateTimeStr FROM UC_User WHERE 1=1 AND IsValid=0 ";
#region 搜索(注意字符串类型注入)
StringBuilder serchstr = new StringBuilder();
UC_User_Ext _csearch;
if (!string.IsNullOrWhiteSpace(Paras.cSearch))
{
_csearch = JsonConvert.DeserializeObject <UC_User_Ext>(Paras.cSearch);
}
else
{
_csearch = new UC_User_Ext();
}
if (!string.IsNullOrWhiteSpace(_csearch.UserName))
{
if (serchstr.Length > 0)
{
serchstr.Append(" AND ");
}
DbParas.Add("@UserName", "%" + _csearch.UserName + "%");
serchstr.Append("AND UserName LIKE @UserName");
}
if (!string.IsNullOrWhiteSpace(_csearch.LoginName))
{
if (serchstr.Length > 0)
{
serchstr.Append(" AND ");
}
DbParas.Add("@LoginName", "%" + _csearch.LoginName + "%");
serchstr.Append(" AND LoginName LIKE @LoginName");
}
if (!string.IsNullOrWhiteSpace(_csearch.Mobile))
{
if (serchstr.Length > 0)
{
serchstr.Append(" AND ");
}
DbParas.Add("@Mobile", "%" + _csearch.Mobile + "%");
serchstr.Append(" AND Mobile LIKE @Mobile");
}
if (!string.IsNullOrWhiteSpace(_csearch.Email))
{
if (serchstr.Length > 0)
{
serchstr.Append(" AND ");
}
DbParas.Add("@Email", "%" + _csearch.Email + "%");
serchstr.Append(" AND Email LIKE @Email");
}
if (_csearch.Status != null)
{
if (serchstr.Length > 0)
{
serchstr.Append(" AND ");
}
DbParas.Add("@Status", _csearch.Status);
serchstr.Append(" AND Status LIKE @Status");
}
if (serchstr.Length > 0)
{
SQL_base += serchstr.ToString();
}
#endregion
#region 排序
string SortUnion = "ORDER BY ";
//默认排序方式
SortUnion += string.IsNullOrWhiteSpace(Paras.sidx) ? "__TMP__ID" : Paras.sidx;
SortUnion += " " + (string.IsNullOrWhiteSpace(Paras.sord) ? "DESC" : Paras.sord);
#endregion
PageHelperParas php = new PageHelperParas()
{
types = 1,
rows = Paras.rows,
page = Paras.page,
SortUnion = SortUnion
};
if (Paras.export) //导出
{
php.dataSql = string.Format("SELECT {0} FROM ({1}) B", "*", SQL_base);
php.exportColumnName = new List <string> {
"序号", "名称"
};
php.exportIgnoreColumnName = new List <string>()
{
"__TMP__ID", "FormTypeID", "OUID", "ParentID", "Gradecode", "parent", "leaf", "expanded", "loaded", "level"
};
php.export = Paras.export;
php.exportAll = (Paras.exportType == 0);
php.exportFileName = Paras.exportFileName;
php.start_page = Paras.exportStartPage;
php.end_page = Paras.exportEndPage;
}
else //分页查询
{
php.dataSql = string.Format("SELECT {0} FROM ({1}) B", "*", SQL_base);
php.countSql = string.Format("SELECT {0} FROM ({1}) B", "count(1)", SQL_base);
}
PageHelper.Query <UC_User_Ext>(php, ref result, DbParas);
return(result);
}
public JsonResult GetUserList(JQParas jq)
{
return(Json(service.Get(jq)));
}
