文件名称：个人管理钱财管理系统
文件大小：1.51MB
文件格式：RAR
更新时间：2011-12-17 04:56:07
个人理财管理系统
private static DataBase _instance; public DataBase() { // // TODO: 在此处添加构造函数逻辑 // } public static DataBase GetInstance() { if (_instance == null) { _instance = new DataBase(); } return _instance; } public static SqlConnection ReturnConn() { string strConn = "Data Source=localhost;USER ID=sa; Password=1984320;Database=PFMS"; SqlConnection Conn = new SqlConnection(strConn); if (Conn.State.Equals(ConnectionState.Closed)) { Conn.Open(); } return Conn; } public static SqlCommand CreateCmd(string procName, SqlParameter[] prams, SqlConnection Conn) { SqlConnection SqlConn = Conn; if (SqlConn.State.Equals(ConnectionState.Closed)) { SqlConn.Open(); } SqlCommand Cmd = new SqlCommand(); Cmd.CommandType = CommandType.StoredProcedure; Cmd.Connection = SqlConn; Cmd.CommandText = procName; if (prams != null) { foreach (SqlParameter parameter in prams) { if (parameter != null) { Cmd.Parameters.Add(parameter); } } } return Cmd; }