/// <summary>아이템 이미지 Paging 조회</summary> public BmItemImgPagingRs GetItemImgPagingList(BmItemImgPagingRq pDataRq) { try { #region SetQuery StringBuilder sbQuery = new StringBuilder(@"SELECT COUNT(Seq) AS 'TotalRowCnt' FROM tbItemImg WHERE 1=1 --@@ItemSeq SELECT * FROM ( SELECT ROW_NUMBER() OVER(ORDER BY RegDt DESC) AS 'RowNum', * FROM tbItemImg WHERE 1=1 --@@ItemSeq ) A WHERE 1=1"); if (pDataRq.Item.ItemSeq > 0) sbQuery = sbQuery.Replace("--@@ItemSeq", " AND ItemSeq = @ItemSeq"); sbQuery.AppendLine(" AND RowNum BETWEEN (@PageSize * @CurPage) + 1 AND ((@PageSize * @CurPage) + @PageSize)"); sbQuery.AppendLine(" ORDER BY DisplayOrder, RegDt ASC"); #endregion SetQuery BmItemImgPagingRs result = new BmItemImgPagingRs(); 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 (pDataRq.Item.ItemSeq > 0) cmd.Parameters.Add("@ItemSeq", SqlDbType.Int, 0).Value = pDataRq.Item.ItemSeq; #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 = ConvertToBmItemImg(ds.Tables[1]); } } da.Dispose(); cmd.Dispose(); return result; } catch (Exception ex) { throw ex; } }
/// <summary>상품 이미지 Paging 조회</summary> public BmItemImgPagingRs GetItemQuantityPagingList(BmItemImgPagingRq pDataRq) { try { using (SqlConn = new SqlConnection(ConnectionString)) { using (TransactionScope scope = new TransactionScope()) { try { SqlConn.Open(); var result = dac.GetItemImgPagingList(pDataRq); scope.Complete(); return result; } catch (Exception ex) { throw ex; } finally { SqlConn.Dispose(); } } } } catch (Exception ex) { WriteLog("Exception", ex.Message); throw; } }
public BmItemPkgRq() { Item = new BmItem(); QuantityList = new BmItemQuantityPagingRq(); ImgList = new BmItemImgPagingRq(); }