Exemplo n.º 1
0
        /// <summary>
        /// T_SHARE 조회하기
        /// </summary>
        /// <param name="Param"></param>
        /// <returns></returns>
        public List <T_SHARE> GetShareList(T_SHARE_COND Param)
        {
            string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Base\\T_SHARE.xml", "GetShareList"
                                                , Param.PAGE.ToString("1")
                                                , Param.PAGE_COUNT.ToString("10")
                                                , Param.SORT_ORDER.ToString("A.SHARE_CODE DESC")
                                                , Param.GUBUN.ToString("") == "banner" ? "1" : "2"
                                                , Param.SHARE_CODE.ToString("")
                                                , Param.SEND_MEMBER_CODE.ToString("")
                                                , Param.AD_CODE.ToString("")
                                                , Param.DEVICE_CODE.ToString("")

                                                , Param.HIDE == null ? "" : (Param.HIDE == false ? "0" : "1")
                                                , Param.TITLE.ToString("")
                                                , Param.DEVICE_NAME.ToString("")
                                                , Param.SEND_MEMBER_NAME.ToString("")
                                                , Param.RECEIVE_MEMBER_NAME.ToString("")
                                                );

            return(db.ExecuteQuery <T_SHARE>(sql).ToList());
        }
 public PartialViewResult pv_shareList(T_SHARE_COND Param)
 {
     ViewBag.list = new ShareService().GetShareList(Param);
     return(PartialView2());
 }