轉帖|使用教程|編輯:我只采一朵|2014-06-09 10:02:45.000|閱讀 7229 次
概述:本文接著完成上一節的未完的界面設計內容,DevExpress換膚功能已經討論過了,這里就不再重復了。首先建立三個全局變量,一個存放文件路徑,一個存放數據,一個存放過濾條件。
# 界面/圖表報表/文檔/IDE等千款熱門軟控件火熱銷售中 >>
相關鏈接:
本文接著完成上一節未完的界面設計內容,DevExpress換膚功能已經討論過了,這里就不再重復了。首先建立三個全局變量,一個存放文件路徑,一個存放數據,一個存放過濾條件。
取得數據并綁定到表格中:
string DBFileName;
DataView dataView;
string[] filter = new string[3];
給 imageList 添加一些圖標(隨便找的):
DBFileName = DevExpress.Utils.FilesHelper.FindingFileName(Application.StartupPath, "Products.xml");
if (!string.IsNullOrEmpty(DBFileName))
{
DataSet dt = new DataSet();
dt.ReadXml(DBFileName);
gridControl1.DataSource = dataView = dt.Tables[0].DefaultView;
}

將工具欄中的種類項與圖標和表格關聯起來:
string[] s = new string[] { "Beverages","Condiments","Confections","Dairy Products",
"Grains/Cereals","Meat/Poultry","Produce","Seafood"};
for (int i = 0; i < s.Length; i++)
repositoryItemImageComboBox1.Items.Add(new ImageComboBoxItem(s[i], i + 1, i));
RepositoryItem ri = repositoryItemImageComboBox1.Clone() as RepositoryItem;
colCategoryID.ColumnEdit = ri;
修改種類項的屬性:
this.repositoryItemImageComboBox1.SmallImages = this.imageList1;
此時運行后界面應該是這樣的:

下面添加條件篩選的功能,首先定義一個設置篩選的方法:
private void SetFilter()
{
string f = "";
foreach (string s in filter)
{
if (f != "" && (!string.IsNullOrEmpty(s)))
{
f += " And";
}
if (!string.IsNullOrEmpty(s))
{
f += s;
}
dataView.RowFilter = (f == "") ? "No Filter" : "Filter: " + f;
iRecords.Caption = "Records: " + dataView.Count.ToString();
}
}
然后定義3種點擊事件,一個是篩選checkBox,一個是小于所選日期,一個選擇種類:
private void discontinued_EditValueChanged(object sender, EventArgs e)
{
if (discontinued.EditValue == null)
filter[0] = "";
else
filter[0] = string.Format("[Discontinued] = {0}", discontinued.EditValue.ToString());
SetFilter();
}
private void lastOrder_EditValueChanged(object sender, EventArgs e)
{
if (lastOrder.EditValue == null)
{
filter[1] = "";
}
else
{
filter[1] = string.Format("[LastOrder] < #{0}#", StringDataToFormat(lastOrder.EditValue.ToString()));
}
SetFilter();
}
private static string StringDataToFormat(string s)
{
try
{
DateTime dt = DateTime.Parse(s);
return string.Format("{0}/{1}/{2}", dt.Month.ToString(), dt.Day.ToString(), dt.Year.ToString());
}
catch
{
return s;
}
}
private void categories_EditValueChanged(object sender, EventArgs e)
{
if (categories.EditValue == null)
filter[2] = "";
else
filter[2] = string.Format("[CategoryID] = {0}",categories.EditValue.ToString());
SetFilter();
}
此時效果如下:

此時界面基本完成,剩下的就是加上一些邊邊角角的東西,比如設置清除篩選條件按鈕:
private void iClearFilter_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
discontinued.EditValue = null;
lastOrder.EditValue = null;
categories.EditValue = null;
}
然后總體效果圖就出來了:

本站文章除注明轉載外,均為本站原創或翻譯。歡迎任何形式的轉載,但請務必注明出處、不得修改原文相關鏈接,如果存在內容上的異議請郵件反饋至chenjj@ke049m.cn