/// <summary> /// 修改类别 /// </summary> /// <param name="CategoryID">ID</param> /// <param name="NAME">需要修改的名称</param> /// <returns></returns> public static bool edit_ctegory(string Category, string Name) { DbCommand comm = DataACCess.CreateComand(); comm.CommandText = "edit"; DbParameter param = comm.CreateParameter(); param.ParameterName = "@Name"; param.Value = Name; param.Size = 20; comm.Parameters.Add(param); param = comm.CreateParameter(); param.ParameterName = "@Category"; param.Value = Category; param.DbType = DbType.String; param.Size = 20; comm.Parameters.Add(param); int result = -1; try { //执行存储过程 result = DataACCess.ExecuteNonQuery(comm); } catch { } //result = 1即执行成功 return(result != -1); }
/// <summary> /// 直接运行存储过程文件返回DATATABLE /// </summary> /// <param name="commtext">存储过程文件名</param> /// <returns></returns> public static DataTable GETdaleis(string commtext) { DbCommand comm = DataACCess.CreateComand(); comm.CommandText = commtext; return(DataACCess.ExcuteselectCommmand(comm)); }