admin_evaluate_workplan.aspx.cs

贸易有限公司项目管理系统(C#.NET2003),供学习参考！

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class Admin_Evaluate_WorkPlan : System.Web.UI.Page
{
    public static SqlConnection MyConnection;
    public static SqlCommand MyCommand;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Name"] == null)
        {
            JS.Alert("您还未登陆或登陆超时！");
            Response.Redirect("Default.aspx");
        }
        int ID = Convert.ToInt32(Request.QueryString["ID"].ToString());
        string name = Request.QueryString["Name"].ToString();
        
        lbNotice.Text = "您好， 您将要对员工" + name + "" +  "本次的工作任务进行评定！";
    }
    protected void btnSubmit_Click(object sender, ImageClickEventArgs e)
    {
        int ID = Convert.ToInt32(Request.QueryString["ID"].ToString());
        string evaluate=txtEva_Content.Text;
        if (EvaWorkPlanInfo(ID, evaluate))
        {
            JS.Alert("评价已经提交！");
            Response.Redirect("Admin_SheduReport.aspx");
        }
    }
    protected void btnReset_Click(object sender, ImageClickEventArgs e)
    {
        txtEva_Content.Text = "";
    }
    public static bool EvaWorkPlanInfo(int i, string s1)
    {
        MyConnection = DB.createCon();
        MyCommand = new SqlCommand("Eva_WorkPlan_Info", MyConnection);
        MyCommand.CommandType = CommandType.StoredProcedure;

        SqlParameter ID = new SqlParameter("@ID", SqlDbType.Int);
        ID.Value = i;
        MyCommand.Parameters.Add(ID);

        SqlParameter Evaluate = new SqlParameter("@Evaluate", SqlDbType.VarChar);
        Evaluate.Value = s1;
        MyCommand.Parameters.Add(Evaluate);

        MyConnection.Open();
        int result;
        result = MyCommand.ExecuteNonQuery();
        MyConnection.Close();
        if (result > 0)
        {
            return true;
        }
        else
        {
            return false;
        }
    }
}