protected void Page_Load(object sender, EventArgs e)
{
//if (!B_ARoleAuth.Check(ZLEnum.Auth.label, "LabelManage"))
//{
// function.WriteErrMsg("没有权限进行此项操作");
//}
B_Permission.CheckAuthEx("design");
if (!IsPostBack)
{
//Call.HideBread(Master);
string cateTlp = "<li class='{0}' role='presentation'><a href='LabelManage.aspx?Cate={1}'>{2}</a></li>";
lblLabel.Text += string.Format(cateTlp, (string.IsNullOrEmpty(LabelCate) ? "active" : ""), "", "所有标签");
DataTable CateTable = bll.GetLabelCateListXML();//标签类别
foreach (DataRow dr in CateTable.Rows)
{
if (string.IsNullOrEmpty(dr["name"].ToString()))
{
continue;
}
string isactive = dr["name"].ToString().Equals(LabelCate) ? "active" : "";
lblLabel.Text += string.Format(cateTlp, isactive, HttpUtility.UrlEncode(dr["name"].ToString()), dr["name"]);
}
//-----------------
KeyWord = Request.QueryString["KeyWord"] ?? "";
DataTable dt = bll.SelAllLabel(LabelCate, KeyWord);
RPT.DataSource = dt;
RPT.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(LabelName))
{
M_Label labelinfo = labelBll.GetLabelXML(LabelName);
param = labelinfo.Param;
}
if (!IsPostBack)
{
CustomLabel_DP.DataSource = labelBll.GetLabelCateListXML();
CustomLabel_DP.DataTextField = "name";
CustomLabel_DP.DataValueField = "name";
CustomLabel_DP.DataBind();
CustomLabel_DP.Items.Insert(0, new ListItem("选择标签类型", ""));
Field_DP.DataSource = labelBll.GetSourceLabelXML();//LabelType
Field_DP.DataTextField = "LabelName";
Field_DP.DataValueField = "LabelID";
Field_DP.DataBind();
Field_DP.Items.Insert(0, new ListItem("选择数据源标签", ""));
lblSys.Text = bfun.GetSysLabel();
lblFun.Text = bfun.GetFunLabel();
DealInvoke();
Call.SetBreadCrumb(Master, "<li><a href='" + customPath2 + "Config/SiteInfo.aspx'>系统设置</a></li><li><a href='LabelManage.aspx'>标签管理</a></li><li class='active'>标签调用</li>");
}
}
public IActionResult LabelManage()
{
PSize = 20;
string LabelCate = GetParam("Cate");
string KeyWord = GetParam("KeyWord");
//-----------------
//KeyWord = RequestEx["KeyWord"] ?? "";
DataTable dt = labelBll.SelAllLabel(LabelCate, KeyWord);
PageSetting setting = PageHelper.GetPagedTable(dt, CPage, PSize);
if (Request.IsAjax())
{
return(PartialView("LabelManage_List", setting));
}
else
{
DataTable CateTable = labelBll.GetLabelCateListXML();//标签类别
CateTable.Columns.Add("label");
DataRow allrow = CateTable.NewRow();
allrow["name"] = "";
allrow["label"] = "全部标签";
CateTable.Rows.InsertAt(allrow, 0);
ViewBag.CateTable = JsonConvert.SerializeObject(CateTable);
return(View(setting));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!B_ARoleAuth.Check(ZLEnum.Auth.label, "LabelManage"))
{
function.WriteErrMsg(Resources.L.没有权限进行此项操作);
}
if (!IsPostBack)
{
if (bll.SelAllLabel().Rows.Count <= 1 && Directory.Exists(Server.MapPath(SiteConfig.SiteOption.TemplateDir + "/配置库/标签/")))
{
Response.Redirect("LabelExport.aspx"); return;
}
Call.HideBread(Master);
DataTable CateTable = bll.GetLabelCateListXML();//标签类别
CateTable.Columns.Add("label");
DataRow allrow = CateTable.NewRow();
allrow["name"] = "";
allrow["label"] = Resources.L.全部标签;
CateTable.Rows.InsertAt(allrow, 0);
LabelTypeData_Hid.Value = JsonConvert.SerializeObject(CateTable);
//-----------------
KeyWord = Request.QueryString["KeyWord"] ?? "";
DataTable dt = bll.SelAllLabel(LabelCate, KeyWord);
RPT.DataSource = dt;
RPT.DataBind();
}
}
private void DPBind()
{
CustomLabel_DP.DataSource = bll.GetLabelCateListXML();
CustomLabel_DP.DataTextField = "name";
CustomLabel_DP.DataValueField = "name";
CustomLabel_DP.DataBind();
CustomLabel_DP.Items.Insert(0, new ListItem("选择标签类型", ""));
Field_DP.DataSource = bll.GetSourceLabelXML();//LabelType
Field_DP.DataTextField = "LabelName";
Field_DP.DataValueField = "LabelID";
Field_DP.DataBind();
Field_DP.Items.Insert(0, new ListItem("选择数据源标签", ""));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CustomLabel_DP.DataSource = labelBll.GetLabelCateListXML();
CustomLabel_DP.DataTextField = "name";
CustomLabel_DP.DataValueField = "name";
CustomLabel_DP.DataBind();
CustomLabel_DP.Items.Insert(0, new ListItem("选择标签类型", ""));
Field_DP.DataSource = labelBll.GetSourceLabelXML();//LabelType
Field_DP.DataTextField = "LabelName";
Field_DP.DataValueField = "LabelID";
Field_DP.DataBind();
Field_DP.Items.Insert(0, new ListItem("选择数据源标签", ""));
lblSys.Text = bfun.GetSysLabel();
lblFun.Text = bfun.GetFunLabel();
//DealInvoke();
Call.HideBread(Master);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (function.isAjax())
{
#region ajax
string result = "";
switch (Action)
{
case "custom":
{
string cate = Request.Form["cate"];
DataTable dt = labelBll.SelAllLabel(cate);
result = JsonConvert.SerializeObject(dt);
}
break;
case "field":
{
int labelid = DataConverter.CLng(Request.Form["labelid"]);
if (labelid < 1)
{
break;
}
M_Label labelMod = labelBll.GetLabelXML(labelid);
string html = "", connStr = SqlHelper.ConnectionString;
html = labelBll.SetLabelColumn(labelMod.LabelField, labelMod.LabelTable, labelMod.LableName, connStr);
result = StringHelper.Base64StringEncode(html);
}
break;
}
Response.Write(result); Response.Flush(); Response.End();
#endregion
}
B_Permission.CheckAuthEx("design");
if (!IsPostBack)
{
Design_Btn.Visible = string.IsNullOrEmpty(Mid);
Save_Btn.Visible = !string.IsNullOrEmpty(Mid);
CustomLabel_DP.DataSource = labelBll.GetLabelCateListXML();
CustomLabel_DP.DataTextField = "name";
CustomLabel_DP.DataValueField = "name";
CustomLabel_DP.DataBind();
CustomLabel_DP.Items.Insert(0, new ListItem("选择标签类型", ""));
Field_DP.DataSource = labelBll.GetSourceLabelXML();//LabelType
Field_DP.DataTextField = "LabelName";
Field_DP.DataValueField = "LabelID";
Field_DP.DataBind();
Field_DP.Items.Insert(0, new ListItem("选择数据源标签", ""));
lblSys.Text = bfun.GetSysLabel();
lblFun.Text = bfun.GetFunLabel();
DealInvoke();
Alias_T.Text = LabelName;
if (!string.IsNullOrEmpty(LName))
{
if (badmin.CheckLogin())
{
Response.Redirect(CustomerPageAction.customPath2 + "Template/LabelSQL.aspx?LabelName=" + HttpUtility.UrlEncode(LabelName));
}
else
{
function.WriteErrMsg("修改动态标签,必须以管理员身份登录");
}
}
}
}
private void MyBind()
{
LabelCate_DP.DataSource = bll.GetLabelCateListXML();
LabelCate_DP.DataBind();
//----绑定第二步数据表
DataTable dsList = dsBll.Sel();
DBList_DP.Items.Add(new ListItem("系统主数据库", "main"));
DBList2_DP.Items.Add(new ListItem("系统主数据库", "main"));
foreach (DataRow dr in dsList.Rows)
{
ListItem item = new ListItem("[外]" + dr["DSName"].ToString(), dr["ID"].ToString());
DBList_DP.Items.Add(item);
DBList2_DP.Items.Add(item);
}
DBList_DP.Items.Add(new ListItem("+添加新数据库", "new"));
DataTable tableDT = DS_GetByDP(D1).Table_List();
BindTableListToDP(tableDT, TableList_DP);
BindTableListToDP(tableDT, TableList2_DP);
//---最终步
CustomLabel_DP.DataSource = bll.GetLabelCateListXML();
CustomLabel_DP.DataBind();
CustomLabel_DP.Items.Insert(0, new ListItem("选择标签类型", ""));
lblSys.Text = funBll.GetSysLabel(); //系统标签
lblFun.Text = funBll.GetFunLabel(); //扩展函数
//-----------------绑定已有数据
if (!string.IsNullOrEmpty(LabelName))
{
M_Label labelMod = bll.GetLabelXML(LabelName);
labelMod.LabelWhere = ClearTableHolder(labelMod.LabelWhere);
labelMod.LabelField = ClearTableHolder(labelMod.LabelField);
labelMod.LabelTable = ClearTableHolder(labelMod.LabelTable);
labelMod.LabelOrder = ClearTableHolder(labelMod.LabelOrder);
//第一步
LabelName_T.Text = labelMod.LableName;
LabelCate_T.Text = labelMod.LabelCate;
LabelType_Rad.SelectedValue = labelMod.LableType.ToString();
Desc_T.Text = labelMod.Desc;
//schema_Text.Text = labelMod.ConnectString;
//第二步
string t1 = "", t2 = "";
if (!string.IsNullOrEmpty(labelMod.DataSourceType) && labelMod.DataSourceType.StartsWith("{"))
{
JObject jobj = JsonConvert.DeserializeObject <JObject>(labelMod.DataSourceType);
DBList_DP.SelectedValue = jobj["ds_m"].ToString();
DBList2_DP.SelectedValue = jobj["ds_m"].ToString();
t1 = jobj["tb_m"].ToString();
t2 = jobj["tb_s"].ToString();
tableDT = DS_GetByDP(D1).Table_List();
BindTableListToDP(tableDT, TableList_DP);
BindTableListToDP(tableDT, TableList2_DP);
}
else
{
B_Label.GetT1AndT2(labelMod.LabelTable, ref t1, ref t2);
}
TableList_DP.SelectedValue = t1;
TableList2_DP.SelectedValue = t2;
TableList_DP_SelectedIndexChanged(null, null);
TableList2_DP_SelectedIndexChanged(null, null);
//是否启用了联接查询
string joinType = B_Label.GetJoinType(labelMod.LabelTable);
if (!string.IsNullOrEmpty(joinType))
{
SqlJoin_DP.SelectedValue = joinType;
string on1 = "", on2 = "";
B_Label.GetOnField(labelMod.LabelTable, ref on1, ref on2);
OnField_DP.SelectedValue = on1;
OnField2_DP.SelectedValue = on2;
}
SqlTable_T.Text = labelMod.LabelTable;
SqlField_T.Text = labelMod.LabelField;
//第三步
RptParam_Bind(labelMod.Param);
Param_Hid.Value = labelMod.Param;
Where_T.Text = labelMod.LabelWhere;
Order_T.Text = labelMod.LabelOrder;
PSize_T.Text = labelMod.LabelCount;
//第四步
textContent.Text = labelMod.Content;
Modeltypeinfo.Text = labelMod.Modeltypeinfo;
Modelvalue.Text = labelMod.Modelvalue;
setroot.SelectedValue = labelMod.setroot;
Valueroot.Text = labelMod.Valueroot;
BoolMode_Chk.Checked = labelMod.IsOpen == 1;
falsecontent.Text = labelMod.FalseContent;
bool_addroot_dp.SelectedValue = labelMod.addroot;
Bread_L.Text = "当前标签：<a href='" + Request.RawUrl + "'>" + labelMod.LableName + "</a>";
}
if (string.IsNullOrEmpty(LabelName))
{
Bread_L.Text = "添加新标签";
if (LabelCate_DP.Items.Count > 0)
{
LabelCate_T.Text = LabelCate_DP.SelectedValue;
}
}
}
private void MyBind()
{
LabelCate_DP.DataSource = bll.GetLabelCateListXML();
LabelCate_DP.DataBind();
//----绑定第二步数据表
DBList_DP.Items.Add(new ListItem("系统主数据库", "main"));
DBList_DP.Items.Add(new ListItem("从数据库", "second"));
DBList_DP.Items.Add(new ListItem("+添加新数据库", "new"));
DBList2_DP.Items.Add(new ListItem("系统主数据库", "main"));
DBList2_DP.Items.Add(new ListItem("从数据库", "second"));
DataTable tableDT = DBCenter.DB.Table_List();
BindTableListToDP(tableDT, TableList_DP);
BindTableListToDP(tableDT, TableList2_DP);
//---最终步
CustomLabel_DP.DataSource = bll.GetLabelCateListXML();
CustomLabel_DP.DataBind();
CustomLabel_DP.Items.Insert(0, new ListItem("选择标签类型", ""));
lblSys.Text = funBll.GetSysLabel(); //系统标签
lblFun.Text = funBll.GetFunLabel(); //扩展函数
//-----------------绑定已有数据
if (!string.IsNullOrEmpty(LabelName))
{
M_Label labelMod = bll.GetLabelXML(LabelName);
//第一步
LabelName_T.Text = labelMod.LableName;
LabelCate_T.Text = labelMod.LabelCate;
LabelType_Rad.SelectedValue = labelMod.LableType.ToString();
Desc_T.Text = labelMod.Desc;
//schema_Text.Text = labelMod.ConnectString;
//第二步
string t1 = "", t2 = "";
B_Label.GetT1AndT2(labelMod.LabelTable, ref t1, ref t2);
TableList_DP.SelectedValue = t1;
TableList2_DP.SelectedValue = t2;
TableList_DP_SelectedIndexChanged(null, null);
TableList2_DP_SelectedIndexChanged(null, null);
//是否启用了联接查询
string joinType = B_Label.GetJoinType(labelMod.LabelTable);
if (!string.IsNullOrEmpty(joinType))
{
SqlJoin_DP.SelectedValue = joinType;
string on1 = "", on2 = "";
B_Label.GetOnField(labelMod.LabelTable, ref on1, ref on2);
OnField_DP.SelectedValue = on1;
OnField2_DP.SelectedValue = on2;
}
SqlTable_T.Text = labelMod.LabelTable;
SqlField_T.Text = labelMod.LabelField;
//第三步
RptParam_Bind(labelMod.Param);
Param_Hid.Value = labelMod.Param;
Where_T.Text = labelMod.LabelWhere;
Order_T.Text = labelMod.LabelOrder;
PSize_T.Text = labelMod.LabelCount;
//第四步
textContent.Text = labelMod.Content;
Modeltypeinfo.Text = labelMod.Modeltypeinfo;
Modelvalue.Text = labelMod.Modelvalue;
setroot.SelectedValue = labelMod.setroot;
Valueroot.Text = labelMod.Valueroot;
BoolMode_Chk.Checked = labelMod.IsOpen == 1;
falsecontent.Text = labelMod.FalseContent;
bool_addroot_dp.SelectedValue = labelMod.addroot;
Bread_L.Text = "当前标签：<a href='" + Request.RawUrl + "'>" + labelMod.LableName + "</a>";
}
if (string.IsNullOrEmpty(LabelName))
{
Bread_L.Text = "添加新标签";
}
}
public void bindShengji()
{
try
{
//升级节点
DataSet nodelist = nll.GetDirectory();
if (nodelist != null)
{
//生成目录
if (!FileSystemObject.IsExist(base.Request.PhysicalApplicationPath + @"\" + SiteConfig.SiteOption.TemplateDir.Replace("/", @"\") + @"\配置库\节点\", FsoMethod.Folder))
{
FileSystemObject.CreateFileFolder(base.Request.PhysicalApplicationPath + @"\" + SiteConfig.SiteOption.TemplateDir.Replace("/", @"\") + @"\配置库\节点\");
}
nodelist.WriteXml(base.Request.PhysicalApplicationPath + @"\" + SiteConfig.SiteOption.TemplateDir.Replace("/", @"\") + @"\配置库\节点\Directory.node");
if (!FileSystemObject.IsExist(base.Request.PhysicalApplicationPath + @"\" + SiteConfig.SiteOption.TemplateDir.Replace("/", @"\") + @"\配置库\节点\NodeList", FsoMethod.Folder))
{
FileSystemObject.CreateFileFolder(base.Request.PhysicalApplicationPath + @"\" + SiteConfig.SiteOption.TemplateDir.Replace("/", @"\") + @"\配置库\节点\NodeList");
}
for (int i = 0; i < nodelist.Tables[0].Rows.Count; i++)
{
int NodeID = DataConverter.CLng(nodelist.Tables[0].Rows[i]["NodeID"]);
string NodeName = nodelist.Tables[0].Rows[i]["NodeName"].ToString();
DataSet nodeset = nll.GetNodeSet(NodeID);
nodeset.WriteXml(base.Request.PhysicalApplicationPath + @"\" + SiteConfig.SiteOption.TemplateDir.Replace("/", @"\") + @"\配置库\节点\NodeList\" + NodeID.ToString() + ".node");
}
}
nodelist.Dispose();
if (!FileSystemObject.IsExist(base.Request.PhysicalApplicationPath + @"\" + SiteConfig.SiteOption.TemplateDir.Replace("/", @"\") + @"\配置库\标签\", FsoMethod.Folder))
{
FileSystemObject.CreateFileFolder(base.Request.PhysicalApplicationPath + @"\" + SiteConfig.SiteOption.TemplateDir.Replace("/", @"\") + @"\配置库\标签\");
}
string dirfilename = base.Request.PhysicalApplicationPath + @"\" + SiteConfig.SiteOption.TemplateDir.Replace("/", @"\") + @"\配置库\标签\Directory.label";
DataSet nodedir = new DataSet("NewDataSet");
DataTable dttemp = labelBll.GetLabelCateListXML();
DataSet dsLabals = new DataSet("NewDataSet");
DataTable dtLabals = new DataTable("DataTable");
dsLabals.Tables.Add(dtLabals);
for (int i = 0; i < dttemp.Rows.Count; i++)
{
DataRow dr = dttemp.Rows[i];
DataSet labeltable1 = new DataSet("NewDataSet");
DataTable dtFIle = FileSystemObject.GetDirectoryInfos(base.Request.PhysicalApplicationPath + @"\" + SiteConfig.SiteOption.TemplateDir.Replace("/", @"\") + @"\配置库\标签\" + dr["name"].ToString(), FsoMethod.File);
for (int ss = 0; ss < dtFIle.Rows.Count; ss++)
{
if (dtFIle.Rows[ss]["content_type"].ToString().ToLower() == "label")
{
string filenameLabel = SiteConfig.SiteMapath().Substring(0, SiteConfig.SiteMapath().Length - 1) + SiteConfig.SiteOption.TemplateDir.Replace("/", @"\") + @"\配置库\标签\" + dr["name"] + @"\" + dtFIle.Rows[ss]["name"];
DataSet tempset = new DataSet();
tempset.ReadXml(filenameLabel);
DataTable converttable = tempset.Tables[0].Copy();
tempset.Dispose();
if (dtLabals.Columns.Count <= 0)
{
for (int jj = 0; jj < converttable.Columns.Count; jj++)
{
dtLabals.Columns.Add(converttable.Columns[jj].ColumnName, converttable.Columns[jj].DataType);
}
}
dtLabals.ImportRow(converttable.Rows[0]);
}
}
if (labeltable1.Tables.Count <= 0)
{
DataTable dtnew = new DataTable("Table");
DataColumn dc = new DataColumn("LabelID", typeof(string));
dtnew.Columns.Add(dc);
dc = new DataColumn("LabelName", typeof(string));
dtnew.Columns.Add(dc);
dc = new DataColumn("LabelType", typeof(string));
dtnew.Columns.Add(dc);
dc = new DataColumn("LabelCate", typeof(string));
dtnew.Columns.Add(dc);
labeltable1.Tables.Add(dtnew);
}
}
for (int i = dtLabals.Columns.Count - 1; i >= 4; i--)
{
dtLabals.Columns.RemoveAt(i);
}
DataTable labeltoptable = dsLabals.Tables[0].Copy();
labeltoptable.TableName = "Table";
nodedir.Tables.Add(labeltoptable);
nodedir.WriteXml(dirfilename);
nodedir.Dispose();
mll.UpModel();
lblKai.Text = "一键开销成功";
}
catch
{
lblKai.Text = "一键开销成功";
throw;
}
}
