本文整理汇总了C#中Filter.GetSQL方法的典型用法代码示例。如果您正苦于以下问题:C# Filter.GetSQL方法的具体用法?C# Filter.GetSQL怎么用?C# Filter.GetSQL使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Filter
的用法示例。
在下文中一共展示了Filter.GetSQL方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
rnd = new Random(DateTime.Now.DayOfYear * 24 + DateTime.Now.Hour); //changes every hour
featured = GetFeaturesMembers();
Page.Form.Attributes["data-form"] = "subscribe";
string sex = MyUtils.IsMale ? "F" : "M";
string sql = "";
photospromo.Visible = MyUtils.GetUserField("id_photo") is DBNull;
sql = "exec GET_RECENT_ACTIVITY "+MyUtils.ID_USER;
db.IgnoreDuplicateKeys = true; //getting multiple id_user in GET_RECENT_ACTIVITY
DataSet d1 = GetUsers(sql,MyUtils.ImageSize.TINY,false);
db.IgnoreDuplicateKeys = false;
repRecentUsersList.DataSource = d1;
repRecentUsersList.DataBind();
noactivity.Visible = d1.Tables[0].Rows.Count == 0;
Filter f = new Filter();
f.orderby = orderby_type.NEWEST;
sql = f.GetSQL(1, 10);
// sql = "exec SEARCH_USERS 1,10,0," + MyUtils.ID_USER + ",'cast (datediff(year,birthdate,getdate()-datepart(dy,birthdate)+1) as int) BETWEEN 18 and 29 and id_photo is not null and sex=''" + sex + "''',1,'GUID, UsersTable.id_user, username as usr,place as plc,title as tit,distance as dis,age,lastlogin_time','id_user desc'";
DataSet d2 = GetUsers(sql);
repNewUsers.DataSource = d2;
repNewUsers.DataBind();
f.orderby = orderby_type.RECENT;
sql = f.GetSQL(1, 10);
// sql = "exec SEARCH_USERS 1,10,0," + MyUtils.ID_USER + ",'cast (datediff(year,birthdate,getdate()-datepart(dy,birthdate)+1) as int) BETWEEN 18 and 29 and id_photo is not null and sex=''" + sex + "''',1,'GUID, UsersTable.id_user, username as usr,place as plc,title as tit,distance as dis,age,lastlogin_time','lastlogin_time desc'";
DataSet d3 = GetUsers(sql);
repRecently.DataSource = d3;
repRecently.DataBind();
}