user_update.aspx.cs

网博Fms在线直播系统 本程序基于fms2.0为核心的实时直播系统

using System;
using System.Text;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace admin
{
	/// <summary>
	/// User_UpDate 的摘要说明。
	/// </summary>
    public partial class User_UpDate : Sp.baseadmin
	{
        public string EndTime = "";
		protected　override void Page_Load(object sender, System.EventArgs e)
        {
            base.Page_Load(sender,e);

			if (!Page.IsPostBack)
			{
				if (Request.QueryString["Uid"]!=null)
				{
				  ShowInfo(int.Parse(Request.QueryString["Uid"]));
				}
			}// 在此处放置用户代码以初始化页面
		}
		private void ShowInfo(int ID)
		{
            string sql = "SELECT *,(select idname from sp_user where id=b.ParentId) as Parentidname  FROM Sp_user b where id='" + ID + "'";
            DataTable dt = Sp.Base.ExecuteSql4Ds(sql).Tables[0];
            DataRow dr = dt.Rows[0];
            this.txtidname.Text = dr["idname"].ToString();
            this.txtusername.Text = dr["username"].ToString();
            this.txtzhuangtai.Text = dr["zhuangtai"].ToString() == "True" ? "正常" : "停止";
            TextBox1.Text = dr["EndTime"].ToString();

		}
		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    

		}
		#endregion

		protected void Button1_Click(object sender, System.EventArgs e)
		{
            Update();
            /******************************增加修改代码********************************/
            //string strErr = "";

       
            //if (strErr != "")
            //{
            //    MessageBox.Show(this, strErr);
            //    return;
            //}

            //Sp.Model.Sp_user model = new Sp.Model.Sp_user();
            //model.id = int.Parse(Request.QueryString["uid"]);
            //model.username = username;
            //model.gufen = gufen;
            //model.pay = pay;
            //Sp.BLL.Sp_user bll = new Sp.BLL.Sp_user();
            //bll.UpdateUser(model);
            MessageBox.Show(this.Page, "修改成功!");
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update()
        {
            int id = int.Parse(Request.QueryString["uid"]);
            string username = this.txtusername.Text;
            DateTime EndTime = DateTime.Parse(TextBox1.Text);

            StringBuilder strSql = new StringBuilder();
            strSql.Append("update Sp_user set ");
            strSql.Append("username=@username,");
            strSql.Append("EndTime=@EndTime");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters = {
					new SqlParameter("@id", SqlDbType.Int,4),
					new SqlParameter("@username", SqlDbType.VarChar,50),
					new SqlParameter("@EndTime", SqlDbType.DateTime)};
            parameters[0].Value = id;
            parameters[1].Value = username;
            parameters[2].Value = EndTime;

           Sp.SQLServerDAL.DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
           ShowInfo(int.Parse(Request.QueryString["Uid"]));
        }

        protected void Button1_Click1(object sender, EventArgs e)
        {

        }
}
}