62,046
社区成员
发帖
与我相关
我的任务
分享
// nest.admin.pages.synchdata
using BusinessRules;
using CommonLibrary;
using nest.admin.pages;
using nest.admin.WebReference;
using System;
using System.Data;
using System.Web;
using System.Web.UI;
using System.Xml;
public class synchdata : Page
{
protected void Page_Load(object sender, EventArgs e)
{
HttpContext.Current.Session["flag"] = ExceptionType.none_exception;
Service1 service = new Service1();
DataTable dataTable = service.AllSeach_Data("CompanyItem", "ID,Url,CompanyName,KeyName1,KeyName2,KeyName3,state", 1, 1, "where [ID]=" + CDataCache.Company.Rows[0]["cid"], "ID", "0", "yanpoyanpo").Tables[0];
if (dataTable.Rows.Count <= 0)
{
return;
}
DataRow dataRow = dataTable.Rows[0];
if (dataRow["State"].ToString() != "3")
{
XmlNode sysXmlNode = CommonClass.GetSysXmlNode("Company");
foreach (DataColumn column in dataTable.Columns)
{
if (!column.ColumnName.ToLower().Equals("ID") && !column.ColumnName.ToLower().Equals("state"))
{
CommonClass.AddNodeAttribute(sysXmlNode, column.ColumnName, dataRow[column.ColumnName].ToString());
}
}
CommonClass.AddNodeAttribute(sysXmlNode, "ID", CDataCache.Company.Rows[0]["id"].ToString());
CommonClass.AddNodeAttribute(sysXmlNode, "OperateType", "2");
int num = (int)CFactory.CPostData(sysXmlNode);
DataTable dataTable2 = ((DataSet)CFactory.CGetData("<KeyInfo />")).Tables[0];
int num2 = (int)CDataCache.Company.Rows[0]["cid"];
for (int i = 0; i < dataTable2.Rows.Count; i++)
{
DataTable dataTable3 = service.AllSeach_Data("VIEW_Guest", "*", 1, 1, "where [Cid]=" + num2 + " and pm=" + dataTable2.Rows[i]["ID"].ToString().Trim(), "ID", "0", "yanpoyanpo").Tables[0];
if (dataTable3.Rows.Count > 0)
{
XmlNode sysXmlNode2 = CommonClass.GetSysXmlNode("KeyInfo");
CommonClass.AddNodeAttribute(sysXmlNode2, "ID", dataTable3.Rows[0]["pm"].ToString());
CommonClass.AddNodeAttribute(sysXmlNode2, "typeid", dataTable3.Rows[0]["TypeID"].ToString());
CommonClass.AddNodeAttribute(sysXmlNode2, "f", dataTable3.Rows[0]["State"].ToString());
CommonClass.AddNodeAttribute(sysXmlNode2, "KeyName", dataTable3.Rows[0]["typename"].ToString().Equals("") ? dataTable3.Rows[0]["Lxr"].ToString() : dataTable3.Rows[0]["typename"].ToString());
CommonClass.AddNodeAttribute(sysXmlNode2, "gid", dataTable3.Rows[0]["ID"].ToString());
CommonClass.AddNodeAttribute(sysXmlNode2, "OperateType", "2");
CFactory.CPostData(sysXmlNode2);
}
}
}
else
{
HttpContext.Current.Session["UserData"] = null;
HttpContext.Current.Session["flag"] = ExceptionType.other_exception;
}
}
}