private void getcallbranchlist() { DataSet ds = null; DataSet callds = null; ds = new DataSet(); callds = new DataSet(); string a_branch_id = ""; try { Hashtable param = new Hashtable(); param.Add("search_sel", (jsonCol["search_sel"] != null) ? jsonCol["search_sel"].GetValue().ToString() : ""); param.Add("search_text", (jsonCol["search_text"] != null) ? jsonCol["search_text"].GetValue().ToString() : ""); ds = store.selectBranchListAll(); if (DbUtil.ContainData(ds)) { foreach (DataRow dt in ds.Tables[0].Rows) { a_branch_id += dt["a_branch_id"].ToString() + "','"; } a_branch_id = a_branch_id.Substring(0, a_branch_id.Length - 3); } param.Add("a_branch_id", a_branch_id); callds = callstore.selectCallBranchList(param); result.Add(new JsonStringValue("result", "000")); result.Add(new JsonStringValue("message", "정상조회 되었습니다.")); result.Add(new JsonStringValue("List", JsonConvert.SerializeObject(callds, Newtonsoft.Json.Formatting.Indented))); } catch (Exception ex) { result.Add(new JsonStringValue("result", "152")); result.Add(new JsonStringValue("message", "리스트 조회시 예외오류가 발생하였습니다.\\n" + ex.Message)); } }
private void synccallbranch() { ResultBox rtnbox = new ResultBox(); ResultBox rtnboxlog = new ResultBox(); DataSet callds = null; callds = new DataSet(); string syncSql = ""; string arr_branch_id = (jsonCol["arr_branch_id"] != null) ? jsonCol["arr_branch_id"].GetValue().ToString() : ""; try { if ("".Equals(arr_branch_id)) { result.Add(new JsonStringValue("result", "995")); result.Add(new JsonStringValue("message", "매장데이터가 없습니다.")); } else { arr_branch_id = arr_branch_id.Substring(1, arr_branch_id.Length - 1); arr_branch_id = arr_branch_id.Replace("|", "','"); Hashtable param = new Hashtable(); param.Add("a_branch_id", arr_branch_id); callds = callstore.synccallbranch(param); if (DbUtil.ContainData(callds)) { foreach (DataRow calldt in callds.Tables[0].Rows) { syncSql += calldt["qry"].ToString(); } Hashtable callparam = new Hashtable(); callparam.Add("qry", syncSql); rtnbox = store.synccallbranchexec(callparam); } string agent_id = base.logOnInfo.UserId.ToString(); string agent_nm = base.logOnInfo.UserName.ToString(); string agent_ip = Request.ServerVariables["REMOTE_ADDR"]; string actionmode = "synccallbranch"; Hashtable logparam = new Hashtable(); logparam.Add("agent_id", agent_id); logparam.Add("agent_nm", agent_nm); logparam.Add("agent_ip", agent_ip); logparam.Add("actionmode", actionmode); logparam.Add("updatedt", arr_branch_id); logparam.Add("descdt", "매장동기화 작업"); rtnboxlog = order.insertadminlog(logparam); result.Add(new JsonStringValue("result", rtnbox.ResultCode)); result.Add(new JsonStringValue("message", rtnbox.ResultMsg)); } } catch (Exception ex) { result.Add(new JsonStringValue("result", "996")); result.Add(new JsonStringValue("message", "동기화 진행시 오류가 발생하였습니다.\\n" + ex.Message)); } }
protected void Page_Load(object sender, EventArgs e) { branch_id = webUtil.GetParam("branch_id", ""); pages = webUtil.GetParam("pages", "1"); if (branch_id == "" || branch_id == null) { webUtil.Alert("잘못된 경로로 접근하셧습니다.", "/store/store_list.aspx"); return; } DataSet ds = null; DataSet ds1 = null; Hashtable param = new Hashtable(); param.Add("branch_id", branch_id); if (!IsPostBack) { Order cm = new Order(); ds = cm.selectBranchInfo(param); #region 마스터코드 바인딩 CodeMaster master = new CodeMaster(); ds1 = master.selectCodeMaster(param); packinginfo.DataSource = ds1.Tables[0]; packinginfo.DataBind(); #endregion if (DbUtil.ContainData(ds)) { DataRow branch = ds.Tables[0].Rows[0]; get_dt = branch["get_dt"].ToString(); a_branch_id = branch["a_branch_id"].ToString(); a_branch_nm = branch["a_branch_nm"].ToString(); a_branch_tel = branch["a_branch_tel"].ToString(); a_branch_addr = branch["a_branch_addr"].ToString(); a_delivery_time = branch["a_delivery_time"].ToString(); a_week_starttime = branch["a_week_starttime"].ToString(); a_week_endtime = branch["a_week_endtime"].ToString(); use_yn = branch["use_yn"].ToString(); a_end_starttime = branch["a_end_starttime"].ToString(); a_end_endtime = branch["a_end_endtime"].ToString(); order_branch_id = branch["order_branch_id"].ToString(); mid = branch["mid"].ToString(); mertkey = branch["mertkey"].ToString(); ocb_branch_id = branch["ocb_branch_id"].ToString(); ocb_branch_cn = branch["ocb_branch_cn"].ToString(); packing_type = branch["packing_type"].ToString(); home_yn = branch["home_yn"].ToString(); online_yn = branch["online_yn"].ToString(); ecoupon_yn = branch["ecoupon_yn"].ToString(); cesco_yn = branch["cesco_yn"].ToString(); carddisc_yn = branch["carddisc_yn"].ToString(); advance_yn = branch["advance_yn"].ToString(); bctop_yn = branch["bctop_yn"].ToString(); lat = branch["lat"].ToString(); lng = branch["lng"].ToString(); } } }