62,046
社区成员
发帖
与我相关
我的任务
分享
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;
/// <summary>
/// Global_Class 的摘要说明
/// </summary>
public class Global_Class
{
public string strMessage;
public string strConn;
public Global_Class() //构造函数内初始化值
{
strConn = ConfigurationManager.ConnectionStrings["连接数据库"].ToString();
}
public static void Response_End(string strMessage)
{
HttpContext.Current.Response.Write(strMessage);
HttpContext.Current.Response.End();
}
}
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>
/// Register 的摘要说明
/// </summary>
public class Register
{
public void Check_Person(out string strMessage, string personname)
{
Global_Class glb = new Global_Class();
SqlConnection conn = new SqlConnection(glb.strConn);
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
SqlCommand comm = new SqlCommand("Register_Check", conn);
comm.Transaction = tran;
try
{
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add("@strMessage", SqlDbType.NVarChar, 1000).Direction = ParameterDirection.Output;
comm.Parameters.Add("@personname", SqlDbType.NVarChar, 50).Value = personname;
comm.ExecuteNonQuery();
strMessage = comm.Parameters["@strMessage"].Value.ToString();
tran.Commit();
}
catch (Exception Message)
{
strMessage = "连接服务失败,详细(" + Message.Message.ToString() + ")";
tran.Rollback();
}
conn.Close();
}
}
Global_Class.cs
---------------------
public class Global_Class
{
public string strMessage;
public static void Response_End(string strMessage)
{
HttpContext.Current.Response.Write(strMessage);
HttpContext.Current.Response.End();
}
static string strConn = Get_Conn();
private static string Get_Conn()
{
string strConn = "";
try
{
strConn = ConfigurationManager.ConnectionStrings["连接数据库"].ToString();
}
catch
{
Response_End("数据库连接配置错误!");
}
return strConn;
}
}
Register.cs
-----------------
public class Register
{
public void Check_Person(out string strMessage, string personname)
{
Global_Class glbClass = new Global_Class();
strConn=glbClass.strConn;
SqlConnection conn = new SqlConnection(strConn);
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
SqlCommand comm = new SqlCommand("Register_Check", conn);
comm.Transaction = tran;
try
{
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add("@strMessage", SqlDbType.NVarChar, 1000).Direction = ParameterDirection.Output;
comm.Parameters.Add("@personname", SqlDbType.NVarChar, 50).Value = personname;
comm.ExecuteNonQuery();
strMessage = comm.Parameters["@strMessage"].Value.ToString();
tran.Commit();
}
catch (Exception Message)
{
strMessage = "连接服务失败,详细(" + Message.Message.ToString() + ")";
tran.Rollback();
}
conn.Close();
}
}