dftable.aspx.cs

简单的岗位考评程序．报表＼查询功能齐全． 窗体是根据数据库中的数据动态生成．

			if(drif.Read())
			{
				drif.Close();
				cmdif.Dispose();
				Response.Write("<script>alert('您所打的分值已经提交!不能再次进行打分!')</script>");
				this.Button2.Enabled=false;
				this.Button1.Enabled=false;
				return;
			}
			else
			{
				drif.Close();
				cmdif.Dispose();

				for(int i=0;i<al1.Count;i++)//
				{
					for(int j=1;j<8;j++)//七项打分
					{
						string sqlinsert;
						//					scoren="score"+j;
						scoren=this.Page.Request.Form[al1[i].ToString()+"_"+j+""].ToString();
						//					temp[i,j]=this.Page.Request.Form[al1[i].ToString()+"_"+j+""].ToString();
						role_id2=al2[i].ToString();

						string sqlselect="select role_id,factor_id,staff_code from score where role_id='"+role_id2+"' and staff_code='"+Session["staff_code"].ToString()+"' and factor_id="+j+"";
						SqlCommand cmdselect=new SqlCommand(sqlselect,cnn);
						SqlDataReader drselect1=cmdselect.ExecuteReader();
						if(drselect1.Read())
						{
							if(scoren=="")
							{
								sqlinsert="update score set score=null where role_id='"+drselect1["role_id"].ToString()+"' and factor_id='"+drselect1["factor_id"].ToString()+"' and staff_code='"+drselect1["staff_code"].ToString()+"'";	
							}
							else
							{
								sqlinsert="update score set score='"+scoren+"' where role_id='"+drselect1["role_id"].ToString()+"' and factor_id='"+drselect1["factor_id"].ToString()+"' and staff_code='"+drselect1["staff_code"].ToString()+"'";	
							}
							drselect1.Close();
							cmdselect.Dispose();
						}
						else
						{
							drselect1.Close();
							cmdselect.Dispose();	
							if(scoren=="")
							{
								sqlinsert="insert into score(role_id,factor_id,staff_code,score) values('"+role_id2+"',"+j+",'"+Session["staff_code"].ToString()+"',null)";
							}
							else
							{
								sqlinsert="insert into score(role_id,factor_id,staff_code,score) values('"+role_id2+"',"+j+",'"+Session["staff_code"].ToString()+"','"+scoren+"')";
							}
						}

						SqlCommand cmd=new SqlCommand(sqlinsert,cnn);
						try
						{
							cmd.ExecuteNonQuery();
						}
						catch(Exception m)
						{
							string aaa=m.Message.Trim().ToString();
							string bbb=myclass.DeleteUnVisibleChar(aaa);
							Response.Write("<script>alert('"+bbb.Replace("\'","\\'")+"')</script>");
							user();
							b_score();
							return;

						}
						cmd.Dispose();	
					}
				}
				Response.Write("<script>alert('保存成功！')</script>");
				user();
				select();
			}
			cnn.Close();
		}
		#endregion

		#region 打分提交失败后,显示用户所打的分
		private void b_score(){
			int k=0;
			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+"'";
//						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=temp[k,1].ToString();
					score2=temp[k,2].ToString();
					score3=temp[k,3].ToString();
					score4=temp[k,4].ToString();
					score5=temp[k,5].ToString();
					score6=temp[k,6].ToString();
					score7=temp[k,7].ToString();
					k++;
					showtable();
				}
				ds1.Dispose();
				da1.Dispose();
			}
			da.Dispose();
			ds.Dispose();
			cnn.Close();
		}
		#endregion

		#region 取得用户填写的分值
		private void temp_source(){
			for(int i=0;i<al1.Count;i++)//
			{
				for(int j=1;j<8;j++)//七项打分
				{
					temp[i,j]=this.Page.Request.Form[al1[i].ToString()+"_"+j+""].ToString();
				}
			}
		}
		#endregion

		#region 提交界面
		private void Button2_Click(object sender, System.EventArgs e)
		{
			SqlConnection cnn=new SqlConnection(ConfigurationSettings.AppSettings["connstring"]);
			cnn.Open();
			temp_source();
			string scoren;
			string role_id2;
			string sql="select * from evaluate_staff where evaluate_ok='1' and staff_code='"+Session["staff_code"].ToString()+"'";
			SqlCommand cmd1=new SqlCommand(sql,cnn);
			SqlDataReader dr=cmd1.ExecuteReader();
			if(dr.Read())
			{
				Response.Write("<script>alert('岗位评价打分已经提交！不能进行重复打分！')</script>");
				this.Button2.Enabled=false;
				this.Button1.Enabled=false;
//				b_score();
				return;
			}
			else{
				dr.Close();
				cmd1.Dispose();
				string sql88="select * from evaluate_staff where staff_code='"+Session["staff_code"].ToString()+"'";
				SqlCommand cmd88=new SqlCommand(sql88,cnn);
				SqlDataReader dr88=cmd88.ExecuteReader();
				if(dr88.Read())
				{
					if(dr88["is_admin"].ToString()=="True")
					{
						dr88.Close();
						cmd88.Dispose();
						for(int i=0;i<al1.Count;i++)//
						{