/// <summary> /// 加载数据 /// </summary> /// <param name="where"></param> /// <param name="order"></param> private void LoadPageData(string where = null, string order = null) { //select * from ( select *,ROW_NUMBER() OVER(Order by Id) as rownum from Account) as twhere t.rownum between (@pageIndex - 1) * pageSize + 1 and @pageSize * pageIndex order by t.Id asc this.LoadData.Func = () => SqlHelperByYem.Query($"select * from(select *,ROW_NUMBER() OVER({order}) as rownum from core.UserAssetRatios where IsDelete=0 and Status in(10,20,40) and DeptRedeemStatus=10 {where})as t where t.rownum between {(this.LoadData.PageIndex - 1) * this.LoadData.PageSize + 1} and {this.LoadData.PageSize * this.LoadData.PageIndex}", null, false); this.LoadData.FuncNums = () => Convert.ToInt16(SqlHelperByYem.ExecuteScalar($"select count(*) from core.UserAssetRatios where IsDelete=0 and Status in(10,20,40) and DeptRedeemStatus=10 {where}")); this.LoadData.LoadOneTablePageData(); this.LoadData.Action = () => this.LoadData.Lbl_infos1.Text = "每页"; this.LoadData.Atcion1 = () => { }; }
/// <summary> /// 加载数据 /// </summary> private void LoadPageData(int pageIndex, int type, string userId = "", string userAssetRatioId = "") { SqlParameter pageIndexParam = new SqlParameter("@pageIndex", pageIndex); SqlParameter pageSizeParam = new SqlParameter("@pageSize", Convert.ToInt32(this.cbx_pageSize.Text)); SqlParameter userIdParam = new SqlParameter("@userId", userId); SqlParameter userAssetRatioIdParam = new SqlParameter("@UserAssetRatioId", userAssetRatioId); SqlParameter totalCountParam = new SqlParameter("@totalCount", SqlDbType.Int) { Direction = ParameterDirection.Output }; SqlParameter[] sqlparams = { pageIndexParam, pageSizeParam, userIdParam, userAssetRatioIdParam, totalCountParam }; this.LoadData.Func = () => SqlHelperByYem.Query(type == 0 ? "[Core].PROC_UserRedeemableSubOrderForDev" : "[Core].PROC_UserRedeemableUserAssetRatioForDev", sqlparams, true); this.LoadData.FuncNums = () => Convert.ToInt32(totalCountParam.Value); this.LoadData.LoadOneTablePageData(); this.LoadData.Action = () => this.LoadData.Lbl_infos1.Text = "每页"; }