public ActionResult SignageControlExcelReport(T_SIGNAGE_CONTROL_COND Cond)
{
List <string> headers = new List <string>()
{
"순번", "메일", "요청자", "콘텐츠", "내용", "요청시간", "완료시간", "시작시간", "종료시간", "등록자", "등록시간", "수정자", "수정시간"
};
Cond.PAGE = 1;
Cond.PAGE_COUNT = 100000;
return(new LoggalBoxService().GetSignageControlList(Cond).Select(s => new {
IDX = s.IDX
, REQUEST_EMAIL = s.REQUEST_EMAIL
, REQUEST_NAME = s.REQUEST_NAME
, CONTENT_URL = s.CONTENT_URL
, CONTENT = s.CONTENT
, SIGN_NAME = s.SIGN_NAME
, PLAY_REQ_TIME = s.PLAY_REQ_TIME
, COMPLEATED_DATE = s.COMPLEATED_DATE
, PLAY_FR_TIME = s.PLAY_FR_TIME
, PLAY_TO_TIME = s.PLAY_TO_TIME
, UPDATE_NAME = s.UPDATE_NAME
, UPDATE_DATE = s.UPDATE_DATE
}).ToList().ToExcel(SessionHelper.LoginInfo.CURRENT_MENU_NAME + DateTime.Now.ToString("_yyyyMMddHHmmss"), headers));
;
}
/// <summary>
/// 사이니지 제어
/// </summary>
/// <param name="Cond"></param>
/// <returns></returns>
public ActionResult SignageControl(T_SIGNAGE_CONTROL_COND Cond)
{
Cond.IDX = Cond.IDX ?? -1;
T_SIGNAGE_CONTROL rtn = new LoggalBoxService().GetSignageControlList(Cond).FirstOrDefault();
if (rtn == null)
{
var data = new LoggalBoxService().GetSignageList(new T_SIGNAGE_COND()
{
SIGN_CODE = Cond.SIGN_CODE ?? -1
}).FirstOrDefault();
if (data != null)
{
rtn = new T_SIGNAGE_CONTROL()
{
SIGN_CODE = Cond.SIGN_CODE, SIGN_NAME = data.SIGN_NAME
};
}
}
ViewBag.data = rtn;
if (!string.IsNullOrEmpty(Cond.USER_ID))
{
var rtnData = new AccountService().GetMemberList(new T_MEMBER_COND {
USER_ID = Cond.USER_ID
}).FirstOrDefault();
if (rtnData != null)
{
rtnData.PASSWORD = "";
ViewBag.login = rtnData;
}
}
return(View());
}
public JsonResult GetSignageControlList(T_SIGNAGE_CONTROL_COND Cond)
{
var list = new LoggalBoxService().GetSignageControlList(Cond);
return(new JsonResult()
{
Data = list
});
}
/// <summary>
/// T_SIGNAGE_CONTROL 조회하기
/// </summary>
/// <param name="Param"></param>
/// <returns></returns>
public List <T_SIGNAGE_CONTROL> GetSignageControlList(T_SIGNAGE_CONTROL_COND Param)
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Signage\\T_SIGNAGE_CONTROL.xml", "GetSignageControlList"
, Param.PAGE.ToString("1")
, Param.PAGE_COUNT.ToString("10")
, Param.SORT_ORDER.ToString("CASE WHEN A.COMPLEATED_DATE IS NULL THEN 0 ELSE 1 END, A.IDX DESC")
, Param.IDX.ToString("")
, Param.SIGN_CODE.ToString("")
, Param.SIGN_NAME.ToString("")
, Param.PLAY_TYPE.ToString("1")
, Param.FR_PLAY_REQ_TIME.ToString("")
, Param.TO_PLAY_REQ_TIME.ToString("")
, Param.IS_COMPLEATED == null ? "" : ((Param.IS_COMPLEATED == true) ? "A.COMPLEATED_DATE IS NOT NULL" : "A.COMPLEATED_DATE IS NULL")
, Param.HIDE.ToBooleanString()
);
return(db.ExecuteQuery <T_SIGNAGE_CONTROL>(sql).ToList());
}
public ActionResult PV_SignageControlList(T_SIGNAGE_CONTROL_COND Cond)
{
ViewBag.list = new LoggalBoxService().GetSignageControlList(Cond);;
return(PartialView2());
}
public IList <T_SIGNAGE_CONTROL> GetSignageControlList([FromBody] T_SIGNAGE_CONTROL_COND Cond)
{
IList <T_SIGNAGE_CONTROL> list = new LoggalBoxService().GetSignageControlList(Cond);
return(list);
}