public string QueryBig()
 {
     IZipImplMgr zMgr = new ZipMgr(connectionString);
     string json = string.Empty;
     try
     {
         json = zMgr.QueryBig(Request.Form["topValue"] ?? "");
     }
     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 = "[]";
     }
     return json;
 }
 //獲取地址
 public HttpResponseBase GetZip()
 {
     string json = string.Empty;
     DataTable store = new DataTable();
     zMgr = new ZipMgr(mySqlConnectionString);
     try
     {
         store = zMgr.GetZip();
         json = "{success:true,data:" + JsonConvert.SerializeObject(store) + "}";
     }
     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,data:[]}";
     }
     this.Response.Clear();
     this.Response.Write(json);
     this.Response.End();
     return this.Response;
 }
        public HttpResponseBase GetData()
        {
            uint orderId =0;
            if(uint.TryParse(Request.Params["order_id"],out orderId))
            {
                orderId = orderId;
            }
            OrderMasterQuery omQuery=new OrderMasterQuery ();
            OrderShowMasterQuery query = new OrderShowMasterQuery();
            string json = string.Empty;
            OrderShowMasterQuery store = new OrderShowMasterQuery();
            _orderMasterMgr = new OrderMasterMgr(mySqlConnectionString);
            zMgr = new ZipMgr(mySqlConnectionString);
            try
            {
                store = _orderMasterMgr.GetData(orderId);
                uint user_id =(uint)(Session["caller"] as Caller).user_id;
                if (_orderMasterMgr.VerifySession(user_id) > 0)
                {
                    store.is_manage_user = true;
                }
                else
                {
                    store.is_manage_user = false;
                }
                if (!string.IsNullOrEmpty(Request.Params["isSecret"]))
                {
                    if (Request.Params["isSecret"] == "false")
                    {
                        store.isSecret = false;
                    }
                    else
                    {
                        store.isSecret = true;
                    }

                }
                omQuery.Order_Id=orderId;
                store.is_send_product = _orderMasterMgr.IsSendProduct(omQuery);//true可以變更 false不可變更。
                store.is_vendor_deliver = _orderMasterMgr.IsVendorDeliver(orderId);
                store.OrderDatePay = CommonFunction.GetNetTime(store.order_date_pay);
                if (!string.IsNullOrEmpty(store.money_collect_date.ToString()) && store.money_collect_date != 0)
                {
                    store.MoneyCollectDate = CommonFunction.GetNetTime(store.money_collect_date);
                }
                store.NoteOrderModifyTime = CommonFunction.GetNetTime(store.note_order_modify_time);
                store.OrderCreateDate = CommonFunction.GetNetTime(store.order_createdate);
                store.OrderDateClose = CommonFunction.GetNetTime(store.order_date_close);
                double value = Convert.ToDouble(store.deduct_happygo * store.deduct_happygo_convert);
                store.Hg_Nt = Math.Round(value).ToString();
                //地址直接讀取
                store.order_address = zMgr.Getaddress(int.Parse(store.order_zip.ToString())) + store.order_address;
                store.delivery_address = zMgr.Getaddress(int.Parse(store.delivery_zip.ToString())) + store.delivery_address;
                if (store.isSecret)
                {
                    #region 添加資安的字段
                    if (store.order_name.Length > 1)
                    {
                        store.order_name = store.order_name.ToString().Substring(0, 1) + "**";
                    }
                    else
                    {
                        store.order_name = store.order_name.ToString() + "**";
                    }             
                    //if (store.order_mobile.Length > 1)
                    //{
                    //    store.order_mobile = store.order_mobile.ToString().Substring(0, 1) + "****";
                    //}
                    //else
                    //{
                    //    store.order_mobile = store.order_mobile.ToString() + "**";
                    //}
                    if (!string.IsNullOrEmpty(store.order_mobile))
                    {
                        if (!CommonFunction.isMobile(store.order_mobile))
                        {
                            if (store.order_mobile.ToString().Length == 48)
                            {
                                store.order_mobile = EncryptComputer.EncryptDecryptTextByApi(store.order_mobile, false);
                                if (!CommonFunction.isMobile(store.order_mobile))
                                {
                                    //異常記錄
                                    Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
                                    logMessage.Content = string.Format("表名:{0},訂單編號:{1},行動電話:{2},Message:{3}", "order_master", store.order_id, store.order_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}", "order_master", store.order_id, store.order_mobile, "訂購人行動電話錯誤");
                                logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
                                log.Error(logMessage);
                            }
                        }
                        if (store.order_mobile.ToString().Length > 3)
                        {
                            store.order_mobile = store.order_mobile.Substring(0, 3) + "***";
                        }
                        else
                        {
                            store.order_mobile = store.order_mobile + "***";
                        }
                    }
                    if (store.order_address.Length > 3)
                    {
                        store.order_address = store.order_address.ToString().Substring(0, 3) + "****";
                    }
                    else
                    {
                        store.order_address = store.order_address.ToString() + "**";
                    }
                    if (store.delivery_name.Length > 1)
                    {
                        store.delivery_name = store.delivery_name.ToString().Substring(0, 1) + "**";
                    }
                    else
                    {
                        store.delivery_name = store.delivery_name.ToString() + "**";
                    }

                    //if (store.delivery_mobile.Length > 1)
                    //{
                    //    store.delivery_mobile = store.delivery_mobile.ToString().Substring(0, 1) + "****";
                    //}
                    //else
                    //{
                    //    store.delivery_mobile = store.delivery_mobile.ToString() + "**";
                    //}
                    if (!string.IsNullOrEmpty(store.delivery_mobile))
                    {
                        if (!CommonFunction.isMobile(store.delivery_mobile))
                        {
                            if (store.delivery_mobile.ToString().Length == 48)
                            {
                                store.delivery_mobile = EncryptComputer.EncryptDecryptTextByApi(store.delivery_mobile, false);
                                if (!CommonFunction.isMobile(store.delivery_mobile))
                                {
                                    //異常記錄
                                    Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
                                    logMessage.Content = string.Format("表名:{0},訂單編號:{1},行動電話:{2},Message:{3}", "order_master", store.order_id, store.delivery_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}", "order_master", store.order_id, store.delivery_mobile, "收貨人行動電話錯誤");
                                logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
                                log.Error(logMessage);
                            }
                        }
                        if (store.delivery_mobile.ToString().Length > 3)
                        {
                            store.delivery_mobile = store.delivery_mobile.Substring(0, 3) + "***";
                        }
                        else
                        {
                            store.delivery_mobile = store.delivery_mobile + "***";
                        }
                    }
                    if (store.delivery_address.Length > 3)
                    {
                        store.delivery_address = store.delivery_address.ToString().Substring(0, 3) + "****";
                    }
                    else
                    {
                        store.delivery_address = store.delivery_address.ToString() + "**";
                    }
                    #endregion
                }
                IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
                timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
                json = "{success:true,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,data:[]}";
            }
            this.Response.Clear();
            this.Response.Write(json);
            this.Response.End();
            return this.Response;
        }
 public string QueryCityZip()
 {
     zMgr = new ZipMgr(mySqlConnectionString);
     string json = string.Empty;
     try
     {
         if (!string.IsNullOrEmpty(Request.Params["zipcode"]))
         {
             json = "{success:true,data:" + JsonConvert.SerializeObject(zMgr.QueryCityAndZip(Request.Params["zipcode"])) + "}";//返回json數據
         }
     }
     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 = "[]";
     }
     return json;
 }
        public string QueryZip()
        {
            zMgr = new ZipMgr(mySqlConnectionString);
            string json = string.Empty;
            try
            {
                if (!string.IsNullOrEmpty(Request.Form["topValue"]))
                {
                    json = zMgr.QuerySmall(Request.Form["topValue"].ToString(), Request.Form["topText"].ToString());
                }

            }
            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 = "[]";
            }
            return json;
        }
Example #6
0
        /*****************chaojie1124j********************/
        public HttpResponseBase GetZip()
        {
            Zip zip = new Zip();
            List<Zip> zipList = new List<Zip>();
            int resultzip = 0;
            if (!string.IsNullOrEmpty(Request.Params["big_code"]))
            {
                zip.bigcode = Request.Params["big_code"];
                resultzip = 1;
            }
            if (!string.IsNullOrEmpty(Request.Params["c_midcode"]))
            {
                zip.middlecode = Request.Params["c_midcode"];
                resultzip = 1;
            }
            if (!string.IsNullOrEmpty(Request.Params["c_zipcode"]))
            {
                zip.zipcode = Request.Params["c_zipcode"];
                resultzip = 1;
            }

            string jsonStr = string.Empty;
            try
            {
                zMgr = new ZipMgr(connectionString);
                zipList = zMgr.GetZipList(zip);
                if (zipList.Count > 0 && resultzip > 0)
                {
                    jsonStr = "{success:true,msg:\"" + zipList[0].big + "  " + zipList[0].middle + "  " + zipList[0].zipcode + "/" + zipList[0].small.Trim() + "\"}";
                }
                else
                {
                    jsonStr = "{success:true,msg:\"" + 100 + "\"}";
                }
            }
            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;
        }
Example #7
0
        public HttpResponseBase ExportVipListCsv()
        {
            string json = string.Empty;
            UserVipListQuery query = new UserVipListQuery();
            List<UserVipListQuery> stores = new List<UserVipListQuery>();
            try
            {
                if (!string.IsNullOrEmpty(Request.Params["dateOne"]))
                {
                    query.create_dateOne = (uint)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["dateOne"]).ToString("yyyy-MM-dd HH:mm:ss"));
                }
                if (!string.IsNullOrEmpty(Request.Params["dateTwo"]))
                {
                    query.create_dateTwo = (uint)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["dateTwo"]).ToString("yyyy-MM-dd HH:mm:ss"));
                }
                if (!string.IsNullOrEmpty(Request.Params["user_id"]))
                {
                    query.user_id = uint.Parse(Request.Params["user_id"]);
                }

                int totalCount = 0;
                query.IsPage = false;
                zMgr = new ZipMgr(mySqlConnectionString);
                usersMgr = new UsersMgr(mySqlConnectionString);
                stores = usersMgr.ExportVipListCsv(query, ref totalCount);
                DataTable _vipdt = usersMgr.IsVipUserId(0);
                DataTable newDt = new DataTable();
                newDt.Columns.Add("user_id", typeof(string));
                newDt.Columns.Add("user_status", typeof(string));
                newDt.Columns.Add("user_name", typeof(string));
                newDt.Columns.Add("user_gender", typeof(string));
                newDt.Columns.Add("VIP", typeof(string));
                // newDt.Columns.Add("user_email", typeof(string));
                newDt.Columns.Add("age", typeof(string));
                newDt.Columns.Add("user_birthday_month", typeof(string));
                // newDt.Columns.Add("user_address", typeof(string));
                newDt.Columns.Add("user_reg_date", typeof(string));//需要轉
                newDt.Columns.Add("order_createdate", typeof(string));//需要轉
                newDt.Columns.Add("last_time", typeof(string));//需要轉
                newDt.Columns.Add("sum_amount", typeof(string));
                newDt.Columns.Add("cou", typeof(string));
                newDt.Columns.Add("aver_amount", typeof(string));//計算得出
                newDt.Columns.Add("sum_bonus", typeof(string));
                newDt.Columns.Add("normal_product", typeof(string));
                newDt.Columns.Add("freight_normal", typeof(string));
                newDt.Columns.Add("low_product", typeof(string));
                newDt.Columns.Add("freight_low", typeof(string));
                newDt.Columns.Add("ct", typeof(string));
                newDt.Columns.Add("HG", typeof(string));
                newDt.Columns.Add("ht", typeof(string));
                newDt.Columns.Add("ml_code", typeof(string));
                //newDt.Columns.Add("order_product_subtotal", typeof(string));
                for (int i = 0; i < stores.Count; i++)
                {
                    DataRow newRow = newDt.NewRow();
                    newRow["user_id"] = stores[i].user_id;
                    //newRow["user_status"] = stores[i].user_status;
                    switch (stores[i].user_status)
                    {
                        case 0: newRow["user_status"] = "未啟用";
                            break;
                        case 1: newRow["user_status"] = "已啟用";
                            break;
                        case 2: newRow["user_status"] = "停用";
                            break;
                        case 5: newRow["user_status"] = "簡易會員";
                            break;
                    }
                    newRow["user_name"] = stores[i].user_name;
                    newRow["user_gender"] = stores[i].user_gender == 0 ? "小姐" : "先生";
                    newRow["VIP"] = "N";
                    for (int j = 0; j < _vipdt.Rows.Count; j++)
                    {
                        if (_vipdt.Rows[j]["user_id"] != null)
                        {
                            if (stores[i].user_id.ToString() == _vipdt.Rows[j]["user_id"].ToString())
                            {
                                newRow["VIP"] = "Y";
                                break;
                            }
                        }
                    }
                    //newRow["user_email"] = stores[i].user_email;
                    newRow["age"] = DateTime.Now.Year - stores[i].user_birthday_year;
                    newRow["user_birthday_month"] = stores[i].user_birthday_month;
                    //if (zMgr.QueryCityAndZip(stores[i].user_zip.ToString()) != null)
                    //{
                    //    newRow["user_address"] = zMgr.QueryCityAndZip(stores[i].user_zip.ToString()).middle + " " + zMgr.QueryCityAndZip(stores[i].user_zip.ToString()).small;
                    //}
                    //else
                    //{
                    //    newRow["user_address"] = "";
                    //}
                    newRow["user_reg_date"] = CommonFunction.DateTimeToString(CommonFunction.GetNetTime(stores[i].user_reg_date));
                    newRow["order_createdate"] = CommonFunction.DateTimeToString(CommonFunction.GetNetTime(stores[i].order_createdate));
                    newRow["last_time"] = newRow["order_createdate"];
                    //if (stores[i].last_time == Convert.ToUInt32(CommonFunction.GetPHPTime("1970-1-1 8:00")))
                    //{
                    //    newRow["last_time"] = "";
                    //}
                    //else
                    //{
                    //    newRow["last_time"] = CommonFunction.DateTimeToString(CommonFunction.GetNetTime(stores[i].last_time));
                    //}
                    newRow["sum_amount"] = stores[i].sum_amount;
                    newRow["cou"] = stores[i].cou;
                    decimal s = stores[i].sum_amount / stores[i].cou;
                    int sint = Convert.ToInt32(s);
                    newRow["aver_amount"] = s > sint ? sint + 1 : sint;
                    newRow["sum_bonus"] = stores[i].sum_bonus;
                    newRow["normal_product"] = stores[i].normal_product;
                    newRow["freight_normal"] = stores[i].freight_normal;
                    newRow["low_product"] = stores[i].low_product;
                    newRow["freight_low"] = stores[i].freight_low;
                    newRow["ct"] = stores[i].ct;
                    newRow["HG"] = stores[i].ct;
                    newRow["ht"] = stores[i].ht;
                    newRow["ml_code"] = stores[i].ml_code;
                    //newRow["order_product_subtotal"] = stores[i].order_product_subtotal;
                    newDt.Rows.Add(newRow);
                }
                // string[] columnName = { "編號", "會員狀態", "姓名", "性別", "VIP", "電子郵件", "年齡", "生日月份", "居住區", "註冊時間", "最近歸檔日", "最近購買日", "購買金額", "購買次數", "客單價", "購物金使用", "常溫商品總額", "常溫商品運費", "低溫商品總額", "低溫商品運費", "中信折抵", "HG折抵", "台新折抵" };
                string[] columnName = { "會員編號", "會員狀態", "姓名", "性別", "VIP", "年齡", "生日月份", "註冊時間", "最近歸檔日", "最近購買日", "購買金額", "購買次數", "客單價", "購物金使用", "常溫商品總額", "常溫商品運費", "低溫商品總額", "低溫商品運費", "中信折抵", "HG折抵", "台新折抵", "會員等級" };//, "近期累積金額" };

                string fileName = "Vip_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".csv";
                string newFileName = Server.MapPath(excelPath) + fileName;
                json = "{success:'true',filename:'" + fileName + "'}";
                CsvHelper.ExportDataTableToCsv(newDt, newFileName, columnName, true);
            }
            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;
        }
Example #8
0
        public HttpResponseBase SaveChannel()
        {
            zMgr = new ZipMgr(connectString);
            chMgr = new ChannelMgr(connectString);
            uMgr = new UsersMgr(connectString);

            string json = string.Empty;
            bool result = false;
            string channel_id = Request.Form["channel_id"] ?? string.Empty;
            try
            {
                if (!string.IsNullOrEmpty(Request.Form["channel_status"]))
                {
                    ch.channel_status = Int32.Parse(Request.Form["channel_status"].ToString());
                }

                if (!string.IsNullOrEmpty(Request.Form["channel_type"]))
                {
                    ch.channel_type = Int32.Parse(Request.Form["channel_type"].ToString());
                }

                if (!string.IsNullOrEmpty(Request.Form["channel_name_full"]))
                {
                    ch.channel_name_full = Request.Form["channel_name_full"].ToString();
                    u.user_name = Request.Form["channel_name_full"].ToString();
                    List<Channel> channel = chMgr.QueryC(" and channel_name_full='" + Request.Form["channel_name_full"] + "'");
                    if (channel != null && channel.Count > 0 && channel.Where(m => m.channel_id == int.Parse(string.IsNullOrEmpty(channel_id) ? "0" : channel_id)).Count() == 0)
                    {
                        json = "{success:true,msg:\""+Resources.Channel.CHANNEL_HAS_EXIST+"。\",channelId:\"" + channel_id + "\"}";

                        this.Response.Clear();
                        this.Response.Write(json);
                        this.Response.End();
                        return this.Response;
                    }
                }

                if (!string.IsNullOrEmpty(Request.Form["channel_name_simple"]))
                {
                    ch.channel_name_simple = Request.Form["channel_name_simple"].ToString();
                }

                if (!string.IsNullOrEmpty(Request.Form["channel_invoice"]))
                {
                    ch.channel_invoice = Request.Form["channel_invoice"].ToString();
                    u.user_password = Request.Form["channel_invoice"].ToString();
                }

                if (!string.IsNullOrEmpty(Request.Form["channel_email"]))
                {
                    ch.channel_email = Request.Form["channel_email"].ToString();
                }
                else
                {
                    ch.channel_email = "";
                }

                if (!string.IsNullOrEmpty(Request.Form["company_cphonenum"]))
                {
                    ch.company_phone = Request.Form["company_cphone"].ToString() +Request.Form["company_cphonenum"].ToString();
                }
                else
                {
                    ch.company_phone = "";
                }

                if (!string.IsNullOrEmpty(Request.Form["company_cfaxnum"]))
                {
                    ch.company_fax = Request.Form["company_cfax"].ToString() +Request.Form["company_cfaxnum"].ToString();
                }
                else
                {
                    ch.company_fax = "";
                }

                if (!string.IsNullOrEmpty(Request.Form["company_zip"]))
                {
                    ch.company_zip = Int32.Parse(Request.Form["company_zip"].ToString());
                }
                else
                {
                    ch.company_zip = 0;
                }

                if (!string.IsNullOrEmpty(Request.Form["company_address"]))
                {
                    ch.company_address = Request.Form["company_address"].ToString();
                }
                else
                {
                    ch.company_address = "";
                }

                if (!string.IsNullOrEmpty(Request.Form["invoice_title"]))
                {
                    ch.invoice_title = Request.Form["invoice_title"].ToString();
                }

                if (!string.IsNullOrEmpty(Request.Form["invoice_zip"]))
                {
                    ch.invoice_zip = Int32.Parse(Request.Form["invoice_zip"].ToString());
                }

                if (!string.IsNullOrEmpty(Request.Form["invoice_address"]))
                {
                    ch.invoice_address = Request.Form["invoice_address"].ToString();
                }

                if (!string.IsNullOrEmpty(Request.Form["contract_createdate"]))
                {
                    ch.contract_createdate = DateTime.Parse(Request.Form["contract_createdate"].ToString());
                }
                else
                {
                    ch.contract_createdate = DateTime.MinValue;
                }

                if (!string.IsNullOrEmpty(Request.Form["contract_start"]))
                {
                    ch.contract_start = DateTime.Parse(Request.Form["contract_start"].ToString());
                }
                else
                {
                    ch.contract_start = DateTime.MinValue;
                }

                if (!string.IsNullOrEmpty(Request.Form["contract_end"]))
                {
                    ch.contract_end = DateTime.Parse(Request.Form["contract_end"].ToString());
                }
                else
                {
                    ch.contract_end = DateTime.MinValue;
                }

                if (!string.IsNullOrEmpty(Request.Form["annaul_fee"]))
                {
                    ch.annaul_fee = Decimal.Parse(Request.Form["annaul_fee"].ToString());
                }
                else
                {
                    ch.annaul_fee = 0;
                }

                if (!string.IsNullOrEmpty(Request.Form["renew_fee"]))
                {
                    ch.renew_fee = Decimal.Parse(Request.Form["renew_fee"].ToString());
                }
                else
                {
                    ch.renew_fee = 0;
                }

                if (!string.IsNullOrEmpty(Request.Form["model_in"]))
                {
                    ch.model_in = Request.Form["model_in"].ToString();
                }
                else
                {
                    ch.model_in = "1";
                }

                if (!string.IsNullOrEmpty(Request.Form["notify_sms"]))
                {
                    ch.notify_sms = Int32.Parse(Request.Form["notify_sms"].ToString());
                }
                else
                {
                    ch.notify_sms = 0;
                }

                //add by xiangwang0413w 2014/06/26 增加 ERP客戶代號
                if (!string.IsNullOrEmpty(Request.Form["erp_id"]))
                {
                    ch.erp_id = Request.Form["erp_id"];
                }

                DataTable dtUsers = uMgr.Query(Request.Form["manager_Email"].ToString());
                if (dtUsers.Rows.Count > 0)//會員信箱已存在
                {
                    DataTable dtUserId = chMgr.QueryUser(dtUsers.Rows[0]["user_id"].ToString());
                    if (string.IsNullOrEmpty(channel_id))//新增
                    {                        
                        if (dtUserId.Rows.Count > 0)//是否被外站使用
                        {
                            json = "{success:true,msg:\""+Resources.Channel.MAIL_WAS_USED+"。\",channelId:\"" + channel_id + "\"}";

                            this.Response.Clear();
                            this.Response.Write(json);
                            this.Response.End();
                            return this.Response;
                        }
                        else
                        {
                            ch.user_id = Int32.Parse(dtUsers.Rows[0]["user_id"].ToString());
                            channel_id = chMgr.Save(ch).ToString();
                            result = Int32.Parse(channel_id) > 0;
                        }
                    }                    
                    else
                    {
                        //修改
                        if (dtUserId.Rows.Count > 0)
                        {
                            if (dtUserId.Rows[0]["channel_id"].ToString() != channel_id)
                            {
                                json = "{success:true,msg:\"" + Resources.Channel.MAIL_WAS_USED + "。\",channelId:\"" + channel_id + "\"}";

                                this.Response.Clear();
                                this.Response.Write(json);
                                this.Response.End();
                                return this.Response;
                            }
                            else
                            {
                                ch.user_id = Int32.Parse(dtUsers.Rows[0]["user_id"].ToString());
                            }
                        }
                        else
                        {
                            ch.user_id = Int32.Parse(dtUsers.Rows[0]["user_id"].ToString());
                        }

                        ch.channel_id = Int32.Parse(channel_id);

                        result = chMgr.Edit(ch) > 0;
                    }
                }
                else
                {
                    //會員信箱不存在
                    u.user_email = Request.Form["manager_Email"].ToString();
                    u.user_name = Request.Form["channel_name_full"].ToString();

                    BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt();
                    u.user_password = hash.SHA256Encrypt(Request.Form["invoice_title"].ToString());

                    u.user_mobile = "0227833183";
                    u.user_phone = "0227833183";
                    u.user_zip = 115;
                    u.user_address = Resources.Channel.USER_ADDRESS;
                    u.user_status = 1;
                    u.user_reg_date = (int)BLL.gigade.Common.CommonFunction.GetPHPTime();
                    u.user_updatedate = (int)BLL.gigade.Common.CommonFunction.GetPHPTime();
                    u.user_birthday_year = 1900;
                    u.user_birthday_month = 01;
                    u.user_birthday_day = 01;

                    if (uMgr.SelSaveID(u) > 0)
                    {
                        ch.user_id = Convert.ToInt32(u.user_id);
                    }
                    if (string.IsNullOrEmpty(channel_id))
                    {
                        channel_id=chMgr.Save(ch).ToString();
                        /**
                         *如果外站類型是gigade,則將參數表中type=deliver_store(即所有物流方式)全部插入channel_shipping表中
                         ***/
                        if (ch.channel_type == 2)
                        {
                            paraMgr = new ParameterMgr(connectString);
                            chsMgr = new ChannelShippingMgr(connectString);
                            List<Parametersrc> Deliver_result = paraMgr.QueryUsed(new Parametersrc { ParameterType = "deliver_store", Used = 1 });
                            foreach (Parametersrc item in Deliver_result)
                            {
                                chs.channel_id = int.Parse(channel_id);
                                chs.shipping_carrior = int.Parse(item.ParameterCode);
                                chs.shipco = item.parameterName;
                                chsMgr.Save(chs);
                            }

                        }
                        /*
                         end by zhongyu0304w at 2013/10/10
                         */
                        result = Int32.Parse(channel_id) > 0;
                    }
                    else
                    {
                        ch.channel_id = int.Parse(channel_id);
                        result = chMgr.Edit(ch) > 0;
                    }
                }

                
                if (result)
                {
                    
                    json = "{success:true,msg:\""+Resources.Channel.SUCCESS+"。\",channelId:\"" + channel_id + "\"}";
                }
                else
                {
                    json = "{success:true,msg:\""+Resources.Channel.FAILED+"\",channelId:\"" + channel_id + "\"}";
                }
            }
            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:true,msg:\"" + Resources.Channel.FAILED + "\",channelId:\"" + channel_id + "\"}";
            }

            this.Response.Clear();
            this.Response.Write(json);
            this.Response.End();
            return this.Response;
        }
Example #9
0
        public HttpResponseBase Import()
        {
            List<OrdersImport> all = (List<OrdersImport>)Session["import"] ?? null;
            int successCount = 0;
            int totalCount = 0;
            string json = string.Empty;
            try
            {
                if (all != null)
                {
                    if (!string.IsNullOrEmpty(Request.Form["Orders"]) && !string.IsNullOrEmpty(Request.Form["Files"]) && !string.IsNullOrEmpty(Request.Form["ImportType"]) && !string.IsNullOrEmpty(Request.Form["Channel"]))
                    {
                        string orders = Request.Form["Orders"];
                        int channel = Convert.ToInt32(Request.Form["Channel"]);
                        string improtType = Request.Form["ImportType"];
                        int site_id = int.Parse(Request.Form["site"]);//add xw
                        string files = Request.Form["Files"];

                        Resource.CoreMessage = new CoreResource("OrderImport");
                        orderImport = OrderImportFactory.InitOrderImport(channel);
                        if (orderImport != null)
                        {
                            string[] names = files.Split('|');
                            string execlFile = files.LastIndexOf("|") != -1 ? Server.MapPath(excelPath) + names[0] : Server.MapPath(excelPath) + files;
                            string pdfFile = files.LastIndexOf("|") != -1 && names.Length == 3 ? names[2] : "";

                            //修改 Excel 表裏面的地址  add by zhuoqin0830w  2015/04/17
                            for (int i = 0; i < all.Count; i++)
                            {
                                zMgr = new ZipMgr(connectionString);
                                if (!string.IsNullOrEmpty(all[i].agpesadrzip))
                                {
                                    string small = zMgr.QueryCityAndZip(all[i].agpesadrzip).small;
                                    int index = all[i].agpesadr.IndexOf(small);
                                    if (index != -1)
                                    {
                                        string newAddress = all[i].agpesadr.Substring(index + small.Length);
                                        all[i].agpesadr = newAddress;
                                    }
                                }
                            }

                            successCount = orderImport.Import2DB(all, pdfFile, improtType, orders, site_id, ref totalCount);
                            if (successCount > 0)
                            {
                                ImportOrdersLog log = new ImportOrdersLog { Channel_Id = channel, TCount = totalCount, Success_Count = successCount };
                                log.File_Name = names[1];
                                log.Import_Date = DateTime.Now;
                                log.Exec_Name = (Session["caller"] as Caller).user_username;

                                importOrdersLogMgr = new ImportOrdersLogMgr(connectionString);
                                importOrdersLogMgr.Save(log);
                            }
                        }
                    }
                    all.FindAll(m => m.IsSel).ForEach(m => m.IsSel = false);
                    Session["import"] = all;
                }
            }
            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 = "{Total:" + totalCount + ",SucccessCount:" + successCount + ",Orders:" + JsonConvert.SerializeObject(all) + "}";
            this.Response.Clear();
            this.Response.Write(json);
            this.Response.End();
            return this.Response;
        }
        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;
        }
Example #11
0
        public Model.Custom.TableChangeLogCustom GetVendorChangeDetail(TableChangeLogQuery query)
        {
            try
            {
                DataTable _dt = _tclDao.GetVendorChangeDetail(query);
                Model.Custom.TableChangeLogCustom _model = new Model.Custom.TableChangeLogCustom();
                if (_dt.Rows.Count > 0)
                {
                    Dao.ParametersrcDao _pDao = new Dao.ParametersrcDao(connStr);
                    List<Model.Parametersrc> _pModel = _pDao.Query(new Model.Parametersrc { ParameterType = "ColumnChange", ParameterCode = "vendor" });
                    List<Model.Parametersrc> _slist = _pDao.QueryParametersrcByTypes("vendor_type");
                    if (_pModel.Count > 0)
                    {
                        _model.vendor_id = Convert.ToInt32(_dt.Rows[0]["vendor_id"].ToString());
                        _model.vendor_name_full = _dt.Rows[0]["vendor_name_full"].ToString();
                        List<Model.TableChangeLog> _list = new List<Model.TableChangeLog>();
                        foreach (DataRow dr in _dt.Rows)
                        {
                            Model.TableChangeLog _log = new Model.TableChangeLog();
                            _log.change_field = dr["change_field"].ToString();
                            if (_log.change_field == "vendor_status")
                            {
                                string[] status_str = { "", "啟用", "停用", "失格" };

                                _log.old_value = status_str[Convert.ToInt32(dr["old_value"].ToString())].ToString();
                                _log.new_value = status_str[Convert.ToInt32(dr["new_value"].ToString())].ToString();


                            }
                            else if (_log.change_field == "product_manage")
                            {

                                ManageUserMgr mu = new ManageUserMgr(connStr);
                                List<ManageUser> o_mlist = mu.GetManageUser(new ManageUser { user_id = Convert.ToUInt32(dr["old_value"].ToString()) });
                                List<ManageUser> n_mlist = mu.GetManageUser(new ManageUser { user_id = Convert.ToUInt32(dr["new_value"].ToString()) });
                                if (o_mlist.Count > 0)
                                {
                                    _log.old_value = o_mlist[0].user_username;
                                }
                                if (n_mlist.Count > 0)
                                {
                                    _log.new_value = n_mlist[0].user_username;
                                }
                            }
                            else if (_log.change_field.IndexOf("contact_type") > -1)
                            {
                                string[] type_str = { "", "負責人", "業務窗口", "圖/文窗口", "出貨負責窗口", "帳務連絡窗口", "客服窗口", "刪除" };

                                _log.old_value = type_str[Convert.ToInt32(dr["old_value"].ToString())].ToString();
                                if (dr["new_value"].ToString() != "")
                                {
                                    _log.new_value = type_str[Convert.ToInt32(dr["new_value"].ToString())].ToString();
                                }
                                else
                                {
                                    _log.new_value = type_str[0].ToString();
                                }
                            }
                            else if (_log.change_field == "vendor_type")//供應商類型
                            {
                                if (_slist.Count > 0)
                                {
                                    var a_o = dr["old_value"].ToString().Split(',');
                                    var a_n = dr["new_value"].ToString().Split(',');
                                    string l_o = ""; string l_n = "";
                                    for (int i = 0; i < a_o.Length; i++)
                                    {
                                        if (!string.IsNullOrEmpty(a_o[i].ToString()))
                                        {
                                            l_o = l_o + _slist.Find(m => m.ParameterCode == a_o[i].ToString()).parameterName + ",";
                                        }
                                    }
                                    for (int i = 0; i < a_n.Length; i++)
                                    {
                                        if (!string.IsNullOrEmpty(a_n[i].ToString()))
                                        {
                                            l_n = l_n + _slist.Find(m => m.ParameterCode == a_n[i].ToString()).parameterName + ",";

                                        }
                                    }
                                    _log.old_value = l_o.TrimEnd(',');
                                    _log.new_value = l_n.TrimEnd(',');
                                }
                            }
                            else if (_log.change_field == "company_address" || _log.change_field == "invoice_address")//公司地址或發票地址
                            {
                                string o_zip = dr["old_value"].ToString().Split('&')[0];
                                string o_adress = dr["old_value"].ToString().Substring(dr["old_value"].ToString().IndexOf('&') + 1);
                                string n_zip = dr["new_value"].ToString().Split('&')[0];
                                string n_adress = dr["new_value"].ToString().Substring(dr["new_value"].ToString().IndexOf('&') + 1);
                                ZipMgr zip = new ZipMgr(connStr);
                                _log.old_value = zip.Getaddress(Convert.ToInt32(o_zip)) + o_adress;
                                _log.new_value = zip.Getaddress(Convert.ToInt32(n_zip)) + n_adress;
                            }
                            else
                            {
                                _log.old_value = dr["old_value"].ToString();
                                _log.new_value = dr["new_value"].ToString();
                            }
                            if (!string.IsNullOrEmpty(dr["field_ch_name"].ToString()))
                            {
                                _log.field_ch_name = dr["field_ch_name"].ToString();
                            }
                            else
                            {
                                _log.field_ch_name = _pModel.Find(m => m.parameterName == _log.change_field).remark;
                            }

                            _list.Add(_log);

                        }
                        _model.tclModel = _list;
                    }
                }
                return _model;
            }
            catch (Exception ex)
            {
                throw new Exception("TableChangeLogMgr-->GetVendorChangeDetail-->" + ex.Message, ex);
            }
        }