Example #1
0
        protected void saveBtn_Click(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                int intId = Int32.Parse(Request.QueryString["intId"]);
                Base sa = new Base();
                String sql;
                string content1;
                content1 = content.Value;

                sql = "update JOLE_webSite set content = @content where Id =" + intId;
                String[,] ds = new String[1, 4];
                ds[0, 0] = "@content";          //参数
                ds[0, 1] = content1;             //内容
                ds[0, 2] = "2";                 //类型
                ds[0, 3] = "4000";              //大小

                sa.ExecutePrem(sql, ds);
                showMessage("修改成功",Request.UrlReferrer.ToString());

            }
            else
            {
                Response.Write("操作错误。");
                Response.End();
            }

        }
Example #2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Base re = new Base();

                webName.Text = re.getSite(1);

                linkMan.Text = re.getSite(4);

                email.Text = re.getSite(5);

                telphone.Text = re.getSite(6);

                mobile.Text = re.getSite(7);

                fax.Value = re.getSite(8);

                bankName.Value = re.getSite(9);

                bankNumber.Value = re.getSite(10);

                address.Value = re.getSite(11);

                qq.Value = re.getSite(51);

                msn.Value = re.getSite(13);

                zhifubao.Value = re.getSite(14);

                webKeyword.Value = re.getSite(15);

                lawName.Value = re.getSite(16);

                icp.Value = re.getSite(2);

                webNum.Value = re.getSite(3);
                wangwang.Value = re.getSite(48);

                webPath.Value = WEBPATH;
                //dr.Clone;
                //rs.Close;

            }

        }
Example #3
0
        public void setInfo(int id,string str)
        {

            Base sd = new Base();
            string sql = "update JOLE_webSite set content = @content where id = @id";
            string [,] ds = new string[2,4];
            ds[1, 0] = "@id";
            ds[1, 1] = id.ToString();
            ds[1, 2] = "1";
            ds[1, 3] = "4";

            ds[0, 0] = "@content";          //参数
            ds[0, 1] = str;                 //内容
            ds[0, 2] = "2";                 //类型
            ds[0, 3] = "4000";              //大小

            sd.ExecutePrem(sql,ds);

        }
Example #4
0
        /// <summary>
        ///  JOLE_webSite表操作
        /// </summary>
        public string getSite(int id)
        {
            try
            {
                OleDbDataReader rs1 = new Base().Record1("select content from JOLE_webSite where id =" + id);
                if (rs1.Read())
                {
                    string str;
                    str = rs1.GetValue(0).ToString();
                    rs1.Close();
                    return str;
                }
                else
                    return "0";
            }
            catch (NullReferenceException e)
            {

                Console.WriteLine(e.Message+"操作错误");
                return "操作错误";

            }
            finally
            {
                Console.WriteLine("清理");
            }

        }