📄 dftable.aspx.cs

📁 简单的岗位考评程序．报表＼查询功能齐全．窗体是根据数据库中的数据动态生成．
💻 CS
📖 第 1 页 / 共 3 页
字号:
12 3 下一页
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;
using System.Configuration;
using gwpj.Class;
namespace gwpj
{
	/// <summary>
	/// WebForm1 的摘要说明。
	/// </summary>
	public class WebForm1 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.Label Label7;
		protected System.Web.UI.WebControls.Label Label8;
		protected System.Web.UI.WebControls.Label Label9;
		protected System.Web.UI.WebControls.Label Label10;
		protected System.Web.UI.WebControls.Label Label2;
	
		DataSet ds,ds1;
		public int i=0,j=0;
		public string strtable,sum1,textbox,role_id1;
		static ArrayList al1=new ArrayList();//存放ＴＥＸＴＢＯＸ的ＮＡＭＥ
		static ArrayList al2=new ArrayList();//存放岗位ＩＤ
		static ArrayList al3=new ArrayList();//存放分值
		string score1,score2,score3,score4,score5,score6,score7,score,user1,user2;
		string map1,map2,map3,map4,map5,map6,map7,title1;

		Form myclass=new Form();
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Button Button2;
		protected System.Web.UI.WebControls.Image Image1;
	
		public string[,] temp=new string[100,8];

		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!Page.IsPostBack){
				user();
				select();
			}
		}

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

		}
		#endregion
		#region 判断数据的ＣＯＬＳＰＡＮ　ＲＯＷＳＰＡＮ　并取得数据
		private void select()
		{
			this.Button1.Enabled=true;
			this.Button2.Enabled=true;
			al1.Clear();
			al2.Clear();
			SqlConnection cnn=new SqlConnection(ConfigurationSettings.AppSettings["connstring"]);
			cnn.Open();
//			string sql="select dept_name from evaluated_role group by dept_name";
			string sql="SELECT dept_name,min(role_id)as role_id FROM evaluated_role GROUP BY dept_name order by role_id";
			
			SqlDataAdapter da=new SqlDataAdapter(sql,cnn);
			ds=new DataSet();
			da.Fill(ds,"gwpj");
			for(i=0;i<ds.Tables["gwpj"].Rows.Count;i++){
				string sqlsum="select count(*) as sum1 from evaluated_role where dept_name='"+ds.Tables["gwpj"].Rows[i].ItemArray[0].ToString()+"'";
				SqlCommand cmdsum=new SqlCommand(sqlsum,cnn);
				SqlDataReader drsum=cmdsum.ExecuteReader();
				if(drsum.Read()){
					sum1=drsum["sum1"].ToString();
				}
				drsum.Close();
				cmdsum.Dispose();
				string sql1="select evaluated_role,role_id from evaluated_role where dept_name='"+ds.Tables["gwpj"].Rows[i].ItemArray[0].ToString()+"'";
				SqlDataAdapter da1=new SqlDataAdapter(sql1,cnn);
				ds1=new DataSet();
				da1.Fill(ds1,"gwpj1");
				for(j=0;j<ds1.Tables["gwpj1"].Rows.Count;j++){
					textbox="TextBox"+ds1.Tables["gwpj1"].Rows[j].ItemArray[1].ToString();
					al1.Add(textbox);
					role_id1=ds1.Tables["gwpj1"].Rows[j].ItemArray[1].ToString();
					al2.Add(role_id1);
					al3.Clear();
					for(int k=1;k<8;k++){
						string sqlshow="select score from fch_score where role_id='"+role_id1+"' and factor_id='"+k+"' and staff_code='"+Session["staff_code"].ToString()+"'";
						SqlCommand cmdshow=new SqlCommand(sqlshow,cnn);
						SqlDataReader drshow=cmdshow.ExecuteReader();
						if(drshow.Read())
						{
							score=drshow["score"].ToString();
							al3.Add(score);
						}
						else{
							drshow.Close();
							score="";
							al3.Add(score);
						}
						drshow.Close();
					}
//					drshow.Close();
					score1=al3[0].ToString();
					score2=al3[1].ToString();
					score3=al3[2].ToString();
					score4=al3[3].ToString();
					score5=al3[4].ToString();
					score6=al3[5].ToString();
					score7=al3[6].ToString();

				  showtable();
				}
				ds1.Dispose();
				da1.Dispose();
			}
			da.Dispose();
			ds.Dispose();
			cnn.Close();
		} 
		#endregion
		#region 显示动态的打分表
		private void showtable()
		{
			if(i==0&&j==0)
			{
				strtable=strtable+"<tr align=\"center\"><td height=\"25\" rowspan='"+sum1+"'>"+ds.Tables["gwpj"].Rows[i].ItemArray[0].ToString()+"</td><td>"+ds1.Tables["gwpj1"].Rows[j].ItemArray[0].ToString()+"</td><td><input name='"+textbox+"_1' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score1+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_1')\" onmouseout=\"hide('m-"+textbox+"_1')\"/><DIV id=\"m-"+textbox+"_1\" onmouseup=\""+map1+"('"+textbox+"_1','m-"+textbox+"_1')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 25%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" ms_positioning=\"FlowLayout\" onmouseout=\"hide('m-"+textbox+"_1')\"><IMG src=\"images\\help1.jpg\"></IMG></DIV></td>"+
					"<td "+title1+"><input name='"+textbox+"_2' type=\"text\" class=\"TextBox\" style=\"width:55px; background-color:#c5d8e9\" value='"+score2+"' "+user1+"  onmouseup=\""+map2+"(this,'m-"+textbox+"_2')\" onmouseout=\"hide('m-"+textbox+"_2')\"/><DIV id=\"m-"+textbox+"_2\" onmouseup=\""+map2+"('"+textbox+"_2','m-"+textbox+"_2')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 36%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_2')\"><IMG src=\"images\\help2.jpg\"></IMG></DIV></td><td><input name='"+textbox+"_3' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score3+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_3')\" onmouseout=\"hide('m-"+textbox+"_3')\"/><DIV id=\"m-"+textbox+"_3\" onmouseup=\""+map1+"('"+textbox+"_3','m-"+textbox+"_3')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 37%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_3')\"><IMG src=\"images\\help3.jpg\"></IMG></DIV></td>"+
					"<td><input name='"+textbox+"_4' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score4+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_4')\" onmouseout=\"hide('m-"+textbox+"_4')\"/><DIV id=\"m-"+textbox+"_4\" onmouseup=\""+map1+"('"+textbox+"_4','m-"+textbox+"_4')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 53%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_4')\"><IMG src=\"images\\help4.jpg\"></IMG></DIV></td><td><input name='"+textbox+"_5' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score5+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_5')\" onmouseout=\"hide('m-"+textbox+"_5')\"/><DIV id=\"m-"+textbox+"_5\" onmouseup=\""+map1+"('"+textbox+"_5','m-"+textbox+"_5')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 36%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_5')\"><IMG src=\"images\\help5.jpg\"></IMG></DIV></td>"+
					"<td><input name='"+textbox+"_6' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score6+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_6')\" onmouseout=\"hide('m-"+textbox+"_6')\"/><DIV id=\"m-"+textbox+"_6\" onmouseup=\""+map1+"('"+textbox+"_6','m-"+textbox+"_6')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 32%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_6')\"><IMG src=\"images\\help6.jpg\"></IMG></DIV></td><td><input name='"+textbox+"_7' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score7+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_7')\" onmouseout=\"hide('m-"+textbox+"_7')\"/><DIV id=\"m-"+textbox+"_7\" onmouseup=\""+map1+"('"+textbox+"_7','m-"+textbox+"_7')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 52%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute\" onmouseout=\"hide('m-"+textbox+"_7')\"><IMG src=\"images\\help7.jpg\"></IMG></DIV></td></tr>";
			}
			else{
				if(i==0&&j!=0)
				{
					strtable=strtable+"<tr align=\"center\"><td>"+ds1.Tables["gwpj1"].Rows[j].ItemArray[0].ToString()+"</td><td><input name='"+textbox+"_1' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score1+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_1')\" onmouseout=\"hide('m-"+textbox+"_1')\"/><DIV id=\"m-"+textbox+"_1\" onmouseup=\""+map1+"('"+textbox+"_1','m-"+textbox+"_1')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 25%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" ms_positioning=\"FlowLayout\" onmouseout=\"hide('m-"+textbox+"_1')\"><IMG src=\"images\\help1.jpg\"></IMG></DIV></td>"+
						"<td "+title1+"><input name='"+textbox+"_2' type=\"text\" class=\"TextBox\" style=\"width:55px; background-color:#c5d8e9\" value='"+score2+"' "+user1+"  onmouseup=\""+map2+"(this,'m-"+textbox+"_2')\" onmouseout=\"hide('m-"+textbox+"_2')\"/><DIV id=\"m-"+textbox+"_2\" onmouseup=\""+map2+"('"+textbox+"_2','m-"+textbox+"_2')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 36%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_2')\"><IMG src=\"images\\help2.jpg\"></IMG></DIV></td><td><input name='"+textbox+"_3' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score3+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_3')\" onmouseout=\"hide('m-"+textbox+"_3')\"/><DIV id=\"m-"+textbox+"_3\" onmouseup=\""+map1+"('"+textbox+"_3','m-"+textbox+"_3')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 37%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_3')\"><IMG src=\"images\\help3.jpg\"></IMG></DIV></td>"+
						"<td><input name='"+textbox+"_4' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score4+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_4')\" onmouseout=\"hide('m-"+textbox+"_4')\"/><DIV id=\"m-"+textbox+"_4\" onmouseup=\""+map1+"('"+textbox+"_4','m-"+textbox+"_4')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 53%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_4')\"><IMG src=\"images\\help4.jpg\"></IMG></DIV></td><td><input name='"+textbox+"_5' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score5+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_5')\" onmouseout=\"hide('m-"+textbox+"_5')\"/><DIV id=\"m-"+textbox+"_5\" onmouseup=\""+map1+"('"+textbox+"_5','m-"+textbox+"_5')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 36%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_5')\"><IMG src=\"images\\help5.jpg\"></IMG></DIV></td>"+
						"<td><input name='"+textbox+"_6' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score6+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_6')\" onmouseout=\"hide('m-"+textbox+"_6')\"/><DIV id=\"m-"+textbox+"_6\" onmouseup=\""+map1+"('"+textbox+"_6','m-"+textbox+"_6')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 32%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_6')\"><IMG src=\"images\\help6.jpg\"></IMG></DIV></td><td><input name='"+textbox+"_7' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score7+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_7')\" onmouseout=\"hide('m-"+textbox+"_7')\"/><DIV id=\"m-"+textbox+"_7\" onmouseup=\""+map1+"('"+textbox+"_7','m-"+textbox+"_7')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 52%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute\" onmouseout=\"hide('m-"+textbox+"_7')\"><IMG src=\"images\\help7.jpg\"></IMG></DIV></td></tr>";
				}
				else{
					if(i!=0&&j==0)
					{
						strtable=strtable+"<tr align=\"center\"><td height=\"25\" rowspan='"+sum1+"'>"+ds.Tables["gwpj"].Rows[i].ItemArray[0].ToString()+"</td><td>"+ds1.Tables["gwpj1"].Rows[j].ItemArray[0].ToString()+"</td><td><input name='"+textbox+"_1' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score1+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_1')\" onmouseout=\"hide('m-"+textbox+"_1')\"/><DIV id=\"m-"+textbox+"_1\" onmouseup=\""+map1+"('"+textbox+"_1','m-"+textbox+"_1')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 25%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" ms_positioning=\"FlowLayout\" onmouseout=\"hide('m-"+textbox+"_1')\"><IMG src=\"images\\help1.jpg\"></IMG></DIV></td>"+
							"<td "+title1+"><input name='"+textbox+"_2' type=\"text\" class=\"TextBox\" style=\"width:55px; background-color:#c5d8e9\" value='"+score2+"' "+user1+"  onmouseup=\""+map2+"(this,'m-"+textbox+"_2')\" onmouseout=\"hide('m-"+textbox+"_2')\"/><DIV id=\"m-"+textbox+"_2\" onmouseup=\""+map2+"('"+textbox+"_2','m-"+textbox+"_2')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 36%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_2')\"><IMG src=\"images\\help2.jpg\"></IMG></DIV></td><td><input name='"+textbox+"_3' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score3+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_3')\" onmouseout=\"hide('m-"+textbox+"_3')\"/><DIV id=\"m-"+textbox+"_3\" onmouseup=\""+map1+"('"+textbox+"_3','m-"+textbox+"_3')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 37%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_3')\"><IMG src=\"images\\help3.jpg\"></IMG></DIV></td>"+
							"<td><input name='"+textbox+"_4' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score4+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_4')\" onmouseout=\"hide('m-"+textbox+"_4')\"/><DIV id=\"m-"+textbox+"_4\" onmouseup=\""+map1+"('"+textbox+"_4','m-"+textbox+"_4')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 53%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_4')\"><IMG src=\"images\\help4.jpg\"></IMG></DIV></td><td><input name='"+textbox+"_5' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score5+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_5')\" onmouseout=\"hide('m-"+textbox+"_5')\"/><DIV id=\"m-"+textbox+"_5\" onmouseup=\""+map1+"('"+textbox+"_5','m-"+textbox+"_5')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 36%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_5')\"><IMG src=\"images\\help5.jpg\"></IMG></DIV></td>"+
							"<td><input name='"+textbox+"_6' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score6+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_6')\" onmouseout=\"hide('m-"+textbox+"_6')\"/><DIV id=\"m-"+textbox+"_6\" onmouseup=\""+map1+"('"+textbox+"_6','m-"+textbox+"_6')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 32%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_6')\"><IMG src=\"images\\help6.jpg\"></IMG></DIV></td><td><input name='"+textbox+"_7' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score7+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_7')\" onmouseout=\"hide('m-"+textbox+"_7')\"/><DIV id=\"m-"+textbox+"_7\" onmouseup=\""+map1+"('"+textbox+"_7','m-"+textbox+"_7')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 52%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute\" onmouseout=\"hide('m-"+textbox+"_7')\"><IMG src=\"images\\help7.jpg\"></IMG></DIV></td></tr>";
					}
					else
					{
						if(i!=0&&j!=0)
						{
							strtable=strtable+"<tr align=\"center\"><td>"+ds1.Tables["gwpj1"].Rows[j].ItemArray[0].ToString()+"</td><td><input name='"+textbox+"_1' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score1+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_1')\" onmouseout=\"hide('m-"+textbox+"_1')\"/><DIV id=\"m-"+textbox+"_1\" onmouseup=\""+map1+"('"+textbox+"_1','m-"+textbox+"_1')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 25%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" ms_positioning=\"FlowLayout\" onmouseout=\"hide('m-"+textbox+"_1')\"><IMG src=\"images\\help1.jpg\"></IMG></DIV></td>"+
								"<td "+title1+"><input name='"+textbox+"_2' type=\"text\" class=\"TextBox\" style=\"width:55px; background-color:#c5d8e9\" value='"+score2+"' "+user1+"  onmouseup=\""+map2+"(this,'m-"+textbox+"_2')\" onmouseout=\"hide('m-"+textbox+"_2')\"/><DIV id=\"m-"+textbox+"_2\" onmouseup=\""+map2+"('"+textbox+"_2','m-"+textbox+"_2')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 36%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_2')\"><IMG src=\"images\\help2.jpg\"></IMG></DIV></td><td><input name='"+textbox+"_3' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score3+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_3')\" onmouseout=\"hide('m-"+textbox+"_3')\"/><DIV id=\"m-"+textbox+"_3\" onmouseup=\""+map1+"('"+textbox+"_3','m-"+textbox+"_3')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 37%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_3')\"><IMG src=\"images\\help3.jpg\"></IMG></DIV></td>"+
								"<td><input name='"+textbox+"_4' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score4+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_4')\" onmouseout=\"hide('m-"+textbox+"_4')\"/><DIV id=\"m-"+textbox+"_4\" onmouseup=\""+map1+"('"+textbox+"_4','m-"+textbox+"_4')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 53%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_4')\"><IMG src=\"images\\help4.jpg\"></IMG></DIV></td><td><input name='"+textbox+"_5' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score5+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_5')\" onmouseout=\"hide('m-"+textbox+"_5')\"/><DIV id=\"m-"+textbox+"_5\" onmouseup=\""+map1+"('"+textbox+"_5','m-"+textbox+"_5')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 36%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_5')\"><IMG src=\"images\\help5.jpg\"></IMG></DIV></td>"+
								"<td><input name='"+textbox+"_6' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score6+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_6')\" onmouseout=\"hide('m-"+textbox+"_6')\"/><DIV id=\"m-"+textbox+"_6\" onmouseup=\""+map1+"('"+textbox+"_6','m-"+textbox+"_6')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 32%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute;\" onmouseout=\"hide('m-"+textbox+"_6')\"><IMG src=\"images\\help6.jpg\"></IMG></DIV></td><td><input name='"+textbox+"_7' type=\"text\" class=\"TextBox\" style=\"width:55px;\" value='"+score7+"' "+user2+"  onmouseup=\""+map1+"(this,'m-"+textbox+"_7')\" onmouseout=\"hide('m-"+textbox+"_7')\"/><DIV id=\"m-"+textbox+"_7\" onmouseup=\""+map1+"('"+textbox+"_7','m-"+textbox+"_7')\" style=\"BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 1px; BORDER-TOP: black 1px solid; PADDING-LEFT: 1px; Z-INDEX: 101; LEFT: 52%; VISIBILITY: hidden; PADDING-BOTTOM: 1px; BORDER-LEFT: black 1px solid; WIDTH: 80px; PADDING-TOP: 1px; BORDER-BOTTOM: black 1px solid; POSITION: absolute\" onmouseout=\"hide('m-"+textbox+"_7')\"><IMG src=\"images\\help7.jpg\"></IMG></DIV></td></tr>";
						}
					}
				}
			}
		}
		#endregion
		#region 打分
		private void Button1_Click(object sender, System.EventArgs e)
		{
			SqlConnection cnn=new SqlConnection(ConfigurationSettings.AppSettings["connstring"]);
			cnn.Open();
			temp_source();
			string scoren;
			string role_id2;
			string sqlif="select evaluate_ok from evaluate_staff where staff_code='"+Session["staff_code"].ToString()+"' and evaluate_ok='1'";
			SqlCommand cmdif=new SqlCommand(sqlif,cnn);
			SqlDataReader drif=cmdif.ExecuteReader();
12 3 下一页
💿 文件大小 547 K
👤 上传用户 yyyz
📂 所属分类数据库系统
🏷️ 相关标签

#程序 #报表 #动态 #查询
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -