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> /// CommonProc 的摘要说明 /// </summary> public class CommonProc { public CommonProc() { // // TODO: 在此处添加构造函数逻辑 // } public static DataSet CommonProcSel(string procname, params object[] obj) { using (SqlConnection sqlcon = new SqlConnection("server=SAMSUNG-B76C7F0;database=ASPNETDB;uid=sa;pwd=sasa;")) { sqlcon.Open(); SqlCommand sqlcmd = new SqlCommand(); sqlcmd.Connection = sqlcon; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.CommandText = procname; SqlCommandBuilder.DeriveParameters(sqlcmd); sqlcmd.Parameters.RemoveAt(0); for (int i = 0; i < sqlcmd.Parameters.Count; i++) { sqlcmd.Parameters[i].Value = obj[i]; } SqlDataAdapter sqldap = new SqlDataAdapter(); sqldap.SelectCommand = sqlcmd; DataSet ds = new DataSet(); sqldap.Fill(ds); return ds; } } public static bool CommonProcTSG(string procname, params object[] obj) { using (SqlConnection sqlcon = new SqlConnection("server=SAMSUNG-B76C7F0;database=ASPNETDB;uid=sa;pwd=sasa;")) { sqlcon.Open(); SqlCommand sqlcmd = new SqlCommand(); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.CommandText = procname; sqlcmd.Connection = sqlcon; SqlCommandBuilder.DeriveParameters(sqlcmd); sqlcmd.Parameters.RemoveAt(0); for (int i = 0; i < sqlcmd.Parameters.Count; i++) { sqlcmd.Parameters[i].Value = obj[i]; } try { sqlcmd.ExecuteNonQuery(); return true; } catch { return false; } finally { sqlcon.Close(); } } } }