public PartialViewResult StoreCombo(string name, T_STORE_COND Param, string selectedValue, string optionLabel, string htmlAttributes)
{
List <SelectListItem> combolist = new List <SelectListItem>();
Param.PAGE_COUNT = 3000;
IList <T_STORE> list = new ALT.BizService.BasicService().GetStoreList(Param);
if (list == null)
{
list = new List <T_STORE>();
}
DROPDOWN_COND data = new DROPDOWN_COND
{
name = name
,
selectList = list.Select(s => new SelectListItem {
Value = s.STORE_CODE.ToString(), Text = s.STORE_NAME, Selected = (selectedValue == s.STORE_CODE.ToString()) ? true : false
}).ToList()
,
optionLabel = optionLabel
,
htmlAttributes = JsonConvert.DeserializeAnonymousType(htmlAttributes, new { @class = "", @style = "", @placeholder = "", @readonly = "" })
};
return(PartialCombo(data));
}
public IList <T_STORE> GetStoreList(T_STORE_COND Cond)
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "HomePage\\T_STORE.xml", "GetStoreList"
, Cond.COMPANY_CODE.ToString("")
, Cond.COMPANY_ID.ToString("")
, Cond.COMPANY_NAME.ToString("")
, Cond.STORE_CODE.ToString("")
, Cond.STORE_ID.ToString("")
, Cond.STORE_NAME.ToString("")
, Cond.STATUS.ToString("")
);
return(db.ExecuteQuery <T_STORE>(sql).ToList());
}
public PartialViewResult PV_StoreList(T_STORE_COND Cond)
{
if (SessionHelper.LoginInfo.STORE.STORE_CODE != 1)
{
Cond.COMPANY_CODE = SessionHelper.LoginInfo.STORE.COMPANY_CODE;
}
if (SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE != 1 && !(SessionHelper.LoginInfo.STORE.STORE_TYPE == 1 || SessionHelper.LoginInfo.STORE.STORE_TYPE == 4))
{
Cond.STORE_CODE = SessionHelper.LoginInfo.STORE.STORE_CODE;
}
ViewBag.list = new BasicService().GetStoreList(Cond);
return(PartialView2());
}
public JsonResult GetStoreList(T_STORE_COND Cond)
{
if (SessionHelper.LoginInfo.STORE.STORE_CODE != 1)
{
Cond.COMPANY_CODE = SessionHelper.LoginInfo.STORE.COMPANY_CODE;
}
if (SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE != 1 && !(SessionHelper.LoginInfo.STORE.STORE_TYPE == 1 || SessionHelper.LoginInfo.STORE.STORE_TYPE == 4))
{
Cond.STORE_CODE = SessionHelper.LoginInfo.STORE.STORE_CODE;
}
return(new JsonResult {
Data = new BasicService().GetStoreList(Cond)
});
}
public IList <T_STORE> GetStoreList(T_STORE_COND Cond)
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Basic\\T_STORE.xml", "GetStoreList"
, Cond.PAGE_COUNT.ToString("15")
, Cond.PAGE.ToString("1")
, Cond.SORT.ToString("B.COMPANY_NAME, A.STORE_NAME")
, Cond.COMPANY_CODE.ToString("")
, Cond.COMPANY_ID.ToString("")
, Cond.COMPANY_NAME.ToString("")
, Cond.STORE_CODE.ToString("")
, Cond.STORE_ID.ToString("")
, Cond.STORE_NAME.ToString("")
, Cond.STATUS.ToString("")
, Cond.INSERT_NAME.ToString("")
);
return(db.ExecuteQuery <T_STORE>(sql).ToList());
}
/// <summary>
/// 매장콤보
/// </summary>
/// <param name="helper"></param>
/// <param name="id"></param>
/// <param name="Param"></param>
/// <param name="selectedValue"></param>
/// <param name="optionLabel"></param>
/// <param name="htmlAttributes"></param>
/// <returns></returns>
public static MvcHtmlString StoreCombo(this HtmlHelper helper, string id, T_STORE_COND Param = null, string selectedValue = null, string optionLabel = "-선택-", object htmlAttributes = null)
{
Param = (Param == null) ? new T_STORE_COND {
DISPLAY_MODE = "Normal"
} : Param;
if (Param.DISPLAY_MODE != "Total")
{
if (SessionHelper.LoginInfo.STORE.STORE_CODE != 1)
{
Param.COMPANY_CODE = SessionHelper.LoginInfo.STORE.COMPANY_CODE;
}
if (!(SessionHelper.LoginInfo.STORE.STORE_TYPE == 1 || SessionHelper.LoginInfo.STORE.STORE_TYPE == 4))
{
Param.STORE_CODE = SessionHelper.LoginInfo.STORE.STORE_CODE;
selectedValue = null;
}
}
if (Param.COMPANY_CODE == null)
{
Param.COMBO_DISPLAY = 1;
}
if (Param.PAGE_COUNT == null)
{
Param.PAGE_COUNT = 999999999;
}
IList <T_STORE> list = Service.basicService.GetStoreList(new T_STORE_COND());
if (list.Count() == 1)
{
optionLabel = null;
}
var combo = list.Select(s => new SelectListItem {
Value = s.STORE_CODE.ToString(), Text = ((Param.COMBO_DISPLAY == 1 && s.COMPANY_NAME != s.STORE_NAME) ? (s.COMPANY_NAME + ">") : "") + s.STORE_NAME, Selected = (selectedValue == s.STORE_CODE.ToString()) ? true : false
});
var arrHtmlAtribute = SemanticUIHelper.SetDefaultSemanticSize(htmlAttributes, semaintic_size);
string shtml = helper.DropDownList(id, combo, optionLabel, arrHtmlAtribute).ToHtmlString();
return(new MvcHtmlString(shtml));
}
public JsonResult GetStoreMapList(T_STORE_COND Cond)
{
if (SessionHelper.LoginInfo.STORE.STORE_CODE != 1)
{
Cond.COMPANY_CODE = SessionHelper.LoginInfo.STORE.COMPANY_CODE;
}
if (SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE != 1 && !(SessionHelper.LoginInfo.STORE.STORE_TYPE == 1 || SessionHelper.LoginInfo.STORE.STORE_TYPE == 4))
{
Cond.STORE_CODE = SessionHelper.LoginInfo.STORE.STORE_CODE;
}
return(new JsonResult {
Data =
new BasicService().GetStoreList(Cond).Where(w => w.LATITUDE > 30 && w.LONGITUDE > 120)
.Select(s => new DAUM_MAPLIST {
ACTIVE_YN = true
, CONTENT = "<b>배너 :</b> " + s.AD_CNT0.ToString() + "/" + s.AD_CNT1.ToString() + "/" + s.AD_CNT2.ToString()
+ " <b>로컬박스 :</b> " + s.DEVICE_CNT0.ToString() + "/" + s.DEVICE_CNT1.ToString() + "/" + s.DEVICE_CNT2.ToString()
, TITLE = s.COMPANY_NAME, LATITUDE = s.LATITUDE, LONGITUDE = s.LONGITUDE, LINK_URL = "/comp/storereg/" + s.STORE_CODE.ToString()
}).ToList()
});
}
public ActionResult StoreExcelReport(T_STORE_COND Cond)
{
if (SessionHelper.LoginInfo.STORE.STORE_CODE != 1)
{
Cond.COMPANY_CODE = SessionHelper.LoginInfo.STORE.COMPANY_CODE;
}
if (SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE != 1 && !(SessionHelper.LoginInfo.STORE.STORE_TYPE == 1 || SessionHelper.LoginInfo.STORE.STORE_TYPE == 4))
{
Cond.STORE_CODE = SessionHelper.LoginInfo.STORE.STORE_CODE;
}
List <string> headers = new List <string>()
{
"회사명", "코드", "아이디", "사업장명", "유형", "대표전화", "이메일", "주소", "상태", "시간대(UTC+)", "비고", "수정자", "수정시간"
};
Cond.PAGE = 1;
Cond.PAGE_COUNT = 100000;
return(new BasicService().GetStoreList(Cond).Select(s => new {
COMPANY_NAME = s.COMPANY_NAME
, STORE_CODE = s.STORE_CODE
, STORE_ID = s.STORE_ID
, STORE_NAME = s.STORE_NAME
, STORE_TYPE_NAME = s.STORE_TYPE_NAME
, PHONE = s.PHONE
, EMAIL = s.EMAIL
, ADDRESS = s.ADDRESS1 + " " + s.ADDRESS2 + "(우)" + s.ZIP_CODE
, STATUS_NAME = s.STATUS_NAME
, TIME_ZONE = s.TIME_ZONE
, REMARK = s.REMARK
, UPDATE_NAME = s.UPDATE_NAME
, UPDATE_DATE = s.UPDATE_DATE
}).ToList().ToExcel(SessionHelper.LoginInfo.CURRENT_MENU_NAME + DateTime.Now.ToString("_yyyyMMddHHmmss"), headers));
}
public ActionResult storeList(T_STORE_COND Cond)
{
ViewBag.data = Cond;
return(View());
}
