/// <summary> /// 更新所有的视图 /// </summary> public void UpdateAllView() { int rowsAffected; SqlParameter[] parameters = { }; Itemsql.RunProcedure("UP_UpdateAllView", parameters, out rowsAffected); }
/// <summary> /// 取记录列表(返回记录数) /// </summary> /// <param name="pageListModel"></param> /// <param name="rowCount"></param> /// <returns></returns> public DataSet GetList(PageListModel pageListModel, ref int rowCount) { SqlParameter[] parameters = { new SqlParameter("@select_list", SqlDbType.VarChar, 1000), new SqlParameter("@table_name", SqlDbType.VarChar, 3000), new SqlParameter("@where", SqlDbType.VarChar, 8000), new SqlParameter("@primary_key", SqlDbType.VarChar, 100), new SqlParameter("@order_by", SqlDbType.VarChar, 100), new SqlParameter("@page_size", SqlDbType.Int), new SqlParameter("@page_index", SqlDbType.Int), new SqlParameter("@bl_page", SqlDbType.Int), new SqlParameter("@flag", SqlDbType.Int), new SqlParameter("@return_Value", SqlDbType.Int), }; parameters[0].Value = pageListModel.SelectList; parameters[1].Value = pageListModel.Tables; parameters[2].Value = pageListModel.StrWhere; parameters[3].Value = pageListModel.PriKey; parameters[4].Value = pageListModel.OrderByField; parameters[5].Value = pageListModel.PageSize; parameters[6].Value = pageListModel.PageIndex; parameters[7].Value = pageListModel.BlPage; parameters[8].Value = pageListModel.Flag; parameters[9].Direction = ParameterDirection.ReturnValue; return(Itemsql.RunProcedure("UP_Common_PageList", parameters, "ds", out rowCount)); }