private void CreateAdvanceSearch() { DataRow[] drs = dtDetail.Select("bIsShow=1"); if (drs.Length > 0) { frmSearchForm frm = new frmSearchForm(); frm.Text = "高级查询"; foreach (DataRow dr in drs) { string sColumnType = dr["sColumnType"].ToString(); switch (sColumnType) { case "C": { frm.AddSearchItem(LangCenter.Instance.IsDefaultLanguage ? dr["sColumnCaption"].ToString() : dr["sColumnEngCaption"].ToString(), dr["sColumnFieldName"].ToString(), FiledType.C, dr["sReturnValue"].ToString(), dr["sReturnValue"].ToString()); break; } case "D": { frm.AddSearchItem(LangCenter.Instance.IsDefaultLanguage ? dr["sColumnCaption"].ToString() : dr["sColumnEngCaption"].ToString(), dr["sColumnFieldName"].ToString(), FiledType.D); break; } case "S": case "L": case "N": { frm.AddSearchItem(LangCenter.Instance.IsDefaultLanguage ? dr["sColumnCaption"].ToString() : dr["sColumnEngCaption"].ToString(), dr["sColumnFieldName"].ToString(), FiledType.S); break; } } } if (frm.ShowDialog() == DialogResult.OK) { InitGridData(frm.SearchSQL); } } }
public virtual void CreateSearchFilter() { DataRow[] drs = DynamicMasterTableData.Select("bQuery=1"); if (drs.Length > 0) { frmSearchForm frmSearch = new frmSearchForm(); foreach (DataRow dr in drs) { string sControlType = dr["sControlType"].ToString(); switch (sControlType) { case "txt": case "mtxt": { frmSearch.AddSearchItem(LangCenter.Instance.IsDefaultLanguage ? dr["sCaption"].ToString() : dr["sEngCaption"].ToString(), dr["sFieldName"].ToString(), FiledType.S); break; } case "cbx": { frmSearch.AddSearchItem(LangCenter.Instance.IsDefaultLanguage ? dr["sCaption"].ToString() : dr["sEngCaption"].ToString(), dr["sFieldName"].ToString(), FiledType.C, dr["sLookupNo"].ToString()); break; } case "lkp": { frmSearch.AddSearchItem(LangCenter.Instance.IsDefaultLanguage ? dr["sCaption"].ToString() : dr["sEngCaption"].ToString(), dr["sFieldName"].ToString(), FiledType.L, dr["sLookupNo"].ToString()); break; } case "det": { frmSearch.AddSearchItem(LangCenter.Instance.IsDefaultLanguage ? dr["sCaption"].ToString() : dr["sEngCaption"].ToString(), dr["sFieldName"].ToString(), FiledType.D); break; } } } if (frmSearch.ShowDialog() == DialogResult.OK) { MasterFilterSQL = " AND " + frmSearch.SearchSQL; } } }