private void RefreshSearch()
{
DataTable dt = bll.GetCommonSearchCurrentUser(Code);
string NullValuePrompt = "", strformat = "";
var drs = dt.Select(String.Format("{0}='Y'", sys_CommonSearchUser.Flag));
if (drs.Length > 0)
{
foreach (DataRow dr in drs)
{
NullValuePrompt += ("、" + dr[sys_CommonSearch.strColumnName]);
strformat += (" OR " + dr[sys_CommonSearch.strSQL]);
}
}
else
{
foreach (DataRow dr in dt.Rows)
{
NullValuePrompt += ("、" + dr[sys_CommonSearch.strColumnName]);
strformat += (" OR " + dr[sys_CommonSearch.strSQL]);
}
}
if (!String.IsNullOrEmpty(NullValuePrompt))
{
this.Properties.NullValuePrompt = NullValuePrompt.Substring(1);
this.ToolTip = this.Properties.NullValuePrompt;
}
if (!String.IsNullOrEmpty(NullValuePrompt))
{
this._sqlFomat = strformat.Substring(4);
}
}
private void frmDialog_CommonSearchSetting_Load(object sender, EventArgs e)
{
DataSource = bll.GetCommonSearchCurrentUser(Code);
gridControl1.DataSource = DataSource;
}