当前文件： ProjectEva/App_Code/Message.cs[2K，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//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)
16
17public class Message
18...{
19    public static SqlConnection MyConnection;
20    public static SqlCommand MyCommand;
21    public Message()
22    ...{
23        //
24        // TODO: 在此处添加构造函数逻辑
25        //
26    }
27    /**//// <summary>
28    /// 执行写入短信的存储过程
29    /// </summary>
30    /// <param name="s1"></param>
31    /// <param name="s2"></param>
32    /// <param name="s3"></param>
33    /// <param name="s4"></param>
34    /// <param name="s5"></param>
35    /// <param name="time"></param>
36    /// <param name="s6"></param>
37    /// <returns></returns>
38    public static bool InsertMessageInfo(string s1, string s2, string s3, string s4, string s5, DateTime time, string s6)
39    ...{
40        MyConnection = DB.createCon();
41        MyCommand = new SqlCommand("Insert_Message_Info", MyConnection);
42        MyCommand.CommandType = CommandType.StoredProcedure;
43
44        SqlParameter From_User = new SqlParameter("@From_User", SqlDbType.VarChar,8);
45        From_User.Value = s1;
46        MyCommand.Parameters.Add(From_User);
47
48        SqlParameter To_User = new SqlParameter("@To_User", SqlDbType.VarChar,8);
49        To_User.Value = s2;
50        MyCommand.Parameters.Add(To_User);
51
52        SqlParameter Title = new SqlParameter("@Title", SqlDbType.VarChar,50);
53        Title.Value = s3;
54        MyCommand.Parameters.Add(Title);
55
56        SqlParameter Content = new SqlParameter("@Content", SqlDbType.VarChar,1000);
57        Content.Value = s4;
58        MyCommand.Parameters.Add(Content);
59
60        SqlParameter Enclosure = new SqlParameter("@Enclosure", SqlDbType.VarChar,50);
61        Enclosure.Value = s5;
62        MyCommand.Parameters.Add(Enclosure);
63
64        SqlParameter SendTime = new SqlParameter("@SendTime", SqlDbType.DateTime);
65        SendTime.Value = time;
66        MyCommand.Parameters.Add(SendTime);
67
68        SqlParameter IfRead = new SqlParameter("@IfRead", SqlDbType.VarChar,8);
69        IfRead.Value = s6;
70        MyCommand.Parameters.Add(IfRead);
71
72        MyConnection.Open();
73        int result;
74        result = MyCommand.ExecuteNonQuery();
75        MyConnection.Close();
76        if (result > 0)
77        ...{
78            return true;
79        }
80        else
81        ...{
82            return false;
83        }
84 
85    }
86
87}
88