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;
}
