/// <summary>
/// 按钮搜索
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void GetSearchFilter(string sql)
{
_para = new QueryProcedurePara();
currentNode = (Group)this.trl_Left.GetDataRecordByNode(this.trl_Left.FocusedNode);
if (currentNode != null)
{
if (currentNode.NodeType == "驾校")
{
sql = sql + string.Format(" a.SchoolID={0}", currentNode.SchoolID);
}
else
{
if (currentNode.NodeType == "分队")
{
sql = sql + string.Format(" a.SchoolID={0}", currentNode.SchoolID);
sql = sql + string.Format(" and a.GroupID={0}", currentNode.GroupID);
}
else
{
sql = sql + string.Format(" a.SchoolID={0}", currentNode.SchoolID);
sql = sql + string.Format(" and (a.GroupID is null or a.GroupID=0) ");
}
}
}
_para.P_Where = sql;
_para.P_PageSize = pageSize;
if (curPage == 0)
{
curPage = 1;
}
_para.P_PageIndex = curPage;
string _orderBy = "a.TrainPlaceID";//默认排序字段
foreach (GridColumn col in this.gv_Student.Columns)
{
if (col.FieldName != "Choose" && col.SortOrder != DevExpress.Data.ColumnSortOrder.None) //判断是否有排序，如果有，加上列排序信息
{
string sortOrder = col.SortOrder.ToString() == "Descending" ? "desc" : "asc"; //升序、降序
_orderBy = "a." + col.FieldName + " " + sortOrder; //注意：此处需要根据字段所属表进行必要的替换对应的字段、表别名等。
break;
}
}
_para.P_OrderBy = _orderBy;
}
private void BindData(QueryProcedurePara para)
{
allCount = 0;
bool result = ThreadExcute(() =>
{
_list = new RoleDao().Query(para, out allCount);
});
if (result)
{
this.gc_Role.DataSource = _list;
this.gc_Role.RefreshDataSource();
if (allCount == 0)
{
curPage = 0;
}
pagingControl1.RefreshPager(pageSize, allCount, curPage);
}
}
/// <summary>
/// 获取
/// </summary>
/// <param name="para"></param>
/// <param name="outPara"></param>
/// <returns></returns>
public List <TicketRule> Query(QueryProcedurePara para, out int TotalCount)
{
const string procedureName = "p_query_ticket_rule";
var parms = new Dictionary <string, QfParameter>();
parms.Add("iPageIndex", new QfParameter("iPageIndex", para.P_PageIndex));
parms.Add("iPageSize", new QfParameter("iPageSize", para.P_PageSize));
parms.Add("vWhere", new QfParameter("vWhere", para.P_Where));
parms.Add("vOrderBy", new QfParameter("vOrderBy", para.P_OrderBy));
parms.Add("iTotalCount", new QfParameter("iTotalCount", para.P_TotalCount));
parms["iTotalCount"].Direction = ParameterDirection.Output;
try
{
List <TicketRule> _list = new List <TicketRule>();
_list = RunProcedureGetList <TicketRule>(procedureName, ref parms);
TotalCount = ValueConvert.ToInt32(parms["iTotalCount"].Value);
return(_list);
}
catch (Exception ex)
{
throw new DsException("获取预约大类列表失败！", ex);
}
}
private void GetSearchFilter(string sql)
{
_para = new QueryProcedurePara();
_para.P_Where = sql;
_para.P_PageSize = pageSize;
if (curPage == 0)
{
curPage = 1;
}
_para.P_PageIndex = curPage;
string _orderBy = "Array";//默认排序字段
foreach (GridColumn col in this.gv_Role.Columns)
{
if (col.FieldName != "Choose" && col.SortOrder != DevExpress.Data.ColumnSortOrder.None) //判断是否有排序，如果有，加上列排序信息
{
string sortOrder = col.SortOrder.ToString() == "Descending" ? "desc" : "asc"; //升序、降序
_orderBy = "a." + col.FieldName + " " + sortOrder; //注意：此处需要根据字段所属表进行必要的替换对应的字段、表别名等。
break;
}
}
_para.P_OrderBy = _orderBy;
}
