Exemplo n.º 1
0
        /// <summary>
        /// 新增會員至群組
        /// </summary>
        /// <returns></returns>
        public HttpResponseBase SaveVipUser()
        {
            string jsonStr = "";
            VipUserQuery vip = new VipUserQuery();
            if (!string.IsNullOrEmpty(Request.Params["usermail"]))
            {
                vip.user_email = Request.Params["usermail"];
            }
            if (!string.IsNullOrEmpty(Request.Params["user_id"]))
            {
                vip.user_id = uint.Parse(Request.Params["user_id"]);
            }
            if (!string.IsNullOrEmpty(Request.Params["group_id"]))
            {
                vip.group_id = uint.Parse(Request.Params["group_id"]);
            }

            vip.create_id = uint.Parse((Session["caller"] as Caller).user_id.ToString());
            vip.update_id = uint.Parse((Session["caller"] as Caller).user_id.ToString());
            vip.createdate = uint.Parse(CommonFunction.GetPHPTime().ToString());
            vip.updatedate = vip.createdate;
            try
            {
                _vipuserMgr = new VipUserMgr(mySqlConnectionString);
                if (_vipuserMgr.AddVipUser(vip) > 0)
                {
                    jsonStr = "{success:true}";
                }
                else
                {
                    jsonStr = "{success:false}";
                }
            }
            catch (Exception ex)
            {
                Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
                logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
                logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
                log.Error(logMessage);
                jsonStr = "{success:false}";
            }
            this.Response.Clear();
            this.Response.Write(jsonStr);
            this.Response.End();
            return this.Response;
        }
Exemplo n.º 2
0
        /// <summary>
        /// 刪除會員至群組
        /// </summary>
        /// <returns></returns>
        public HttpResponseBase DeleVipUser()
        {
            string jsonStr = "";
            VipUserQuery vip = new VipUserQuery();
            if (!string.IsNullOrEmpty(Request.Params["vid"]))
            {
                vip.v_id = uint.Parse(Request.Params["vid"]);
            }

            try
            {
                _vipuserMgr = new VipUserMgr(mySqlConnectionString);
                if (_vipuserMgr.DeleVipUser(vip) > 0)
                {
                    jsonStr = "{success:true}";
                }
                else
                {
                    jsonStr = "{success:false}";
                }
            }
            catch (Exception ex)
            {
                Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
                logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
                logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
                log.Error(logMessage);
                jsonStr = "{success:false}";
            }
            this.Response.Clear();
            this.Response.Write(jsonStr);
            this.Response.End();
            return this.Response;
        }
Exemplo n.º 3
0
        public HttpResponseBase ExportFile()
        {
            string json = string.Empty;
            int totalCount = 0;
            _vipuserMgr = new VipUserMgr(mySqlConnectionString);
            try
            {
                DataTable store = new DataTable();
                VipUserQuery query = new VipUserQuery();
                query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
                query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
                if (!string.IsNullOrEmpty(Request.Params["searchState"]))
                {
                    query.search_state = Convert.ToInt32(Request.Params["searchState"]);
                }
                if (!string.IsNullOrEmpty(Request.Params["search_text"]))
                {
                    query.serchtype = Request.Params["search_text"].ToString();
                }
                if (!string.IsNullOrEmpty(Request.Params["start_date"]))
                {
                    query.start = Convert.ToDateTime(Request.Params["start_date"]);
                }
                if (!string.IsNullOrEmpty(Request.Params["end_date"]))
                {
                    query.end = Convert.ToDateTime(Request.Params["end_date"]);
                }
                if (!string.IsNullOrEmpty(Request.Params["source"]))
                {
                    query.source = Convert.ToUInt32(Request.Params["source"]);
                }
                if (!string.IsNullOrEmpty(Request.Params["uid"]))
                {
                    query.User_Id = Convert.ToUInt32(Request.Params["uid"]);
                }
                query.IsPage = false;
                DataTable dtHZ = new DataTable();
                string newExcelName = string.Empty;
                dtHZ.Columns.Add("黑名單編號", typeof(int));
                dtHZ.Columns.Add("會員郵箱", typeof(String));
                dtHZ.Columns.Add("添加來源", typeof(String));
                dtHZ.Columns.Add("狀態", typeof(String));
                dtHZ.Columns.Add("會員編號", typeof(int));
                dtHZ.Columns.Add("創建者", typeof(String));
                dtHZ.Columns.Add("列入黑名單日期", typeof(String));
                dtHZ.Columns.Add("修改者", typeof(String));
                dtHZ.Columns.Add("修改時間", typeof(String));
                store = _vipuserMgr.GetBlackList(query, out totalCount);
                foreach (DataRow dr_v in store.Rows)
                {
                    DataRow dr = dtHZ.NewRow();
                    dr[0] = dr_v["v_id"].ToString();
                    dr[1] = dr_v["user_email"].ToString();
                    dr[2] = dr_v["source"].ToString() == "2" ? "客服" : "用戶";
                    dr[3] = dr_v["status"].ToString() == "0" ? "解除" : "鎖定";
                    dr[4] = dr_v["user_id"].ToString();
                    dr[5] = dr_v["createUsername"].ToString();
                    dr[6] = dr_v["create"].ToString();
                    dr[7] = dr_v["updateUsername"].ToString();
                    dr[8] = dr_v["updatedate"].ToString();
                    dtHZ.Rows.Add(dr);
                }
                string[] colname = new string[dtHZ.Columns.Count];
                string filename = "BlackList" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
                newExcelName = Server.MapPath(excelPath_export) + filename;
                for (int i = 0; i < dtHZ.Columns.Count; i++)
                {
                    colname[i] = dtHZ.Columns[i].ColumnName;
                }

                if (System.IO.File.Exists(newExcelName))
                {
                    System.IO.File.Delete(newExcelName);
                }
                ExcelHelperXhf.ExportDTtoExcel(dtHZ, "", newExcelName);
                json = "{success:true,ExcelName:\'" + filename + "\'}";
            }
            catch (Exception ex)
            {
                Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
                logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
                logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
                log.Error(logMessage);
            }
            this.Response.Clear();
            this.Response.Write(json);
            this.Response.End();
            return this.Response;
        }
Exemplo n.º 4
0
        /// <summary>
        /// 新增黑名單
        /// </summary>
        /// <returns></returns>
        public HttpResponseBase UpdateBlackList()
        {
            string json = string.Empty;
            _vipuserMgr = new VipUserMgr(mySqlConnectionString);
            try
            {
                string mail = string.Empty;
                if (!string.IsNullOrEmpty(Request.Params["mail"]))
                {
                    mail = Request.Params["mail"].ToString();
                }
                int result = _vipuserMgr.UpdateBlackList(mail);
                if (result > 0)
                {
                    json = "{success:true}";
                }
                else if (result == -1)
                {
                    json = "{success:false,msg:0}";
                }
                else if (result == -2)
                {
                    json = "{success:false,msg:1}";
                }
            }
            catch (Exception ex)
            {

                Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
                logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
                logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
                log.Error(logMessage);

            }
            this.Response.Clear();
            this.Response.Write(json);
            this.Response.End();
            return this.Response;
        }
Exemplo n.º 5
0
        /// <summary>
        /// 更改狀態 啟用或者禁用
        /// </summary>
        /// <returns></returns>
        public JsonResult UpdateState()
        {
            uint id = 0;
            uint activeValue = 0;
            _vipuserMgr = new VipUserMgr(mySqlConnectionString);
            VipUserQuery query = new VipUserQuery();
            if (!string.IsNullOrEmpty(Request.Params["id"]))
            {
                id = Convert.ToUInt32(Request.Params["id"]);
            }
            if (!string.IsNullOrEmpty(Request.Params["active"]))
            {
                activeValue = Convert.ToUInt32(Request.Params["active"]);
            }
            query.v_id = id;

            if (!string.IsNullOrEmpty(Request.Params["uid"]))
            {
                query.user_id = Convert.ToUInt32(Request.Params["uid"]);
            }
            query.status = activeValue;
            query.update_id = Convert.ToUInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString());
            if (_vipuserMgr.UpdateState(query) > 0)
            {
                return Json(new { success = "true", msg = "1" });
            }
            else
            {
                return Json(new { success = "false", msg = "" });
            }

        }
Exemplo n.º 6
0
        public HttpResponseBase GetBlackList()
        {
            string json = string.Empty;
            int totalCount = 0;
            _vipuserMgr = new VipUserMgr(mySqlConnectionString);
            try
            {
                DataTable store = new DataTable();
                VipUserQuery query = new VipUserQuery();
                query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
                query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
                if (!string.IsNullOrEmpty(Request.Params["searchState"]))
                {
                    query.search_state = Convert.ToInt32(Request.Params["searchState"]);
                }
                if (!string.IsNullOrEmpty(Request.Params["search_text"]))
                {
                    query.serchtype = Request.Params["search_text"].ToString().Replace("\\", "\\\\").Trim();
                }
                if (!string.IsNullOrEmpty(Request.Params["start_date"]))
                {
                    query.start = Convert.ToDateTime(Request.Params["start_date"]);
                }
                if (!string.IsNullOrEmpty(Request.Params["end_date"]))
                {
                    query.end = Convert.ToDateTime(Request.Params["end_date"]);
                }
                if (!string.IsNullOrEmpty(Request.Params["source"]))
                {
                    query.source = Convert.ToUInt32(Request.Params["source"]);
                }
                if (!string.IsNullOrEmpty(Request.Params["uid"]))
                {
                    query.User_Id = Convert.ToUInt32(Request.Params["uid"]);
                }
                store = _vipuserMgr.GetBlackList(query, out totalCount);

                foreach (DataRow item in store.Rows)
                {
                    item["user_email"] = item["user_email"].ToString().Split('@')[0] + "@***";
                }
                IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
                timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
                json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";
            }
            catch (Exception ex)
            {
                Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
                logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
                logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
                log.Error(logMessage);
                json = "{success:false}";
            }
            this.Response.Clear();
            this.Response.Write(json);
            this.Response.End();
            return this.Response;
        }
Exemplo n.º 7
0
        public HttpResponseBase GetUserInfo()
        {
            string json = "{success:false}";
            try
            {
                int type = 0; int related_id = 0; string urlType = string.Empty; int totalCount = 0;
                int info_id = 0; string info_type = string.Empty;
                if (!string.IsNullOrEmpty(Request.Params["relatedID"]))
                {
                    related_id = Convert.ToInt32(Request.Params["relatedID"].ToString());//表主鍵欄位
                }
                if (!string.IsNullOrEmpty(Request.Params["type"]))
                {
                    type = Convert.ToInt32(Request.Params["type"].ToString());//secret_type,表某一模塊
                }
                if (!string.IsNullOrEmpty(Request.Params["urlType"]))//url地址
                {
                    urlType = Request.Params["urlType"].ToString();
                }
                if (!string.IsNullOrEmpty(Request.Params["info_id"]))
                {
                    info_id = Convert.ToInt32(Request.Params["info_id"].ToString());
                }
                if (!string.IsNullOrEmpty(Request.Params["info_type"]))
                {
                    info_type = Request.Params["info_type"].ToString();
                }
                switch (info_type)//1.會員查詢頁面2.訂單內容3.簡訊查詢4.聯絡客服列表
                {
                    case "users":
                        UsersMgr _usermgr = new UsersMgr(mySqlConnectionString);
                        Users u = new Users();
                        Users uModel = _usermgr.GetUser(new Users { user_id = Convert.ToUInt32(info_id) }).FirstOrDefault();

                        if (uModel != null)
                        {
                            if (!string.IsNullOrEmpty(uModel.user_mobile))
                            {
                                if (!CommonFunction.isMobile(uModel.user_mobile))
                                {
                                    if (uModel.user_mobile.ToString().Length == 48)
                                    {
                                        uModel.user_mobile = EncryptComputer.EncryptDecryptTextByApi(uModel.user_mobile, false);
                                        if (!CommonFunction.isMobile(uModel.user_mobile))
                                        {
                                            //異常記錄
                                            Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
                                            logMessage.Content = string.Format("表名:{0},編號:{1},行動電話:{2},Message:{3}", "users", uModel.user_id, uModel.user_mobile, "行動電話解密后不滿足正則表達式");
                                            logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
                                            log.Error(logMessage);
                                        }
                                    }
                                    else
                                    {
                                        //異常記錄
                                        Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
                                        logMessage.Content = string.Format("表名:{0},編號:{1},行動電話:{2},Message:{3}", "users", uModel.user_id, uModel.user_mobile, "行動電話錯誤");
                                        logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
                                        log.Error(logMessage);
                                    }
                                }
                            }
                        }
                        json = "{success:true,\"user_id\":\"" + uModel.user_id + "\",\"user_name\":\"" + uModel.user_name + "\",\"user_email\":\"" + uModel.user_email + "\",\"user_mobile\":\"" + uModel.user_mobile + "\",\"user_adress\":\"" + uModel.user_address + "\"}";

                        this.Response.Clear();
                        this.Response.Write(json);
                        this.Response.End();
                        return this.Response;
                    case "trial_share":
                        TrialRecordMgr _recordMgr = new TrialRecordMgr(mySqlConnectionString);
                        TrialShare tModel = _recordMgr.GetTrialShare(new TrialShare { share_id = related_id, user_id = info_id });
                        json = "{success:true,\"user_id\":\"" + tModel.user_id + "\",\"user_name\":\"" + tModel.user_name + "\"}";
                        break;
                    case "manager_user":
                        ManageUserMgr _muMgr = new ManageUserMgr(mySqlConnectionString);
                        ManageUser muModel = _muMgr.GetManageUser(new ManageUser { user_id = Convert.ToUInt32(info_id) }).FirstOrDefault();
                        json = "{success:true,\"user_id\":\"" + muModel.user_id + "\",\"user_name\":\"" + muModel.user_username + "\",\"user_email\":\"" + muModel.user_email + "\"}";
                        break;
                    case "vip_user":
                        VipUserMgr vipusersMgr = new VipUserMgr(mySqlConnectionString);
                        VipUser model = vipusersMgr.GetSingleByID(related_id);
                        json = "{success:true,\"v_id\":\"" + model.v_id + "\",\"user_id\":\"" + model.user_id + "\",\"user_email\":\"" + model.user_email + "\"}";
                        break;
                    case "edm_group_email":
                        EdmGroupEmailMgr edmgroupmailMgr = new EdmGroupEmailMgr(mySqlConnectionString);
                        EdmGroupEmailQuery egemodel = edmgroupmailMgr.GetModel(new EdmGroupEmail { email_id = Convert.ToUInt32(related_id), group_id = Convert.ToUInt32(info_id) }).FirstOrDefault();
                        json = "{success:true,\"user_id\":\"" + egemodel.email_id + "\",\"user_name\":\"" + egemodel.email_name + "\",\"user_email\":\"" + egemodel.email_address + "\"}";
                        break;
                    case "edm_test":
                        EdmTestMgr edmtestMgr = new EdmTestMgr(mySqlConnectionString);
                        EdmTestQuery etmodel = edmtestMgr.GetModel(new EdmTestQuery { email_id = Convert.ToUInt32(related_id) }).FirstOrDefault();
                        json = "{success:true,\"user_id\":\"" + etmodel.email_id + "\",\"user_name\":\"" + etmodel.test_username + "\",\"user_email\":\"" + etmodel.email_address + "\"}";

                        break;
                    case "order_master":
                        OrderMasterMgr omMgr = new OrderMasterMgr(mySqlConnectionString);
                        zMgr = new ZipMgr(mySqlConnectionString);
                        DataTable dt = omMgr.GetOrderidAndName(related_id);
                        json = "{success:true,\"order_id\":\"" + dt.Rows[0][0] + "\",\"order_name\":\"" + dt.Rows[0][1] + "\",\"order_phone\":\"" + dt.Rows[0][2] + "\",\"order_mobile\":\"" + dt.Rows[0][3] + "\",\"order_address\":\"" + zMgr.Getaddress(int.Parse(dt.Rows[0][9].ToString())) + dt.Rows[0][4] + "\",\"delivery_name\":\"" + dt.Rows[0][5] + "\",\"delivery_phone\":\"" + dt.Rows[0][6] + "\",\"delivery_mobile\":\"" + dt.Rows[0][7] + "\",\"delivery_address\":\"" + zMgr.Getaddress(int.Parse(dt.Rows[0][10].ToString())) + dt.Rows[0][8] + "\"}";
                        break;
                    case "order_master1":
                        OrderMasterMgr omMgr1 = new OrderMasterMgr(mySqlConnectionString);
                        DataTable dt1 = omMgr1.GetOrderidAndName(related_id);
                        json = "{success:true,\"order_id\":\"" + dt1.Rows[0][0] + "\",\"order_name\":\"" + dt1.Rows[0][1] + "\"}";
                        break;
                    case "order_payment_hitrust":
                        TabShowMgr OphMgr = new TabShowMgr(mySqlConnectionString);
                        DataTable store = new DataTable();
                        store = OphMgr.GetOderHitrustDT(related_id);
                        json = "{success:true,\"id\":\"" + store.Rows[0]["id"] + "\",\"pan\":\"" + store.Rows[0]["pan"] + "\",\"bankname\":\"" + store.Rows[0]["bankname"] + "\"}";
                        break;
                    case "order_payment_nccc":
                        TabShowMgr OpnMgr = new TabShowMgr(mySqlConnectionString);
                        DataTable Opn = new DataTable();
                        store = OpnMgr.GetNCCC(related_id);
                        json = "{success:true,\"nccc_id\":\"" + Opn.Rows[0]["nccc_id"] + "\",\"nccc_pan\":\"" + Opn.Rows[0]["pan"] + "\",\"nccc_bankname\":\"" + Opn.Rows[0]["bankname"] + "\"}";
                        break;
                    //case "send_mail":
                    //    SendMailMgr sendmailMgr = new SendMailMgr(mySqlConnectionString);
                    //    SendMail sendModel = sendmailMgr.GetModel(new SendMail { id = related_id });
                    //    json = "{success:true,\"sender_address\":\"" + sendModel.sender_address + "\",\"sender_name\":\"" + sendModel.sender_name + "\",\"send_type\":\"" + sendModel.send_type
                    //        + "\",\"recipient\":\"" + sendModel.recipient + "\",\"recipient_name\":\"" + sendModel.recipient_name
                    //        + "\"}";
                    //    break;
                }
                switch (type)//1.會員查詢頁面2.訂單內容3.簡訊查詢4.聯絡客服列表
                {
                    case 1:
                        if (urlType == "/Member/RecommendMember")//推薦會員中推薦者的信息
                        {
                            UserRecommendMgr _userrecommendMgr = new UserRecommendMgr(mySqlConnectionString);
                            DataTable _urdtno = _userrecommendMgr.getUserInfo(related_id);
                            if (_urdtno.Rows.Count > 0)
                            {

                                json = "{success:true,\"user_id\":\"" + "" + "\",\"user_name\":\"" + "" + "\",\"user_email\":\"" + "" + "\",\"user_adress\":\"" + "" + "\",\"ur_name\":\"" + _urdtno.Rows[0]["name"] + "\",\"ur_mail\":\"" + _urdtno.Rows[0]["mail"] + "\",\"no_ur_name\":\"" + _urdtno.Rows[0]["user_name"] + "\"}";
                            }
                        }
                        else if (urlType == "/Member/UserLoginLog")//會員登入記錄
                        {
                            UserLoginLogMgr _userloginlog = new UserLoginLogMgr(mySqlConnectionString);
                            DataTable _dtull = _userloginlog.GetUserInfo(related_id);
                            if (_dtull.Rows.Count > 0)
                            {

                                json = "{success:true,\"user_id\":\"" + _dtull.Rows[0]["user_id"] + "\",\"user_name\":\"" + _dtull.Rows[0]["user_name"] + "\",\"user_email\":\"" + _dtull.Rows[0]["user_email"] + "\",\"user_adress\":\"" + _dtull.Rows[0]["user_address"] + "\"}";
                            }
                        }
                        else
                        {
                            UsersListMgr _userMgr = new UsersListMgr(mySqlConnectionString);
                            BLL.gigade.Model.Custom.Users _user = _userMgr.getModel(related_id);
                            if (_user != null)
                            {

                                json = "{success:true,\"user_id\":\"" + _user.user_id + "\",\"user_name\":\"" + _user.user_name + "\",\"user_email\":\"" + _user.user_email + "\",\"user_adress\":\"" + _user.user_address + "\"}";
                            }
                        }
                        break;
                    case 2:
                        OrderQuestionMgr _IOrderQuesMgr = new OrderQuestionMgr(mySqlConnectionString);
                        DataTable _dtques = _IOrderQuesMgr.GetUserInfo(related_id);
                        if (_dtques.Rows.Count > 0)
                        {

                            json = "{success:true,\"user_id\":\"" + _dtques.Rows[0]["user_id"] + "\",\"user_name\":\"" + _dtques.Rows[0]["user_name"] + "\",\"user_email\":\"" + _dtques.Rows[0]["user_email"] + "\",\"user_adress\":\"" + "" + "\",\"order_id\":\"" + _dtques.Rows[0]["order_id"] + "\"}";
                        }
                        break;
                    case 3:
                        SmsMgr _ISmsMgr = new SmsMgr(mySqlConnectionString);

                        SmsQuery SmsStore = _ISmsMgr.GetSmsList(new SmsQuery { id = related_id }, out totalCount).FirstOrDefault();
                        if (SmsStore != null)
                        {

                            json = "{success:true,\"user_id\":\"" + "" + "\",\"user_name\":\"" + "" + "\",\"user_email\":\"" + "" + "\",\"user_mobile\":\"" + SmsStore.mobile + "\",\"user_adress\":\"" + "" + "\"}";
                        }
                        break;
                    case 4:
                        ContactUsQuestionMgr _ctactMgr = new ContactUsQuestionMgr(mySqlConnectionString);
                        DataTable _dt = _ctactMgr.GetUserInfo(related_id);
                        if (_dt.Rows.Count > 0)
                        {

                            json = "{success:true,\"user_id\":\"" + _dt.Rows[0]["user_id"] + "\",\"user_name\":\"" + _dt.Rows[0]["user_name"] + "\",\"user_email\":\"" + _dt.Rows[0]["user_email"] + "\",\"user_adress\":\"" + "" + "\"}";
                        }
                        break;
                    case 7://供應商詳情
                        VendorQuery _dtven = null;
                        if (urlType == "/Vendor/VendorBrandList")
                        {
                            VendorBrandSetMgr _IvendorBrandSet = new VendorBrandSetMgr(mySqlConnectionString);
                            VendorBrandSetQuery query = _IvendorBrandSet.GetModelById(related_id);
                            VendorMgr _vendorMgr = new VendorMgr(mySqlConnectionString);

                            _dtven = _vendorMgr.Query(new VendorQuery { vendor_id = query.vendor_id, IsPage = false }, ref totalCount).FirstOrDefault();
                            if (_dtven != null)
                            {
                                json = "{success:true,\"user_id\":\"" + "" + "\",\"user_name\":\"" + _dtven.vendor_name_full + "\",\"user_email\":\"" + "" + "\",\"user_phone\":\"" + "" + "\",\"user_adress\":\"" + "" + "\",\"simple_name\":\"" + _dtven.vendor_name_simple + "\"}";
                            }
                        }
                        else if (urlType == "/Vendor/VendorLoginList")
                        {
                            VendorLoginListMgr _Ivendorloginlist = new VendorLoginListMgr(mySqlConnectionString);

                            VendorLoginQuery query = _Ivendorloginlist.Query(new VendorLoginQuery { login_id = Convert.ToUInt32(related_id), IsPage = false }, out totalCount).FirstOrDefault();
                            VendorMgr _vendorMgr = new VendorMgr(mySqlConnectionString);

                            _dtven = _vendorMgr.Query(new VendorQuery { vendor_id = query.vendor_id, IsPage = false }, ref totalCount).FirstOrDefault();
                            if (_dtven != null)
                            {
                                json = "{success:true,\"user_id\":\"" + _dtven.vendor_code + "\",\"user_name\":\"" + _dtven.vendor_name_full + "\",\"user_email\":\"" + "" + "\",\"user_phone\":\"" + "" + "\",\"user_adress\":\"" + "" + "\",\"simple_name\":\"" + _dtven.vendor_name_simple + "\"}";
                            }
                        }
                        else
                        {
                            VendorMgr _vendorMgr = new VendorMgr(mySqlConnectionString);

                            _dtven = _vendorMgr.Query(new VendorQuery { vendor_id = Convert.ToUInt32(related_id), IsPage = false }, ref totalCount).FirstOrDefault();
                            if (_dtven != null)
                            {
                                json = "{success:true,\"user_id\":\"" + _dtven.vendor_code + "\",\"user_name\":\"" + _dtven.vendor_name_full + "\",\"user_email\":\"" + _dtven.vendor_email + "\",\"user_phone\":\"" + "" + "\",\"user_adress\":\"" + _dtven.vendor_company_address + "\",\"simple_name\":\"" + _dtven.vendor_name_simple + "\"}";
                            }

                        }

                        break;
                    case 9:
                        MailUserMgr _IMailUserMgr = new MailUserMgr(mySqlConnectionString);
                        DataTable _dtmu = _IMailUserMgr.GetUserInfo(related_id);
                        if (_dtmu.Rows.Count > 0)
                        {

                            json = "{success:true,\"user_id\":\"" + _dtmu.Rows[0]["user_id"] + "\",\"user_name\":\"" + _dtmu.Rows[0]["user_name"] + "\",\"user_email\":\"" + _dtmu.Rows[0]["user_email"] +  "\",\"user_adress\":\"" + _dtmu.Rows[0]["user_address"] + "\"}";                        }
                        break;
                    case 10:
                        PaperAnswerMgr _paperAnswerMgr = new PaperAnswerMgr(mySqlConnectionString);
                        PaperAnswer store = _paperAnswerMgr.GetPaperAnswerList(new PaperAnswer { answerID = related_id, IsPage = false }, out totalCount).FirstOrDefault();
                        if (store != null)
                        {
                            json = "{success:true,\"user_id\":\"" + store.userid + "\",\"user_name\":\"" + "" + "\",\"user_email\":\"" + store.userMail + "\",\"user_phone\":\"" + "" + "\",\"user_adress\":\"" + "" + "\"}";
                        }
                        break;
                    case 14://會員等級歷程
                        UserLevelLogMgr _userLevelLog = new UserLevelLogMgr(mySqlConnectionString);
                        //   UserLevelLogQuery store


                        UserLevelLogQuery levelStore = _userLevelLog.GetUserLevelLogList(new UserLevelLogQuery { user_id = Convert.ToUInt32(related_id), IsPage = false, isSecret = false }, out totalCount).FirstOrDefault();
                        if (levelStore != null)
                        {
                            json = "{success:true,\"user_id\":\"" + levelStore.user_id + "\",\"user_name\":\"" + levelStore.user_name + "\",\"user_email\":\"" + levelStore.user_email + "\"}";
                        }
                        break;
                    case 18://企業會員管理
                        _vipUserGroup = new VipUserGroupMgr(mySqlConnectionString);

                        VipUserGroupQuery vipStore = _vipUserGroup.GetVipUserGList(new VipUserGroupQuery { group_id = Convert.ToUInt32(related_id), IsPage = false, isSecret = false }, out totalCount).FirstOrDefault();
                        if (vipStore != null)
                        {
                            json = "{success:true,\"group_committe_chairman\":\"" + vipStore.group_committe_chairman + "\",\"group_committe_phone\":\"" + vipStore.group_committe_phone + "\",\"group_committe_mail\":\"" + vipStore.group_committe_mail + "\"}";
                        }
                        break;
                    case 19://商品點擊查詢
                        _IBrowseDataMgr = new BrowseDataMgr(mySqlConnectionString);
                        DataTable _dtBrowse = _IBrowseDataMgr.GetBrowseDataList(new BrowseDataQuery { id = related_id, IsPage = false, isSecret = false }, out totalCount);
                        string user_name = (_dtBrowse.Rows[0]["user_name"].ToString());
                        string user_id = (_dtBrowse.Rows[0]["user_id"].ToString());
                        json = "{success:true,\"user_name\":\"" + user_name + "\",\"user_id\":\"" + user_id + "\"}";
                        break;
                    case 22://聯合信用卡銀行卡號
                        _tabshow = new TabShowMgr(mySqlConnectionString);

                        //  OrderPaymentNcccQuery OPNQuery = new OrderPaymentNcccQuery();
                        OrderPaymentNcccQuery OPNQuery = _tabshow.GetNCCC(new OrderPaymentNcccQuery { nccc_id = (uint)related_id, IsPage = false, isSecret = false }, out totalCount).FirstOrDefault();
                        json = "{success:true,\"nccc_id\":\"" + OPNQuery.nccc_id + "\",\"nccc_pan\":\"" + OPNQuery.pan + "\",\"nccc_bankname\":\"" + OPNQuery.bankname + "\"}";
                        break;
                    case 23://退貨
                        _orderReturnStatus = new OrderReturnStatusMgr(mySqlConnectionString);

                        OrderMaster om = _orderReturnStatus.GetOrderInfo(Convert.ToUInt32(related_id));


                        json = "{success:true,\"orc_name\":\"" + om.Delivery_Name + "\",\"orc_mobile\":\"" + om.Delivery_Mobile + "\",\"orc_address\":\"" + om.Delivery_Address + "\"}";
                        break;

                }

            }
            catch (Exception ex)
            {
                Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
                logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
                logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
                log.Error(logMessage);
                json = "{success:false}";
            }
            this.Response.Clear();
            this.Response.Write(json);
            this.Response.End();
            return this.Response;
        }