27,579
社区成员
发帖
与我相关
我的任务
分享
public DataSet GetListByClassId(Pagination pagetion, int classID, out int totalPage, out int totalCount)
{
pagetion.Fields = "";
string condition = "News_classId=" + classID.ToString();
pagetion.TableName = "Tb_News";
pagetion.Fields = "*";
pagetion.IsGroup = 0;
pagetion.TotalCount =0;
pagetion.PageCount = 0;
pagetion.GroupColumn = "News_id ";
pagetion.Condition = " 1=1 ";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Table",pagetion.TableName),
new SqlParameter("@OrderColumn","News_id"),
new SqlParameter("@TotalCount", pagetion.TotalCount),
new SqlParameter("@TotalPage", pagetion.PageCount),
new SqlParameter("@CurrentPage",pagetion.PageIndex),
new SqlParameter("@PageSize",pagetion.PageSize),
new SqlParameter("@Group",pagetion.IsGroup),
new SqlParameter("@GroupColumn",pagetion.GroupColumn),
new SqlParameter("@Column",pagetion.Fields),
new SqlParameter("@Condition",pagetion.Condition)
};
return DBHelper.GetDataSet("[Pro]", "Tb_News", para);
}
/// <summary>
/// 执行有参存储过程,并返DataSet
/// </summary>
public static DataSet GetDataSet(string prcName,string tableName, params SqlParameter[] values)
{
SqlCommand cmd = new SqlCommand(prcName, Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(values);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds,tableName);
return ds;
}
SqlParameter totalCountPara = new SqlParameter("@TotalCount", SqlDbType.Int, 4);
totalCountPara.Direction = ParameterDirection.Output;
totalCountPara.Value = 2;
SqlParameter totalPagePara = new SqlParameter("@TotalPage", SqlDbType.Int, 4);
totalPagePara.Direction = ParameterDirection.Output;
totalPagePara.Value = 2;
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Table",pagetion.TableName),
new SqlParameter("@OrderColumn","News_id"),
totalCountPara,
totalPagePara,
new SqlParameter("@CurrentPage",pagetion.PageIndex),
new SqlParameter("@PageSize",pagetion.PageSize),
new SqlParameter("@Group",pagetion.IsGroup),
new SqlParameter("@GroupColumn",pagetion.GroupColumn),
new SqlParameter("@Column",pagetion.Fields),
new SqlParameter("@Condition",pagetion.Condition)
};
还是会报错 怎么样才算是提前赋值呢?
SqlParameter p = new SqlParameter();
p.ParameterName = "@TotalPage";
p.Size = 50;
p.Direction = ParameterDirection.Output;
string 取得的值 = para[3].Value.ToString();
pagetion.TotalCount =0;
pagetion.PageCount = 0;