示例#1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["userid"] == null)
            {
                Response.Redirect("Login.aspx");
                return;
            }
            string shopid = Session["userid"].ToString();

            var shopinfo = new ShopInfoDb().getShopinfo(int.Parse(shopid));

            if (shopinfo.ShopNum == "123456")
            {
                shopinfo.ShopNum = "90002";
            }
            //
            var list = new CarDetialInfoDb().GetCarLIst(shopinfo.ShopNum);

            if (catTypeList == null)
            {
                catTypeList = new CarTypeInfoDb().GetAllCarType();
            }

            repCarlist.DataSource = list;
            repCarlist.DataBind();
        }
示例#2
0
        public void ProcessRequest(HttpContext context)
        {
            var type = context.Request["type"];
            var dbid = context.Request["id"];
            var retstr = "";
            int id, ii;

            int.TryParse(dbid, out id);
            context.Response.ContentType = "text/plain";
            switch (type)
            {
            case "chkuser":
                if (id <= 0)
                {
                    break;
                }
                var sdb = new ShopInfoDb().getShopinfo(id);
                ii     = new ShopInfoDb().ExecSql("update ShopInfo set start=1");
                retstr = ii > 0 ? "{\"ret\":\"OK\" }" : "{\"ret\":\"NO\" }";
                break;

            case "deluser":
                var op = new ShopInfoDb().DeleteData(id);
                retstr = op == true ? "{\"ret\":\"OK\" }": "{\"ret\":\"NO\" }";
                break;
            }
            context.Response.Write(retstr);
        }
示例#3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string username = Request.Form["username"];
            string pwd      = Request.Form["password"];

            if (string.IsNullOrEmpty(username) && string.IsNullOrEmpty(username))
            {
                return;
            }


            int number;



            if (!int.TryParse(username, out number))
            {
                msg = "您输入的编号有误";
                return;
            }

            var shopitem = new ShopInfoDb().Login(username, pwd);

            if (shopitem == null)
            {
                msg = "用户名或密码错误";
                return;
            }

            Session["userid"] = shopitem.Id;

            Response.Redirect("Search.aspx");
        }
示例#4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string username = Request.Form["username"];
            string pwd      = Request.Form["password"];

            Session["userid"]  = null;
            Session["ShopNum"] = null;

            if (Request.QueryString["url"] != null)
            {
                backurl = Request.QueryString["url"];
            }


            if (string.IsNullOrEmpty(username) && string.IsNullOrEmpty(username))
            {
                return;
            }

            int number;

            if (!int.TryParse(username, out number))
            {
                msg = "您输入的编号有误";
                return;
            }

            var shopitem = new ShopInfoDb().Login(username, pwd);

            if (shopitem == null)
            {
                msg = "用户名或密码错误";
                return;
            }
            if (shopitem.start == 0)
            {
                msg = "帐号待审核请联系客服";
                return;
            }

            Session["userid"]  = shopitem.Id;
            Session["ShopNum"] = shopitem.ShopNum;

            if (Request.Form["url"] != null && Request.Form["url"] != "")
            {
                Response.Redirect(Request.Form["url"]);
            }
            else
            {
                Response.Redirect("Searchs.aspx");
            }
        }
示例#5
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string id = "0";

            if (Session["userid"] != null)
            {
                id = Session["userid"].ToString();
            }
            int idd = 0;

            int.TryParse(id, out idd);
            var sdb = new ShopInfoDb();

            shop = sdb.getShopinfo(idd);
            if (shop == null)
            {
                shop = new ShopInfo();
            }
            if (!Page.IsPostBack)
            {
                string username = "", opwd = "", pwd, pwd1;
                if (Request.RequestType.ToUpper() == "POST")
                {
                    opwd = Request["oldpwd"];
                    pwd  = Request["pwd"];
                    pwd1 = Request["pwd1"];
                    if (pwd != pwd1)
                    {
                        ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>输入密码错误!</td></tr>"; //"请刷新页面";
                        return;
                    }
                    if (!RegexServer.regIsMatch(pwd, "^[A-Za-z0-9]+${6,10}"))
                    {
                        ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>登录密码必须是6-10位</td></tr>"; //"请刷新页面";
                        return;
                    }
                    if (shop.ShopPwd == opwd)
                    {
                        shop.ShopPwd = pwd;
                        sdb.UpdateData(shop);
                        ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>密码个性成功</td></tr>"; //"请刷新页面";
                    }
                    else
                    {
                        ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>请输入登录密码</td></tr>"; //"请刷新页面";
                    }
                }
            }
        }
示例#6
0
        private void loadShopImg()
        {
            var       list        = new ShopInfoDb().GetAllShopinfo();
            WebClient myWebClient = new WebClient();
            string    path        = Server.MapPath("/");

            foreach (var item in list)
            {
                string file1 = "http://www.912sc.com/" + item.IdCart.TrimStart('/');
                string file2 = "http://www.912sc.com/" + item.BusinessLicense.TrimStart('/');



                string newfile  = path + item.IdCart.TrimStart('/').Replace("/", "\\");
                string newfile2 = path + item.BusinessLicense.TrimStart('/').Replace("/", "\\");
                if (File.Exists(newfile))
                {
                    continue;
                }
                try
                {
                    myWebClient.DownloadFile(file1, newfile);
                }
                catch (Exception ex)
                {
                    LogServer.WriteLog(ex.Message + "item" + item.Id + "\t" + file1);
                }
                try
                {
                    myWebClient.DownloadFile(file2, newfile2);
                }
                catch (Exception ex)
                {
                    LogServer.WriteLog(ex.Message + "item" + item.Id + "\t" + file2);
                }
            }
        }
示例#7
0
        private void DataBing()
        {
            int    currentPage = 0;
            string key         = "";

            if (Request.QueryString["pageid"] != null)
            {
                int.TryParse(Request.QueryString["pageid"].ToString(), out currentPage);
            }
            string query = "";

            if (Request.QueryString["key"] != null)
            {
                key     = HttpUtility.HtmlDecode(Request.QueryString["key"]);
                keyword = key;
                query   = "&key=" + HttpUtility.UrlEncode(key);
            }

            string cartype = "";

            if (Request.QueryString["cartype"] != null)
            {
                cartype = Request.QueryString["cartype"];
                query   = "&cartype=" + cartype;
            }

            if (currentPage <= 0)
            {
                currentPage = 1;
            }


            int    totalCount = 0, totalpage;
            string shopid = Session["userid"].ToString();

            var shopinfo = new ShopInfoDb().getShopinfo(int.Parse(shopid));

            // IEnumerable<CarDetialInfo> querys = new CarDetialInfoDb().GetCarLIst(shopinfo.ShopNum);
            string where = " 1=1 and";
            if (!string.IsNullOrEmpty(key))
            {
                where = $" ProTitle like '%{key}%' and";
            }
            if (!string.IsNullOrEmpty(cartype))
            {
                where = $"CarType = '{cartype}' and";
            }
            var list = new CarDetialInfoDb().Exec($"where {where} SellerNumber='{shopinfo.ShopNum}'", currentPage, 10, "id", 1, out totalCount, out totalpage);//   t(shopinfo.ShopNum);


            int pagesize = 10;
            int index    = (currentPage - 1) * pagesize;

            list = list.Skip(index).Take(pagesize).ToList();
            string url = "UserCarList.aspx";

            if (catTypeList == null)
            {
                catTypeList = new CarTypeInfoDb().GetAllCarType();
            }

            //  int totalpage = totalCount / pagesize;
            //if (totalCount % pagesize > 0)
            //    totalpage = totalpage + 1;
            string syyurl = url;
            string xyyurl = url;
            string wyurl  = url + "?pageid=" + ((currentPage + 1) > totalpage ? totalpage:(currentPage + 1)) + query;

            if (currentPage > 1)
            {
                syyurl = url + "?pageid=" + ((currentPage - 1) < 1?1:(currentPage - 1)) + query;
                if (currentPage < totalpage)
                {
                    xyyurl = url + "?pageid=" + totalpage + query;
                }
            }
            else
            {
                if (currentPage < totalpage)
                {
                    xyyurl = url + "?pageid=" + totalpage + query;
                }
            }

            pagenum = string.Format("共{0}条&nbsp;&nbsp;{1}/{5}页&nbsp;&nbsp;<a href=\"UserCarList.aspx?/" + url + "\">首页</a>&nbsp;&nbsp;<a href='{2}'>上一页</a>&nbsp;&nbsp;<a href='{3}'>下一页</a>&nbsp;&nbsp;<a href='{4}'>尾页</a>&nbsp;&nbsp; ", totalCount, currentPage, syyurl, xyyurl, wyurl, totalpage);

            repCarlist.DataSource = list;
            repCarlist.DataBind();
        }
示例#8
0
        private void addCar(int id = 0)
        {
            ///static/carImg/load
            var p_sort      = Request.Form["p_sort"];
            var p_brand     = Request.Form["p_brand"];
            var p_brandName = "";
            var probrand    = new BandInfoDb().getBrandByKey(p_brand);

            if (probrand != null)
            {
                p_brandName = probrand.BrandName;
            }

            var p_name    = HttpUtility.UrlDecode(Request.Form["p_name"]);
            var uptype    = Request.Form["uptype"];
            var pic       = Request.Form["imgs"];
            var piclist   = pic.Split(',');
            var priallimg = "";

            foreach (var tempimg in piclist)
            {
                priallimg = priallimg + string.Format("/carimg/small/{0}.jpg;", pic);
            }

            var mainpic             = Request.Form["p_mainpic"];
            var p_color             = Request.Form["p_color"];
            var p_price             = Request.Form["p_price"];
            var isfixprice          = Request.Form["isfixprice"];
            var p_year              = Request.Form["p_year"];
            var p_month             = Request.Form["p_month"];
            var p_kilometre         = Request.Form["p_kilometre"];
            var p_gas               = Request.Form["p_gas"];
            var p_country           = Request.Form["p_country"];
            var p_transmission      = Request.Form["p_transmission"];
            var p_emissionstandards = Request.Form["p_emissionstandards"];
            var p_fuel              = Request.Form["p_fuel"];
            var p_details           = Request.Form["p_details"];
            var p_img               = Request.Form[""];
            var ac = Request.Form["ac"];

            var    pstate       = Request.Form["pstate"];
            var    page         = Request.Form["page"];
            var    subbrand2    = Request.Form["p_subbrand"];
            string subbrandName = "";
            var    prosubbrand  = new BandInfoDb().getBrandByKey(subbrand2);

            if (prosubbrand != null)
            {
                subbrandName = prosubbrand.BrandName;
            }


            CarDetialInfo pro = new CarDetialInfo();

            pro.Id              = id;
            pro.CarType         = p_sort;
            pro.BrandInfo       = p_brandName;
            pro.BrandInfoKey    = p_brand;
            pro.BrandType       = subbrandName;
            pro.BrandTypeKey    = subbrand2;
            pro.OtherParam      = p_name;
            pro.ShangPaiTime    = p_year + "-" + p_month;
            pro.ShangPaiYear    = int.Parse(p_year);
            pro.ShangPaiMonth   = int.Parse(p_month);
            pro.Images          = priallimg;
            pro.mianimg         = mainpic;
            pro.baojia          = decimal.Parse(p_price);
            pro.CarColor        = p_color;
            pro.LiCheng         = p_kilometre;
            pro.PaiLiang        = p_gas;
            pro.country         = p_country;
            pro.BianShuQi       = p_transmission;
            pro.RanYou          = p_fuel;
            pro.Remark          = p_details;
            pro.ProTitle        = pro.BrandInfo + " " + pro.BrandType + " " + pro.OtherParam;
            pro.PaiFangBiaoZhun = p_emissionstandards;
            if (Session["userid"] == null)
            {
                Response.Redirect("Login.aspx");
                return;
            }
            string shopid = Session["userid"].ToString();

            var shopinfo = new ShopInfoDb().getShopinfo(int.Parse(shopid));

            if (shopid != null)
            {
                pro.SellerName     = shopinfo.CompanyName;
                pro.SellerNumber   = shopinfo.ShopNum;
                pro.SellerPhone    = shopinfo.PhoneNumber;
                pro.CarSellAddress = shopinfo.CompanyAddress;
            }


            new CarDetialInfoDb().AddCarinfo(pro);
            Response.Redirect("UserCarList.aspx");
        }
示例#9
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string id = "0";

            if (Session["userid"] != null)
            {
                id = Session["userid"].ToString();
            }
            int idd = 0;

            int.TryParse(id, out idd);
            var sdb = new ShopInfoDb();

            shop = sdb.getShopinfo(idd);
            if (shop == null)
            {
                shop = new ShopInfo();
            }
            if (!Page.IsPostBack)
            {
                if (idd == 0)
                {
                    ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>没有对应的数据,不能修改</td></tr>"; //"请刷新页面";
                    return;
                }
                if (Request.RequestType.ToUpper() == "POST")
                {
                    //var IdCart = Request.Form["userCompany"];
                    //if (!string.IsNullOrEmpty(IdCart))
                    //{
                    //    shop.IdCart = IdCart;
                    //}
                    shop.PhoneNumber = Request.Form["phoneNum"];
                    if (string.IsNullOrEmpty(shop.PhoneNumber))
                    {
                        ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>请输入手机号码</td></tr>"; //"请刷新页面";
                        return;
                    }
                    float phonenum = 0;
                    if (shop.PhoneNumber.Length != 11 || !float.TryParse(shop.PhoneNumber, out phonenum))
                    {
                        ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>您输入的手机号码有误</td></tr>"; //"请刷新页面";
                        return;
                    }

                    //var BusinessLicense = Request.Form["CompanyLisent"];
                    //if (!string.IsNullOrEmpty(BusinessLicense))
                    //{
                    //    shop.BusinessLicense = BusinessLicense;
                    //}

                    shop.CompanyName = Request.Form["companyName"];
                    if (string.IsNullOrEmpty(shop.CompanyName))
                    {
                        ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>请输入公司名称</td></tr>"; //"请刷新页面";
                        return;
                    }

                    shop.ShopNum = Request.Form["netNumber"];
                    if (string.IsNullOrEmpty(shop.ShopNum))
                    {
                        ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>请输入公司名称短号</td></tr>"; //"请刷新页面";
                        return;
                    }

                    shop.PhoneShopNum = Request.Form["phoneNumber"];

                    if (string.IsNullOrEmpty(shop.PhoneShopNum))
                    {
                        ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>请输入公司名称短码</td></tr>"; //"请刷新页面";
                        return;
                    }
                    //^[A-Za-z0-9]+$
                    new ShopInfoDb().UpdateData(shop);
                    ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>您的数据已提交成功</td></tr>"; //"请刷新页面";
                }
            }
        }
示例#10
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Request.Form["companyName"] == null)
            {
                return;
            }

            string validCode = Request.Form["code"];

            if (Session["validCode"] == null)
            {
                ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>验证码已过期,请刷新页面重试</td></tr>"; //"请刷新页面";
                return;
            }
            if (Session["validCode"].ToString() != validCode)
            {
                ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>您输入的验证码有误,请重试</td></tr>"; //"请刷新页面";
                return;
            }

            ShopInfo shop = new ShopInfo();

            shop.IdCart = Request.Form["userCompany"];
            if (string.IsNullOrEmpty(shop.IdCart))
            {
                ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>请上传身份证</td></tr>"; //"请刷新页面";
                return;
            }
            shop.PhoneNumber = Request.Form["phoneNum"];
            if (string.IsNullOrEmpty(shop.PhoneNumber))
            {
                ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>请输入手机号码</td></tr>"; //"请刷新页面";
                return;
            }
            float phonenum = 0;

            if (shop.PhoneNumber.Length != 11 || !float.TryParse(shop.PhoneNumber, out phonenum))
            {
                ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>您输入的手机号码有误</td></tr>"; //"请刷新页面";
                return;
            }

            shop.BusinessLicense = Request.Form["CompanyLisent"];
            if (string.IsNullOrEmpty(shop.BusinessLicense))
            {
                ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>请上传营业执照</td></tr>"; //"请刷新页面";
                return;
            }

            shop.CompanyName = Request.Form["companyName"];
            if (string.IsNullOrEmpty(shop.CompanyName))
            {
                ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>请输入公司名称</td></tr>"; //"请刷新页面";
                return;
            }

            shop.ShopNum = Request.Form["netNumber"];
            int tempnum = 0;

            if (string.IsNullOrEmpty(shop.ShopNum) || !int.TryParse(shop.ShopNum, out tempnum))
            {
                ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>请输入短号</td></tr>"; //"请刷新页面";
                return;
            }

            if (shop.ShopNum.Length != 5)
            {
                ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>短号为5位纯数学</td></tr>"; //"请刷新页面";
                return;
            }


            var tempshopinfo = new ShopInfoDb().GetShopinfo(shop.ShopNum);

            if (tempshopinfo != null)
            {
                ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>此短号已被注册</td></tr>"; //"请刷新页面";
                return;
            }

            shop.ShopPwd = Request.Form["pwd"];

            if (!RegexServer.regIsMatch(shop.ShopPwd, "^[A-Za-z0-9]+${6,10}"))
            {
                ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>请输入登录密码</td></tr>"; //"请刷新页面";
                return;
            }
            //^[A-Za-z0-9]+$

            new ShopInfoDb().AddShopInfo(shop);

            ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>您的数据已提交成功</td></tr>"; //"请刷新页面";

            Response.Redirect("regsuccess.aspx");
            return;
        }
示例#11
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string id = "0";

            if (Session["userid"] != null)
            {
                id = Session["userid"].ToString();
            }
            int idd = 0;

            int.TryParse(id, out idd);
            var sdb = new ShopInfoDb();

            shop = sdb.getShopinfo(idd);
            if (shop == null)
            {
                shop = new ShopInfo();
            }
            if (!Page.IsPostBack)
            {
                if (idd == 0)
                {
                    ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>没有对应的数据,不能修改</td></tr>"; //"请刷新页面";
                    return;
                }
                if (Request.RequestType.ToUpper() == "POST")
                {
                    //var IdCart = Request.Form["userCompany"];
                    //if (!string.IsNullOrEmpty(IdCart))
                    //{
                    //    shop.IdCart = IdCart;
                    //}
                    shop.PhoneNumber = Request.Form["phoneNum"];
                    if (string.IsNullOrEmpty(shop.PhoneNumber))
                    {
                        ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>请输入手机号码</td></tr>"; //"请刷新页面";
                        return;
                    }
                    float phonenum = 0;
                    if (shop.PhoneNumber.Length != 11 || !float.TryParse(shop.PhoneNumber, out phonenum))
                    {
                        ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>您输入的手机号码有误</td></tr>"; //"请刷新页面";
                        return;
                    }

                    //var BusinessLicense = Request.Form["CompanyLisent"];
                    //if (!string.IsNullOrEmpty(BusinessLicense))
                    //{
                    //    shop.BusinessLicense = BusinessLicense;
                    //}

                    shop.CompanyName = Request.Form["companyName"];
                    if (string.IsNullOrEmpty(shop.CompanyName))
                    {
                        ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>请输入公司名称</td></tr>"; //"请刷新页面";
                        return;
                    }
                    shop.CompanyAddress = Request.Form["CompanyAddress"];
                    if (string.IsNullOrEmpty(shop.CompanyAddress))
                    {
                        ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>请输入公司地址</td></tr>"; //"请刷新页面";
                        return;
                    }

                    //shop.ShopNum = Request.Form["netNumber"];
                    //if (string.IsNullOrEmpty(shop.ShopNum))
                    //{
                    //    ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>请输入公司名称短号</td></tr>"; //"请刷新页面";
                    //    return;
                    //}

                    var shortnum = Request.Form["phoneNumber"];

                    if (string.IsNullOrEmpty(shortnum))
                    {
                        ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>请输入公司名称短码</td></tr>"; //"请刷新页面";
                        return;
                    }

                    var numlist = shortnum.Replace("、", " ").Replace(",", " ").Replace(";", " ").Replace(",", " ").Replace(";", " ").Split(' ');

                    List <string> resultnum = new List <string>();

                    foreach (var item in numlist)
                    {
                        var tempitem = item.Trim(' ');
                        if (tempitem == "" || tempitem.Length < 3)
                        {
                            continue;
                        }
                        int tempnum;
                        if (int.TryParse(tempitem, out tempnum))
                        {
                            resultnum.Add(tempitem);
                        }
                    }

                    var PhoneShopNum = string.Join(" ", resultnum);

                    if (string.IsNullOrEmpty(PhoneShopNum))
                    {
                        ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>请输入公司名称短码</td></tr>"; //"请刷新页面";
                        return;
                    }

                    if (shop.PhoneShopNum != PhoneShopNum)
                    {
                        shop.PhoneShopNum = PhoneShopNum;
                        new CarDetialInfoDb().UpdateCarinfoByShopnum(shop.PhoneShopNum, shop.ShopNum);
                    }

                    //^[A-Za-z0-9]+$

                    new ShopInfoDb().UpdateData(shop);
                    //  new CarDetialInfoDb().ExecSql("update CarDetialInfo set ProNum='" + shop.PhoneShopNum + "' where SellerNumber='" + shop.ShopNum + "' and  pronum is NULL ");
                    ErrorMsg = "<tr><td width=\'80\' height=\'40\' align=\'right\'></td><td style=\'color:red;\'>您的数据已提交成功</td></tr>"; //"请刷新页面";
                }
            }
        }