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表中找到对应项!");
}
}
