/// <summary>AdminMemberList Paging 조회</summary> public BmAdminMemberPagingRs GetAdminMemberPagingList(BmAdminMemberPagingRq pDataRq) { try { #region SetQuery StringBuilder sbQuery = new StringBuilder(@"SELECT COUNT(Seq) AS 'TotalRowCnt' FROM tbAdmin WHERE 1=1 --@@Id --@@Name SELECT * FROM ( SELECT ROW_NUMBER() OVER(ORDER BY RegDt DESC) AS 'RowNum', * FROM tbAdmin WHERE 1=1 --@@Id --@@Name ) A WHERE 1=1"); if (string.IsNullOrEmpty(pDataRq.Admin.Id) == false) sbQuery = sbQuery.Replace("--@@Id", " AND Id LIKE '%' + @Id + '%'"); if (string.IsNullOrEmpty(pDataRq.Admin.Name) == false) sbQuery = sbQuery.Replace("--@@Name", " AND Name LIKE '%' + @Name + '%'"); sbQuery.AppendLine(" AND RowNum BETWEEN (@PageSize * @CurPage) + 1 AND ((@PageSize * @CurPage) + @PageSize)"); #endregion SetQuery BmAdminMemberPagingRs result = new BmAdminMemberPagingRs(); SqlCommand cmd = new SqlCommand(); cmd.Connection = SqlConn; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = sbQuery.ToString(); #region Set Parameters cmd.Parameters.Add("@PageSize", SqlDbType.Int, 0).Value = pDataRq.Paging.PageSize; cmd.Parameters.Add("@CurPage", SqlDbType.Int, 0).Value = pDataRq.Paging.CurPage; if (string.IsNullOrEmpty(pDataRq.Admin.Id) == false) cmd.Parameters.Add("@Id", SqlDbType.VarChar, 20).Value = pDataRq.Admin.Id; if (string.IsNullOrEmpty(pDataRq.Admin.Name) == false) cmd.Parameters.Add("@Name", SqlDbType.VarChar, 20).Value = pDataRq.Admin.Name; #endregion Set Parameters SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count == 1) { result.TotalCount = Convert.ToInt32(ds.Tables[0].Rows[0]["TotalRowCnt"].ToString()); if (result.TotalCount > 0 && ds.Tables[1].Rows.Count > 0) { result.List = ConvertToBmAdminMember(ds.Tables[1]); } } da.Dispose(); cmd.Dispose(); return result; } catch (Exception ex) { throw ex; } }
/// <summary>AdminMemberList Paging 조회</summary> public BmAdminMemberPagingRs GetAdminMemberPagingList(BmAdminMemberPagingRq pDataRq) { try { using (SqlConn = new SqlConnection(ConnectionString)) { using (TransactionScope scope = new TransactionScope()) { try { SqlConn.Open(); var result = dac.GetAdminMemberPagingList(pDataRq); scope.Complete(); return result; } catch (Exception ex) { throw ex; } finally { SqlConn.Dispose(); } } } } catch (Exception ex) { WriteLog("Exception", ex.Message); throw; } }
/// <summary>리스트 검색</summary> private void ListSearch() { BizMember bizMember = new BizMember(); BmAdminMemberPagingRq bmAdminMemberRq = new BmAdminMemberPagingRq(); #region Set Rq bmAdminMemberRq.Paging.CurPage = ucPaging.CurPage; bmAdminMemberRq.Paging.PageSize = ucPaging.PageSize; if (string.IsNullOrEmpty(tbxSearch.Text) == false) { if (ddlSearchType.SelectedValue == "Id") { bmAdminMemberRq.Admin.Id = tbxSearch.Text; } else { bmAdminMemberRq.Admin.Name = tbxSearch.Text; } } #endregion Set Rq var result = bizMember.GetAdminMemberPagingList(bmAdminMemberRq); ucPaging.TotalRowCount = result.TotalCount; vwBmAdminMemberList = result.List; rptAdminMemberList.DataSource = vwBmAdminMemberList; rptAdminMemberList.DataBind(); }