private void lnkLbClearFilter_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
try
{
lnkLbClearFilter.Visible = false;
DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(dgvDeliveryMaster);
bsDelivery.DataSource = dtDeliveryMaster;
dgvDeliveryMaster.DataSource = bsDelivery;
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
private void DataGridView_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
string filterStatus = DataGridViewAutoFilterColumnHeaderCell.GetFilterStatus(dataGridView);
if (string.IsNullOrEmpty(filterStatus))
{
ShowAllLabel.Visible = false;
FilterStatusLabel.Visible = false;
}
else
{
ShowAllLabel.Visible = true;
FilterStatusLabel.Visible = true;
FilterStatusLabel.Text = filterStatus;
}
}
void dgvbindingcomplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
string filterstatus = DataGridViewAutoFilterColumnHeaderCell.GetFilterStatus(dgv);
if (string.IsNullOrEmpty(filterstatus))
{
ssl1.Visible = false;
ssl2.Visible = false;
}
else
{
ssl1.Visible = true;
ssl2.Visible = true;
ssl2.Text = filterstatus;
}
}
protected void ShowFilterStatus()
{
string filterStatus = DataGridViewAutoFilterColumnHeaderCell.GetFilterStatus(dataGridView);
// set labels when not filtered
if (string.IsNullOrEmpty(filterStatus) && AllRowsAreVisible)
{
ShowLabelsWhenNotFiltered();
}
// set labels when filtered
else
{
ShowLabelsWhenFiltered();
filterStatusLabel.Text = filterStatus;
}
}
private void dataGridViewPackageBackup_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
String filterStatus = DataGridViewAutoFilterColumnHeaderCell
.GetFilterStatus(dataGridViewPackageBackup);
if (String.IsNullOrEmpty(filterStatus))
{
showAllLabelH.Visible = false;
fiterStatusLabelH.Visible = false;
}
else
{
showAllLabelH.Visible = true;
fiterStatusLabelH.Visible = true;
fiterStatusLabelH.Text = filterStatus;
}
}
private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
// Continue only if the data source has been set.
String filterStatus = DataGridViewAutoFilterColumnHeaderCell
.GetFilterStatus(dataGridView1);
if (String.IsNullOrEmpty(filterStatus))
{
showAllLabel.Visible = false;
filterStatusLabel.Visible = false;
}
else
{
showAllLabel.Visible = true;
filterStatusLabel.Visible = true;
filterStatusLabel.Text = filterStatus;
}
}
// Updates the filter status label.
private void dgvOrders_DataBindingComplete(object sender,
DataGridViewBindingCompleteEventArgs e)
{
String filterStatus = DataGridViewAutoFilterColumnHeaderCell
.GetFilterStatus(dgvExpenseCodes);
if (String.IsNullOrEmpty(filterStatus))
{
showAllLabel.Visible = false;
filterStatusLabel.Visible = false;
}
else
{
showAllLabel.Visible = true;
filterStatusLabel.Visible = true;
filterStatusLabel.Text = filterStatus;
}
}
private void dgvConfiguration_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
String filterStatus = DataGridViewAutoFilterColumnHeaderCell.GetFilterStatus(dgvConfiguration);
if (String.IsNullOrEmpty(filterStatus))
{
lnkShowAllConfiguration.Visible = false;
lblFilterConfigurationStatus.Visible = false;
}
else
{
lnkShowAllConfiguration.Visible = true;
lblFilterConfigurationStatus.Visible = true;
lblFilterConfigurationStatus.Text = filterStatus;
}
foreach (DataGridViewColumn col in dgvConfiguration.Columns)
{
col.HeaderCell.Tag = col.Width / 2 <= 0 ? col.Width : col.Width / 2;
}
}
/// <summary>
/// Clear filter on data grid view - shows all records.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lnklblClearFilter_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
try
{
// lnklblClearFilter.Visible = false;
DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(dgvTasks);
//bsTansList.DataSource = ShipmentTANs;
//dgvShipmentTANs.DataSource = bsTansList;
if (HeaderCheckBox.Checked)
{
HeaderCheckBox.Checked = false;
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
/// <summary>
/// Removes the filter from the BindingSource bound to the specified DataGridView.
/// </summary>
/// <param name="dataGridView">The DataGridView bound to the BindingSource to unfilter.</param>
public static void RemoveFilter(DataGridView dataGridView)
{
DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(dataGridView);
}
private void toolStripStatus_ShowAll_Click(object sender, EventArgs e)
{
DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(this.dataGridView1);
}
private void toolStripButton6_Click(object sender, EventArgs e)
{
DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(gv_taskmanager);
}
private void tsbRemoveFilter_Click(object sender, EventArgs e)
{
DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(dgvUserProjectGroups);
}
/// <summary>
/// Формированре масива
/// значений для графика функции
/// для всех значений
/// </summary>
/// <param name="nameCol">имя столбца</param>
private void sampleValues(string nameCol)
{
string strQuery = string.Empty;
int countList = -1;
string elem;
////??? без таблицы, использовать m_dictValues
//var enValues = (from r in m_tblEdit.AsEnumerable()
// where r.Field<string>("N_ALG") == m_nameAlg
// select new
// {
// nameCol = r.Field<float>(nameCol),
// }).Distinct();
if (!(nameCol == "A3"))
{
//countList = enValues.Count();
//pointList = new PointPairList[countList];
//for (int i = 0; i < enValues.Count(); i++)
//{
// elem = enValues.ElementAt(i).nameCol.ToString().Replace(",", ".");
// strQuery = " N_ALG = " + "'" + m_nameAlg + "'and " + nameCol + " = " + elem + "";
// ftTableF = m_tblEdit.Select(strQuery);
// createPointLists(i, ftTableF);
//}
}
else
{
//var enValuesA2 = (from r in m_tblEdit.AsEnumerable()
// where r.Field<string>("N_ALG") == m_nameAlg
// select new
// {
// nameCol = r.Field<float>("A2"),
// }).Distinct();
//countList = enValues.Count() * enValuesA2.Count();
pointList = new PointPairList[countList];
int num = 0;
string m_ftValue = DataGridViewAutoFilterColumnHeaderCell.FilterValue();
elem = m_ftValue.ToString().Replace(",", ".");
//for (int i = 0; i < enValuesA2.Count(); i++)
//{
// strQuery = " N_ALG = " + "'" + m_nameAlg + "' and " + nameCol + " = " + elem + " and A2= " + enValuesA2.ElementAt(i).nameCol.ToString().Replace(",", ".") + "";
// //??? без таблицы, использовать m_dictValues
// //ftTableF = m_tblEdit.Select(strQuery);
// //if (!(ftTableF.Count() == 0))
// //{
// // createPointLists(num, ftTableF);
// // num++;
// //}
// //else
// // ;
//}
}
createGraphs();
}
private void lnkShowAllConfiguration_Click(object sender, EventArgs e)
{
DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(dgvConfiguration);
}
/// <summary>
/// Gets a status string for the specified DataGridView indicating the
/// number of visible rows in the bound, filtered BindingSource, or
/// String.Empty if all rows are currently visible.
/// </summary>
/// <param name="dataGridView">The DataGridView bound to the
/// BindingSource to return the filter status for.</param>
/// <returns>A string in the format "x of y records found" where x is
/// the number of rows currently displayed and y is the number of rows
/// available, or String.Empty if all rows are currently displayed.</returns>
public static String GetFilterStatus(DataGridView dataGridView)
{
return(DataGridViewAutoFilterColumnHeaderCell.GetFilterStatus(dataGridView));
}
void remclick(object sender, EventArgs e)
{
DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(dgv);
}
// Clears the filter when the user clicks the "Show All" link
// or presses ALT+A.
private void showAllLabel_Click(object sender, EventArgs e)
{
DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(dataGridView1);
}
private void lnkShowAllSource_Click(object sender, EventArgs e)
{
DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(dgvSource);
}
