using System;
using System.Collections;
using
System.ComponentModel;
using System.Data;
using System.Drawing;
using
System.Web;
using System.Web.SessionState;
using System.Web.UI;
using
System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using
System.Data.SqlClient;
namespace localhost.模版后台管理
{
 ///
<summary>
 /// SkinManage 的摘要说明。
 /// </summary>
 public
class SkinManage : System.Web.UI.Page
 {
  protected
System.Web.UI.WebControls.Button BtnSelectAll;
  protected
System.Web.UI.WebControls.Button BtnDel;
  protected
System.Web.UI.WebControls.Button BtnSubmit;
  protected
System.Web.UI.WebControls.CheckBox CheckBoxSelectAll;
  protected
System.Web.UI.WebControls.DataGrid DataGrid2;
  protected bool
selected=false;
 
  private void Page_Load(object sender, System.EventArgs
e)
  {
   // 在此处放置用户代码以初始化页面
   // 在此处放置用户代码以初始化页面
   SqlConnection
Conn;
   Conn=new
SqlConnection("server=localhost;database=Skin;uid=sa;pwd=''");
   Conn.Open();   
   SqlDataAdapter
da=new SqlDataAdapter("select Id,Skin_name from SkinBin",Conn);
   DataSet
ds=new
DataSet();
   da.Fill(ds,"skin");
   da.Fill(ds,"skinall");
//   show_string=ds.Tables["skin"].Rows[0][0].ToString();   
   DataGrid2.DataSource=ds.Tables["skinall"].DefaultView;
   DataGrid2.DataBind();
  }
  #region Web 窗体设计器生成的代码
  override protected void OnInit(EventArgs
e)
  {
   //
   // CODEGEN: 该调用是 ASP.NET Web
窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  
  ///
<summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  ///
</summary>
  private void InitializeComponent()
  {   
   this.DataGrid2.DeleteCommand += new
System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid2_DeleteCommand);
   this.BtnSelectAll.Click
+= new
System.EventHandler(this.BtnSelectAll_Click);
   this.CheckBoxSelectAll.CheckedChanged
+= new
System.EventHandler(this.CheckBoxSelectAll_CheckedChanged);
   this.Load +=
new System.EventHandler(this.Page_Load);
  }
  #endregion
  private void DataGrid2_DeleteCommand(object source,
System.Web.UI.WebControls.DataGridCommandEventArgs
e)
  {
   try
   {
    SqlConnection Conn;
    Conn=new
SqlConnection("server=localhost;database=Skin;uid=sa;pwd=''");
    Conn.Open();
    string
Id="";
    Id=e.Item.Cells[2].Text;
    SqlCommand Comm=new
SqlCommand("update SkinBin set IsDefault=1 where
Id="+Id,Conn);
    Comm.ExecuteNonQuery();
   }
   catch
   {
   }
   Response.Write("<script>alert('模版已更改,请查看用户界面');</script>");
}
  private void BtnSelectAll_Click(object sender, System.EventArgs
e)
  { 
   
//   for (int i = 0; i < GridView1.Rows.Count;
i++)//从第一一行循环至结束,一次更新所有的成绩
//   {        
//    GridViewRow row =
GridView1.Rows[i];//定义grideviewrow
//    c.成绩
=Convert.ToDecimal(((TextBox)row.Cells[0].FindControl("TextBox1")).Text);//将TextBox1中输入的字符串转化为Decimal型
//    c.课程号
= GridView1.DataKeys[i].Values[0].ToString();
//    c.学号 =
GridView1.DataKeys[i].Values[1].ToString();
//    if
(ChafenBOLActions.UpdateScore(c) == 1)
//    { Label1.Text = "更新成功";
}
//    else
//    {
//     break;//更新不成功,跳出
//    }
//          
//   }
   int ct=0;
   if(IsPostBack)
   {
    
    bool
b;
    ArrayList ar=new ArrayList();
    for(int
i=0;i<DataGrid2.Items.Count;i++)
    { 
     b=((CheckBox)DataGrid2.Items[i].FindControl("CheckBoxSelect")).Checked;
     if
(b)
     {
      ct++;
     }
    }
    
   }
   Response.Write(ct);
  }
  private void CheckBoxSelectAll_CheckedChanged(object sender,
System.EventArgs e)
  { 
   
//   selected=!selected;
   for(int
i=0;i<DataGrid2.Items.Count;i++)
   {     
    ((CheckBox)DataGrid2.Items[i].FindControl("CheckBoxSelect")).Checked=
CheckBoxSelectAll.Checked;
   }
  }
 
  
 }
}
 
                    
                     
                    
                 
                    
                 
 
                
            
         
         浙公网安备 33010602011771号
浙公网安备 33010602011771号