using?System;
using?System.Data;
using?System.Data.SqlClient;
using?System.Web;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.IO;
using?System.Security.Cryptography;
using?System.Text;
using?System.Data.OleDb;
using?System.Configuration;
namespace?Common
{
????public?class?Database
????{
???????
????????Send?s?=?new?Send（）;
????????///?

????????///?數(shù)據(jù)庫連接
????????///?

????????///?
????????public?static?SqlConnection?CreateDB（）
????????{
????????????return?new?SqlConnection（System.Configuration.ConfigurationManager.ConnectionStrings[“SQLConnString“].ConnectionString）;
????????}

????????///?

????????///?返回MD5
????????///?

????????///?
????????///?
????????public?string?Md5（string?password）
????????{
????????????MD5CryptoServiceProvider?hashmd5?=?new?MD5CryptoServiceProvider（）;
????????????//使用加密服務(wù)提供程序?（CSP）?提供的實(shí)現(xiàn)，計(jì)算輸入數(shù)據(jù)的?MD5?哈希值。無法繼承此類。
????????????return?BitConverter.ToString（hashmd5.ComputeHash（Encoding.Default.GetBytes（password）））.Replace（“-“?““）.ToLower（）;
????????????//System命名空間BitConverter將基礎(chǔ)數(shù)據(jù)類型與字節(jié)數(shù)組相互轉(zhuǎn)換。
????????????//GetBytes將指定的數(shù)據(jù)轉(zhuǎn)換為字節(jié)數(shù)組。?
????????????//ComputeHash計(jì)算輸入數(shù)據(jù)的哈希值的方法。?
????????}

????????public?static?string?sjhm?=?““;?//定義變量
????????public?string?Sjhm
????????{
????????????get
????????????{
????????????????return?sjhm;
????????????}
????????????set
????????????{
????????????????sjhm?=?value;
????????????}

????????}

????????///?

????????///?返回結(jié)果1:用戶名?
????????///?

????????///?
????????///?
????????///?
????????public?string?rettitle（string?sessionid?string?type）
????????{
????????????string?ret?=?“0“;

????????????DataTable?dt?=?new?DataTable（）;
????????????dt?=?GetTables（“select?*?from?d_user?where?d_id=“?+?SessionValue（“1“）?+?““）;
????????????if?（dt?!=?null）
????????????{
????????????????if?（dt.Rows.Count?>?0）
????????????????{
????????????????????if?（type?==?“1“）
????????????????????{
????????????????????????ret?=?dt.Rows[0][“d_uname“].ToString（）;
????????????????????}
????????????????????else?if?（type?==?“2“）
????????????????????{
????????????????????????ret?=?dt.Rows[0][“d_schoolname“].ToString（）;
????????????????????}
????????????????????else?if?（type?==?“3“）
????????????????????{
????????????????????????ret?=?dt.Rows[0][“d_schoolid“].ToString（）;
????????????????????}
????????????????????else?if?（type?==?“4“）
????????????????????{
????????????????????????ret?=?dt.Rows[0][“d_sjh“].ToString（）;
????????????????????}
????????????????????else?if?（type?==?“5“）
????????????????????{
????????????????????????ret?=?dt.Rows[0][“d_bmid“].ToString（）;
????????????????????}
????????????????????else?if?（type?==?“6“）
????????????????????{
????????????????????????ret?=?dt.Rows[0][“d_bj“].ToString（）;
????????????????????}