1using System;
  2using System.Text;
  3using System.Collections;
  4using System.ComponentModel;
  5using System.Data;
  6using System.Data.SqlClient;
  7using System.Drawing;
  8using System.Web;
  9using System.Web.SessionState;
 10using System.Web.UI;
 11using System.Web.UI.WebControls;
 12using System.Web.UI.HtmlControls;
 13
 14namespace admin
 15...{
 16    /**//// <summary>
 17    /// User_UpDate 的摘要说明。
 18    /// </summary>
 19    public partial class User_UpDate : Sp.baseadmin
 20    ...{
 21        public string EndTime = "";
 22        protected　override void Page_Load(object sender, System.EventArgs e)
 23        ...{
 24            base.Page_Load(sender,e);
 25
 26            if (!Page.IsPostBack)
 27            ...{
 28                if (Request.QueryString["Uid"]!=null)
 29                ...{
 30                  ShowInfo(int.Parse(Request.QueryString["Uid"]));
 31                }
 32            }// 在此处放置用户代码以初始化页面
 33        }
 34        private void ShowInfo(int ID)
 35        ...{
 36            string sql = "SELECT *,(select idname from sp_user where id=b.ParentId) as Parentidname  FROM Sp_user b where id='" + ID + "'";
 37            DataTable dt = Sp.Base.ExecuteSql4Ds(sql).Tables[0];
 38            DataRow dr = dt.Rows[0];
 39            this.txtidname.Text = dr["idname"].ToString();
 40            this.txtusername.Text = dr["username"].ToString();
 41            this.txtzhuangtai.Text = dr["zhuangtai"].ToString() == "True" ? "正常" : "停止";
 42            TextBox1.Text = dr["EndTime"].ToString();
 43
 44        }
 45        Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
 46        override protected void OnInit(EventArgs e)
 47        ...{
 48            //
 49            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
 50            //
 51            InitializeComponent();
 52            base.OnInit(e);
 53        }
 54        
 55        /**//// <summary>
 56        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 57        /// 此方法的内容。
 58        /// </summary>
 59        private void InitializeComponent()
 60        ...{    
 61
 62        }
 63        #endregion
 64
 65        protected void Button1_Click(object sender, System.EventArgs e)
 66        ...{
 67            Update();
 68            /**//******************************增加修改代码********************************/
 69            //string strErr = "";
 70
 71       
 72            //if (strErr != "")
 73            //{
 74            //    MessageBox.Show(this, strErr);
 75            //    return;
 76            //}
 77
 78            //Sp.Model.Sp_user model = new Sp.Model.Sp_user();
 79            //model.id = int.Parse(Request.QueryString["uid"]);
 80            //model.username = username;
 81            //model.gufen = gufen;
 82            //model.pay = pay;
 83            //Sp.BLL.Sp_user bll = new Sp.BLL.Sp_user();
 84            //bll.UpdateUser(model);
 85            MessageBox.Show(this.Page, "修改成功!");
 86        }
 87        /**//// <summary>
 88        /// 更新一条数据
 89        /// </summary>
 90        public void Update()
 91        ...{
 92            int id = int.Parse(Request.QueryString["uid"]);
 93            string username = this.txtusername.Text;
 94            DateTime EndTime = DateTime.Parse(TextBox1.Text);
 95
 96            StringBuilder strSql = new StringBuilder();
 97            strSql.Append("update Sp_user set ");
 98            strSql.Append("username=@username,");
 99            strSql.Append("EndTime=@EndTime");
100            strSql.Append(" where id=@id");
101            SqlParameter[] parameters = ...{
102                    new SqlParameter("@id", SqlDbType.Int,4),
103                    new SqlParameter("@username", SqlDbType.VarChar,50),
104                    new SqlParameter("@EndTime", SqlDbType.DateTime)};
105            parameters[0].Value = id;
106            parameters[1].Value = username;
107            parameters[2].Value = EndTime;
108
109           Sp.SQLServerDAL.DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
110           ShowInfo(int.Parse(Request.QueryString["Uid"]));
111        }
112
113        protected void Button1_Click1(object sender, EventArgs e)
114        ...{
115
116        }
117}
118}
119