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>"); } }
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 = "添加新标签"; } }