protected void BindData()
{
string condition = "IsDel=0 And LineID=" + MyLine.ID;
DateTime dtBegin = GetUrlDateTime("bdate");
DateTime dtEnd = GetUrlDateTime("edate");
if (dtBegin != DateTime.MinValue && dtEnd != DateTime.MinValue && dtEnd > dtBegin)
{
condition = condition + " And GoDate>='" + dtBegin.ToStartString() + "' And GoDate<='" + dtEnd.ToEndString() + "'";
}
AdminSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex);
WebQuery query = new WebQuery();
query.Fields = TravelGroupInfo.AllFields;
query.OrderBy = "ID";
query.PrimaryKey = TravelGroupInfo.TablePrimaryKey;
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = TravelGroupInfo.TableOrViewName;
query.Condition = condition;
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
if (dtBegin != DateTime.MinValue && dtEnd != DateTime.MinValue)
{
tbBegin.Text = dtBegin.ToDateOnlyString();
tbEnd.Text = dtEnd.ToDateOnlyString();
}
}
protected void BindData()
{
int pageIndex = GetUrlInt("p");
if (pageIndex <= 0)
{
pageIndex = 1;
}
WebPager pager = SiteSetting.CreateWebPagerForGridView(gvData, pageIndex);
pager.PageCSSName = "NotShowPage";
pager.PageSize = 10000;
WebQuery query = new WebQuery();
query.Fields = OrderDetailInfo.AllFields;
query.OrderBy = "ID";
query.PrimaryKey = OrderDetailInfo.TablePrimaryKey;
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = OrderDetailInfo.TableOrViewName;
query.Condition = "AddMemberName='" + CurrentMember.UserName + "' And OrderNum='" + OrderNum + "'";
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
}
protected void BindData()
{
int pageIndex = GetUrlInt("p");
if (pageIndex <= 0)
{
pageIndex = 1;
}
SiteSetting.CreateWebPagerForDataList(dtPhoto, pageIndex);
WebQuery query = new WebQuery();
query.Fields = "*";
query.OrderBy = "ID desc";
query.PrimaryKey = PicWallInfo.TablePrimaryKey;
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = PicWallInfo.TableOrViewName;
query.Condition = "1=1";
dtPhoto.Db = TMS.Db.Helper;
dtPhoto.Query = query;
dtPhoto.DataBind();
dtPhoto.RepeatDirection = RepeatDirection.Horizontal;
dtPhoto.RepeatColumns = 5;
}
public async Task GetMyIp()
{
var webQuery = new WebQuery(new ProgressCancelNotifier(), false, false);
var test = await webQuery.GetMyIpAsync();
Assert.IsFalse(test.StartsWith("192.168"));
}
protected void BindData()
{
string condition = "OrderStatus='" + OrderStatus.WaitingConfirm + "'";
DateTime dtBegin = GetUrlDateTime("bdate");
DateTime dtEnd = GetUrlDateTime("edate");
if (dtBegin != DateTime.MinValue && dtEnd != DateTime.MinValue && dtBegin <= dtEnd)
{
condition = condition + " And AddTime>='" + dtBegin.ToStartString() + "' And AddTime<='" + dtEnd.ToEndString() + "'";
}
AdminSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex);
WebQuery query = new WebQuery();
query.Fields = "*";
query.OrderBy = "OrderNum desc";
query.PrimaryKey = "OrderNum";
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = "V_Order";
query.Condition = condition;
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
tbBegin.Text = dtBegin == DateTime.MinValue ? "" : dtBegin.ToDateOnlyString();
tbEnd.Text = dtEnd == DateTime.MinValue ? "" : dtEnd.ToDateOnlyString();
}
protected void BindData()
{
string realName = GetUrlString("RealName");
AdminSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex);
WebQuery query = new WebQuery();
query.Ascending = false;
if (!realName.IsNullOrEmpty())
{
query.Condition = "RealName like '%" + realName + "%'";
}
query.Fields = SiteUserBLL.AllFields;
query.OrderBy = "RoleIDs";
query.PrimaryKey = "Name";
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = "SiteUser";
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
tbName.Text = realName;
}
/// <summary>
/// Saves a new WebQuery or updates an already existing WebQuery.
/// </summary>
/// <param name="WebQuery">WebQuery to be saved.</param>
/// <param name="WebQueryId">WebQueryId of the WebQuery creating</param>
/// <returns>WebQueryId</returns>
public long SaveWebQuery(WebQueryDTO webQueryDTO)
{
long webQueryId = 0;
if (webQueryDTO.WebQueryId == 0)
{
var webQuery = new WebQuery()
{
WebQueryId = webQueryDTO.WebQueryId,
Body = webQueryDTO.Body,
PhoneNumber = webQueryDTO.PhoneNumber,
CreatedOn = DateTime.Now,
Name = webQueryDTO.Name,
EmailAddress = webQueryDTO.EmailAddress,
RespondedTo = webQueryDTO.RespondedTo,
};
this.UnitOfWork.Get <WebQuery>().AddNew(webQuery);
this.UnitOfWork.SaveChanges();
webQueryId = webQuery.WebQueryId;
return(webQueryId);
}
return(webQueryId);
}
protected void BindData()
{
string condition = "CostType='" + CostType.JoinGroup + "' And UserName='******'";
DateTime dtBegin = GetUrlDateTime("bdate");
DateTime dtEnd = GetUrlDateTime("edate");
if (dtBegin != DateTime.MinValue && dtEnd != DateTime.MinValue && dtBegin <= dtEnd)
{
condition = condition + " And AddTime>='" + dtBegin.ToStartString() + "' And AddTime<='" + dtEnd.ToEndString() + "'";
}
SiteSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex);
WebQuery query = new WebQuery();
query.Fields = "*";
query.OrderBy = "ID desc";
query.PrimaryKey = "ID";
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = "V_CostHistory";
query.Condition = condition;
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
tbBegin.Text = dtBegin == DateTime.MinValue ? "" : dtBegin.ToDateOnlyString();
tbEnd.Text = dtEnd == DateTime.MinValue ? "" : dtEnd.ToDateOnlyString();
}
public void EmptyQuery()
{
HttpClient client = new HttpClient(baseAddresses[0]);
WebQuery <Customer> emptyQuery = client.CreateQuery <Customer>();
Console.WriteLine("Empty query resource at: {0}", emptyQuery.RequestUri.AbsoluteUri);
}
protected void BindData()
{
string condition = "IsDel=0";
string keyword = GetUrlString("keyword");
if (!keyword.IsNullOrEmpty())
{
condition = condition + " And Name like '%" + keyword + "%'";
}
AdminSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex);
WebQuery query = new WebQuery();
query.Ascending = false;
query.Fields = TMS.PromotionInfo.AllFields;
query.OrderBy = "ID desc";
query.PrimaryKey = TMS.PromotionInfo.TablePrimaryKey;
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = TMS.PromotionInfo.TableOrViewName;
query.Condition = condition;
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
tbKeyWord.Text = keyword;
}
/// <summary>
/// Gets companies data from monitor
/// </summary>
/// <param name="requestPath">Request path, used for API calls (URI)</param>
/// <param name="accessToken">Access Token for API call (JWT OAuth)</param>
/// <param name="accountId">Account id</param>
/// <param name="filterStartDate">Start date for the filtering</param>
/// <param name="filterEndDate">End date for the filtering</param>
/// <returns>The json, containing companies data from monitor</returns>
public virtual IEnumerable <object> Invoke(
string accessToken,
string requestPath,
string accountId,
string filterStartDate,
string filterEndDate)
{
ApiClient apiClient = new ApiClient(ApiClient.Demo_REST_BasePath);
// Construct API headers
// step 2 start
apiClient.SetBasePath(ApiClient.Demo_REST_BasePath);
apiClient.Configuration.DefaultHeader.Add("Authorization", String.Format("Bearer {0}", accessToken));
apiClient.Configuration.DefaultHeader.Add("Content-Type", "application/json");
// step 2 end
// Declare variables
// step 4 start
DataSetApi dataSetApi = new DataSetApi(apiClient);
WebQuery options = PrepareWebQuery(filterStartDate, filterEndDate, accountId);
var cursoredResult = dataSetApi.PostWebQuery("2.0", "monitor", options);
// step 4 end
return(cursoredResult.Result);
}
protected void GetId5_Click(object sender, EventArgs e)
{
string address = "http://localhost:8081/contacts/";
HttpClient client = this.GetClient(address);
WebQuery <Contact> contacts = client.CreateQuery <Contact>();
var contact = contacts.Skip <Contact>(4).Take <Contact>(1);
string result = string.Empty;
List <Contact> finalList = contact.ToList <Contact>();
if (finalList.Count == 0)
{
result = "There are less than 5 contacts";
}
else
{
result = "Get the 5th contact: ";
result += string.Format(CultureInfo.InvariantCulture, "\r\n Contact Name: {0}, Contact Id: {1}", finalList[0].Name, finalList[0].Id);
}
this.TextBox4.Text = ((WebQuery <Contact>)contact).RequestUri.AbsoluteUri;
this.Result.Text = result;
}
protected void BindData()
{
string condition = "IsDel=0 And GoDate>'" + DateTime.Now.ToString() + "' And ID not in(Select GroupID from PromotionGroup Where PromotionID=" + MyPromotion.ID + ")";
DateTime dtBegin = GetUrlDateTime("bdate");
DateTime dtEnd = GetUrlDateTime("edate");
if (dtBegin != DateTime.MinValue && dtEnd != DateTime.MinValue && dtEnd > dtBegin)
{
condition = condition + " And GoDate>='" + dtBegin.ToStartString() + "' And GoDate<='" + dtEnd.ToEndString() + "'";
}
AdminSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex);
WebQuery query = new WebQuery();
query.Fields = "*";
query.OrderBy = "ID desc";
query.PrimaryKey = "ID";
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = "V_Group_Line";
query.Condition = condition;
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
if (dtBegin != DateTime.MinValue && dtEnd != DateTime.MinValue)
{
tbBegin.Text = dtBegin.ToDateOnlyString();
tbEnd.Text = dtEnd.ToDateOnlyString();
}
}
object list(string userName, string permission)
{
var site = (Site)jc["site"];
WebQuery q = new WebQuery();
q.Id = "users.list";
q.LoadCondidtion();
if (!string.IsNullOrEmpty(userName))
{
q["userName"] = userName;
}
if (!string.IsNullOrEmpty(permission))
{
q["permission"] = permission;
}
q["siteId"] = site.Id;
q.TotalCount = SiteUsers.Count(q);
if (q.PageIndex1 > q.PageCount)
{
q.PageIndex = Math.Max(q.PageCount - 1, 0);
}
var dt = SiteUsers.GetDataTable(q);
var data = new ArrayList();
foreach (DataRow item in dt.Rows)
{
data.Add(new
{
id = item["userId"].ToString(),
user_name = item["userName"] is DBNull ? "用户不存在" : item["userName"].ToString(),
display_name = item["displayName"] is DBNull ? "用户不存在" : item["displayName"].ToString(),
mobile = item["mobile"] is DBNull ? "用户不存在" : item["mobile"].ToString(),
email = item["email"] is DBNull ? "用户不存在" : item["email"].ToString(),
post_count = item["postCount"].ToInt(),
permission = StringEnum <PermissionLevel> .ToString(StringEnum <PermissionLevel> .SafeParse(item["permission"].ToString())),
date_created = item["dateCreated"].ToDateTime(),
date_last_visit = item["dateLastVisit"].ToDateTime()
});
}
return(new
{
code = 1,
data = data,
paging = new
{
total_count = q.TotalCount,
page_size = q.PageSize,
page_index = q.PageIndex1
},
orderbys = q.orderbys
});
}
object list(string id, string title, string domain)
{
WebQuery q = new WebQuery();
q.Id = "site.list";
q.LoadCondidtion();
if (!string.IsNullOrEmpty(id))
{
q["siteId"] = id;
}
if (!string.IsNullOrEmpty(title))
{
q["title"] = title;
}
if (!string.IsNullOrEmpty(domain))
{
q["domain"] = domain;
}
q.TotalCount = Site.Count(q);
if (q.PageIndex1 > q.PageCount)
{
q.PageIndex = Math.Max(q.PageCount - 1, 0);
}
var dt = Site.GetDataTable(q);
var data = new ArrayList();
foreach (DataRow item in dt.Rows)
{
data.Add(new
{
id = item["id"].ToString(),
title = item["title"].ToString(),
domain = item["domain"].ToString(),
key_words = item["keyWords"].ToString(),
description = item["description"].ToString(),
display_name = item["displayName"] is DBNull ? string.Empty : item["displayName"].ToString(),
date_created = item["dateCreated"].ToDateTime(),
sort_order = item["sortOrder"].ToInt()
});
}
return(new
{
code = 1,
data = data,
paging = new
{
total_count = q.TotalCount,
page_size = q.PageSize,
page_index = q.PageIndex1
},
orderbys = q.orderbys
});
}
object publish_list(string key, string category)
{
var site = (Site)jc["site"];
WebQuery q = new WebQuery();
q.Id = "posts.publish_list";
q.LoadCondidtion();
if (!string.IsNullOrEmpty(key))
{
q["key"] = key;
}
if (!string.IsNullOrEmpty(category))
{
q["category"] = category;
}
q.TotalCount = Posts.Count(q);
if (q.PageIndex1 > q.PageCount)
{
q.PageIndex = Math.Max(q.PageCount - 1, 0);
}
q["siteId"] = site.Id;
var dt = Posts.GetDataTable(q);
var data = new ArrayList();
foreach (DataRow item in dt.Rows)
{
data.Add(new
{
id = item["id"].ToString(),
site_id = site.Id,
title = item["title"].ToString(),
category = item["category"] is DBNull ? string.Empty : item["category"].ToString(),
date_created = item["dateCreated"].ToDateTime(),
view_count = item["viewCount"].ToInt(),
sort_order = item["sortOrder"].ToInt(),
date_published = item["datePublished"].ToDateTime()
});
}
return(new
{
code = 1,
data = data,
paging = new
{
total_count = q.TotalCount,
page_size = q.PageSize,
page_index = q.PageIndex1
},
orderbys = q.orderbys
});
}
/// <summary>
/// paging list
/// </summary>
protected void list <T>(string queryId) where T : IQueryObject
{
QueryCondition q = new WebQuery();
q.LoadCondidtion();
q.Id = queryId;
list <T>(q);
}
public void WebQueryTest()
{
var fakeUrl = "http://weixin.sogou.com/";
var query = new WebQuery(fakeUrl);
query.Execute();
var res = query.Res;
StringAssert.Contains(res, "<html>");
}
object trash(string key)
{
var site = (Site)jc["site"];
WebQuery q = new WebQuery();
q.Id = "trash.list";
q.LoadCondidtion();
if (!string.IsNullOrEmpty(key))
{
q["key"] = key;
}
q["siteId"] = site.Id;
q["userId"] = jc.UserName;
q.TotalCount = Posts.Count(q);
if (q.PageIndex1 > q.PageCount)
{
q.PageIndex = Math.Max(q.PageCount - 1, 0);
}
var dt = Posts.GetDataTable(q);
var data = new ArrayList();
foreach (DataRow item in dt.Rows)
{
data.Add(new
{
id = item["id"].ToString(),
title = item["title"].ToString(),
category = item["category"] is DBNull ? string.Empty : item["category"].ToString(),
date_created = item["dateCreated"].ToDateTime(),
view_count = item["viewCount"].ToInt(),
sort_order = item["sortOrder"].ToInt(),
status = StringEnum <Status> .ToString(StringEnum <Status> .SafeParse(item["status"].ToString())),
display_name = item["displayName"] is DBNull ? "未知用户" : item["displayName"].ToString(),
date_published = item["datePublished"].ToDateTime()
});
}
return(new
{
code = 1,
data = data,
paging = new
{
total_count = q.TotalCount,
page_size = q.PageSize,
page_index = q.PageIndex1
},
orderbys = q.orderbys
});
}
public virtual HtmlDocument GetPage(string url, string method = "GET")
{
var webQuery = new WebQuery(url)
{
Method = method
};
AddCookies(webQuery);
return(webQuery.GetPage());
}
public async Task GetImageHideIp()
{
var url = new Uri(@"http://www.performance-parts.fr/424-thickbox_default/bac-a-casques-omp-noir.jpg");
var webQuery = new WebQuery(new ProgressCancelNotifier(), false, false, true);
Image image = await webQuery.GetImageAsync(url);
if (image == null)
{
throw new Exception();
}
}
protected virtual void AddCookies(WebQuery webQuery)
{
var cookies = _headerRequestRepository.GetHeaderRequest(HeaderRequestType.Cookie);
if (cookies.Any())
{
foreach (var headerRequest in cookies)
{
webQuery.AddCookie(headerRequest.Name, headerRequest.Value);
}
}
}
private async Task <decimal> GetExchangeRateFromWebAsync(string iFromCurrency, string iToCurrency)
{
Uri url = new Uri(CONVERTURL.FormatString(iFromCurrency, iToCurrency));
var weQuery = new WebQuery(Notifier, false, WithSafeNetwork);
string htmlResponse = await weQuery.GetSourceAsync(url);
HtmlAgilityPack.HtmlDocument theDocument = new HtmlAgilityPack.HtmlDocument();
theDocument.LoadHtml(htmlResponse);
return(Convert.ToDecimal(theDocument.DocumentNode.SelectSingleNode(".//span[@class='bld']").InnerText.Split(' ').First().Replace(".", ",")));
}
object list(string name)
{
var site = (Site)jc["site"];
WebQuery q = new WebQuery();
q.Id = "widget.list";
q.LoadCondidtion();
if (!string.IsNullOrEmpty(name))
{
q["name"] = name;
}
q["siteId"] = site.Id;
q.TotalCount = Widget.Count(q);
if (q.PageIndex1 > q.PageCount)
{
q.PageIndex = Math.Max(q.PageCount - 1, 0);
}
var dt = Widget.GetDataTable(q);
var data = new ArrayList();
foreach (DataRow item in dt.Rows)
{
data.Add(new
{
id = item["id"].ToString(),
site_id = item["siteId"].ToString(),
name = item["name"].ToString(),
date_created = item["dateCreated"].ToDateTime(),
title = item["title"].ToString(),
container_id = item["containerId"].ToString(),
display_name = item["displayName"] is DBNull ? string.Empty : item["displayName"].ToString()
});
}
return(new
{
code = 1,
data = data,
paging = new
{
total_count = q.TotalCount,
page_size = q.PageSize,
page_index = q.PageIndex1
},
orderbys = q.orderbys
});
}
public async Task GetHtmlSource()
{
var url = new Uri(@"https://www.google.fr");
var webQuery = new WebQuery(new ProgressCancelNotifier(), false, false);
string sourcehtml = await webQuery.GetSourceAsync(url);
string sourcehtml2 = webQuery.GetSource(url);
if (sourcehtml.IsNullOrEmpty())
{
throw new Exception();
}
}
/// <summary>
/// Get list of <see cref="Person"/> from the service
/// </summary>
/// <param name="filter"></param>
/// <returns>List of <see cref="Person"/></returns>
/// <remarks>
/// NOTE: In reality, this API should be filtering and paging on the server to cater for realistic data sets
/// </remarks>
public async Task <IEnumerable <Person> > GetPersonsAsync(string filter = null)
{
// Get the list of people from the service
IEnumerable <Person> persons = await WebQuery.GetJson <IEnumerable <Person> >(new Uri($"{BaseUrl}?includeColours=true"), new CancellationTokenSource().Token);
// Optionally filter it
if (!string.IsNullOrEmpty(filter))
{
persons = persons.Where(p => p.FullName.ToLower().Contains(filter.ToLower())).ToList <Person>();
}
return(persons);
}
public void SaveToDatabase(WebQuery model)
{
EF.Models.RentalFinderEntities rentalFinderEntities = new EF.Models.RentalFinderEntities();
var webquery = new WebQuery()
{
Name = model.Name,
Email = model.Email,
Phone = model.Phone,
Message = model.Message,
CreatedOn = model.CreatedOn
};
//<webquery>
//rentalFinderEntities.SaveChanges(webquery);
}
/// <summary>
/// Maps WebQuery EF object to WebQuery Model Object and
/// returns the WebQuery model object.
/// </summary>
/// <param name="result">EF WebQuery object to be mapped.</param>
/// <returns>WebQuery Model Object.</returns>
public WebQuery MapEFToModel(EF.Models.WebQuery data)
{
var webQuery = new WebQuery()
{
WebQueryId = data.WebQueryId,
Name = data.Name,
EmailAddress = data.EmailAddress,
Body = data.Body,
CreatedOn = data.CreatedOn,
RespondedTo = data.RespondedTo,
};
return(webQuery);
}
object list_with_permission(string parentId)
{
var site = (Site)jc["site"];
#region 校验用户对站点的权限
var relation = (from q in SiteUsers.CreateContext()
where q.UserId == jc.UserName && q.SiteId == site.Id
select q).FirstOrDefault();
//如果没有站点的管理权限
if (relation == null)
{
return new { code = 403, msg = "没有权限访问" }
}
;
#endregion
WebQuery qc = new WebQuery();
qc.Id = "category.list.permission";
qc.LoadCondidtion();
qc.NoPaging();
#region 加载参数
qc["parentId"] = string.IsNullOrWhiteSpace(parentId) ? string.Empty : parentId;
qc["site"] = site.Id;
qc["userId"] = jc.UserName;
#endregion
var dt = CategoryUsers.GetDataTable(qc);
var data = new ArrayList();
foreach (DataRow item in dt.Rows)
{
data.Add(new
{
id = item["id"].ToString(),
name = item["title"].ToString(),
isParent = item["hasChildren"].ToBoolean()
});
}
return(data);
}
protected void BindData()
{
string condition = "IsDel=0";
string keyword = GetUrlString("keyword");
int catID = GetUrlInt("CatID");
if (!keyword.IsNullOrEmpty())
{
condition = condition + " And Name like '%" + keyword + "%'";
}
if (catID > 0)
{
LineCatInfo cat = allCats.Find(s => s.ID == catID);
if (cat != null)
{
if (cat.ParentID == 0)
{
condition = condition + " And FirstCatID=" + catID;
}
else
{
condition = condition + " And SecondCatID=" + catID;
}
}
}
AdminSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex);
WebQuery query = new WebQuery();
query.Fields = LineInfo.AllFields;
query.OrderBy = "ID desc";
query.PrimaryKey = LineInfo.TablePrimaryKey;
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = LineInfo.TableOrViewName;
query.Condition = condition;
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
tbKeyWord.Text = keyword;
ddlCat.SelectedValue = catID.ToString();
}
