/// <summary>
/// 获得某一个xpath的详细信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Xpath getInfo(Guid id)
{
Xpath path = new Xpath();
DatabaseAccess database = new DatabaseAccess();
String sql = "select * from xpath where id='" + id + "'";
try {
SqlDataReader data = database.executeQuery(sql);
if (data.Read()) {
path.Id = data.GetGuid(0);
path.Websitename = data.GetString(1);
path.Weblanguage = data.GetString(2);
path.Baseurl = data.GetString(3);
path.Cntitle = data.GetString(4);
path.Entitle = data.GetString(5);
path.Unit = data.GetString(6);
path.Types = data.GetString(7);
path.Author = data.GetString(8);
path.Articletype = data.GetString(9);
path.Source = data.GetString(10);
path.Language = data.GetString(11);
path.Journalname = data.GetString(12);
path.Publishtime = data.GetString(13);
path.Levels = data.GetString(14);
path.Recordtype = data.GetString(15);
path.Forbid = (int)data["forbid"];
}
} catch (Exception e) {
throw new Exception(e.Message);
} finally {
database.close();
}
return path;
}
public override int GetHashCode()
{
var hashCode = (Name != null ? Name.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Code != null ? Code.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Base != null ? Base.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Type != null ? Type.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Description != null ? Description.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Xpath != null ? Xpath.GetHashCode() : 0);
return(hashCode);
}
public TaoMoiVuAnPopUp()
{
x = new Xpath();
#region Controls initialize
quyetĐinhKhoiToVuAnSo = new TextBox("quyết định khởi tố vụ án số", x.D["inputQuyetDinhKhoiToVuAnSo"], "");
ngayQuyetDinhKhoiToVuAn = new DateTimePicker("chọn ngày", x.D["buttonNgayQuyetDinhKhoiToVuAn"], "");
ngayQdMot = new Other("ngày 1", x.D["ngayMot"], "");
ngayQd = new Other("chọn ngày", x.D["Ngay15QuyetDinhKhoiToVuAn"], "");
coQuanRaQuyetDinh = new ComboBox("cơ quan ra QĐ", x.D["dropdownCoQuanRaQuyetDinh"], "");
coQuanCongAn = new Other("cơ quan công an", x.D["coQuanCongAn"], "");
dieuLuatVu = new TextBox("điều luật vụ", x.D["inputDieuLuatVu"], "");
toiVuKhong = new Other("tội vu khống", x.D["toiVuKhong"], "");
donViRaQuyetDinh = new TextBox("đơn vị ra QĐ", x.D["inputDonViRaQuyetDinh"], "");
tenVuAn = new TextBox("tên vụ án", x.D["inputTenVuAn"], "");
maVuCuaToaAn = new TextBox("mã vụ của tòa án", x.D["inputMaVuCuaToaAn"], "");
clickLoaiToiPham = new CheckBox("loại tội phạm check", x.D["clickLoaiToiPham"], "");
btnLoaiToiPhamChuaXD = new Button("chưa xác định", x.D["btnLoaiToiPhamChuaXD"], "");
chonLoaiToiPham = new Button("chọn loại tội phạm", x.D["chonLoaiToiPham"], "");
btnLoaiToiPhamItNghiemTrong = new Button("ít nghiêm trọng", x.D["btnLoaiToiPhamItNghiemTrong"], "");
btnLoaiToiPhamNghiemTrong = new Button("nghiêm trọng", x.D["btnLoaiToiPhamNghiemTrong"], "");
btnLoaiToiPhamRatNghiemTrong = new Button("rất nghiêm trọng", x.D["btnLoaiToiPhamRatNghiemTrong"], "");
btnLoaiToiPhamDacBietNghiemTrong = new Button("đặc biệt nghiêm trọng", x.D["btnLoaiToiPhamDacBietNghiemTrong"], "");
txtNgayXayRa = new TextBox("ngày xảy ra", x.D["txtNgayXayRa"], "");
ngayXayRa = new DateTimePicker("ngày xảy ra", x.D["inputThang"], "");
thang = new TextBox("tháng", x.D["inputThang"], "");
nam = new TextBox("năm", x.D["inputNam"], "");
gio = new TextBox("giờ", x.D["inputGio"], "");
noiXayRa = new TextBox("nơi xảy ra", x.D["inputNoiXayRa"], "");
chiTietNoiXayRa = new TextBox("chi tiết nơi xảy ra", x.D["inputChiTietNoiXayRa"], "");
ghiChu = new TextBox("ghi chú", x.D["inputGhiChu"], "");
ghiAmGhiHinhBiMat = new CheckBox();
ngheDienThoaiBiMat = new CheckBox();
thuThapBiMatDuLieuDienTu = new CheckBox();
ghiLai = new Button("buttonGhiLai", x.D["buttonGhiLai"], "");
quayLai = new Button("buttonQuayLai", x.D["buttonQuayLai"], "");
ngayQDKhoiToTuNgayText = new TextBox("txt ngày quyết định khởi tố", x.D["ngayQDKhoiToTuNgayText"], "");
ngayQDKhoiToDenNgayText = new TextBox("txt ngày quyết định khởi tố", x.D["ngayQDKhoiToDenNgayText"], "");
txtNgayQDKhoiToVuAn = new TextBox("text ngày quyết định khởi tố vụ án", x.D["txtNgayQDKhoiToVuAn"], "");
o = new Other();
#endregion
//x = new Xpath();
//this.driver = driver;
}
public Page()
{
//actionCount = 0;
xpath = new Xpath();
maVuAn = new TextBox("mã vụ án", xpath.D["maVuAn"], "");
tenVuAn = new TextBox("tên vụ án", xpath.D["tenVuAn"], "");
tenBiCan = new TextBox("tên bị can", xpath.D["inputTenBiCan"], "");
toiDanh = new TextBox("tội danh", xpath.D["inputToiDanh"], "");
QDKhoiToVuAnSo = new TextBox("tội danh", xpath.D["inputToiDanh"], "");
noiDKHKTT = new TextBox("nơi đk hộ khẩu thường trú", xpath.D["noiDkhktt"], "");
noiOHienTai = new TextBox("ct nơi ở hiện tại", xpath.D["chiTietNoiOHienTai"], "");
tenKSVien = new TextBox("tên KSV", xpath.D["tenKsVien"], "");
thuLySo = new TextBox("thụ lý số", xpath.D["thuLySo"], "");
timKiem = new Button("tìm kiếm", xpath.D["timKiem"], "");
doiGiaoDien = new Button();
}
/// <summary>
/// 插入一条数据到数据库
/// </summary>
/// <param name="path">Xpath的对象</param>
/// <returns></returns>
public Boolean insert(Xpath path)
{
Boolean insert = false;
DatabaseAccess database = new DatabaseAccess();
String sql = "insert into xpath(id,websitename,weblanguage,baseurl,cntitle,entitle,unit,types,author,articletype,source,language,journalname,publishtime,levels,recordtype,forbid) values(NewId(),'"
+ path.Websitename + "','" + path.Weblanguage + "','" + path.Baseurl + "','" + path.Cntitle + "','" + path.Entitle + "','" + path.Unit + "','" + path.Types + "','" + path.Author + "','" + path.Articletype + "','" + path.Source + "','" + path.Language + "','" + path.Journalname + "','" + path.Publishtime + "','" + path.Levels + "','" + path.Recordtype + "',0)";
try {
insert = database.executeUpdate(sql);
} catch (Exception e) {
throw new Exception(e.Message);
} finally {
database.close();
}
return insert;
}
/// <summary>
/// 获得所有已经添加到数据库的论文网站
/// </summary>
/// <returns></returns>
public List<Xpath> webSiteList()
{
List<Xpath> webList = new List<Xpath>();
DatabaseAccess database = new DatabaseAccess();
String sql = "select id,websitename,baseurl from xpath where forbid=1";
try {
SqlDataReader result = database.executeQuery(sql);
while (result.Read()) {
Xpath path = new Xpath();
path.Id = result.GetGuid(0);
path.Baseurl = result.GetString(2);
path.Websitename = result.GetString(1) + "(" + path.Baseurl + ")";
webList.Add(path);
}
} catch (Exception e) {
throw new Exception(e.Message);
} finally {
database.close();
}
return webList;
}
/// <summary>
/// 更新整个数据的内容
/// </summary>
/// <param name="path">xpath的实例</param>
/// <returns></returns>
public Boolean update(Xpath path)
{
Boolean update = false;
DatabaseAccess database = new DatabaseAccess();
string sql = "update xpath set websitename='" + path.Websitename + "',weblanguage='" + path.Weblanguage + "',baseurl='" + path.Baseurl + "',cntitle='" + path.Cntitle + "',entitle='" + path.Entitle + "',unit='" + path.Unit + "',author='" + path.Author + "',types='" + path.Types + "',articletype='" + path.Articletype + "',source='" + path.Source + "',language='" + path.Language + "',journalname='" + path.Journalname + "',publishtime='" + path.Publishtime + "',levels='" + path.Levels + "',recordtype='" + path.Recordtype + "',forbid=" + path.Forbid + " where id='" + path.Id+"'";
try {
update = database.executeUpdate(sql);
} catch (Exception e) {
throw new Exception(e.Message);
}
return update;
}
/// <summary>
/// 获得抓取规则的所有数据
/// </summary>
/// <param name="page">第几页</param>
/// <param name="size">每页显示的数据</param>
/// <returns></returns>
public List<Xpath> pathList(int page,int size)
{
List<Xpath> pathList = new List<Xpath>();
DatabaseAccess database = new DatabaseAccess();
String sql = "select top(" + size + ") * from xpath where id not in(select top( " + (page - 1) * size + ") id from xpath)";
try {
SqlDataReader result = database.executeQuery(sql);
while (result.Read()) {
Xpath path = new Xpath();
path.Id = (Guid)result["id"];
path.Baseurl = result["baseurl"].ToString();
path.Websitename = result["websitename"].ToString();
path.Weblanguage = result["weblanguage"].ToString();
path.Cntitle = result["cntitle"].ToString();
path.Entitle = result["entitle"].ToString();
path.Unit = result["unit"].ToString();
path.Types = result["types"].ToString();
path.Author = result["author"].ToString();
path.Articletype = result["articletype"].ToString();
path.Source = result["source"].ToString();
path.Language = result["language"].ToString();
path.Journalname = result["journalname"].ToString();
path.Publishtime = result["publishtime"].ToString();
path.Levels = result["levels"].ToString();
path.Recordtype = result["recordtype"].ToString();
path.Forbid = (int)result["forbid"];
pathList.Add(path);
}
} catch (Exception e) {
throw new Exception(e.Message);
} finally {
database.close();
}
return pathList;
}
protected void Page_Load(object sender, EventArgs e)
{
//LogEntry le;
if (PreviousPage != null && PreviousPage.IsValid)
{
var tb = (TextBox)PreviousPage.FindControl("tbXmlUri");
if (tb == null || string.IsNullOrEmpty(tb.Text))
{
string error = "<h2>Unable to read XML URL</h2>";
LiteralControl lc = new LiteralControl(error);
phAnchors.Controls.Add(lc);
return;
}
string xmlUrl = tb.Text;
string[] permittedProtocols = new string[] { "http", "https" };
if (!Util.UrlHasPermittedProtocol(xmlUrl, permittedProtocols))
{
//le = new LogEntry();
//le.Categories.Add(LogCategory.GENERAL);
//le.Title = "Invalid protocol in XML URL";
//le.Message = xmlUrl;
//le.Severity = TraceEventType.Error;
//le.ExtendedProperties.Add(new KeyValuePair<string, object>("Client IP", Request.UserHostAddress));
//Logger.Write(le);
string error = "<h2>Invalid protocol in URL.</h2>";
LiteralControl lc = new LiteralControl(error);
phAnchors.Controls.Add(lc);
return;
}
if (Util.IsUrlReferencingThisMachine(xmlUrl,
Request.ServerVariables["SERVER_NAME"],
Request.ServerVariables["HTTP_HOST"],
permittedProtocols))
{
//le = new LogEntry();
//le.Categories.Add(LogCategory.GENERAL);
//le.Title = "Invalid XML URL";
//le.Message = string.Format("{0} references hosting machine", xmlUrl);
//le.Severity = TraceEventType.Error;
//le.ExtendedProperties.Add(new KeyValuePair<string, object>("Client IP", Request.UserHostAddress));
//Logger.Write(le);
string error = "<h2>Invalid URL.</h2>";
LiteralControl lc = new LiteralControl(error);
phAnchors.Controls.Add(lc);
return;
}
XmlDocument xdoc = new XmlDocument();
try {
/*
* A bunch of exceptions can potentially occur here -
* 1) can't resolve hostname
* 2) unable to connect to remote server
* 3) file not found (404)
* 4) xml parse error
*/
xdoc.Load(xmlUrl);
}
catch (Exception ex) {
string error = "<h2>Error loading XML</h2>";
error += string.Format("<h3>{0}</h3>", ex.Message);
LiteralControl lce = new LiteralControl(error);
phAnchors.Controls.Add(lce);
//LogEntry leEx = new LogEntry();
//leEx.Categories.Add(LogCategory.GENERAL);
//leEx.Title = "XmlDocument.Load() failed";
//leEx.Message = ex.Message;
//leEx.Severity = TraceEventType.Error;
//leEx.ExtendedProperties.Add(new KeyValuePair<string, object>("Xml URL", xmlUrl));
//leEx.ExtendedProperties.Add(new KeyValuePair<string, object>("Client IP", Request.UserHostAddress));
//Logger.Write(leEx);
return;
}
/*
* Make a copy of Application["lstXpathExpressionInfo"] for this request
* so that parallel requests don't overwrite XpathExpressionInfo.NumRequests
*/
List <XpathExpressionInfo> lstXei = Application["lstXpathExpressionInfo"] as List <XpathExpressionInfo>;
List <XpathExpressionInfo> lstXei2 = new List <XpathExpressionInfo>(lstXei.Count);
foreach (var xei in lstXei)
{
lstXei2.Add(XpathExpressionInfo.Duplicate(xei));
}
var matcher = new Xpath();
string matches = string.Empty;
try {
matches = matcher.Match(xdoc, lstXei2);
}
catch (Exception ex) {
string error = "<h2>Error analyzing XML</h2>";
error += string.Format("<h3>{0}</h3>", ex.Message);
LiteralControl lce = new LiteralControl(error);
phAnchors.Controls.Add(lce);
//LogEntry leEx = new LogEntry();
//leEx.Categories.Add(LogCategory.GENERAL);
//leEx.Title = "Xpath.Match() failed";
//leEx.Message = ex.Message;
//leEx.Severity = TraceEventType.Error;
//leEx.ExtendedProperties.Add(new KeyValuePair<string, object>("Xml URL", xmlUrl));
//leEx.ExtendedProperties.Add(new KeyValuePair<string, object>("Client IP", Request.UserHostAddress));
//for (int i = 0; i < lstXei.Count; i++) {
// var xei = lstXei[i];
// string name = "XPath" + (i + 1);
// leEx.ExtendedProperties.Add(new KeyValuePair<string, object>(name, xei.XpathExpression));
//}
//Logger.Write(leEx);
return;
}
LiteralControl lcMatches = new LiteralControl(matches);
phResult.Controls.Add(lcMatches);
//le = new LogEntry();
////le.Categories.Add(LogCategory.REQUESTS);
//le.Title = "Request Successful";
//le.Message = xmlUrl;
//le.Severity = TraceEventType.Information;
//le.ExtendedProperties.Add(new KeyValuePair<string, object>("Client IP", Request.UserHostAddress));
//Logger.Write(le);
}
}
public void GenerateXpath_Click(object sender, EventArgs e)
{
string Tvalue = TvalueTxtBox.Text;
string Target = TargetTxtBox.Text;
if (!string.IsNullOrEmpty(txtLindex.Text))
{
JSupport.Index = txtLindex.Text;
}
string Option = SelectOptions.Text;
if (string.IsNullOrEmpty(Option))
{
MessageBox.Show("控件选择为必填项");
}
else
{
XpathDateView.Rows.Clear();
try
{
switch (Option)
{
case "普通按钮":
Xpath = JXpath.Button(Tvalue, Target);
break;
case "勾选按钮":
Xpath = JXpath.Radio(Tvalue, Target);
break;
case "树节点按钮":
Xpath = JXpath.TreeNode(Tvalue, Target);
break;
case "图标按钮":
Xpath = JXpath.IConButton(Tvalue, Target);
break;
case "普通文本框":
Xpath = JXpath.Input(Target, Tvalue);
break;
case "文件文本框":
Xpath = JXpath.FileInput(Target, Tvalue);
break;
case "普通下拉框":
Xpath = JXpath.Select(Target, Tvalue);
break;
}
}
catch (Exception error)
{
MessageBox.Show(string.Format("{0}：请重试", error));
}
//Print xpath and control format
var Collection = Xpath.Split('|');
foreach (string item in Collection)
{
XpathDateView.Rows.Add(item.Trim());
}
}
}
