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();
}
}
}
