Example #1
0
        /// <summary>
        /// T_SIGNAGE_PLACE 조회하기	(로컬사인장소 - T_SIGNAGE_PLACE 저장 -  selectparam Query)
        /// </summary>
        /// <param name="Param"></param>
        /// <returns></returns>
        public List <T_SIGNAGE_PLACE> GetSignagePlaceList(T_SIGNAGE_PLACE_COND Param)
        {
            string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Signage\\T_SIGNAGE_PLACE.xml", "GetSignagePlaceList"
                                                , Param.IDX.ToString("")
                                                , Param.SIGN_CODE.ToString("")
                                                , Param.PLACE_TYPE.ToString("1")
                                                , Param.CK_CODE.ToString("")
                                                , Param.REGION.ToString("")
                                                , Param.JIBUN_ADDRESS.ToString("")
                                                , Param.ROAD_ADDRESS.ToString("")
                                                , Param.BUILDING.ToString("")
                                                , Param.ZIP_CODE.ToString("")
                                                );

            return(db.ExecuteQuery <T_SIGNAGE_PLACE>(sql).ToList());
        }
Example #2
0
 public PartialViewResult PV_SignagePlaceList(T_SIGNAGE_PLACE_COND Cond)
 {
     ViewBag.list = new LoggalBoxService().GetSignagePlaceList(Cond);
     return(PartialView2());
 }