protected void bt_SaveCondition_Click(object sender, EventArgs e) { ADFind_FindConditionBLL _f = null; if (ddl_FindCondition.SelectedValue != "0") { _f = new ADFind_FindConditionBLL(Int32.Parse(ddl_FindCondition.SelectedValue)); } else if (Session["AdvancedFindNewID"] != null) { _f = new ADFind_FindConditionBLL((int)Session["AdvancedFindNewID"]); Session["AdvancedFindNewID"] = null; ddl_FindCondition.DataSource = ADFind_FindConditionBLL.GetMyADFind(PanelCode, (int)Session["UserID"]); ddl_FindCondition.DataBind(); ddl_FindCondition.Items.Insert(0, new ListItem("请选择...", "0")); ddl_FindCondition.SelectedValue = _f.Model.ID.ToString(); bt_SaveCondition.OnClientClick = ""; } if (_f != null) { string _text = ""; string _value = ""; foreach (ListItem lt in lbx_search.Items) { if (lt.Value != "") { _text += lt.Text + "|"; _value += lt.Value + "|"; } } _f.Model.ConditionText = _text; _f.Model.ConditionValue = _value; _f.Model.ConditionSQL = GenarateSQL(); _f.Model.OpStaff = Int32.Parse(Session["UserID"].ToString()); _f.Update(); MessageBox.Show(this.Page, "高级条件保存成功!"); } }
private void BindDropDown() { UD_PanelBLL panelbll = new UD_PanelBLL(PanelCode, true); if (panelbll.Model != null) { ViewState["Panel"] = panelbll.Model.ID; //获取当前Panel已保存的查询条件 ddl_FindCondition.DataSource = ADFind_FindConditionBLL.GetMyADFind(PanelCode, (int)Session["UserID"]); ddl_FindCondition.DataBind(); ddl_FindCondition.Items.Insert(0, new ListItem("请选择...", "0")); //获取当前Pannel中包括的数据表 ddl_TableName.DataSource = UD_Panel_TableBLL.GetTableListByPanelID(panelbll.Model.ID); ddl_TableName.DataBind(); ddl_TableName_SelectedIndexChanged(null, null); bt_SaveCondition.OnClientClick = "javascript:OpenNewAdvancedFind('" + panelbll.Model.ID.ToString() + "')"; } else { MessageBox.Show(this.Page, "对不起,指定的PanelCode未在UD_Panel表中找到对应项!"); } }