程序博客网 > 数据库设计三大模式

用来增加要评选的老师的个人情况 CS

来源：互联网 发布：数据库设计三大模式 编辑：程序博客网 时间：2024/04/29 20:38

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.Configuration;
using System.Text;
using System.Data.SqlClient;
using System.IO;

namespace JMEDUWEB
{
 /// <summary>
 /// zTeachAdd 的摘要说明。
 /// 用来增加要评选的老师的个人情况
 /// </summary>
 public class zTeachAdd : System.Web.UI.Page
 {
  private DataFactory.DBOperator DBO=DataFactory.DBOperator .Instance (ConfigurationSettings.AppSettings["ConnString"]);
  protected System.Web.UI.WebControls.ImageButton del;
  protected System.Web.UI.WebControls.ImageButton overcheck;
  protected System.Web.UI.WebControls.ImageButton recheck;
  protected System.Web.UI.WebControls.Button AddTeachersBtn;
  protected System.Web.UI.WebControls.TextBox txtgroup;
  protected System.Web.UI.WebControls.TextBox txttid;
  protected System.Web.UI.WebControls.TextBox txttname;
  protected System.Web.UI.WebControls.TextBox txttschool;
  protected System.Web.UI.WebControls.TextBox txtturl;
  protected System.Web.UI.WebControls.TextBox txtids;
  protected System.Web.UI.WebControls.Button EditTeachBtn;
 
  protected System.Web.UI.WebControls.DataGrid DataGrid0;
 
  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   if(!Page.IsPostBack)
   {
    if (Session["userNamezTeacher"]==null)
    {
     //Response.End();
    }
    bendData1();

   }
  }

  #region Web 窗体设计器生成的代码
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {   
   this.DataGrid0.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid0_PageIndexChanged);
   this.DataGrid0.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid0_ItemDataBound);
   this.del.Click += new System.Web.UI.ImageClickEventHandler(this.del_Click);
   this.overcheck.Click += new System.Web.UI.ImageClickEventHandler(this.overcheck_Click);
   this.AddTeachersBtn.Click += new System.EventHandler(this.AddTeachersBtn_Click);
   this.EditTeachBtn.Click += new System.EventHandler(this.EditTeachBtn_Click);
   this.Load += new System.EventHandler(this.Page_Load);

  }
  #endregion

  private void bendData1()
  {
   DBO.Open ();
   if(1==1)
   {
    //DataTable dt=DBO.DBDataTable ("select * from article where channel='"+channel.Value.ToString().Trim()+"' and checked='1' order by SubjectId,ArticleSendDate");
    DataTable dt=DBO.DBDataTable ("SELECT * FROM zTeachVote");
     
    //select top 20 * from article where type='"+"index"+"' and checked='1' order by articleType,s_datetime desc");
    int iend=dt.Rows.Count==0?13:(dt.Rows.Count<13?(13-dt.Rows.Count):(dt.Rows.Count % 13==0?0:13-(dt.Rows.Count % 13)));
    int intLastPgReCount0=13-iend; //记录DataGrid0最后一页的记录数
    for (int i=1 ;i<=iend;i++)
    {
     System.Data.DataRow re=dt.NewRow();
     dt.Rows.Add(re);
    }
    DataGrid0.DataSource=dt; 
    DataGrid0.DataBind ();
   }
  }

  private void DataGrid0_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
  {
   DataGrid0.CurrentPageIndex=e.NewPageIndex;
   bendData1();
  }

  private void DataGrid0_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
  {
   string strItemType=e.Item.ItemType.ToString();
   if(e.Item.ItemType == ListItemType.Header)    //DataGrid的头部加载javascript事件
   {
    //CheckBox chk = (CheckBox)e.Item.FindControl("chkAll0");
    //chk.Attributes.Add("onclick","javascript:return SelectAll(this.checked,this.id);");//全选
    
   }
   else if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)//DataGrid的内容项加载javascript事件
   {  
    CheckBox chk = (CheckBox)e.Item.FindControl("chkSelect0");
    //chk.Attributes.Add("onclick","javascript:return SelectAll(this.checked,this.id),chkNO(this.checked,this.id);");
    chk.Attributes.Add("onclick","javascript:return SelectAll(this.checked,this.id),chkNO(this.checked,this.id);");
    e.Item.Attributes.Add("onmouseover","aa(this,'move')"); //焦点变色
    e.Item.Attributes.Add("onmouseout","aa(this,'over')");  //取回原色
    e.Item.Attributes.Add("class","dg");        //列表内容CSS 样色
    if(1==1)
    {
     //获取文章相对路径e.Item .Cells [3].Text为URL值
     //     if(Convert.ToString(DataBinder.Eval(e.Item.DataItem,"IsOutLink"))=="1")//转向外部连接
     //     {
     //      e.Item .Cells [2].Text ="<a href='"+e.Item .Cells [3].Text+"' target =_blank ><img src='images/dot_y.gif' border =0 align =absmiddle> "+e.Item .Cells [2].Text+"</a>";
     //     }
     //     else//内部连接
     //     {
     //      e.Item .Cells [2].Text ="<a href='"+"index"+"/"+e.Item .Cells [3].Text+"' target =_blank ><img src='images/dot_y.gif' border =0 align =absmiddle> "+e.Item .Cells [2].Text+"</a>";
     //     }
     string KEYVALUE=e.Item.Cells[4].Text.ToString().Trim();      //获取文章栏目的标识SubjectId
     //DataTable dt_keyname=DBO.DBDataTable("select * from ArticleSubject where SubjectId='"+KEYVALUE+"' and ChannelChar='"+channel.Value.ToString().Trim()+"'" );
     //     DataTable dt_keyname=DBO.DBDataTable("select top 50 * from dic where keyvalue='"+KEYVALUE+"' and keyid='"+"index"+"'" );
     //     if (dt_keyname.Rows.Count>0)
     //     {
     //      //string article_name=dt_keyname.Rows[0]["SubjectName"].ToString().Trim(); //子栏目表识
     //      string article_name=dt_keyname.Rows[0]["keyname"].ToString().Trim(); //子栏目表识
     //      e.Item.Cells[5].Text=article_name;          //在DataGrid上显示文章的类型
     //     }
     //     DBO.Open();
     //     //System.Data.SqlClient.SqlDataReader dr_username=(SqlDataReader)DBO2.ObjDataRead("select 用户名称 from 用户表 where 用户编号='"+e.Item .Cells [7].Text.ToString().Trim()+"'");
     //     System.Data.SqlClient.SqlDataReader dr_username=(SqlDataReader)DBO.ObjDataRead("select username,department from userinfo where userid='"+e.Item .Cells [7].Text.ToString().Trim()+"'");
     //     if(dr_username.Read())
     //     {
     //      //Channel_Name.Text=dr_name["ChannelName"].ToString();
     //      //Subject_Name.Text=dr_name[1].ToString();
     //      //e.Item.Cells[7].Text=dr_username["用户名称"].ToString().Trim();
     //      //e.Item.Cells[7].Text=dr_username["username"].ToString().Trim();
     //      e.Item.Cells[7].Text="<p title='"+dr_username["department"].ToString().Trim()+"' style='CURSOR: hand'>"+dr_username["username"].ToString().Trim()+"</p>";
     //     }
     //     dr_username.Close();
     DBO.Close();
     //e.Item.Cells[8].Text="<span class='check' onClick=EditArticle('0','"+e.Item.Cells[0].Text+"')>编辑</span>";
     //DataTable dt=DBO.DBDataTable ("select * from article where channel='"+channel.Value.ToString().Trim()+"' and checked='1'");
     DataTable dt=DBO.DBDataTable ("SELECT * FROM zTeachVote");
      //select * from article where type='"+"index"+"' and checked='1'");
     int countid=e.Item.ItemIndex;
     int iend=dt.Rows.Count==0?13:(dt.Rows.Count<13?(13-dt.Rows.Count):(dt.Rows.Count % 13==0?0:13-(dt.Rows.Count % 13)));//填的空行条数
     int dtcount=dt.Rows.Count;
     int int_index=13-iend;//删除绑定按钮的开始行数

     int rowid=countid+1;
     //DataGrid0.Items[i].Cells [0].Text

     e.Item.Cells[6].Text="<span class='check' onClick=EditArticleMe('1','"+rowid+"','"+e.Item.Cells[0].Text+"')>编辑</span>";
   
     if(DataGrid0.CurrentPageIndex==DataGrid0.PageCount-1)//当是DataGrid最后一页时
     {
      if(int_index>0&e.Item.ItemIndex>=int_index)//从第int_index开始删除所添加空行内的多余内容
      {
       e.Item .Cells [1].Text ="";
       e.Item .Cells [2].Text ="";
       //e.Item .Cells [8].Text ="";
       e.Item .Cells [6].Text ="";
      }
     }
    
     if(DataGrid0.CurrentPageIndex==0&dt.Rows.Count==0)//当DataGrid没有数据时
     {
      e.Item .Cells [1].Text ="";
      e.Item .Cells [2].Text ="";
      //e.Item .Cells [8].Text ="";
     }
    }
    else  //不会执行的
    {
     //获取文章相对路径e.Item .Cells [3].Text为URL值
     if(Convert.ToString(DataBinder.Eval(e.Item.DataItem,"IsOutLink"))=="1")//转向外部连接
     {
      e.Item .Cells [2].Text ="<a href='"+e.Item .Cells [3].Text+"' target =_blank ><img src='images/dot_y.gif' border =0 align =absmiddle> "+e.Item .Cells [2].Text+"</a>";
     }
     else   //内部连接
     {
      e.Item .Cells [2].Text ="<a href='"+"index"+"/"+e.Item .Cells [3].Text+"' target =_blank ><img src='images/dot_y.gif' border =0 align =absmiddle> "+e.Item .Cells [2].Text+"</a>";
     }
     //e.Item .Cells [2].Text ="<a href='"+channel.Value.ToString().Trim()+"/"+e.Item .Cells [3].Text+"' target =_blank><img src='images/dot_y.gif' border =0 align =absmiddle> "+e.Item .Cells [2].Text+"</a>";
     string KEYVALUE=e.Item.Cells[4].Text.ToString().Trim();      //获取文章栏目的标识SubjectId
     //DataTable dt_keyname=DBO.DBDataTable("select * from ArticleSubject where SubjectId='"+KEYVALUE+"' and ChannelChar='"+channel.Value.ToString().Trim()+"'" );
     DataTable dt_keyname=DBO.DBDataTable("select * from dic where keyvalue='"+KEYVALUE+"' and keyid='"+"index"+"'" );
     if (dt_keyname.Rows.Count>0)
     {
      //string article_name=dt_keyname.Rows[0]["SubjectName"].ToString().Trim(); //子栏目表识
      string article_name=dt_keyname.Rows[0]["keyname"].ToString().Trim(); //子栏目表识
      e.Item.Cells[5].Text=article_name;          //在DataGrid上显示文章的类型
     }
     ////////////////////////
     /////////////////
     //////////
     DBO.Open();
     //System.Data.SqlClient.SqlDataReader dr_username=(SqlDataReader)DBO2.ObjDataRead("select 用户名称 from 用户表 where 用户编号='"+e.Item .Cells [7].Text.ToString().Trim()+"'");
//     System.Data.SqlClient.SqlDataReader dr_username=(SqlDataReader)DBO.ObjDataRead("select username,department from userinfo where userid='"+e.Item .Cells [7].Text.ToString().Trim()+"'");
//     if(dr_username.Read())
//     {
//      //Channel_Name.Text=dr_name["ChannelName"].ToString();
//      //Subject_Name.Text=dr_name[1].ToString();
//      //e.Item.Cells[7].Text=dr_username["用户名称"].ToString().Trim();
//      //e.Item.Cells[7].Text=dr_username["username"].ToString().Trim();
//      e.Item.Cells[7].Text="<p title='"+dr_username["department"].ToString().Trim()+"' style='CURSOR: hand'>"+dr_username["username"].ToString().Trim()+"</p>";
//     }
//     dr_username.Close();
//     DBO.Close();
     //e.Item.Cells[8].Text="<span class='check' onClick=EditArticle('0','"+e.Item.Cells[0].Text+"')>编辑</span>";
     //DataTable dt=DBO.DBDataTable ("select * from article where channel='"+channel.Value.ToString().Trim()+"' and SubjectId='"+aType.Items[aType.SelectedIndex].Value.ToString().Trim()+"' and checked='1'");
     DataTable dt=DBO.DBDataTable ("select * from article where type='"+"index"+"' and articleType='"+"1"+"' and checked='1'");
     int countid=e.Item.ItemIndex;
     int iend=dt.Rows.Count==0?13:(dt.Rows.Count<13?(13-dt.Rows.Count):(dt.Rows.Count % 13==0?0:13-(dt.Rows.Count % 13)));//填的空行条数
     int dtcount=dt.Rows.Count;
     int int_index=13-iend;//删除绑定按钮的开始行数
     if(DataGrid0.CurrentPageIndex==DataGrid0.PageCount-1)//当是DataGrid最后一页时
     {
      if(int_index>0&e.Item.ItemIndex>=int_index)
      {
       e.Item .Cells [1].Text ="";
       e.Item .Cells [2].Text ="";
       e.Item .Cells [8].Text ="";
      }
     }
     if(DataGrid0.CurrentPageIndex==0&dt.Rows.Count==0)//当DataGrid没有数据时
     {
      e.Item .Cells [1].Text ="";
      e.Item .Cells [2].Text ="";
      e.Item .Cells [8].Text ="";
     }
    }
   }
  }

  private void AddTeachersBtn_Click(object sender, System.EventArgs e)
  {
   String str="INSERT INTO zTeachVote (tgroup, tid, tname, tschool, turl) VALUES ('"+txtgroup.Text.Trim()+"',"+
    txttid.Text.Trim()+",'"+txttname.Text.Trim()+"','"+txttschool.Text.Trim()+"','"+txtturl.Text.Trim()+"')";
   DBO.Open();
   Response.Write(str);
   DBO.ExecuteNonQuery(str);
   //"update article set checked='0' where id='"+articleid.Value.ToString().Trim()+"'");
   DBO.Close();
   bendData1();
  }

  private void overcheck_Click(object sender, System.Web.UI.ImageClickEventArgs e)  // 给选定的老师投票
  {
  
  }

  private void del_Click(object sender, System.Web.UI.ImageClickEventArgs e)
  {
   string ErrorDel="";
   
   DBO.Open ();
   for(int i=0;i<DataGrid0.Items.Count;i++)
   {
    CheckBox Check= ((CheckBox) DataGrid0.Items[i].FindControl("chkSelect0"));
    if(Check.Checked)
    {
     //DBO.BeginTrans ();
     //DBO.ExecuteNonQuery ("delete from article where ArticleId='"+DataGrid0.Items[i].Cells [0].Text+"' and checked='1'"); //删除信息在数据库的记录
     DBO.ExecuteNonQuery ("delete from zteachvote where id='"+DataGrid0.Items[i].Cells [0].Text+"' "); //删除信息在数据库的记录
     //DataTable dt=DBO.DBDataTable ("select * from article where ArticleId='"+DataGrid0.Items[i].Cells [0].Text+"'");
     
//     if(DataGrid0.Items[i].Cells[9].Text.ToString().Trim()!="1")//如果不是转向外部连接的，删除对应的文件
//     {
//      //删除文件
//      string path="";//文件路径
//
//      path=Server.MapPath("./"+channel.Value.ToString().Trim()+"/"+DataGrid0.Items[i].Cells [3].Text.ToString().Trim());  //获取文章物理路径
//      path=path.Substring(0,path.LastIndexOf('//'));             //获取文章所在文件夹物理路径
//      
//      string KEYVALUE=DataGrid0.Items[i].Cells[4].Text.ToString().Trim();      //获取文章栏目的标识SubjectId
//      try
//      {
//       if(path!="")
//       {
//        DirectoryInfo ifExistDirectory=new DirectoryInfo(path);
//        if(ifExistDirectory.Exists)
//        {
//         System.IO .Directory .Delete (path,true);
//        }
//       }
//       DBO.CommitTrans ();
//       //UpdateHtml.updatehtml(channel.Value.ToString(),T_name.Text);
//       intDelCount=intDelCount+1;
//      }
//      catch(Exception ee)
//      {
//       string fs=ee.Message;
//       DBO.RollbackTrans ();
//      }
//     }
//     else
//     {
//      DBO.CommitTrans ();
//      intDelCount=intDelCount+1;
//     }
    }
   }
   DBO.Close ();
   //更新数据
   //UpdateHtml.updatehtml(channel.Value.ToString(),T_name.Text);      //更新html列表
//   if(intLastPgReCount0==intDelCount&&DataGrid0.CurrentPageIndex>0)     //如果当前页上只有一条数据并且DataGrid的当前页索引大于0，那么就让DataGrid返回上一页
//   {
//    DataGrid0.CurrentPageIndex--;
//   }
   bendData1();
  }

  private void EditTeachBtn_Click(object sender, System.EventArgs e)  // 修改老师的信息
  {
   String str="UPDATE zTeachVote  SET tgroup = '"+txtgroup.Text.Trim()+"',tid ="+
    txttid.Text.Trim()+",tname ='"+txttname.Text.Trim()+"',tschool ='"+txttschool.Text.Trim()+"',turl ='"+txtturl.Text.Trim()+"' WHERE id ="+ txtids.Text.Trim();
   DBO.Open();
   Response.Write(str);
   DBO.ExecuteNonQuery(str);
   //"update article set checked='0' where id='"+articleid.Value.ToString().Trim()+"'");
   DBO.Close();
   bendData1();
   // UPDATE zTeachVote  SET tgroup =, tid =, tname =, tschool =, turl =  WHERE (id = 2)
  }
 }
}

 

数据库设计三大模式 数据库设计三大模式
原创粉丝点击
热门IT博客
java 红黑树原理java 红黑树原理
淘宝哪些活动淘宝哪些活动
2016最新网络语言
淘宝助理复制宝贝
软件自由职业工作者
手机淘宝怎么注册用户
排队叫号管理系统源码
淘宝怎么使用优惠券
天上的星星,有我知多少
怎么查看ubuntu的版本
javascript弹出提示框
js object 删除元素
淘宝品质保障商品标识
在淘宝买折叠刀违法吗
手机淘宝怎么看评分
胡润百富 知乎
网络什么偏门来钱快
camtasia studio软件
js获取数组的长度
淘宝实名认证怎么更改
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防，我是瞎子 追忆 国庆追忆 追忆贝壳 往事追忆 追忆逍遥 追忆的贝壳 追忆天空 追忆歌曲 追忆歌词 追忆的意思 追忆的英文 追忆图片 歌曲追忆 此情可待成追忆 此情可待成追忆可是什么意思 fgo追忆的贝壳 此情可待成追忆下一句 追忆逝水年华 此情只待成追忆 追忆什么意思 追忆的近义词 追忆是什么意思 追憶 追悔莫及 追悔 追悔莫及的意思 前任渣了我之后都追悔莫及 追悼词父亲 母亲追悼词 追悼读音 追悼的拼音 追悼志摩 追悼的意思 台湾为何追悼郑洞国 农村老人追悼词范文 追悼的近义词 催人泪下的追悼词父亲 老人去世的追悼词 大追捕 追捕 西安大追捕

程序博客网，程序员的互联网技术博客家园。csdn论坛精品 msdn技术资料都在这里