protected void Page_PreRender(object sender, EventArgs e)
{
this.labelname = BasePage.RequestString("name");
if (!string.IsNullOrEmpty(this.labelname))
{
string path = WebConfigurationManager.AppSettings["EasyOne:LabelXsltPath"];
this.xmlfilepath = HttpContext.Current.Server.MapPath(path) + @"\" + this.labelname + ".config";
this.Dbtype = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelDataType");
string presstr = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelDataSource");
string str3 = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelSqlString");
string istr = string.Empty;
XmlDocument document = new XmlDocument();
document.Load(this.xmlfilepath);
XmlNodeList attriblist = document.SelectNodes("root/attributes");
presstr = this.ParaProc(attriblist, presstr);
str3 = this.ParaProc(attriblist, str3).Replace("@pagesize", "10").Replace("@startrow", "0");
if ((string.Compare(this.Dbtype, "xml_read", StringComparison.OrdinalIgnoreCase) != 0) && string.IsNullOrEmpty(str3))
{
base.Response.Write("查询语句为空！");
}
else
{
istr = LabelManage.GetDBQuery(this.Dbtype, presstr, str3, attriblist);
this.XmlProc(this.Dbtype, presstr, istr);
}
}
else
{
base.Response.Write("标签名称为空！");
}
}
protected void SetInit(string xmlpath)
{
this.TxtLabelType.Text = XmlManage.ReadFileNode(xmlpath, "root/LabelType");
this.TxtLabelIntro.Text = XmlManage.ReadFileNode(xmlpath, "root/LabelIntro");
string strB = XmlManage.ReadFileNode(xmlpath, "root/LabelDataType");
string str2 = XmlManage.ReadFileNode(xmlpath, "root/OutType");
for (int i = 0; i < this.RbtDataType.Items.Count; i++)
{
if ((string.Compare(this.RbtDataType.Items[i].Value, strB, StringComparison.OrdinalIgnoreCase) == 0) && !this.RbtDataType.Items[i].Selected)
{
this.RbtDataType.Items[i].Selected = true;
break;
}
}
for (int j = 0; j < this.RBLOutType.Items.Count; j++)
{
if ((string.Compare(this.RBLOutType.Items[j].Value, str2, StringComparison.OrdinalIgnoreCase) == 0) && !this.RBLOutType.Items[j].Selected)
{
this.RBLOutType.Items[j].Selected = true;
break;
}
}
if ((string.Compare(strB, "static", StringComparison.Ordinal) == 0) || (string.Compare(strB, "sql_sysquery", StringComparison.Ordinal) == 0))
{
this.PanelOutSide.Visible = false;
}
else if (this.PanelOutSide.Visible)
{
if (string.Compare(strB, "ole_read", StringComparison.Ordinal) == 0)
{
string str3 = XmlManage.ReadFileNode(xmlpath, "root/LabelDbPath");
if (string.IsNullOrEmpty(str3))
{
this.TxtDataSource.Text = XmlManage.ReadFileNode(xmlpath, "root/LabelDataSource");
}
else
{
this.TxtDataSource.Text = str3;
}
}
else if (string.Compare(strB, "sql_sysstoredquery", StringComparison.Ordinal) == 0)
{
this.TxtDataSource.Text = XmlManage.ReadFileNode(xmlpath, "root/LabelSqlString");
this.BtnTestDataSource.Visible = false;
}
else
{
this.TxtDataSource.Text = XmlManage.ReadFileNode(xmlpath, "root/LabelDataSource");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.action = BasePage.RequestString("action");
this.labelname = BasePage.RequestString("name");
this.m_LabelLibPath = "~/" + SiteConfig.SiteOption.LabelDir;
if (string.IsNullOrEmpty(this.labelname))
{
BasePage.ResponseRedirect("Label.aspx");
}
else
{
string path = WebConfigurationManager.AppSettings["EasyOne:LabelXsltPath"];
this.xmlfilepath = HttpContext.Current.Server.MapPath(path) + @"\" + this.labelname + ".config";
if (!base.IsPostBack)
{
if (LabelManage.GetAttributeList(this.xmlfilepath).Count == 0)
{
this.attlist.Text = "您尚未建立属性!<a href=\"LabelProperty.aspx?action=" + this.action + "&name=" + this.labelname + "\">建立属性</a>";
}
else
{
foreach (LabelAttributeInfo info in LabelManage.GetAttributeList(this.xmlfilepath))
{
string text = this.attlist.Text;
this.attlist.Text = text + "<div onclick=\"cit()\" outype=\"2\" class=\"spanfixdiv\" alt=\"" + info.Intro + "
默认值：" + info.DefaultValue + "\">" + info.AttributeName + "</div>";
}
}
if (!string.IsNullOrEmpty(XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelTemplate")))
{
this.TxtTemplate.Text = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelTemplate");
}
ListItem item = new ListItem();
item.Text = "全部分类";
this.DropLabelList.DataSource = LabelManage.GetLabelTypeList();
this.DropLabelList.DataTextField = "Name";
this.DropLabelList.DataValueField = "Name";
this.DropLabelList.DataBind();
this.DropLabelList.Items.Insert(0, item);
this.BuildLabelList(string.Empty);
this.TxtTemplateTest.Text = "{PE.Label id=\"" + this.labelname + "\" /}";
}
this.TxtTemplate.Attributes.Add("onmouseup", "dragend(this)");
this.TxtTemplate.Attributes.Add("onClick", "savePos(this)");
this.TxtTemplate.Attributes.Add("onmousemove", "DragPos(this)");
}
this.SmpNavigator.AdditionalNode = this.labelname;
}
protected static DataTable GetDataBaseSchema(string dtype, string xpath, string tablename)
{
switch (dtype)
{
case "sql_sysquery":
return(LabelManage.GetSchemaTable(tablename, string.Empty, DataSourceType.None));
case "sql_outquery":
return(LabelManage.GetSchemaTable(tablename, XmlManage.ReadFileNode(xpath, "root/LabelDataSource"), DataSourceType.Sql));
case "ole_read":
return(LabelManage.GetSchemaTable(tablename, XmlManage.ReadFileNode(xpath, "root/LabelDataSource"), DataSourceType.Ole));
case "odbc_read":
return(LabelManage.GetSchemaTable(tablename, XmlManage.ReadFileNode(xpath, "root/LabelDataSource"), DataSourceType.Odbc));
case "orc_read":
return(LabelManage.GetSchemaTable(tablename, XmlManage.ReadFileNode(xpath, "root/LabelDataSource"), DataSourceType.Oracle));
}
return(null);
}
protected void BtnNext_Click(object sender, EventArgs e)
{
string str = XmlManage.ReadFileNode(this.xmlfilepath, "root/OutType");
string str2 = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelDataType");
if (str2 != null)
{
if (!(str2 == "static"))
{
if (str2 == "sql_sysstoredquery")
{
BasePage.ResponseRedirect("LabelTemplate.aspx?action=" + this.action + "&name=" + base.Server.UrlEncode(this.m_LabelName));
return;
}
if (str2 == "xml_read")
{
BasePage.ResponseRedirect("LabelTemplate.aspx?action=" + this.action + "&name=" + base.Server.UrlEncode(this.m_LabelName));
return;
}
}
else
{
switch (str)
{
case "txt":
case "xml":
BasePage.ResponseRedirect("LabelTemplateStatic.aspx?action=" + this.action + "&name=" + base.Server.UrlEncode(this.m_LabelName));
return;
default:
BasePage.ResponseRedirect("LabelTemplateStatic.aspx?action=" + this.action + "&name=" + base.Server.UrlEncode(this.m_LabelName));
return;
}
}
}
BasePage.ResponseRedirect("LabelSqlBuild.aspx?action=" + this.action + "&name=" + base.Server.UrlEncode(this.m_LabelName));
}
protected void Page_Load(object sender, EventArgs e)
{
this.action = BasePage.RequestString("action");
this.m_LabelName = BasePage.RequestString("name");
this.m_LabelLibPath = "~/" + SiteConfig.SiteOption.LabelDir;
if (string.IsNullOrEmpty(this.m_LabelName))
{
BasePage.ResponseRedirect("Label.aspx");
}
else
{
string path = WebConfigurationManager.AppSettings["EasyOne:LabelXsltPath"];
this.xmlfilepath = HttpContext.Current.Server.MapPath(path) + @"\" + this.m_LabelName + ".config";
this.Dbtype = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelDataType");
string presstr = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelDataSource");
string str3 = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelSqlString");
string istr = string.Empty;
XmlDocument document = new XmlDocument();
document.Load(this.xmlfilepath);
XmlNodeList attriblist = document.SelectNodes("root/attributes");
presstr = this.ParaProc(attriblist, presstr);
str3 = this.ParaProc(attriblist, str3).Replace("@pagesize", "10").Replace("@startrow", "0");
if (((string.Compare(this.Dbtype, "static", StringComparison.Ordinal) == 0) && (string.Compare(this.Dbtype, "xml_read", StringComparison.Ordinal) == 0)) && string.IsNullOrEmpty(str3))
{
this.ShowXml.Text = "查询语句为空！";
return;
}
if (((string.Compare(this.Dbtype, "static", StringComparison.Ordinal) != 0) && (string.Compare(this.Dbtype, "sql_sysquery", StringComparison.Ordinal) != 0)) && ((string.Compare(this.Dbtype, "sql_sysstoredquery", StringComparison.Ordinal) != 0) && string.IsNullOrEmpty(presstr)))
{
this.ShowXml.Text = "数据源地址为空！";
return;
}
istr = LabelManage.GetDBQuery(this.Dbtype, presstr, str3, attriblist);
XmlDocument document2 = (XmlDocument)this.XmlProc(this.Dbtype, presstr, istr);
if (!string.IsNullOrEmpty(document2.OuterXml))
{
this.rootnode = document2.DocumentElement;
this.ShowXml.Text = this.GetXmlScheam(2).ToString();
}
else
{
document2.LoadXml("<root></root>");
this.rootnode = document2.DocumentElement;
this.ShowXml.Text = this.GetXmlScheam(2).ToString();
}
if (LabelManage.GetAttributeList(this.xmlfilepath).Count == 0)
{
this.attlist.Text = "您尚未添加参数!<a href=\"LabelProperty.aspx?action=" + this.action + "&name=" + this.m_LabelName + "\">添加参数</a>";
}
else
{
foreach (LabelAttributeInfo info in LabelManage.GetAttributeList(this.xmlfilepath))
{
string text = this.attlist.Text;
this.attlist.Text = text + "<div onclick=\"cit()\" outype=\"3\" class=\"spanfixdiv\" alt=\"" + info.Intro + "
默认值：" + info.DefaultValue + "\">" + info.AttributeName + "</div>";
}
}
this.TxtTemplate.Attributes.Add("onmouseup", "dragend(this)");
this.TxtTemplate.Attributes.Add("onClick", "savePos(this)");
this.TxtTemplate.Attributes.Add("onmousemove", "DragPos(this)");
if (!base.IsPostBack)
{
string filename = HttpContext.Current.Server.MapPath("~/") + @"\Temp\DefaultLabelTemplate.xsl";
if (string.Compare(this.action, "modify", StringComparison.OrdinalIgnoreCase) == 0)
{
this.TxtTemplate.Text = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelTemplate").Replace("><", ">\n<");
}
else
{
XmlDocument document3 = new XmlDocument();
document3.Load(filename);
this.TxtTemplate.Text = document3.OuterXml.Replace("><", ">\n<");
}
this.TxtTemplateTest.Text = "{PE.Label id=\"" + this.m_LabelName + "\" /}";
}
}
this.SmpNavigator.AdditionalNode = this.m_LabelName;
}
protected void Page_Load(object sender, EventArgs e)
{
this.action = BasePage.RequestString("action");
this.m_LabelName = BasePage.RequestString("name");
this.m_LabelLibPath = "~/" + SiteConfig.SiteOption.LabelDir;
if (string.IsNullOrEmpty(this.m_LabelName))
{
BasePage.ResponseRedirect("Label.aspx");
}
string path = WebConfigurationManager.AppSettings["EasyOne:LabelXsltPath"];
this.xmlfilepath = HttpContext.Current.Server.MapPath(path) + @"\" + this.m_LabelName + ".config";
if (string.Compare(this.action, "modify", StringComparison.OrdinalIgnoreCase) == 0)
{
this.BtnSave.Visible = true;
}
this.Dbtype = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelDataType");
if (!base.IsPostBack)
{
string str2;
DataRow[] rowArray;
this.TxtSqlstr.Text = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelSqlString");
DataTable table = new DataTable();
if ((string.Compare("sql_sysquery", this.Dbtype, StringComparison.OrdinalIgnoreCase) == 0) || (string.Compare("sql_outquery", this.Dbtype, StringComparison.OrdinalIgnoreCase) == 0))
{
if (DataConverter.CBoolean(XmlManage.ReadFileNode(this.xmlfilepath, "root/UsePage")))
{
this.ChkPage.Checked = true;
this.CountShow.Visible = true;
this.TxtSqlCount.Text = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelSqlCount");
}
if (string.Compare("sql_sysquery", this.Dbtype, StringComparison.OrdinalIgnoreCase) == 0)
{
rowArray = LabelManage.GetSystemSchemaDataBases().Select("", " TABLE_NAME ");
table = LabelManage.GetSystemSchemaDataBases().Clone();
table.Rows.Clear();
foreach (DataRow row in rowArray)
{
table.ImportRow(row);
}
}
else
{
str2 = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelDataSource");
rowArray = LabelManage.GetSchemaDataBase(str2, DataSourceType.Sql).Select("", " TABLE_NAME ");
table = LabelManage.GetSchemaDataBase(str2, DataSourceType.Sql).Clone();
table.Rows.Clear();
foreach (DataRow row2 in rowArray)
{
table.ImportRow(row2);
}
}
}
else if (string.Compare(this.Dbtype, "ole_read", StringComparison.OrdinalIgnoreCase) == 0)
{
if (DataConverter.CBoolean(XmlManage.ReadFileNode(this.xmlfilepath, "root/UsePage")))
{
this.ChkPage.Checked = true;
this.CountShow.Visible = true;
this.PageShow.Visible = true;
this.TxtSqlCount.Text = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelSqlCount");
this.TxtSqlPage.Text = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelSqlPage");
}
str2 = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelDataSource");
rowArray = LabelManage.GetSchemaDataBase(str2, DataSourceType.Ole).Select("", " TABLE_NAME ");
table = LabelManage.GetSchemaDataBase(str2, DataSourceType.Ole).Clone();
table.Rows.Clear();
foreach (DataRow row3 in rowArray)
{
table.ImportRow(row3);
}
}
else if (string.Compare(this.Dbtype, "odbc_read", StringComparison.OrdinalIgnoreCase) == 0)
{
if (DataConverter.CBoolean(XmlManage.ReadFileNode(this.xmlfilepath, "root/UsePage")))
{
this.ChkPage.Checked = true;
this.CountShow.Visible = true;
this.PageShow.Visible = true;
this.TxtSqlCount.Text = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelSqlCount");
this.TxtSqlPage.Text = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelSqlPage");
}
str2 = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelDataSource");
rowArray = LabelManage.GetSchemaDataBase(str2, DataSourceType.Odbc).Select("", " TABLE_NAME ");
table = LabelManage.GetSchemaDataBase(str2, DataSourceType.Odbc).Clone();
table.Rows.Clear();
foreach (DataRow row4 in rowArray)
{
table.ImportRow(row4);
}
}
else if (string.Compare(this.Dbtype, "orc_read", StringComparison.OrdinalIgnoreCase) == 0)
{
if (DataConverter.CBoolean(XmlManage.ReadFileNode(this.xmlfilepath, "root/UsePage")))
{
this.ChkPage.Checked = true;
this.CountShow.Visible = true;
this.TxtSqlCount.Text = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelSqlCount");
}
str2 = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelDataSource");
rowArray = LabelManage.GetSchemaDataBase(str2, DataSourceType.Oracle).Select("", " TABLE_NAME ");
table = LabelManage.GetSchemaDataBase(str2, DataSourceType.Oracle).Clone();
table.Rows.Clear();
foreach (DataRow row5 in rowArray)
{
table.ImportRow(row5);
}
}
this.DbTableDownList.DataSource = table;
this.DbTableDownList.DataTextField = "TABLE_NAME";
this.DbTableDownList.DataValueField = "TABLE_NAME";
this.DbTableDownList.DataBind();
ListItem item = new ListItem();
item.Text = "请选择一个表";
this.DbTableDownList.Items.Insert(0, item);
this.DbTableDownList2.DataSource = table;
this.DbTableDownList2.DataTextField = "TABLE_NAME";
this.DbTableDownList2.DataValueField = "TABLE_NAME";
this.DbTableDownList2.DataBind();
item.Text = "请选择一个表";
this.DbTableDownList2.Items.Insert(0, item);
if (LabelManage.GetAttributeList(this.xmlfilepath).Count == 0)
{
this.attlist.Text = "您尚未添加参数!<a href=\"LabelProperty.aspx?action=" + this.action + "&name=" + this.m_LabelName + "\">添加参数</a>";
}
else
{
foreach (LabelAttributeInfo info in LabelManage.GetAttributeList(this.xmlfilepath))
{
this.attlist.Text = this.attlist.Text + "<div onmousedown=\"dragstart();\" class=\"spanfixdiv\">" + info.AttributeName + "</div>";
}
}
}
base.Form.Attributes.Add("onmouseup", "dragclear()");
base.Form.Attributes.Add("onmousemove", "dragmove()");
this.TxtSqlstr.Attributes.Add("onmouseup", "dragend(1);");
this.TxtSqlstr.Attributes.Add("onmousemove", "movePoint();;");
this.TxtSqlPage.Attributes.Add("onmouseup", "dragend(1);");
this.TxtSqlPage.Attributes.Add("onmousemove", "movePoint();;");
this.TxtSqlCount.Attributes.Add("onmouseup", "dragend(1);");
this.TxtSqlCount.Attributes.Add("onmousemove", "movePoint();;");
this.SmpNavigator.AdditionalNode = this.m_LabelName;
}
protected void DBTableDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
if (this.DbTableDownList2.SelectedIndex <= 0)
{
this.Span1.Visible = false;
}
else
{
DataTable table = new DataTable();
string dbtype = this.Dbtype;
if (dbtype != null)
{
if (!(dbtype == "sql_sysquery"))
{
if (dbtype == "sql_outquery")
{
table = LabelManage.GetSchemaTable(this.DbTableDownList2.SelectedValue, XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelDataSource"), DataSourceType.Sql);
}
else if (dbtype == "ole_read")
{
table = LabelManage.GetSchemaTable(this.DbTableDownList2.SelectedValue, XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelDataSource"), DataSourceType.Ole);
}
else if (dbtype == "odbc_read")
{
table = LabelManage.GetSchemaTable(this.DbTableDownList2.SelectedValue, XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelDataSource"), DataSourceType.Odbc);
}
else if (dbtype == "orc_read")
{
table = LabelManage.GetSchemaTable(this.DbTableDownList2.SelectedValue, XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelDataSource"), DataSourceType.Oracle);
}
}
else
{
table = LabelManage.GetSchemaTable(this.DbTableDownList2.SelectedValue, string.Empty, DataSourceType.None);
}
}
this.DbFieldDownList2.DataSource = table;
this.DbFieldList2.DataSource = table;
this.DbFieldDownList2.DataTextField = "ColumnName";
this.DbFieldDownList2.DataValueField = "ColumnName";
this.DbFieldDownList2.DataBind();
this.DbFieldList2.DataTextField = "ColumnName";
this.DbFieldList2.DataValueField = "ColumnName";
this.DbFieldList2.DataBind();
this.Span1.Visible = true;
}
}
protected void BtnSqlbilud_Click(object sender, EventArgs e)
{
this.query = new SelectQueryBuilder();
this.querycount = new SelectQueryBuilder();
if (this.DbTableDownList.SelectedIndex > 0)
{
bool flag = true;
bool flag2 = true;
bool flag3 = false;
bool flag4 = false;
if (string.Compare(this.Dbtype, "orc_read", StringComparison.OrdinalIgnoreCase) == 0)
{
flag3 = true;
}
else if ((string.Compare(this.Dbtype, "odbc_read", StringComparison.OrdinalIgnoreCase) == 0) && Regex.IsMatch(XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelType"), "mysql", RegexOptions.IgnoreCase))
{
flag4 = true;
}
string input = XmlManage.ReadFileNode(this.xmlfilepath, "root/LabelDbPath");
if ((string.Compare(this.Dbtype, "ole_read", StringComparison.OrdinalIgnoreCase) == 0) && Regex.IsMatch(input, "xls", RegexOptions.IgnoreCase))
{
this.query.SelectFromTable("[" + this.DbTableDownList.SelectedValue + "]");
this.querycount.SelectFromTable("[" + this.DbTableDownList.SelectedValue + "]");
}
else
{
this.query.SelectFromTable(this.DbTableDownList.SelectedValue);
this.querycount.SelectFromTable(this.DbTableDownList.SelectedValue);
}
StringBuilder builder = new StringBuilder();
if ((this.DbTableDownList2.SelectedIndex <= 0) || (this.DbTableDownList.SelectedIndex == this.DbTableDownList2.SelectedIndex))
{
for (int i = 0; i < this.DbFieldDownList.Items.Count; i++)
{
if (this.DbFieldDownList.Items[i].Selected)
{
builder.Append(this.DbFieldDownList.Items[i].Value + ",");
flag = false;
}
}
if (flag)
{
this.query.SelectAllColumns();
}
else
{
this.query.SelectColumns(builder.ToString().Split(new char[] { ',' }));
}
this.querycount.SelectColumn("count(*)");
this.QueryProc(-1);
}
else
{
string selectedValue = this.Dbtj.SelectedValue;
if (selectedValue != null)
{
if (!(selectedValue == "InnerJoin"))
{
if (selectedValue == "LeftJoin")
{
if (this.Dbys.SelectedValue == "=")
{
this.query.AddJoin(JoinType.LeftJoin, this.DbTableDownList2.SelectedValue, this.DbFieldList2.SelectedValue, Comparison.Equals, this.DbTableDownList.SelectedValue, this.DbFieldList.SelectedValue);
this.querycount.AddJoin(JoinType.LeftJoin, this.DbTableDownList2.SelectedValue, this.DbFieldList2.SelectedValue, Comparison.Equals, this.DbTableDownList.SelectedValue, this.DbFieldList.SelectedValue);
}
else
{
this.query.AddJoin(JoinType.LeftJoin, this.DbTableDownList2.SelectedValue, this.DbFieldList2.SelectedValue, Comparison.Like, this.DbTableDownList.SelectedValue, this.DbFieldList.SelectedValue);
this.querycount.AddJoin(JoinType.LeftJoin, this.DbTableDownList2.SelectedValue, this.DbFieldList2.SelectedValue, Comparison.Like, this.DbTableDownList.SelectedValue, this.DbFieldList.SelectedValue);
}
}
else if (selectedValue == "OuterJoin")
{
if (this.Dbys.SelectedValue == "=")
{
this.query.AddJoin(JoinType.OuterJoin, this.DbTableDownList2.SelectedValue, this.DbFieldList2.SelectedValue, Comparison.Equals, this.DbTableDownList.SelectedValue, this.DbFieldList.SelectedValue);
this.querycount.AddJoin(JoinType.OuterJoin, this.DbTableDownList2.SelectedValue, this.DbFieldList2.SelectedValue, Comparison.Equals, this.DbTableDownList.SelectedValue, this.DbFieldList.SelectedValue);
}
else
{
this.query.AddJoin(JoinType.OuterJoin, this.DbTableDownList2.SelectedValue, this.DbFieldList2.SelectedValue, Comparison.Like, this.DbTableDownList.SelectedValue, this.DbFieldList.SelectedValue);
this.querycount.AddJoin(JoinType.OuterJoin, this.DbTableDownList2.SelectedValue, this.DbFieldList2.SelectedValue, Comparison.Like, this.DbTableDownList.SelectedValue, this.DbFieldList.SelectedValue);
}
}
else if (selectedValue == "RightJoin")
{
if (this.Dbys.SelectedValue == "=")
{
this.query.AddJoin(JoinType.RightJoin, this.DbTableDownList2.SelectedValue, this.DbFieldList2.SelectedValue, Comparison.Equals, this.DbTableDownList.SelectedValue, this.DbFieldList.SelectedValue);
this.querycount.AddJoin(JoinType.RightJoin, this.DbTableDownList2.SelectedValue, this.DbFieldList2.SelectedValue, Comparison.Equals, this.DbTableDownList.SelectedValue, this.DbFieldList.SelectedValue);
}
else
{
this.query.AddJoin(JoinType.RightJoin, this.DbTableDownList2.SelectedValue, this.DbFieldList2.SelectedValue, Comparison.Like, this.DbTableDownList.SelectedValue, this.DbFieldList.SelectedValue);
this.querycount.AddJoin(JoinType.RightJoin, this.DbTableDownList2.SelectedValue, this.DbFieldList2.SelectedValue, Comparison.Like, this.DbTableDownList.SelectedValue, this.DbFieldList.SelectedValue);
}
}
}
else if (this.Dbys.SelectedValue == "=")
{
this.query.AddJoin(JoinType.InnerJoin, this.DbTableDownList2.SelectedValue, this.DbFieldList2.SelectedValue, Comparison.Equals, this.DbTableDownList.SelectedValue, this.DbFieldList.SelectedValue);
this.querycount.AddJoin(JoinType.InnerJoin, this.DbTableDownList2.SelectedValue, this.DbFieldList2.SelectedValue, Comparison.Equals, this.DbTableDownList.SelectedValue, this.DbFieldList.SelectedValue);
}
else
{
this.query.AddJoin(JoinType.InnerJoin, this.DbTableDownList2.SelectedValue, this.DbFieldList2.SelectedValue, Comparison.Like, this.DbTableDownList.SelectedValue, this.DbFieldList.SelectedValue);
this.querycount.AddJoin(JoinType.InnerJoin, this.DbTableDownList2.SelectedValue, this.DbFieldList2.SelectedValue, Comparison.Like, this.DbTableDownList.SelectedValue, this.DbFieldList.SelectedValue);
}
}
int irlist = 0;
for (int j = 0; j < this.DbFieldDownList.Items.Count; j++)
{
if (this.DbFieldDownList.Items[j].Selected)
{
builder.Append(this.DbTableDownList.SelectedValue + "." + this.DbFieldDownList.Items[j].Value + ",");
flag = false;
irlist++;
}
}
if (flag)
{
irlist = this.DbFieldDownList.Items.Count;
builder.Append(this.DbTableDownList.SelectedValue + ".*,");
}
for (int k = 0; k < this.DbFieldDownList2.Items.Count; k++)
{
if (this.DbFieldDownList2.Items[k].Selected)
{
builder.Append(this.DbTableDownList2.SelectedValue + "." + this.DbFieldDownList2.Items[k].Value + ",");
flag2 = false;
}
}
if (flag2)
{
builder.Append(this.DbTableDownList2.SelectedValue + ".*");
}
this.query.SelectColumns(builder.ToString().Split(new char[] { ',' }));
this.querycount.SelectColumn("count(*)");
this.QueryProc(irlist);
}
if (flag3)
{
this.query.AddWhere("rownum", Comparison.LessOrEquals, DataConverter.CLng(this.TxtOutNum.Text), 0);
}
else if (!flag4)
{
this.query.TopRecords = DataConverter.CLng(this.TxtOutNum.Text);
}
if (flag4)
{
this.TxtSqlstr.Text = this.query.BuildQuery();
if (DataConverter.CLng(this.TxtOutNum.Text) > 0)
{
this.TxtSqlstr.Text = this.TxtSqlstr.Text + " limit " + this.TxtOutNum.Text;
}
}
else
{
this.TxtSqlstr.Text = this.query.BuildQuery();
}
if ((string.Compare(this.Dbtype.Split(new char[] { '_' })[0], "sql", StringComparison.Ordinal) != 0) && !flag3)
{
this.TxtSqlPage.Text = this.query.BuildQuery();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.m_LabelName = BasePage.RequestString("name").Trim();
this.m_LabelLibPath = "~/" + SiteConfig.SiteOption.LabelDir;
this.InitDropLabelType();
this.DropLabelType.Attributes.Add("onChange", "addclass('" + this.DropLabelType.ClientID + "','" + this.TxtLabelType.ClientID + "')");
if (!this.Page.IsPostBack)
{
if (string.IsNullOrEmpty(this.m_LabelName))
{
this.TxtLabelName.Text = this.m_LabelName;
if (!string.IsNullOrEmpty(this.TxtLabelName.Text))
{
string path = WebConfigurationManager.AppSettings["EasyOne:LabelXsltPath"];
string xmlpath = HttpContext.Current.Server.MapPath(path) + @"\" + this.TxtLabelName.Text + ".config";
this.SetInit(xmlpath);
}
else
{
this.PanelOutSide.Visible = false;
}
}
else
{
this.TxtLabelName.Text = this.m_LabelName;
this.ViewState["oldlabelname"] = this.m_LabelName;
string str = WebConfigurationManager.AppSettings["EasyOne:LabelXsltPath"];
string str2 = HttpContext.Current.Server.MapPath(str) + @"\" + this.m_LabelName + ".config";
string str3 = HttpContext.Current.Server.MapPath(this.m_LabelLibPath) + @"\" + this.m_LabelName + ".config";
if (File.Exists(str3))
{
if (File.Exists(str2))
{
File.Delete(str2);
}
File.Copy(str3, str2, true);
}
this.SetInit(str2);
string str4 = XmlManage.ReadFileNode(str2, "root/OutType");
this.BtnSave.Visible = true;
this.LinkJump.Visible = true;
ListItem item = new ListItem();
item.Text = "跳转到";
this.LinkJump.Items.Add(item);
this.LinkJump.AutoPostBack = true;
ListItem item2 = new ListItem();
item2.Text = "设置标签参数";
item2.Value = "LabelProperty.aspx?action=modify&name=" + base.Server.UrlEncode(this.m_LabelName);
this.LinkJump.Items.Add(item2);
ListItem item3 = new ListItem();
string selectedValue = this.RbtDataType.SelectedValue;
if (selectedValue != null)
{
if (!(selectedValue == "static"))
{
if ((selectedValue == "sql_sysstoredquery") || (selectedValue == "xml_read"))
{
item3.Text = "标签内容编辑";
item3.Value = "LabelTemplate.aspx?action=modify&name=" + base.Server.UrlEncode(this.m_LabelName);
this.LinkJump.Items.Add(item3);
goto Label_0412;
}
}
else
{
item3.Text = "标签内容编辑";
switch (str4)
{
case "txt":
case "xml":
item3.Value = "LabelTemplateStatic.aspx?action=modify&name=" + base.Server.UrlEncode(this.m_LabelName);
break;
default:
item3.Value = "LabelTemplate.aspx?action=modify&name=" + base.Server.UrlEncode(this.m_LabelName);
break;
}
this.LinkJump.Items.Add(item3);
goto Label_0412;
}
}
item3.Text = "标签查询设置";
item3.Value = "LabelSqlBuild.aspx?action=modify&name=" + base.Server.UrlEncode(this.m_LabelName);
this.LinkJump.Items.Add(item3);
ListItem item4 = new ListItem();
item4.Text = "标签内容编辑";
item4.Value = "LabelTemplate.aspx?action=modify&name=" + base.Server.UrlEncode(this.m_LabelName);
this.LinkJump.Items.Add(item4);
}
}
Label_0412:
this.SmpNavigator.AdditionalNode = this.m_LabelName;
}
