public MyLink GetMyLink(int id)
{
MyLink myLink = new MyLink();
myLink.MyLinkId = 199;
myLink.Name = "My first Link";
return(myLink);
}
public override void ToStream(Stream output)
{
output.Write(TLUtils.SignatureToBytes(Signature));
MyLink.ToStream(output);
ForeignLink.ToStream(output);
User.ToStream(output);
}
private static string GetUrl(MyLink link, string path)
{
var trimmedPath = path.TrimLastCharacter();
return(link.QueryString.IsNullOrEmpty()
? trimmedPath
: $"{trimmedPath}?{link.QueryString}");
}
private static string GetUrl(MyLink link, IPublishedContent content)
{
if (link.QueryString.IsNullOrEmpty())
{
return(content.Url);
}
return($"{content.Url}?{link.QueryString}");
}
public void CreateMyLink(MyLink myLink)
{
if (myLink == null)
{
throw new ArgumentException(nameof(myLink));
}
myLink.CreatedTime = DateTime.Now;
_context.MyLinks.Add(myLink);
}
void IMyLinksService.CreateMyLink(MyLink myLink, string nameId)
{
ExtranetUser user = _extranetUserRepository.GetExtranetUser(nameId);
if (user == null)
{
throw new NullReferenceException();
}
myLink.UserId = user.UserId;
_myLinksRepository.CreateMyLink(myLink);
}
public void GetMyLinkTest()
{
int id = 29;
MyLink testLink = new MyLink
{
MyLinkId = 29
};
_mockMyLinksRepository.Setup(x => x.GetMyLink(id)).Returns(testLink);
var myLink = _sut.GetMyLink(id);
Assert.Equal(id, myLink.MyLinkId);
}
public Guid Create(MyLinkDTO model)
{
var entity = new MyLink
{
Id = Guid.NewGuid(),
UserId = model.UserId,
ContentId = model.ContentId,
QueryString = model.QueryString.Trim('?'),
CreatedDate = DateTime.UtcNow,
ActivityId = model.ActivityId
};
_myLinksRepository.Add(entity);
return(entity.Id);
}
public void AddNewLinkTest()
{
MyLink testLink = new MyLink
{
MyLinkId = 29
};
List <MyLink> myTestLinks = new List <MyLink>();
myTestLinks.Add(testLink);
bool result = true;
_mockMyLinksRepository.Setup(x => x.CreateMyLink(testLink));
_mockMyLinksRepository.Setup(x => x.SaveChanges()).Returns(result);
Assert.True(result);
}
public void GetMyLinksTest()
{
int id = 29;
MyLink testLink = new MyLink
{
MyLinkId = 29
};
List <MyLink> myTestLinks = new List <MyLink>();
myTestLinks.Add(testLink);
_mockMyLinksRepository.Setup(x => x.GetMyLinks()).Returns(myTestLinks);
var myLinks = _sut.GetMyLinks().ToList <MyLink>();
Assert.Single(myLinks);
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
MyLink link = new MyLink();
link.L_Title = txtTitle.Text;
link.L_URL = txtURL.Text;
link.L_SID = ((UserInfo)Session["ServiceUser"]).U_SID;
if (ViewState["strAction"].ToString() == "update")
{
link.L_ID = Convert.ToInt32(ViewState["lid"]);
MyLinkService.Update_MyLink(link);
}
else if (ViewState["strAction"].ToString() == "add")
{
MyLinkService.Insert_MyLink(link);
}
CommonFunction.AlertAndRedirect(Literal1, "操作成功", "MyLinkMgr.aspx");
}
private string LoadEntities(HttpContext context)
{
var fbsj = "00";//context.Request["fbsj"];
var gzgw = context.Request["work"];
var ssldbm = context.Request["place"];
var page = context.Request["page"];
string url = string.Format(@"http://fjlylm.com/vizpxx.asp?ssldbm={0}&gzgw={1}&fbsj={2}&page={3}", ssldbm, gzgw, fbsj, page);
string content = CommonUtility.HttpUtility.Get(url, System.Text.Encoding.Default);
int iTableStart = content.IndexOf("<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"95%\" class=\"pix9\">", 0);
if (iTableStart < 1)
{
return("");
}
int iTableEnd = content.IndexOf("</table>", iTableStart);
if (iTableEnd < 1)
{
return("");
}
string strWeb = content.Substring(iTableStart, iTableEnd - iTableStart);
#region Tr列表
//生成HtmlDocument
HtmlDocument doc = new HtmlDocument();
doc.LoadHtml(strWeb);
List <MyLink> myLinkList = new List <MyLink>();
foreach (HtmlNode trNode in doc.DocumentNode.SelectNodes("//tr"))
{
if (!trNode.InnerHtml.Contains("font"))
{
var mylink = new MyLink();
foreach (HtmlNode tdNode in trNode.ChildNodes)
{
HtmlAttribute width = tdNode.Attributes["width"];
if (width == null)
{
continue;
}
HtmlNode node;
switch (width.Value)
{
case "40%":
node = tdNode.ChildNodes.FindFirst("a");
mylink.Url = node.OuterHtml.Replace("zwxq.asp", "WorkDetail.html");
break;
case "35%":
node = tdNode.ChildNodes.FindFirst("p");
mylink.Work = node.InnerHtml.Trim();
break;
case "10%":
node = tdNode.ChildNodes.FindFirst("p");
mylink.Num = node.InnerHtml.Trim();
break;
case "12%":
node = tdNode.ChildNodes.FindFirst("p");
mylink.Time = node.InnerHtml.Trim();
break;
default:
break;
}
}
myLinkList.Add(mylink);
}
}
#endregion
if (myLinkList.Count > 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("<table class=\"table table-bordered\"><thead><tr><th>企业名称</th><th>招聘职位</th><th>招聘人数</th><th>登记时间</th></tr></thead><tbody>");
foreach (var item in myLinkList)
{
sb.AppendFormat(
"<tr><th scope=\"row\">{0}</th><td>{1}</td><td>{2}</td><td>{3}</td></tr>",
item.Url, item.Work, item.Num, item.Time
);
}
sb.Append("</tbody></table>");
//分页
int iPageStart = content.IndexOf("<p align='center' vAlign='bottom'>", 0);
if (iPageStart < 1)
{
return(sb.ToString());
}
int iPageEnd = content.IndexOf("转到：", iPageStart);
if (iPageEnd < 1)
{
return(sb.ToString());
}
string pageContent = content.Substring(iPageStart, iPageEnd + 3 - iPageStart);
HtmlDocument pageDoc = new HtmlDocument();
pageDoc.LoadHtml(pageContent);
MyPage mypage = new MyPage();
var ANodeList = pageDoc.DocumentNode.SelectNodes("//a");
if (ANodeList == null)
{
return(sb.ToString());
}
foreach (HtmlNode aNode in ANodeList)
{
if (aNode.ChildNodes.FindFirst("font").InnerHtml == "上一页")
{
mypage.Previous = aNode.Attributes["href"].Value;
}
else
{
mypage.Next = aNode.Attributes["href"].Value;
}
}
iPageStart = pageContent.IndexOf("] ", "] ".Length);
iPageEnd = pageContent.IndexOf("转到：", iPageStart);
mypage.Desc = pageContent.Substring(iPageStart, iPageEnd - iPageStart);
sb.AppendFormat(
"<nav><ul class=\"pager\"><li><a href='#'onclick=\"queryPage({0})\">上一页</a></li><li><a href='#'onclick=\"queryPage({1})\">下一页</a></li><li>{2}</li><li style=\"display:none;\">转到{3}</li></ul></nav>"
, GetPageParam(mypage.Previous), GetPageParam(mypage.Next), mypage.Desc, mypage.SelPage
);
return(sb.ToString());
}
return("");
}
public void DeleteMyLink(MyLink myLink)
{
_context.Remove(myLink);
}
public void UpdateMyLink(MyLink myLink)
{
throw new NotImplementedException();
}
public void DeleteMyLink(MyLink myLink)
{
_myLinksRepository.DeleteMyLink(myLink);
}
public void UpdateMyLink(MyLink myLink)
{
_myLinksRepository.UpdateMyLink(myLink);
}
public MyLink GetMyLink(int id, int userId)
{
MyLink result = _context.MyLinks.FirstOrDefault(p => p.MyLinkId == id && p.UserId == userId);
return(result);
}
public frmInputPipeLength(MyLink link, SystemVRF sysItem)
{
InitializeComponent();
this.mylink = link;
this._sysItem = sysItem;
}
/// <summary>
/// 编辑友情链接信息
/// </summary>
/// <param name="link"></param>
/// <returns></returns>
public static int Update_MyLink(MyLink link)
{
string sqlStr = "update T_MyLink set L_Title='" + link.L_Title + "',L_URL='" + link.L_URL + "',L_SID='" + link.L_SID + "' where L_ID=" + link.L_ID;
return(DBHelper.ExecuteCommand(sqlStr));
}
/// <summary>
/// 添加友情链接
/// </summary>
/// <param name="link"></param>
/// <returns></returns>
public static int Insert_MyLink(MyLink link)
{
string sqlStr = "insert into T_MyLink(L_Title,L_URL,L_SID) values('" + link.L_Title + "','" + link.L_URL + "','" + link.L_SID + "')";
return(DBHelper.ExecuteCommand(sqlStr));
}
public void UpdateMyLink(MyLink myLink)
{
_context.Update(myLink);
}
public string LoadNewlist(HttpContext context)
{
var fbsj = "00";
var gzgw = context.Request["work"];
var ssldbm = context.Request["place"];
var page = context.Request["page"];
string url = string.Format(@"http://fjlylm.com/vizpxx.asp?ssldbm={0}&gzgw={1}&fbsj={2}&page={3}", ssldbm, gzgw, fbsj, page);
string content = CommonUtility.HttpUtility.Get(url, System.Text.Encoding.Default);
int iTableStart = content.IndexOf("<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"95%\" class=\"pix9\">", 0);
if (iTableStart < 1)
{
return("");
}
int iTableEnd = content.IndexOf("</table>", iTableStart);
if (iTableEnd < 1)
{
return("");
}
string strWeb = content.Substring(iTableStart, iTableEnd - iTableStart);
#region Tr列表
//生成HtmlDocument
HtmlDocument doc = new HtmlDocument();
doc.LoadHtml(strWeb);
List <MyLink> myLinkList = new List <MyLink>();
foreach (HtmlNode trNode in doc.DocumentNode.SelectNodes("//tr"))
{
if (!trNode.InnerHtml.Contains("font"))
{
var mylink = new MyLink();
foreach (HtmlNode tdNode in trNode.ChildNodes)
{
HtmlAttribute width = tdNode.Attributes["width"];
if (width == null)
{
continue;
}
HtmlNode node;
switch (width.Value)
{
case "40%":
node = tdNode.ChildNodes.FindFirst("a");
mylink.Url = node.OuterHtml.Replace("zwxq.asp", "detail.html");
break;
case "35%":
node = tdNode.ChildNodes.FindFirst("p");
mylink.Work = node.InnerHtml.Trim();
break;
case "10%":
node = tdNode.ChildNodes.FindFirst("p");
mylink.Num = node.InnerHtml.Trim();
break;
case "12%":
node = tdNode.ChildNodes.FindFirst("p");
mylink.Time = node.InnerHtml.Trim();
break;
default:
break;
}
}
myLinkList.Add(mylink);
}
}
#endregion
if (myLinkList.Count > 0)
{
var tableJson = new TableJson()
{
myLinkList = myLinkList
};
//分页
int iPageStart = content.IndexOf("<p align='center' vAlign='bottom'>", 0);
if (iPageStart < 1)
{
return(GetJson(tableJson));
}
int iPageEnd = content.IndexOf("转到：", iPageStart);
if (iPageEnd < 1)
{
return(GetJson(tableJson));
}
string pageContent = content.Substring(iPageStart, iPageEnd + 3 - iPageStart);
HtmlDocument pageDoc = new HtmlDocument();
pageDoc.LoadHtml(pageContent);
MyPage mypage = new MyPage();
var ANodeList = pageDoc.DocumentNode.SelectNodes("//a");
if (ANodeList == null)
{
return(GetJson(tableJson));
}
foreach (HtmlNode aNode in ANodeList)
{
if (aNode.ChildNodes.FindFirst("font").InnerHtml == "上一页")
{
mypage.Previous = GetPageParam(aNode.Attributes["href"].Value);
}
else
{
mypage.Next = GetPageParam(aNode.Attributes["href"].Value);
}
}
iPageStart = pageContent.IndexOf("] ", "] ".Length);
iPageEnd = pageContent.IndexOf("转到：", iPageStart);
mypage.Desc = pageContent.Substring(iPageStart, iPageEnd - iPageStart).Replace("]", "");
tableJson.mypage = mypage;
return(GetJson(tableJson));
}
return("");
}
public TableJson LoadEntities(string queryPage, int currentPageIndex, List <WhereParam> whereList)
{
string cmdWhere = "";
List <OracleParameter> parameters = new List <OracleParameter>();
whereList.ForEach(p =>
{
cmdWhere += string.Format(p.Where, p.ParameterName);
parameters.Add(new OracleParameter()
{
ParameterName = p.ParameterName,
Value = p.Value
});
});
string sqlSelect = @"select count(*) from LYJYGD.ZP03 w inner join LYJYGD.ZP01 c on w.ZPA001=C.ZPA001
where w.ZPC006=1 and w.ZPC010=0 {0} ";
string commandText = string.Format(sqlSelect, cmdWhere);
int count = 0;
try
{
count = int.Parse(
OracleHelper.ExecuteScalar(OracleHelper.ConnectionString, CommandType.Text, commandText, parameters).ToString()
);
}
catch (Exception ex)
{
return(null);
}
int pageSize = 10;
sqlSelect = @"
select *
from (select a.*, rownum rn
from (select w.ZPC001,
w.ZPA001,
w.ZPA002,
w.ZPB003,
w.ZPC002,
w.ZPC004
from LYJYGD.ZP03 w
inner join LYJYGD.ZP01 c
on w.ZPA001 = C.ZPA001
where w.ZPC006 = 1
and w.ZPC010 = 0 {0}
order by w.ZPC004 desc, w.ZPA002) a)
where rn >{1}
and rn <{2}
";
commandText = string.Format(sqlSelect, cmdWhere, (currentPageIndex - 1) * pageSize, currentPageIndex * pageSize + 1);
var reader = OracleHelper.ExecuteReader(OracleHelper.ConnectionString, CommandType.Text, commandText, parameters);
StringBuilder sb = new StringBuilder();
List <MyLink> myLinkList = new List <MyLink>();
while (reader.Read())
{
try
{
MyLink mylink = new MyLink(); //target=\"_blank\"
mylink.Url = string.Format("<a href=\"detail.html?id={0}\">{1}</a>", reader["ZPC001"].ToString(), reader["ZPA002"]);
mylink.Work = reader["ZPB003"].ToString();
mylink.Company = reader["ZPA002"].ToString();
mylink.Num = reader["ZPC002"].ToString();
mylink.Time = ((DateTime)reader["ZPC004"]).ToString("yyyy-MM-dd");
myLinkList.Add(mylink);
}
catch (Exception ex)
{
return(null);
}
}
MyPage page = new MyPage();
int pageTotals = (int)(count / pageSize) + 1;
if (currentPageIndex - 1 > 0)
{
page.Previous = string.Format("{0},'{1}'", queryPage, currentPageIndex - 1);
}
if (currentPageIndex + 1 <= pageTotals)
{
page.Next = string.Format("{0},'{1}'", queryPage, currentPageIndex + 1);
}
page.SelPage = pageTotals.ToString();
page.Desc = string.Format(" 页次：<strong><font color=\"red\">{0}</font>/{1}</strong>页" +
" 共<b>{2}</b>条信息<b>{3}</b>条信息/页 </div>",
currentPageIndex, page.SelPage, count, pageSize
);
TableJson tableJson = new TableJson();
tableJson.myLinkList = myLinkList;
tableJson.mypage = page;
return(tableJson);
}
