Пример #1
0
 /// <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;
     }
 }
Пример #2
0
 /// <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;
 }