private void FindDataFromMemory(string keyFilter)
{
DataTable dtView = m_dtAllData.Clone();
if (keyFilter != string.Empty)
{
string filterString = FilterStringUtil.GetFilterstring(typeof(eColView), keyFilter);
DataView dv = m_dtAllData.DefaultView;
dv.RowFilter = filterString;
dtView = dv.ToTable();
////get only the rows you want
//DataRow[] results = m_dtAllData.Select(filterString);
////populate new destination table
//foreach (DataRow dr in results)
// dtView.ImportRow(dr);
}
else
{
dtView = m_dtAllData.Copy();
//foreach (DataRow dr in m_dtAllData.Rows)
// dtView.ImportRow(dr);
}
fpInventorySummary.DataSource = dtView;
}
private DataTable FilterData(DataTable dtView, string filterText)
{
if (filterText.Trim() == String.Empty)
{
return(dtView);
}
//string[] colNames = Enum.GetNames(typeof(eColView));
//string filterString = string.Empty;
//for (int i = 0; i < colNames.Length; i++)
//{
// filterString += string.Format(@"CONVERT({0},'System.String') LIKE '%{1}%' ", colNames[i], filterText);
// if (i != colNames.Length - 1)
// filterString += " OR ";
//}
string filterString = FilterStringUtil.GetFilterstring(typeof(eColView), filterText);
//get only the rows you want
DataRow[] results = m_AllShipTransData.Select(filterString);
DataTable dtFilter = dtView.Clone();
//populate new destination table
foreach (DataRow dr in results)
{
dtFilter.ImportRow(dr);
}
return(dtFilter);
}
private DataTable FilterData(DataTable dtView, string keyFilter)
{
if (keyFilter.Trim() == String.Empty)
{
return(dtView);
}
string filterString = FilterStringUtil.GetFilterstring(typeof(eColView), keyFilter);
////get only the rows you want
DataRow[] results = dtView.Select(filterString);
DataTable dtFilter = dtView.Clone();
////populate new destination table
foreach (DataRow dr in results)
{
dtFilter.ImportRow(dr);
}
//DataView dv = m_dtAllData.DefaultView;
//dv.RowFilter = filterString;
//dtFilter = dv.ToTable();
return(dtFilter);
}
private void FindDataFromMemory(string keyFilter)
{
DataTable dtView = m_dtAllData.Clone();
if (keyFilter != string.Empty)
{
string filterString = FilterStringUtil.GetFilterstring(dtView, keyFilter);
DataView dv = m_dtAllData.DefaultView;
dv.RowFilter = filterString;
dtView = dv.ToTable();
////get only the rows you want
//DataRow[] results = m_dtAllData.Select(filterString);
////populate new destination table
//foreach (DataRow dr in results)
// dtView.ImportRow(dr);
}
else
{
dtView = m_dtAllData.Copy();
//foreach (DataRow dr in m_dtAllData.Rows)
// dtView.ImportRow(dr);
}
//RenameColumn(dtView, dtDateBegin.Value.Value);
//fpInventorySummary.DataSource = dtView;
fpInventorySummary.DataSource = RenameColumn(dtView, dtDateBegin.Value.Value);
if (shtInventorySummary.Columns.Count == ((int)eColView.Weight) + 1)
{
SetFormatData();
}
}
private void LoadItemData(string keyFilter)
{
//set ให้ show column ทั้งหมด
shtView.Columns[0, shtView.Columns.Count - 1].Visible = true;
InventoryPeriodBIZ inventoryPeriodBIZ = new InventoryPeriodBIZ();
InventoryPeriodDTO inventoryPeriodDTO = inventoryPeriodBIZ.LoadCurrentPeriod();
DataTable dt = null;
InventoryBIZ inventoryBIZ = new InventoryBIZ();
if (m_searchType == eSearchType.All)
{
dt = inventoryBIZ.LoadAllLotNo(inventoryPeriodDTO.YEAR_MONTH);
shtView.Columns[(int)eColView.ON_HAND_QTY].Visible = false;
}
else if (m_searchType == eSearchType.DependOnItemAndLocation)
{
dt = inventoryBIZ.LoadAllLotNoByItemAndLocation(inventoryPeriodDTO.YEAR_MONTH, m_itemCode, m_locationCode);
}
else
{
dt = inventoryBIZ.LoadAllLotNo(inventoryPeriodDTO.YEAR_MONTH);
shtView.Columns[(int)eColView.ON_HAND_QTY].Visible = false;
}
DataTable dtView = dt.Clone();
if (keyFilter != string.Empty)
{
// string filterString = string.Format(@"
// {1} LIKE '%{0}%'
// OR {2} LIKE '%{0}%'
// ", keyFilter, eColView.LOT_NO, eColView.PACK_NO);
string filterString = FilterStringUtil.GetFilterstring(dtView, keyFilter);
//get only the rows you want
DataRow[] results = dt.Select(filterString);
//populate new destination table
foreach (DataRow dr in results)
{
dtView.ImportRow(dr);
}
}
else
{
foreach (DataRow dr in dt.Rows)
{
dtView.ImportRow(dr);
}
}
fpView.DataSource = dtView;
}
private DataTable FilterData(DataTable dtView, string filterText)
{
if (filterText.Trim() == String.Empty)
{
return(dtView);
}
string filterString = FilterStringUtil.GetFilterstring(dtView, filterText);
//get only the rows you want
DataRow[] results = m_dtLog.Select(filterString);
DataTable dtFilter = dtView.Clone();
//populate new destination table
foreach (DataRow dr in results)
{
dtFilter.ImportRow(dr);
}
return(dtFilter);
}
private void LoadItemData(string keyFilter)
{
try
{
ItemBIZ biz = new ItemBIZ();
m_dtAllData = biz.LoadItemList();
DataTable dtView = null;// m_dtAllData.Clone();
if (keyFilter != string.Empty)
{
string filterString = FilterStringUtil.GetFilterstring(typeof(eColView), keyFilter);
DataView dv = m_dtAllData.DefaultView;
dv.RowFilter = filterString;
dtView = dv.ToTable();
////get only the rows you want
//DataRow[] results = m_dtAllData.Select(filterString);
////populate new destination table
//foreach (DataRow dr in results)
// dtView.ImportRow(dr);
}
else
{
//foreach (DataRow dr in m_dtAllData.Rows)
// dtView.ImportRow(dr);
dtView = m_dtAllData.Copy();
}
fpItemView.DataSource = dtView;
CtrlUtil.SpreadUpdateColumnSorting(shtItemView);
}
catch (Exception ex)
{
MessageDialog.ShowBusiness(this, ex.Message);
}
}
