public DataSet GetBBPackageList(Common.Entities.Enum.PackageClientType packageClientType, string unitCode, int is_webapp) { string sql = "select * from smc_packageext where 1=1 and pe_usefulststus=1"; string sClientType = EnumTranslator.TransPackageClientTypeToString(packageClientType); if (packageClientType != Common.Entities.Enum.PackageClientType.All) { sql += " and pe_clienttype='" + sClientType + "' and pe_isbb=1"; } if (!String.IsNullOrEmpty(unitCode)) { sql += " and pe_UnitCode='" + unitCode + "'"; } if (is_webapp > 0) { sql += " and tablename='webapplication'"; } else if (is_webapp < 0) { sql += " and tablename<>'webapplication'"; } DataSet ds = this.ExecuteDataset(sql, CommandType.Text); return(ds); }
public DataSet SearchPackageList(string keyword, string category, string unitCode, Common.Entities.Enum.PackageClientType clientType, Common.Entities.Enum.PackageTrait trait, int page, int pageSize, out int pageCount, out int recordCount, string uid, int is_webapp) { if (pageSize == 0) { pageSize = 10; } string sClientType = EnumTranslator.TransPackageClientTypeToString(clientType); string sql = "select * from smc_packageext where 1=1"; sql += " and pe_usefulststus=1"; if (!String.IsNullOrEmpty(keyword)) { sql += " and pe_Name like '%" + keyword + "%'"; } if (!String.IsNullOrEmpty(category)) { sql += " and pe_CategoryID like '%" + category + "%'"; } if (!String.IsNullOrEmpty(unitCode)) { sql += " and pe_UnitCode = '" + unitCode + "'"; } if (!String.IsNullOrEmpty(sClientType)) { sql += " and pe_ClientType = '" + sClientType + "'"; } if (is_webapp > 0) { sql += " and tablename='WebApplication' "; } else if (is_webapp < 0) { sql += " and tablename <>'WebApplication' "; } if (trait != Common.Entities.Enum.PackageTrait.All) { if (trait == Common.Entities.Enum.PackageTrait.Bibei) { sql += " and pe_Isbb=1"; } else if (trait == Common.Entities.Enum.PackageTrait.Tuijian) { sql += " and pe_IsTJ=1"; } } string order = "pe_CreatedTime desc"; if (trait == Common.Entities.Enum.PackageTrait.Sc) { sql = "select ext.* from smc_collect c join smc_packageext ext on ext.pe_id=c.pe_id where c.uid='" + uid + "'"; sql += " and ext.pe_usefulststus=1"; order = "ext.pe_CreatedTime desc"; } string tableName = SmartBox.Console.Common.StoredProcedureHelper.GetTableName(sql); string columns = SmartBox.Console.Common.StoredProcedureHelper.GetColumns(sql); string where = SmartBox.Console.Common.StoredProcedureHelper.GetWhere(sql); if (trait == Common.Entities.Enum.PackageTrait.ZX) { columns = " top 20 " + columns; } string table = sql; SqlParameter[] pars = new SqlParameter[] { new SqlParameter("@TableName", tableName), new SqlParameter("@Columns", columns), new SqlParameter("@CurrentPageIndex", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@RecordCount", 0), new SqlParameter("@PAGECOUNT", 0), new SqlParameter("@OrderByColumns", order), new SqlParameter("@Where", where), new SqlParameter("@WITH", "") }; pars[4].Direction = ParameterDirection.InputOutput; pars[5].Direction = ParameterDirection.InputOutput; DataSet ds = this.ExecuteDataset("Select_Pagination_ex", CommandType.StoredProcedure, pars); pageCount = Convert.ToInt32(pars[5].Value); recordCount = Convert.ToInt32(pars[4].Value); return(ds); }