public string dataset_fields1()
{
try
{
CellNo.Send(this.httpRequest_0);
}
catch (Exception)
{
}
string strsql = this.xmlDocument_0.DocumentElement.ChildNodes.Item(0).InnerText;
int iPageNo = int.Parse(this.xmlDocument_0.DocumentElement.ChildNodes.Item(1).InnerText);
int iPageSize = int.Parse(this.xmlDocument_0.DocumentElement.ChildNodes.Item(2).InnerText);
XmlNode oFields = this.xmlDocument_0.DocumentElement.ChildNodes.Item(3);
return(this.dataset_fields1(strsql, iPageNo, iPageSize, oFields, false, null));
}
public XmlNode exportXMLnode()
{
XmlDocument xmlDoc = new XmlDocument();
StringWriter stringWriter = new StringWriter();
XmlTextWriter xmlTextWriter = new XmlTextWriter(stringWriter);
XmlNode rootNode = null;
if (isNodeComment)
{
rootNode = xmlDoc.CreateComment(comment);
xmlDoc.AppendChild(rootNode);
return(rootNode);
}
rootNode = xmlDoc.CreateElement(dimnType.ToString());
xmlDoc.AppendChild(rootNode);
#region IEC61850Server
if (slaveType == SlaveTypes.IEC61850Server)
{
foreach (string attr in arrAttributes)
{
XmlAttribute attrName = xmlDoc.CreateAttribute(attr);
attrName.Value = (string)this.GetType().GetProperty(attr).GetValue(this);
rootNode.Attributes.Append(attrName);
}
XmlAttribute attr2 = xmlDoc.CreateAttribute("ReportingIndex");
attr2.Value = iec61850reportingindex.ToString();
rootNode.Attributes.Append(attr2);
XmlAttribute attrDataType = xmlDoc.CreateAttribute("DataType");
attrDataType.Value = DataType.ToString();
rootNode.Attributes.Append(attrDataType);
XmlAttribute attrCommandType = xmlDoc.CreateAttribute("CommandType");
attrCommandType.Value = CommandType.ToString();
rootNode.Attributes.Append(attrCommandType);
XmlAttribute attrDeadband = xmlDoc.CreateAttribute("BitPos");
attrDeadband.Value = BitPos.ToString();
rootNode.Attributes.Append(attrDeadband);
XmlAttribute attrMultiplier = xmlDoc.CreateAttribute("Complement");
attrMultiplier.Value = Complement.ToString();
rootNode.Attributes.Append(attrMultiplier);
XmlAttribute attrConstant = xmlDoc.CreateAttribute("Description");
attrConstant.Value = Description.ToString();
rootNode.Attributes.Append(attrConstant);
}
#endregion IEC61850Server
#region SPORTSLAVE,IEC101SLAVE,IEC104,MODBUSSLAVE,UNKNOWN
if ((slaveType == SlaveTypes.DNP3SLAVE) || (slaveType == SlaveTypes.SPORTSLAVE) || (slaveType == SlaveTypes.IEC101SLAVE) || (slaveType == SlaveTypes.IEC104) || (slaveType == SlaveTypes.MODBUSSLAVE) || (slaveType == SlaveTypes.UNKNOWN) || (slaveType == SlaveTypes.MQTTSLAVE) || (slaveType == SlaveTypes.SMSSLAVE))
{
foreach (string attr in arrAttributes)
{
XmlAttribute attrName = xmlDoc.CreateAttribute(attr);
attrName.Value = (string)this.GetType().GetProperty(attr).GetValue(this);
rootNode.Attributes.Append(attrName);
}
}
#endregion SPORTSLAVE,IEC101SLAVE,IEC104,MODBUSSLAVE,UNKNOWN
#region GDisplaySlave
if (slaveType == SlaveTypes.GRAPHICALDISPLAYSLAVE)
{
foreach (string attr in arrAttributes)
{
XmlAttribute attrName = xmlDoc.CreateAttribute(attr);
attrName.Value = (string)this.GetType().GetProperty(attr).GetValue(this);
rootNode.Attributes.Append(attrName);
}
XmlAttribute attrCellNo = xmlDoc.CreateAttribute("CellNo");
attrCellNo.Value = CellNo.ToString();
rootNode.Attributes.Append(attrCellNo);
XmlAttribute attrWidget = xmlDoc.CreateAttribute("Widget");
attrWidget.Value = Widget.ToString();
rootNode.Attributes.Append(attrWidget);
//XmlAttribute attrUnit = xmlDoc.CreateAttribute("Unit");
//attrUnit.Value = UnitID.ToString();
//rootNode.Attributes.Append(attrUnit);
XmlAttribute attrComplement = xmlDoc.CreateAttribute("Complement");
attrComplement.Value = Complement.ToString();
rootNode.Attributes.Append(attrComplement);
XmlAttribute attrDescription = xmlDoc.CreateAttribute("Description");
attrDescription.Value = Description.ToString();
rootNode.Attributes.Append(attrDescription);
}
#endregion GDisplaySlave
return(rootNode);
}
public static string getRes(ConnectionConfig connConfig, XmlDocument xdoc, HttpRequest Request)
{
string sendData = xdoc.DocumentElement.OuterXml;
string str2 = Request[("userId")];
string str3 = "";
string str4 = "";
DBOperator @operator = connConfig.getDBOperator();
@operator.Open();
IDbCommand myComm = @operator.Connection.CreateCommand();
myComm.Connection = (@operator.Connection);
string strSql = "SELECT FCQ_ORG.vpath,FCQ_ORG.java_dotnet FROM FCQ_BUG_USER INNER JOIN FCQ_ORG ON FCQ_BUG_USER.org_name = FCQ_ORG.org_name WHERE FCQ_BUG_USER.item_name = FCQ_ORG.item_name and FCQ_BUG_USER.fcbug_user_id = '" + str2 + "'";
IDataReader reader = @operator.exeSql(strSql);
if (reader.Read())
{
str3 = reader.GetString(0);
str4 = reader.GetString(1);
}
reader.Close();
string str9 = "/ebsys/eformaspx/webbill.aspx";
if ((str4 != "") && (str4 != ".net版"))
{
str9 = "/servlet/WebBill";
}
Logger.debug(str3 + str9 + "?key=readDomainRes xml=" + sendData);
string str8 = CellNo.domainRun(str3 + str9 + "?key=readDomainRes", sendData);
Logger.debug("content:" + str8);
string str6 = "";
if (str8.Length <= 0)
{
return("从数据库中没有取到资源内容!");
}
IDbTransaction transaction = null;
transaction = @operator.Connection.BeginTransaction();
myComm.Transaction = (transaction);
try
{
str6 = new MaxNo(connConfig, xdoc).getRecnum1("RES", myComm);
Logger.debug("resId=" + str6);
myComm.CommandText = ("insert into fcq_bug_res (res_id,res_text) values ('" + str6 + "','" + str8.Replace("'", "''") + "')");
myComm.ExecuteNonQuery();
transaction.Commit();
myComm.Dispose();
@operator.Close();
}
catch (Exception exception)
{
try
{
transaction.Rollback();
}
catch (Exception)
{
}
Logger.debug(exception.StackTrace);
throw exception;
}
finally
{
try
{
@operator.Close();
}
catch (Exception)
{
}
}
return(str6);
}
