本文整理汇总了C#中dangdongcmm.model.ListOptions类的典型用法代码示例。如果您正苦于以下问题：C# ListOptions类的具体用法？C# ListOptions怎么用？C# ListOptions使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
ListOptions类属于dangdongcmm.model命名空间，在下文中一共展示了ListOptions类的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: BindDDL_Cid
public static void BindDDL_Cid(ListOptions options, DropDownList ddl, int cid, int pid, string separator)
{
int numResults = 0;
List<CategoryInfo> list = (new CCategory(LANG)).Getlist(cid, pid, options, out numResults);
if (list == null) return;
foreach (CategoryInfo info in list)
{
string sep = pid == 0 ? "" : separator + "---";
ListItem item = new ListItem(sep + info.Name, info.Id.ToString());
ddl.Items.Add(item);
BindDDL_Cid(options, ddl, cid, info.Id, sep);
}
}示例2: BindDDL_Cid_DDL
public static void BindDDL_Cid_DDL(ListOptions options, DropDownList ddl, int cid, int pid, string separator)
{
options.SortExp = Queryparam.Sqlcolumn.Orderd;
options.GetAll = true;
List<CategoryInfo> list = (new CCategory(CCommon.LANG)).Wcmm_Getlist(cid, pid, options);
if (list == null) return;
foreach (CategoryInfo info in list)
{
string sep = pid == 0 ? "" : separator + "---";
ListItem item = new ListItem(sep + info.Name, info.Id.ToString());
ddl.Items.Add(item);
BindDDL_Cid_DDL(options, ddl, cid, info.Id, sep);
}
}示例3: Get_ListOptions
public ListOptions Get_ListOptions()
{
ListOptions options = new ListOptions();
options.PageIndex = PageIndex;
options.PageSize = PageSize;
options.SortExp = SortExp;
options.SortDir = SortDir.ToString();
UserInfo user = CCommon.Get_CurrentUser();
if (user != null)
{
options.Username = user.Username;
options.GetAll = CCommon.Right_sys();
}
return options;
}示例4: Wcmm_Search
public List<MemberInfo> Wcmm_Search(int grouptype, string keywords, ListOptions options, out int numResults)
{
try
{
List<MemberInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += CFunctions.Expression_GetPermit(options.GetAll, options.Username);
string Searchquery = CGeneral.Get_Searchquery(keywords);
SQL += grouptype == -1 ? "" : " AND A.grouptype=" + grouptype;
SQL += CFunctions.IsNullOrEmpty(Searchquery) ? "" : " AND (" + Searchquery + ")";
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
MemberInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<MemberInfo>();
arr.Add(info);
}
}
numResults = this.Wcmm_Searchcount(iConn, grouptype, keywords, options);
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}示例5: Wcmm_Getlistcount
private int Wcmm_Getlistcount(iSqlConnection iConn, int memberid, ListOptions options)
{
try
{
int numResults = 0;
string SQL = SQL_COUNT.Replace(Queryparam.Varstring.VAR_TABLENAME, TABLENAME);
SQL += memberid == 0 ? "" : " AND A.memberid=" + memberid;
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
if (dar.Read())
{
numResults = dar.IsDBNull(0) ? 0 : dar.GetInt32(0);
}
}
return numResults;
}
catch
{
return 0;
}
}示例6: Wcmm_Searchcount
private int Wcmm_Searchcount(iSqlConnection iConn, string Setof_Catalogue, string keywords, ListOptions options)
{
try
{
int numResults = 0;
string SQL = SQL_COUNT.Replace(Queryparam.Varstring.VAR_TABLENAME, TABLENAME);
SQL += CFunctions.Expression_GetPermit(options.GetAll, options.Username);
SQL += CFunctions.IsNullOrEmpty(Setof_Catalogue) ? "" : " AND A.cid IN(" + Setof_Catalogue + ")";
string Searchquery = CGeneral.Get_Searchquery(keywords);
SQL += string.IsNullOrEmpty(Searchquery) ? "" : " AND (" + Searchquery + ")";
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
if (dar.Read())
{
numResults = dar.IsDBNull(0) ? 0 : dar.GetInt32(0);
}
}
return numResults;
}
catch
{
return 0;
}
}示例7: Searchcount
private int Searchcount(iSqlConnection iConn, string Setof_Catalogue, string keywords, ListOptions options)
{
try
{
int numResults = 0;
string SQL = SQL_COUNT.Replace(Queryparam.Varstring.VAR_TABLENAME, TABLENAME);
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += options.Markas == (int)CConstants.State.MarkAs.None ? "" : " AND A.markas=" + options.Markas;
SQL += CFunctions.IsNullOrEmpty(Setof_Catalogue) ? "" : " AND A.cid IN(" + Setof_Catalogue + ")";
string Searchquery = CGeneral.Get_Searchquery(keywords);
SQL += string.IsNullOrEmpty(Searchquery) ? "" : " AND (" + Searchquery + ")";
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
if (dar.Read())
{
numResults = dar.IsDBNull(0) ? 0 : dar.GetInt32(0);
}
}
return numResults;
}
catch
{
return 0;
}
}示例8: Getlist
public List<FileattachInfo> Getlist(int belongto, int iid, ListOptions options, out int numResults)
{
try
{
List<FileattachInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += options.Markas == (int)CConstants.State.MarkAs.None ? "" : " AND A.markas=" + options.Markas;
SQL += " AND A.belongto=" + belongto;
SQL += " AND A.iid=" + iid;
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
FileattachInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<FileattachInfo>();
arr.Add(info);
}
dar.Close();
}
numResults = this.Getlistcount(iConn, belongto, iid, options.Markas);
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}示例9: Wcmm_Getlist
public List<FeedbackInfo> Wcmm_Getlist(int pid, ListOptions options, out int numResults)
{
try
{
List<FeedbackInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += " AND A.pid=" + pid;
SQL += " AND A.pis=0";
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
FeedbackInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<FeedbackInfo>();
arr.Add(info);
}
}
numResults = this.Wcmm_Getlistcount(iConn, pid);
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}示例10: Getlistcount
private int Getlistcount(iSqlConnection iConn, ListOptions options)
{
try
{
int numResults = 0;
string SQL = SQL_COUNT.Replace(Queryparam.Varstring.VAR_TABLENAME, TABLENAME);
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += options.Markas == (int)CConstants.State.MarkAs.None ? "" : " AND A.markas=" + options.Markas;
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
if (dar.Read())
{
numResults = dar.IsDBNull(0) ? 0 : dar.GetInt32(0);
}
}
return numResults;
}
catch
{
return 0;
}
}示例11: Search
public List<LibrariesInfo> Search(int cid, string keywords, ListOptions options, out int numResults)
{
try
{
List<LibrariesInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string Setof_Catalogue = cid == 0 ? "" : (new CCategory(LANG)).Get_setof(cid, "");
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += options.Markas == (int)CConstants.State.MarkAs.None ? "" : " AND A.markas=" + options.Markas;
SQL += cid == 0 ? "" : " AND A.cid IN(" + Setof_Catalogue + ")";
string Searchquery = CGeneral.Get_Searchquery(keywords);
SQL += string.IsNullOrEmpty(Searchquery) ? "" : " AND (" + Searchquery + ")";
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
LibrariesInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<LibrariesInfo>();
arr.Add(info);
}
dar.Close();
}
numResults = this.Searchcount(iConn, Setof_Catalogue, keywords, options);
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}示例12: Getlist_extend
public List<GeneralInfo> Getlist_extend(int belongto, int aid, ListOptions options)
{
try
{
List<GeneralInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = "SELECT A.name, A.introduce, A.description, A.filepreview, A.cid, A.iconex, A.status, A.timeupdate, A.username, A.id, ROW_NUMBER() OVER(ORDER BY A." + options.SortExp + (options.SortDir == "Ascending" ? " ASC" : " DESC") + ") AS rownumber FROM " + TABLENAME + " AS A"
+ " INNER JOIN " + LANG + CConstants.TBDBPREFIX + "extenditem AS J ON J.iid=A.id";
SQL += belongto == 0 ? "" : " AND J.belongto=" + belongto;
SQL += aid == 0 ? "" : " AND J.aid=" + aid;
SQL += " WHERE A.id<>0 AND A.status<>" + (int)CConstants.State.Status.Deleted;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
GeneralInfo info = this.getDataReader_ext(dar);
if (arr == null)
arr = new List<GeneralInfo>();
arr.Add(info);
}
dar.Close();
}
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}示例13: Wcmm_Report
public List<LibrariesInfo> Wcmm_Report(SearchInfo isearch, ListOptions options, out int numResults)
{
try
{
List<LibrariesInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
isearch.Setof_Category = isearch.Cid == 0 ? "" : (new CCategory(LANG)).Get_setof(isearch.Cid, "");
SQL += isearch.Cid == 0 ? "" : " AND A.cid IN(" + isearch.Setof_Category + ")";
isearch.Searchquery = CGeneral.Get_Searchquery(isearch.Keywords);
SQL += CFunctions.IsNullOrEmpty(isearch.Searchquery) ? "" : " AND (" + isearch.Searchquery + ")";
SQL += " AND (A.timeupdate BETWEEN '" + isearch.Datefr + "' AND '" + isearch.Dateto + "')";
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
LibrariesInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<LibrariesInfo>();
arr.Add(info);
}
}
numResults = this.Wcmm_Reportcount(iConn, isearch, options);
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}示例14: Wcmm_Reportcount
private int Wcmm_Reportcount(iSqlConnection iConn, SearchInfo isearch, ListOptions options)
{
try
{
int numResults = 0;
string SQL = SQL_COUNT.Replace(Queryparam.Varstring.VAR_TABLENAME, TABLENAME);
SQL += CFunctions.IsNullOrEmpty(isearch.Setof_Category) ? "" : " AND A.cid IN(" + isearch.Setof_Category + ")";
SQL += string.IsNullOrEmpty(isearch.Searchquery) ? "" : " AND (" + isearch.Searchquery + ")";
SQL += " AND (A.timeupdate BETWEEN '" + isearch.Datefr + "' AND '" + isearch.Dateto + "')";
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
if (dar.Read())
{
numResults = dar.IsDBNull(0) ? 0 : dar.GetInt32(0);
}
}
return numResults;
}
catch
{
return 0;
}
}示例15: Wcmm_Getlist_buildmenu
public List<GeneralInfo> Wcmm_Getlist_buildmenu(int cid, ListOptions options)
{
try
{
List<GeneralInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += CFunctions.Expression_GetPermit(options.GetAll, options.Username);
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += cid == 0 ? "" : " AND A.cid=" + cid;
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
GeneralInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<GeneralInfo>();
arr.Add(info);
}
}
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}