/// <summary> /// /// </summary> /// <param name="dbVistor"></param> /// <param name="sqlCommand"></param> /// <param name="param"></param> /// <returns></returns> public string FirstRow(DataBaseVisitor dbVistor, string sqlCommand, SqlParameter[] param) { DataBase DB = new DataBase(); if (false == DB.Open()) DB.Open(); SqlCommand cmd = new SqlCommand(dbVistor.ExecSql(sqlCommand), DB.m_sqlCon); if (param != null) { foreach (SqlParameter parameter in param) cmd.Parameters.Add(parameter); } try { string DeptName = cmd.ExecuteScalar().ToString(); return DeptName; } catch (Exception ex) { throw new Exception(ex.Message); return null; } }
/// <summary> /// 修改密码 /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static bool CheckDb() { bool Flag = true; DataBase db = new DataBase(); try { Flag = db.Open(); } catch { Flag = false; } finally { db.Dispose(); } return Flag; }