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>
15public class Resource
16...{
17    public static SqlConnection MyConnection;
18    public static SqlCommand MyCommand;
19    public Resource()
20    ...{
21        //
22        // TODO: 在此处添加构造函数逻辑
23        //
24    }
25    /**//// <summary>
26    /// 执行添加资源的存储过程
27    /// </summary>
28    /// <param name="s1"></param>
29    /// <param name="s2"></param>
30    /// <param name="s3"></param>
31    /// <param name="time"></param>
32    /// <param name="s4"></param>
33    /// <param name="s5"></param>
34    /// <returns></returns>
35    public static bool InsertResourceInfo(string s1, string s2, string s3,  DateTime time, string s4, string s5)
36    ...{
37        MyConnection = DB.createCon();
38        MyCommand = new SqlCommand("Insert_Resource_Info", MyConnection);
39        MyCommand.CommandType = CommandType.StoredProcedure;
40
41        SqlParameter File_Name = new SqlParameter("@File_Name", SqlDbType.VarChar);
42        File_Name.Value = s1;
43        MyCommand.Parameters.Add(File_Name);
44
45        SqlParameter File_Intro = new SqlParameter("@File_Intro", SqlDbType.VarChar);
46        File_Intro.Value = s2;
47        MyCommand.Parameters.Add(File_Intro);
48
49        SqlParameter Publisher = new SqlParameter("@Publisher", SqlDbType.VarChar);
50        Publisher.Value = s3;
51        MyCommand.Parameters.Add(Publisher);
52
53        SqlParameter UpTime = new SqlParameter("@UpTime", SqlDbType.DateTime);
54        UpTime.Value = time;
55        MyCommand.Parameters.Add(UpTime);
56
57        SqlParameter File_Size = new SqlParameter("@File_Size", SqlDbType.VarChar);
58        File_Size.Value = s4;
59        MyCommand.Parameters.Add(File_Size);
60
61        SqlParameter File_Ico = new SqlParameter("@File_Ico", SqlDbType.VarChar);
62        File_Ico.Value = s5;
63        MyCommand.Parameters.Add(File_Ico);
64
65        
66
67        MyConnection.Open();
68        int result;
69        result = MyCommand.ExecuteNonQuery();
70        MyConnection.Close();
71        if (result > 0)
72        ...{
73            return true;
74        }
75        else
76        ...{
77            return false;
78        }
79
80    }
81}
82