当前文件： ProjectEva/App_Code/WorkPlan.cs[4K，2009-6-12 11:52:27]，打开代码结构图

		            
  1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Web;
  5using System.Web.Security;
  6using System.Web.UI;
  7using System.Web.UI.WebControls;
  8using System.Web.UI.WebControls.WebParts;
  9using System.Web.UI.HtmlControls;
 10using System.Data.SqlClient;
 11/**//// <summary>
 12/// 黄建华（2007.9）
 13/// 工作计划实体类
 14/// </summary>
 15/// <summary>
 16/// WorkPlan 的摘要说明
 17/// </summary>
 18public class WorkPlan
 19...{
 20    public static SqlConnection MyConnection;
 21    public static SqlCommand MyCommand;
 22    public WorkPlan()
 23    ...{
 24        //
 25        // TODO: 在此处添加构造函数逻辑
 26        //
 27    }
 28    /**//// <summary>
 29    /// 写入工作计划方法
 30    /// </summary>
 31    /// <param name="s1"></param>
 32    /// <param name="s2"></param>
 33    /// <param name="time"></param>
 34    /// <returns></returns>
 35    public static bool InsertWorkPlanInfo(string s1, string s2, DateTime time)
 36    ...{
 37        MyConnection = DB.createCon();
 38        MyCommand = new SqlCommand("Insert_WorkPlan_Info", MyConnection);
 39        MyCommand.CommandType = CommandType.StoredProcedure;
 40
 41        SqlParameter Emp_Name = new SqlParameter("@Emp_Name", SqlDbType.VarChar);
 42        Emp_Name.Value = s1;
 43        MyCommand.Parameters.Add(Emp_Name);
 44
 45        SqlParameter Task_Content = new SqlParameter("@Task_Content", SqlDbType.VarChar);
 46        Task_Content.Value = s2;
 47        MyCommand.Parameters.Add(Task_Content);
 48
 49        SqlParameter Start_Time = new SqlParameter("@Start_Time", SqlDbType.DateTime);
 50        Start_Time.Value = time;
 51        MyCommand.Parameters.Add(Start_Time);
 52
 53        
 54        MyConnection.Open();
 55        int result;
 56        result = MyCommand.ExecuteNonQuery();
 57        MyConnection.Close();
 58        if (result > 0)
 59        ...{
 60            return true;
 61        }
 62        else
 63        ...{
 64            return false;
 65        }
 66    }
 67    /**//// <summary>
 68    /// 写入完成工作任务的方法
 69    /// </summary>
 70    /// <param name="i"></param>
 71    /// <param name="time"></param>
 72    /// <param name="s1"></param>
 73    /// <param name="s2"></param>
 74    /// <param name="s3"></param>
 75    /// <returns></returns>
 76    public static bool UpdateWorkPlanInfo(int i,DateTime time,string s1, string s2,string  s3)
 77    ...{
 78        MyConnection = DB.createCon();
 79        MyCommand = new SqlCommand("Update_WorkPlan_Info", MyConnection);
 80        MyCommand.CommandType = CommandType.StoredProcedure;
 81
 82        SqlParameter ID = new SqlParameter("@ID", SqlDbType.Int);
 83        ID.Value = i;
 84        MyCommand.Parameters.Add(ID);
 85
 86        SqlParameter Finish_Time = new SqlParameter("@Finish_Time", SqlDbType.DateTime);
 87        Finish_Time.Value = time;
 88        MyCommand.Parameters.Add(Finish_Time);
 89
 90        SqlParameter Status = new SqlParameter("@Status", SqlDbType.VarChar);
 91        Status.Value = s1;
 92        MyCommand.Parameters.Add(Status);
 93
 94        SqlParameter Document = new SqlParameter("@Document", SqlDbType.VarChar);
 95        Document.Value = s2;
 96        MyCommand.Parameters.Add(Document);
 97
 98
 99        SqlParameter Gain = new SqlParameter("@Gain", SqlDbType.VarChar);
100        Gain.Value = s3;
101        MyCommand.Parameters.Add(Gain);
102
103        MyConnection.Open();
104        int result;
105        result = MyCommand.ExecuteNonQuery();
106        MyConnection.Close();
107        if (result > 0)
108        ...{
109            return true;
110        }
111        else
112        ...{
113            return false;
114        }
115    }
116    /**//// <summary>
117    /// 对工作任务评价的方法
118    /// </summary>
119    /// <param name="i"></param>
120    /// <param name="s1"></param>
121    /// <returns></returns>
122    public static bool EvaWorkPlanInfo(int i, string s1)
123    ...{
124        MyConnection = DB.createCon();
125        MyCommand = new SqlCommand("Eva_WorkPlan_Info", MyConnection);
126        MyCommand.CommandType = CommandType.StoredProcedure;
127
128        SqlParameter ID = new SqlParameter("@ID", SqlDbType.Int);
129        ID.Value = i;
130        MyCommand.Parameters.Add(ID);
131
132        SqlParameter Evaluate = new SqlParameter("@Evaluate", SqlDbType.VarChar);
133        Evaluate.Value = s1;
134        MyCommand.Parameters.Add(Evaluate);
135
136        
137
138
139        MyConnection.Open();
140        int result;
141        result = MyCommand.ExecuteNonQuery();
142        MyConnection.Close();
143        if (result > 0)
144        ...{
145            return true;
146        }
147        else
148        ...{
149            return false;
150        }
151    }
152}
153