예제 #1
0
 private string proxyAccount(string content, string[] arr, Func<string, string> msgRet, string authId)
 {
     if (!online(authId))
     {
         return msgRet("请登录");
     }
     Regex g = new Regex("开代理\\s\\d{11}\\s\\w{2,5}\\s\\d");
     if (g.IsMatch(content))
     {
         using (busyManDataContext busy = new busyManDataContext(conStr))
         {
             var f = busy.HCTLoginUser.FirstOrDefault(p => p.Account > 888800001 && p.UserState == 1);
             f.Name = arr[2];
             f.Phone = arr[1];
             f.UserState = int.Parse(arr[3]);
             busy.SubmitChanges();
             return
                 msgRet(
                     string.Format("{0} {1} {2} {3}", f.Name, f.Phone, f.Account,
                         f.Password));
         }
     }
     else
     {
         return msgRet("格式:开代理 电话 姓名 0:使用1:测试");
     }
 }
예제 #2
0
 private string searchAccount(string[] arr, Func<string, string> msgRet, string authId)
 {
     if (!online(authId))
     {
         return msgRet("请登录");
     }
     string aaa = arr[1];
     Regex accountReg = new Regex("100\\d{3}");
     Regex phoneReg = new Regex("1\\d{10}");
     Regex nameReg = new Regex("[u4e00-u9fa5]+");
     Regex valueReg = new Regex("\\d+");
     using (busyManDataContext context = new busyManDataContext(conStr))
     {
         if (arr.Length != 2)
         {
             return msgRet("查帐号 店铺号/手机号/店铺名/客户姓名");
         }
         StringBuilder sblog = new StringBuilder();
         context.Log = new StringWriter(sblog);
         bool notaccount = !accountReg.IsMatch(aaa);
         bool notphone = !phoneReg.IsMatch(aaa);
         bool isvalue = valueReg.IsMatch(aaa);
         bool notname = isvalue;
         var s = (from p in context.HCTShop
                  where (notaccount || p.Number.ToString() == aaa)
                        && (notphone || p.ShopkeeperPhone == aaa)
                        && (notname || SqlMethods.Like(p.ShopName, "%" + aaa + "%"))
                  orderby p.Number
                  select p).Take(10).ToList();
         if (s.Count == 0)
             return msgRet("没有信息");
         StringBuilder sb = new StringBuilder("账号 姓名 电话 城市 区域 商场 楼层 店铺名\r\n");
         foreach (var v in s)
         {
             sb.AppendFormat("{0} {1} {2} {3} {4} {5} {6} {7}\r\n", v.Number,
                 v.ShopkeeperName, v.ShopkeeperPhone, v.AddrCity, v.AddrDistrict,
                 v.AddrMarket, v.AddrFloor, v.ShopName);
         }
         context.Log.Flush();
         //StringBuilder sb = new StringBuilder();
         // HCTShop v = context.HCTShop.SingleOrDefault(p => p.Number.ToString() == aaa);
         // sb.AppendFormat("{0} {1} {2} {3} {4} {5} {6} {7}\r\n", v.Number,
         //         v.ShopkeeperName, v.ShopkeeperPhone, v.AddrCity, v.AddrDistrict,
         //         v.AddrMarket, v.AddrFloor, v.ShopName);
         WriteLog("[SQL] ", sblog.ToString());
         return msgRet(sb.ToString());
     }
 }
예제 #3
0
        private string modifyAccountInfo(string[] arr, Func<string, string> msgRet, string authId)
        {
            if (!online(authId))
            {
                return msgRet("请登录");
            }
            if (arr.Length != 9)
            {
                return msgRet("账号 姓名 电话 城市 区域 商场 楼层 店铺名");
            }
            int id = int.Parse(arr[1]);
            string name = arr[2];
            string phone = arr[3];
            string city = arr[4];
            string dis = arr[5];
            string market = arr[6];
            string floor = arr[7];
            string shopName = arr[8];
            using (busyManDataContext context = new busyManDataContext(conStr))
            {

                var shop = context.HCTShop.SingleOrDefault(p => p.Number == id);
                var account = context.HCTLoginUser.SingleOrDefault(p => p.Account == id);
                if (shop != null && account != null)
                {
                    shop.ShopkeeperName = name;
                    shop.ShopkeeperPhone = phone;
                    shop.AddrCity = city;
                    shop.AddrMarket = market;
                    shop.AddrDistrict = dis;
                    shop.AddrFloor = floor;
                    shop.ShopName = shopName;
                    shop.CompanyName = shopName;
                    WriteLog("modifyAccountInfoBAK", string.Format("{0},{1},{2},{3},{4},{5},{6},{7}", shop.Number, shop.ShopkeeperName, shop.ShopkeeperPhone, shop.AddrCity, shop.AddrDistrict, shop.AddrMarket, shop.AddrFloor, shop.ShopName));
                    var cmp = context.HCTCompany.SingleOrDefault(
                        p => p.CompanyNumber == shop.CompanyNumber);
                    cmp.CompanyName = shopName;
                    cmp.CompanyPhone = phone;
                    account.Name = name;
                    account.Phone = phone;
                    account.UserState = 0;
                    account.Address = city + dis + market + floor;
                    context.SubmitChanges();
                    WriteLog("modifyAccountInfo", string.Format("{0},{1},{2},{3},{4},{5},{6},{7}", arr[1], arr[2], arr[3], arr[4], arr[5], arr[6], arr[7], arr[8]));
                    return msgRet(string.Format("{0} {1} {2}", shop.Number, shop.ShopName, account.Password));
                }
                else
                {
                    return msgRet("店铺信息错误");
                }
            }
        }