resource.cs

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

using System;
using System.Data;
using System.Configuration;
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;
/// <summary>
/// 黄建华（2007.9）
/// 资源实体类
/// </summary>
public class Resource
{
    public static SqlConnection MyConnection;
    public static SqlCommand MyCommand;
	public Resource()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    /// <summary>
    /// 执行添加资源的存储过程
    /// </summary>
    /// <param name="s1"></param>
    /// <param name="s2"></param>
    /// <param name="s3"></param>
    /// <param name="time"></param>
    /// <param name="s4"></param>
    /// <param name="s5"></param>
    /// <returns></returns>
    public static bool InsertResourceInfo(string s1, string s2, string s3,  DateTime time, string s4, string s5)
    {
        MyConnection = DB.createCon();
        MyCommand = new SqlCommand("Insert_Resource_Info", MyConnection);
        MyCommand.CommandType = CommandType.StoredProcedure;

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

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

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

        SqlParameter UpTime = new SqlParameter("@UpTime", SqlDbType.DateTime);
        UpTime.Value = time;
        MyCommand.Parameters.Add(UpTime);

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

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

        

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

    }
}