Ejemplo n.º 1
0
 /// <summary>
 /// 执行存储过程不带参数
 /// </summary>
 /// <param name="db">链接数据库EF DbContext对象</param>
 /// <param name="cmdText">SQL语句、存储过程名称</param>
 /// <returns></returns>
 public static int ExecuteNonQueryPro(this CTMSContext db, string cmdText)
 {
     try
     {
         return(db.ExecuteNonQuery(CommandType.StoredProcedure, cmdText, null));
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }
Ejemplo n.º 2
0
 /// <summary>
 /// 执行SQL语句带参数
 /// </summary>
 /// <param name="db">链接数据库EF DbContext对象</param>
 /// <param name="cmdText">SQL语句、存储过程名称</param>
 /// <param name="sqlParams">参数 SqlParameter集合</param>
 /// <returns></returns>
 public static int ExecuteNonQuery(this CTMSContext db, string cmdText, DbParameter[] sqlParams)
 {
     try
     {
         return(db.ExecuteNonQuery(CommandType.Text, cmdText, sqlParams));
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }