/// <summary>
/// 载入高级查询条件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ddl_FindCondition_SelectedIndexChanged(object sender, EventArgs e)
{
lbx_search.Items.Clear();
if (ddl_FindCondition.SelectedValue != "0")
{
ADFind_FindCondition _findcondition = new ADFind_FindConditionBLL(Int32.Parse(ddl_FindCondition.SelectedValue)).Model;
if (!string.IsNullOrEmpty(_findcondition.ConditionText))
{
char[] charSeparators = new char[] { '|' };
string[] _texts = _findcondition.ConditionText.Split(charSeparators, StringSplitOptions.RemoveEmptyEntries);
string[] _values = _findcondition.ConditionValue.Replace("'|'", "'#'").Split(charSeparators, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < _texts.Length; i++)
{
if (!string.IsNullOrEmpty(_texts[i]))
{
lbx_search.Items.Add(new ListItem(_texts[i], _values[i].Replace("'#'", "'|'")));
}
}
}
bt_SaveCondition.Enabled = true;
bt_SaveCondition.OnClientClick = "";
}
else
{
bt_SaveCondition.OnClientClick = "javascript:OpenNewAdvancedFind('" + ViewState["Panel"].ToString() + "')";
//bt_SaveCondition.Enabled = false;
}
}
protected void bt_OK_Click(object sender, EventArgs e)
{
if (ddl_PanelList.SelectedValue == "0")
{
MessageBox.Show(this, "请选择所属Panel！");
return;
}
ADFind_FindConditionBLL _findconditionbll;
if ((int)ViewState["ID"] != 0)
{
//修改
_findconditionbll = new ADFind_FindConditionBLL((int)ViewState["ID"]);
}
else
{
//新增
_findconditionbll = new ADFind_FindConditionBLL();
_findconditionbll.Model.CreateDate = DateTime.Now;
_findconditionbll.Model.OpStaff = int.Parse(Session["UserID"].ToString());
}
#region 获取界面信息
_findconditionbll.Model.Name = tbx_Name.Text;
_findconditionbll.Model.ConditionText = tbx_ConditionText.Text;
_findconditionbll.Model.ConditionValue = tbx_ConditionValue.Text;
_findconditionbll.Model.ConditionSQL = tbx_ConditionSQL.Text;
_findconditionbll.Model.Panel = new Guid(ddl_PanelList.SelectedValue);
_findconditionbll.Model.IsPublic = ddl_IsPublic.SelectedValue;
#endregion
if ((int)ViewState["ID"] != 0)
{
//修改
if (_findconditionbll.Update() == 0)
{
MessageBox.ShowAndRedirect(this, "更新记录保存成功!", "FindCondition_List.aspx");
}
}
else
{
//新增
ViewState["ID"] = _findconditionbll.Add();
if ((int)ViewState["ID"] > 0)
{
MessageBox.ShowAndRedirect(this, "新增记录保存成功!", "FindCondition_List.aspx");
}
}
}
protected void bt_Save_Click(object sender, EventArgs e)
{
ADFind_FindConditionBLL _f = new ADFind_FindConditionBLL();
_f.Model.CreateDate = DateTime.Now;
_f.Model.OpStaff = int.Parse(Session["UserID"].ToString());
_f.Model.Name = tbx_Name.Text;
_f.Model.Panel = (Guid)ViewState["PanelID"];
_f.Model.IsPublic = ddl_IsPublic.SelectedValue;
Session["AdvancedFindNewID"] = _f.Add();
MessageBox.ResponseScript(this, "window.close();");
}
protected void bt_OK_Click(object sender, EventArgs e)
{
if (ddl_PanelList.SelectedValue == "0")
{
MessageBox.Show(this, "请选择所属Panel！");
return;
}
ADFind_FindConditionBLL _findconditionbll;
if ((int)ViewState["ID"] != 0)
{
//修改
_findconditionbll = new ADFind_FindConditionBLL((int)ViewState["ID"]);
}
else
{
//新增
_findconditionbll = new ADFind_FindConditionBLL();
_findconditionbll.Model.CreateDate = DateTime.Now;
_findconditionbll.Model.OpStaff = int.Parse(Session["UserID"].ToString());
}
#region 获取界面信息
_findconditionbll.Model.Name = tbx_Name.Text;
_findconditionbll.Model.ConditionText = tbx_ConditionText.Text;
_findconditionbll.Model.ConditionValue = tbx_ConditionValue.Text;
_findconditionbll.Model.ConditionSQL = tbx_ConditionSQL.Text;
_findconditionbll.Model.Panel = new Guid(ddl_PanelList.SelectedValue);
_findconditionbll.Model.IsPublic = ddl_IsPublic.SelectedValue;
#endregion
if ((int)ViewState["ID"] != 0)
{
//修改
if (_findconditionbll.Update() == 0)
{
MessageBox.ShowAndRedirect(this, "更新记录保存成功!", "FindCondition_List.aspx");
}
}
else
{
//新增
ViewState["ID"] = _findconditionbll.Add();
if ((int)ViewState["ID"] > 0)
{
MessageBox.ShowAndRedirect(this, "新增记录保存成功!", "FindCondition_List.aspx");
}
}
}
protected void bt_Save_Click(object sender, EventArgs e)
{
ADFind_FindConditionBLL _f = new ADFind_FindConditionBLL();
_f.Model.CreateDate = DateTime.Now;
_f.Model.OpStaff = int.Parse(Session["UserID"].ToString());
_f.Model.Name = tbx_Name.Text;
_f.Model.Panel = (Guid)ViewState["PanelID"];
_f.Model.IsPublic = ddl_IsPublic.SelectedValue;
Session["AdvancedFindNewID"] = _f.Add();
MessageBox.ResponseScript(this, "window.close();");
}
protected void bt_Delete_Click(object sender, EventArgs e)
{
ADFind_FindConditionBLL _findconditionbll;
if ((int)ViewState["ID"] != 0)
{
_findconditionbll = new ADFind_FindConditionBLL((int)ViewState["ID"]);
try
{
_findconditionbll.Delete();
MessageBox.ShowAndRedirect(this, "删除条件记录成功!", "FindCondition_List.aspx");
}
catch
{
MessageBox.Show(this, "由于该查询条件正在系统中使用,暂时无法删除!");
}
}
}
protected void bt_Delete_Click(object sender, EventArgs e)
{
ADFind_FindConditionBLL _findconditionbll;
if ((int)ViewState["ID"] != 0)
{
_findconditionbll = new ADFind_FindConditionBLL((int)ViewState["ID"]);
try
{
_findconditionbll.Delete();
MessageBox.ShowAndRedirect(this, "删除条件记录成功!", "FindCondition_List.aspx");
}
catch
{
MessageBox.Show(this, "由于该查询条件正在系统中使用,暂时无法删除!");
}
}
}
private void BindGrid()
{
if (ddl_PanelList.SelectedValue != "0")
{
string _conditionstring = "Panel='" + ddl_PanelList.SelectedValue + "'";
if (tbx_Find.Text.Trim() != "")
{
_conditionstring += " and Name like '%" + tbx_Find.Text.Trim() + "%'";
}
IList <ADFind_FindCondition> _conditioins = ADFind_FindConditionBLL.GetModelList(_conditionstring);
if (ViewState["PageIndex"] != null)
{
gv_List.PageIndex = Int32.Parse(ViewState["PageIndex"].ToString());
}
gv_List.DataSource = _conditioins;
gv_List.DataBind();
}
}
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 BindData()
{
ADFind_FindCondition _findcondition = new ADFind_FindConditionBLL((int)ViewState["ID"]).Model;
#region 绑定基本信息
lb_ID.Text = _findcondition.ID.ToString();
tbx_Name.Text = _findcondition.Name;
tbx_ConditionText.Text = _findcondition.ConditionText;
tbx_ConditionValue.Text = _findcondition.ConditionValue;
tbx_ConditionSQL.Text = _findcondition.ConditionSQL;
if (_findcondition.CreateDate != new DateTime(1900, 1, 1))
{
tbx_CreateDate.Text = _findcondition.CreateDate.ToString();
}
ddl_IsPublic.SelectedValue = _findcondition.IsPublic;
ddl_PanelList.SelectedValue = _findcondition.Panel.ToString();
ddl_PanelList.Enabled = false;
#endregion
}
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表中找到对应项!");
}
}
private void BindData()
{
ADFind_FindCondition _findcondition = new ADFind_FindConditionBLL((int)ViewState["ID"]).Model;
#region 绑定基本信息
lb_ID.Text = _findcondition.ID.ToString();
tbx_Name.Text = _findcondition.Name;
tbx_ConditionText.Text = _findcondition.ConditionText;
tbx_ConditionValue.Text = _findcondition.ConditionValue;
tbx_ConditionSQL.Text = _findcondition.ConditionSQL;
if (_findcondition.CreateDate != new DateTime(1900, 1, 1)) tbx_CreateDate.Text = _findcondition.CreateDate.ToString();
ddl_IsPublic.SelectedValue = _findcondition.IsPublic;
ddl_PanelList.SelectedValue = _findcondition.Panel.ToString();
ddl_PanelList.Enabled = false;
#endregion
}
/// <summary>
/// 载入高级查询条件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ddl_FindCondition_SelectedIndexChanged(object sender, EventArgs e)
{
lbx_search.Items.Clear();
if (ddl_FindCondition.SelectedValue != "0")
{
ADFind_FindCondition _findcondition = new ADFind_FindConditionBLL(Int32.Parse(ddl_FindCondition.SelectedValue)).Model;
if (!string.IsNullOrEmpty(_findcondition.ConditionText))
{
char[] charSeparators = new char[] { '|' };
string[] _texts = _findcondition.ConditionText.Split(charSeparators, StringSplitOptions.RemoveEmptyEntries);
string[] _values = _findcondition.ConditionValue.Replace("'|'", "'#'").Split(charSeparators, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < _texts.Length; i++)
{
if (!string.IsNullOrEmpty(_texts[i]))
{
lbx_search.Items.Add(new ListItem(_texts[i], _values[i].Replace("'#'", "'|'")));
}
}
}
bt_SaveCondition.Enabled = true;
bt_SaveCondition.OnClientClick = "";
}
else
{
bt_SaveCondition.OnClientClick = "javascript:OpenNewAdvancedFind('" + ViewState["Panel"].ToString() + "')";
//bt_SaveCondition.Enabled = false;
}
}
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, "高级条件保存成功！");
}
}
