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