using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Text; using System.Data.SqlClient; using System.Collections.Generic; using System.Xml; using DSWeb.EntityDA; namespace DSWeb.FeeCodes { public partial class SysDeptAdapter : System.Web.UI.Page { private string strMark; private string strPos; private int iPos = 0; public string strSubcompany = ""; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strPost = Request.Url.ToString(); if (Request.QueryString["mask"] != null) { strMark = Request.QueryString["mask"].ToString(); } if (Request.QueryString["pos"] != null) { strPos = Request.QueryString["pos"].ToString(); iPos = int.Parse(strPos); } if (Request.QueryString["strSubcompany"] != null) { UnicodeEncoding unicode = new UnicodeEncoding(); strSubcompany = unicode.GetString(unicode.GetBytes(Request.QueryString["strSubcompany"].ToString())); } XmlDocument docs = GetDoc(); Response.ContentType = "text/xml"; Response.Write(docs.OuterXml.ToString()); } } public string BuildXML() { StringBuilder resultBuilder = new StringBuilder(); resultBuilder.Append(""); resultBuilder.AppendFormat("", iPos == 0 ? string.Empty : " add=\"true\""); if (!string.IsNullOrEmpty(strMark)) { string js=""; SysDeptDA SysDeptDA = new SysDeptDA(); DataSet ds = SysDeptDA.GetSysDeptSQL(" and LINKID in (select top 1 GID from company where [NAME]='" + strSubcompany + "' and ISDISABLE=0 and ISDELETED=0)"); if (ds != null) { foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["DEPTNO"].ToString().Trim() != "" || dr["DEPTNAME"].ToString().Trim() != "") { js = dr["DEPTNO"].ToString().Trim() + " | " + dr["DEPTNAME"].ToString().Trim(); resultBuilder.AppendFormat("", dr["DEPTNO"].ToString().Trim(), js);// dr["DEPTNAME"].ToString().Trim()); } } } } resultBuilder.AppendFormat("", "", ""); resultBuilder.Append(""); return resultBuilder.ToString().Replace("&", "&"); } public XmlDocument GetDoc() { XmlDocument xmldoc = new XmlDocument(); string content = BuildXML(); try { xmldoc.LoadXml(content); } catch (Exception) { } return xmldoc; } } }