public void LoadFilteredDRDetails(SqlDataSource DRDetailsDataSource, int DRID_S, int DRID_E, int CustomerNumber)
{
StringBuilder search_command = new StringBuilder();
search_command.Append(" SELECT DR.DRNo, DRDtl.SKU, DRDtl.StyleNo, DR.ItemStatus, DRDtl.Quantity, DRDtl.UnitPrice FROM DR INNER JOIN DRDtl ON DR.ID = DRDtl.DRID ");
search_command.Append(" where DR.ID between @ID_S and @ID_E and custno =@Customer_Number ");
Parameter prmDRIDS = new Parameter
{
DbType = System.Data.DbType.Int32 ,
Name = "ID_S",
DefaultValue = DRID_S.ToString(),
};
Parameter prmDRIDE = new Parameter
{
DbType = System.Data.DbType.Int32,
Name = "ID_E",
DefaultValue = DRID_E.ToString(),
};
Parameter prmCustomerNumber = new Parameter
{
DbType = System.Data.DbType.Int32,
Name = "Customer_Number",
DefaultValue = CustomerNumber.ToString(),
};
DRDetailsDataSource.SelectParameters.Add(prmDRIDS);
DRDetailsDataSource.SelectParameters.Add(prmDRIDE);
DRDetailsDataSource.SelectParameters.Add(prmCustomerNumber);
DRDetailsDataSource.SelectCommand = search_command.ToString();
DRDetailsDataSource.DataBind();
// SELECT DR.DRNo, DRDtl.SKU, DRDtl.StyleNo, DR.ItemStatus, DRDtl.Quantity, DRDtl.UnitPrice FROM DR
//INNER JOIN DRDtl ON DR.ID = DRDtl.DRID
//where DR.ID between @IDS and @IDE and custno =@CustomerNumber
}
public SqlDataSource SearchOutletDataSource(SqlDataSource sql_data_source, string search_parameter, string Brand)
{
//if (Brand != "ALL")
//{
//if (search_parameter != string.Empty)
// {
// sql_data_source.SelectCommand = "SELECT [CustNo], [CompName], [brand] FROM [CustInfo] where brand ='"+ Brand +"' and CompName Like '%" +
// search_parameter + "%'";
// }
// else
// {
// sql_data_source.SelectCommand = "SELECT [CustNo], [CompName], [brand] FROM [CustInfo] where brand ='" + Brand + "' ";
// }
//}
//else
//{
if (search_parameter != string.Empty)
{
sql_data_source.SelectCommand = "SELECT [CustNo], [CompName], [brand] FROM [CustInfo] where CompName Like '%" +
search_parameter + "%'";
}
else
{
sql_data_source.SelectCommand = "SELECT [CustNo], [CompName], [brand] FROM [CustInfo] ";
}
//}
sql_data_source.DataBind();
return sql_data_source;
}
public void FilterSalesInvoiceList(SqlDataSource datasource, string filter_field_type)
{
switch (filter_field_type)
{
case "POSTED":
datasource.SelectCommand = SearchCommand(filter_field_type);
datasource.DataBind();
break;
case "UNPOSTED":
datasource.SelectCommand = SearchCommand(filter_field_type);
datasource.DataBind();
break;
case "CANCELLED":
datasource.SelectCommand = SearchCommand(filter_field_type);
datasource.DataBind();
break;
}
}
public void SearchCustomers(SqlDataSource CustomerDatasource, string search_parameter, string Brand)
{
StringBuilder commandText = new StringBuilder();
commandText.Append("SELECT [CustNo], [CompName],[PGNo] FROM [CustInfo] WHERE ([brand] = '" + Brand + "')");
if (search_parameter != "")
{
commandText.Append(" and CompName LIKE'%"+search_parameter+"%'");
}
CustomerDatasource.SelectCommand = commandText.ToString();
CustomerDatasource.DataBind();
}
public void SeachCustomers(SqlDataSource CustomerDataSource, string search_parameter)
{
StringBuilder search_command = new StringBuilder();
search_command.Append("SELECT [CustNo], [CompName] FROM [CustInfo] ");
if (!string.IsNullOrEmpty(search_parameter))
{
search_command.Append(" WHERE CompName LIKE '%"+search_parameter+"%' ");
}
CustomerDataSource.SelectCommand = search_command.ToString();
CustomerDataSource.DataBind();
}
public void SearchGeneralMemo(SqlDataSource data_source, string search_parameter)
{
StringBuilder command_text = new StringBuilder();
command_text.Append("SELECT [ID], [MemoNo], [MemoDate], [BrandName], [GrpNo], [PriceType], [FromDate], [ToDate], [Status] FROM [GenMemo] WHERE ");
if (search_parameter != "")
{
command_text.Append(" MemoNo LIKE '%" + search_parameter + "%' AND Status = 'Pending' ");
}
data_source.SelectCommand = command_text.ToString();
data_source.DataBind();
}
public SqlDataSource SearchUsers(SqlDataSource UsersDataSource, string search_parameter)
{
StringBuilder CommandText = new StringBuilder();
CommandText.Append("SELECT Users.ID, Users.UserName, Users.FullName, Users.Email, lstDept.ListDesc, lstUserLevel.ListDesc AS UserLevel FROM Users INNER JOIN lstDept ON Users.DeptID = lstDept.ID INNER JOIN lstUserLevel ON Users.UserLevelID = lstUserLevel.ID WHERE (lstDept.ID = 4) ");
if (search_parameter != "")
{
CommandText.Append(" AND Users.UserName LIKE '%" + search_parameter + "%'");
}
UsersDataSource.SelectCommand = CommandText.ToString();
UsersDataSource.DataBind();
return UsersDataSource;
}
public void AdvanceSearch(SqlDataSource datasource, string search_parameter, string filter_type, DateTime date_from, DateTime date_to, string CompanyName)
{
if (filter_type != string.Empty)
{
switch (filter_type)
{
case "POSTED":
datasource.SelectCommand = AdvanceSearchCommand(search_parameter, "1", filter_type, date_from, date_to, CompanyName);
datasource.DataBind();
break;
case "UNPOSTED":
datasource.SelectCommand = AdvanceSearchCommand(search_parameter, "0", filter_type, date_from, date_to, CompanyName);
datasource.DataBind();
break;
case "CANCELLED":
datasource.SelectCommand = AdvanceSearchCommand(search_parameter, "1", filter_type, date_from, date_to, CompanyName);
datasource.DataBind();
break;
//default:
// string CommandText;
// CommandText = "SELECT [ID], [CRSID], [CRSNo], [CRSDate], [Customer], [TotalAmt], [PUSNo], [PkgNo], [ItemStatus] FROM CRS";
// CommandText += "WHERE CRSDate BETWEEN '" + date_from + "' AND '" + date_to + "'";
// if (search_parameter != string.Empty)
// {
// CommandText += " AND CRSNo LIKE '%" + search_parameter + "%' ";
// //CommandText += " OR ID LIKE '%" + search_parameter + "%' ";
// }
// if (!CompanyName.Equals(string.Empty))
// {
// CommandText += " AND Customer LIKE '%" + CompanyName + "%'";
// }
// datasource.SelectCommand = CommandText;
// datasource.DataBind();
//break;
}
}
else
{
}
}
public void FilterStyles(SqlDataSource StylesDataSource, string Brand="")
{
StringBuilder commandText = new StringBuilder();
commandText.Append("SELECT DISTINCT(Style.StyleNo) AS STYLE_NUMBER, [StyleID] AS RECORD_NO, Style.[StyleDesc] AS DESCRIPTION, Cost AS COST_PRICE,Style.BrandName,Product.AP_Type FROM [STYLE] INNER JOIN Product on Product.StyleNo=Style.StyleNo ");
if (Brand != "")
{
commandText.Append(" WHERE Style.BrandName ='" + Brand + "' ");
}
commandText.Append(" ORDER BY StyleID DESC");
StylesDataSource.SelectCommand = commandText.ToString();
StylesDataSource.SelectCommandType = SqlDataSourceCommandType.Text;
StylesDataSource.DataBind();
}
public void AdvanceSearch(SqlDataSource datasource, string search_parameter, string filter_type, DateTime date_from, DateTime date_to, string CompanyName)
{
if (filter_type != string.Empty)
{
switch (filter_type)
{
case "POSTED":
datasource.SelectCommand = AdvanceSearchCommand(search_parameter, "1", filter_type, date_from, date_to, CompanyName);
datasource.DataBind();
break;
case "UNPOSTED":
datasource.SelectCommand = AdvanceSearchCommand(search_parameter, "0", filter_type, date_from, date_to, CompanyName);
datasource.DataBind();
break;
case "CANCELLED":
datasource.SelectCommand = AdvanceSearchCommand(search_parameter, "1", filter_type, date_from, date_to, CompanyName);
datasource.DataBind();
break;
}
}
else
{
}
}
public void SeachOutRightmrkDownMemoIncludeDateRange(SqlDataSource OutRightDataSource, string search_parameter, DateTime date_from, DateTime date_to)
{
string CommandText = string.Empty;
if(search_parameter != string.Empty)
{
CommandText = "SELECT MDMemo.ID, MDMemo.MemoNo, MDMemo.MemoDate, MDMemo.Header, MDMemo.Intro, CustInfo.CompName, MDMemo.RemInvDate, MDMemo.GenMemoNo, MDMemo.Message, MDMemo.Footer FROM MDMemo INNER JOIN CustInfo ON MDMemo.CustNo = CustInfo.CustNo WHERE "
+ " MDMemo.MemoNo LIKE '%" +
search_parameter + "%' OR CustInfo.CompName LIKE '%" +
search_parameter + "%' AND (MDMemo.MemoType = 'Outright') AND MDMemo.MemoDate BETWEEN '"+date_from +"' AND '"+ date_to +"'";
}else {
CommandText = "SELECT MDMemo.ID, MDMemo.MemoNo, MDMemo.MemoDate, MDMemo.Header, MDMemo.Intro, CustInfo.CompName, MDMemo.RemInvDate, MDMemo.GenMemoNo, MDMemo.Message, MDMemo.Footer FROM MDMemo INNER JOIN CustInfo ON MDMemo.CustNo = CustInfo.CustNo WHERE "
+ " MDMemo.MemoDate BETWEEN '" + date_from + "' AND '" + date_to + "' AND (MDMemo.MemoType = 'Outright')";
}
OutRightDataSource.SelectCommand = CommandText;
OutRightDataSource.DataBind();
}
public SqlDataSource SearchOutletDataSource(SqlDataSource sql_data_source, string search_parameter)
{
if (search_parameter != string.Empty)
{
sql_data_source.SelectCommand = "SELECT [CustNo], [CompName], [CustCode], [CustType], [brand], [BrandNameNo], [ArrangeType], [Addr1], [BRAND_CODE] FROM [CustInfo] a inner join [BRANDS] b on a.[brand]=b.[BRAND_DESCRIPTION] where CompName Like '%" + search_parameter + "%'";
}
else
{
sql_data_source.SelectCommand = "SELECT [CustNo], [CompName], [CustCode], [CustType], [brand], [BrandNameNo], [ArrangeType], [Addr1] FROM [CustInfo]";
}
sql_data_source.DataBind();
return sql_data_source;
}
public SqlDataSource SearchStyleDataSource(SqlDataSource sql_data_source, string search_parameter)
{
if (search_parameter != string.Empty)
{
sql_data_source.SelectCommand = "SELECT [StyleNo], [BrandName], [StyleDesc], [AP_Type], [BRAND_CODE] FROM [Style] a inner join [BRANDS] b on a.BrandName=b.BRAND_DESCRIPTION where StyleNo Like '%" + search_parameter + "%'";
}
else
{
sql_data_source.SelectCommand = "SELECT [StyleNo], [BrandName], [StyleDesc], [AP_Type], [BRAND_CODE] FROM [Style] a inner join [BRANDS] b on a.BrandName=b.BRAND_DESCRIPTION";
}
sql_data_source.DataBind();
return sql_data_source;
}
public void SearchConcessionMarkDownMemo(SqlDataSource OutRightDataSource, string search_parameter)
{
OutRightDataSource.SelectCommand = "SELECT MDMemo.ID, MDMemo.MemoNo, MDMemo.MemoDate, MDMemo.Header, MDMemo.Intro, CustInfo.CompName, MDMemo.RemInvDate, MDMemo.GenMemoNo, MDMemo.Message, MDMemo.Footer FROM MDMemo INNER JOIN CustInfo ON MDMemo.CustNo = CustInfo.CustNo WHERE "
+ " MDMemo.MemoNo LIKE '%" + search_parameter + "%' OR CustInfo.CompName LIKE '%" + search_parameter + "%' AND (MDMemo.MemoType = 'Concession')";
OutRightDataSource.DataBind();
}
public void SearchCustomerReturnSlipWithDateRange(SqlDataSource DataSource, string PostedStatus, string search_parameter, DateTime date_from, DateTime date_to)
{
string CommandText = string.Empty;
CommandText = "SELECT [ID], [CRSID], [CRSNo], [CRSDate], [Customer], [PUSNo], [TotalAmt], [PkgNo], [ItemStatus] FROM [CRS] ";
CommandText += " WHERE CRSDate BETWEEN '" + date_from + "' AND '" + date_to + "' ";
if (PostedStatus != "CONFIRMED")
{
if (search_parameter != string.Empty)
{
CommandText += " AND CRSNo LIKE '%" + search_parameter + "%' OR Customer LIKE '%" + search_parameter + "%' ";
if (PostedStatus == "POSTED")
{
CommandText += " AND ynPosted=1 AND ynCancelled=0";
}
else
{
CommandText += " AND ynPosted=0 AND ynCancelled=0 ";
}
}
else
{
if (PostedStatus == "POSTED")
{
CommandText += " AND ynPosted=1 AND ynCancelled=0 ";
}
else
{
CommandText += " AND ynPosted=0 AND ynCancelled=0 ";
}
}
}
else
{
if (search_parameter != string.Empty)
{
CommandText += " AND CRSNo LIKE '%" + search_parameter + "%' OR Customer LIKE '%" + search_parameter + "%' ";
CommandText += " AND ynCancelled=1";
}
else
{
CommandText += " AND ynCancelled=1";
}
}
DataSource.SelectCommand = CommandText;
DataSource.DataBind();
}
public void SearchDeliveryReceiptList(SqlDataSource datasource, string search_parameter)
{
string CommandText = string.Empty;
CommandText = "SELECT [ID], [DRNo], [DRDate], [PLNo], [CustNo], [DeliveredTo], [CustAddr], [TotalQty], [TotalAmt], [ItemStatus] FROM [DR] ";
CommandText += " WHERE DRNo LIKE '%" + search_parameter + "%' ORDER BY DRDate DESC ";//OR ID LIKE '%"+ search_parameter+"%'";
datasource.SelectCommand = CommandText;
datasource.DataBind();
}
public void SearchCustomerReturnSlipList(SqlDataSource datasource, string search_parameter, string Status, string SearchOption)
{
switch (Status)
{
case "CANCELLED":
datasource.SelectCommand = SearchCommand(search_parameter, "1", Status, SearchOption);
datasource.DataBind();
break;
case "POSTED":
datasource.SelectCommand = SearchCommand(search_parameter, "1", Status, SearchOption);
datasource.DataBind();
break;
case "UNPOSTED":
datasource.SelectCommand = SearchCommand(search_parameter, "0", Status, SearchOption);
datasource.DataBind();
break;
}
}
public void FilterCustomerReturnSlipList(SqlDataSource datasource, string filter_field_type)
{
string CommandText = string.Empty;
switch (filter_field_type)
{
case "POSTED":
CommandText = "SELECT [ID], [CRSID], [CRSNo], [CRSDate], [Customer], [TotalAmt], [PUSNo], [PkgNo], [ItemStatus] FROM CRS WHERE ynPosted=1 and ynCancelled=0 ORDER BY CRSDate DESC ";
datasource.SelectCommand = CommandText;
datasource.DataBind();
break;
case "UNPOSTED":
CommandText = "SELECT [ID], [CRSID], [CRSNo], [CRSDate], [Customer], [TotalAmt], [PUSNo], [PkgNo], [ItemStatus] FROM CRS WHERE ynPosted=0 and ynCancelled=0 ORDER BY CRSDate DESC ";
datasource.SelectCommand = CommandText;
datasource.DataBind();
break;
case "CANCELLED":
CommandText = "SELECT [ID], [CRSID], [CRSNo], [CRSDate], [Customer], [TotalAmt], [PUSNo], [PkgNo], [ItemStatus] FROM CRS WHERE ynCancelled=1 ORDER BY CRSDate DESC ";
datasource.SelectCommand = CommandText;
datasource.DataBind();
break;
//default:
// CommandText = "SELECT [ID], [CRSID], [CRSNo], [CRSDate], [Customer], [TotalAmt], [PUSNo], [PkgNo], [ItemStatus] FROM CRS ";
// datasource.SelectCommand = CommandText;
// datasource.DataBind();
// break;
}
}
public void SearchForwarderCustomer(SqlDataSource ForwarderCustomerDataSource, string searchParameter,int forwarderNumber,string brandName="")
{
StringBuilder strCmd = new StringBuilder();
strCmd.Append("SELECT FORWARDER_CUSTOMERS.RECORD_NO, CustInfo.CompName, CustInfo.brand,CustNo FROM CustInfo INNER JOIN FORWARDER_CUSTOMERS ON CustInfo.CustNo = FORWARDER_CUSTOMERS.CUSTOMER_NO WHERE ( FORWARDER_CUSTOMERS.FORWARDER_NO = "+forwarderNumber+") ");
if (!string.IsNullOrEmpty(searchParameter))
{
if (!string.Equals(brandName,"ALL"))
{
strCmd.Append(" AND CustInfo.brand ='"+brandName+"' ");
}
strCmd.Append(" AND CustInfo.CompName LIKE '%"+searchParameter+"%' ");
}
else
{
if (!string.Equals(brandName, "ALL"))
{
strCmd.Append(" AND CustInfo.brand ='" + brandName + "' ");
}
}
ForwarderCustomerDataSource.SelectCommand = strCmd.ToString();
ForwarderCustomerDataSource.DataBind();
}
public SqlDataSource Sample()
{
SqlDataSource ds = new SqlDataSource();
DbManager dbm = Accessor.GetDbManager();
ds = IRMS.Components.DataSource.IRMSDataSource(dbm.Connection.ConnectionString, dbm.DataProvider.ProviderName);
ds.SelectCommand = "SELECT * FROM DR";
ds.DataSourceMode = SqlDataSourceMode.DataSet;
ds.EnableCaching = true;
ds.EnableViewState = true;
ds.DataBind();
return ds;
}
public void FilterCustomerReturnSlip(SqlDataSource DataSource, string PostedStatus)
{
string CommandText = string.Empty;
CommandText = "SELECT [ID], [CRSID], [CRSNo], [CRSDate], [Customer], [PUSNo], [TotalAmt], [PkgNo], [ItemStatus] FROM [CRS] ";
if (PostedStatus != "CONFIRMED")
{
switch (PostedStatus)
{
case "POSTED":
CommandText += " WHERE ynPosted=1 AND ynCancelled=0 and CRS.CRSNo not in(SELECT CRS_CONFIRMATIONS.CRS_NUMBER from CRS_CONFIRMATIONS) order by CRSDate DESC";
break;
case "UNPOSTED":
CommandText += " WHERE ynPosted=0 AND ynCancelled=0 and CRS.CRSNo not in(SELECT CRS_CONFIRMATIONS.CRS_NUMBER from CRS_CONFIRMATIONS) order by CRSDate DESC";
break;
case "CANCELLED":
CommandText += " WHERE ynCancelled=1 ORDER BY CRSDate DESC ";
break;
default:
break;
}
}
else
{
CommandText = "SELECT [ID], [CRSID], [CRSNo], [CRSDate], [Customer], [PUSNo], [TotalAmt], [PkgNo], [ItemStatus] FROM [CRS] ";
CommandText += " INNER JOIN CRS_CONFIRMATIONS ON CRS.CRSNo = CRS_CONFIRMATIONS.CRS_NUMBER order by CRSDate DESC";
}
DataSource.SelectCommand = CommandText;
DataSource.DataBind();
}
public void FilterCustomerReturnSlip(SqlDataSource DataSource,string PostedStatus)
{
string CommandText = string.Empty;
CommandText = "SELECT [ID], [CRSID], [CRSNo], [CRSDate], [Customer], [PUSNo], [TotalAmt], [PkgNo], [ItemStatus] FROM [CRS] ";
if (PostedStatus != "CONFIRMED")
{
if (PostedStatus == "POSTED")
{
if (CRSConfirmationCount() > 0)
{
CommandText += " INNER JOIN CRS_CONFIRMATIONS ON CRS.CRSNo != CRS_CONFIRMATIONS.CRS_NUMBER WHERE ynPosted=1 AND ynCancelled=0 order by CRSDate DESC";
}
else
{
CommandText += " WHERE ynPosted=1 AND ynCancelled=0 order by CRSDate DESC";
}
}
else
{
if (CRSConfirmationCount() > 0)
{
CommandText += " INNER JOIN CRS_CONFIRMATIONS ON CRS.CRSNo != CRS_CONFIRMATIONS.CRS_NUMBER WHERE ynPosted=0 AND ynCancelled=0 order by CRSDate DESC";
}
else
{
CommandText += " WHERE ynPosted=0 AND ynCancelled=0 order by CRSDate DESC";
}
}
}
else
{
CommandText = "SELECT [ID], [CRSID], [CRSNo], [CRSDate], [Customer], [PUSNo], [TotalAmt], [PkgNo], [ItemStatus] FROM [CRS] ";
CommandText += " INNER JOIN CRS_CONFIRMATIONS ON CRS.CRSNo = CRS_CONFIRMATIONS.CRS_NUMBER order by CRSDate DESC";
}
DataSource.SelectCommand = CommandText;
DataSource.DataBind();
}
//public void SearchSalesInvoiceList(SqlDataSource datasource, string search_parameter, string Status)
//{
// string CommandText = string.Empty;
// CommandText = "SELECT [ID], [SIID], [SINo], [SIDate], [CustNo], [SoldTo], [CustAddr], [TotalAmt], [TotalQty], [PLNo] FROM SI";
// CommandText += " WHERE SINo LIKE '%" + search_parameter + "%' ";
// CommandText +=" OR PLNo LIKE '%" + search_parameter + "%' ";
// if(Status !="CANCELLED")
// {
// CommandText + =" and ";
// }else
// {
// }
// datasource.SelectCommand = CommandText;
// datasource.DataBind();
//}
public void SearchSalesInvoiceList(SqlDataSource datasource, string search_parameter, string Status,string SearchOption)
{
switch (Status)
{
case "CANCELLED":
datasource.SelectCommand = SearchCommand(search_parameter, "1", Status, SearchOption);
datasource.DataBind();
break;
case "POSTED":
datasource.SelectCommand = SearchCommand(search_parameter, "1", Status, SearchOption);
datasource.DataBind();
break;
case "UNPOSTED":
datasource.SelectCommand = SearchCommand(search_parameter, "0", Status, SearchOption);
datasource.DataBind();
break;
//default:
// SearchSalesInvoiceList(datasource, search_parameter);
// break;
}
}
public void SearchGeneralMemoByMemoNoAndBrand(SqlDataSource data_source, string BrandName, string search_parameter)
{
StringBuilder command_text = new StringBuilder();
command_text.Append("SELECT [ID], [MemoNo], [MemoDate], [BrandName], [GrpNo], [PriceType], [FromDate], [ToDate], [Status] FROM [GenMemo] WHERE ");
command_text.Append(" BrandName = '" + BrandName + "' and ");
command_text.Append(" MemoNo LIKE '%" + search_parameter + "%' order by fromDate Desc");
data_source.SelectCommand = command_text.ToString();
data_source.DataBind();
}
public void SearchCustomer(SqlDataSource CustomerDataSource,string search_parameter)
{
string CommandText = string.Empty;
CommandText = "SELECT [CustNo], [CompName], [brand], [Addr1] FROM [CustInfo] WHERE ([ynActive] =1) ";
CommandText += " and CompName LIKE '%" + search_parameter + "%' OR brand LIKE '%"+ search_parameter +"%'";
CustomerDataSource.SelectCommand = CommandText;
CustomerDataSource.DataBind();
}
public void SearchCustomerReturnSlip(SqlDataSource DataSource, string PostedStatus, string search_parameter,string searchMode)
{
string CommandText = string.Empty;
CommandText = "SELECT [ID], [CRSID], [CRSNo], [CRSDate], [Customer], [PUSNo], [TotalAmt], [PkgNo], [ItemStatus] FROM [CRS] ";
if (PostedStatus != "CONFIRMED")
{
CommandText += " WHERE ";
if (search_parameter != string.Empty)
{
switch (PostedStatus)
{
case "POSTED":
CommandText += " ynPosted=1 AND ynCancelled=0";
CommandText += " and CRS.CRSNo not in(SELECT CRS_CONFIRMATIONS.CRS_NUMBER from CRS_CONFIRMATIONS) AND "
+searchMode+" LIKE '%" + search_parameter + "%' ";
break;
case "UNPOSTED":
CommandText += " ynPosted=0 AND ynCancelled=0";
CommandText += " and CRS.CRSNo not in(SELECT CRS_CONFIRMATIONS.CRS_NUMBER from CRS_CONFIRMATIONS) AND "
+ searchMode + " LIKE '%" + search_parameter + "%' ";
break;
case "CANCELLED":
CommandText += " ynCancelled=0 AND "
+ searchMode + " LIKE '%" + search_parameter + "%' ";
break;
default:
break;
}
}
else
{
switch (PostedStatus)
{
case "POSTED":
CommandText += " ynPosted=1 AND ynCancelled=0";
break;
case "UNPOSTED":
CommandText += " ynPosted=0 AND ynCancelled=0";
break;
case "CANCELLED":
CommandText += " ynCancelled=0";
break;
default:
break;
}
}
}
else
{
if (search_parameter != string.Empty)
{
CommandText += " WHERE CRSNo LIKE '%" + search_parameter + "%' OR Customer LIKE '%" + search_parameter + "%' ";
CommandText += " AND ynCancelled=1";
}
else
{
CommandText += " WHERE ynCancelled=1";
}
}
DataSource.SelectCommand = CommandText;
DataSource.DataBind();
}
public void SearchForwarder(SqlDataSource ForwarderDataSource, string search_parameter)
{
string CommandText = string.Empty;
CommandText = "SELECT [RECORD_NUMBER], [FORWARDER_NAME], [FORWARDER_ADDRESS], [FORWARDER_CONTACT], [DATE_RECORDED] FROM [FORWARDERS] ";
CommandText += " WHERE FORWARDER_NAME LIKE '%"+ search_parameter +"%' ";
ForwarderDataSource.SelectCommand = CommandText;
ForwarderDataSource.DataBind();
}
public void SearchCustomerReturnSlipList(SqlDataSource datasource,string search_parameter)
{
string CommandText = string.Empty;
CommandText = "SELECT [ID], [CRSID], [CRSNo], [CRSDate], [Customer], [TotalAmt], [PUSNo], [PkgNo], [ItemStatus] FROM CRS WHERE CRSNo LIKE '%" + search_parameter + "%' ORDER BY CRSDate DESC ";// OR ID LIKE '%" + search_parameter + "%'";
datasource.SelectCommand = CommandText;
datasource.DataBind();
}
/*public List<Customer> SearchCustomer(string[] search_parameter)
{
string[] columns = new string[1];
columns[0] = "CUSTOMER_NAME";
return Accessor.Query.SelectByKeyWords<Customer>(search_parameter, columns);
}*/
public void FilterCustomerByBrandName(SqlDataSource DataSource, string BrandName, string TextSearch)
{
string CommandText = string.Empty;
CommandText = "SELECT [CustNo], [CompName] FROM [CustInfo] where Compname like '%" + TextSearch + "%" + BrandName + "%'";
DataSource.SelectCommand = CommandText;
DataSource.DataBind();
}
public void FilterDeliveryReceiptList(SqlDataSource datasource, string filter_field_type)
{
string CommandText = string.Empty;
switch (filter_field_type)
{
case "POSTED":
CommandText = "SELECT [ID], [DRNo], [DRDate], [PLNo], [CustNo], [DeliveredTo], [CustAddr], [TotalQty], [TotalAmt], [ItemStatus] FROM [DR] WHERE ynPosted=1 AND ynCancelled=0 ORDER BY DRDate DESC";
datasource.SelectCommand = CommandText;
datasource.DataBind();
break;
case "UNPOSTED":
CommandText = "SELECT [ID], [DRNo], [DRDate], [PLNo], [CustNo], [DeliveredTo], [CustAddr], [TotalQty], [TotalAmt], [ItemStatus] FROM [DR] WHERE ynPosted=0 AND ynCancelled=0 ORDER BY DRDate DESC";
datasource.SelectCommand = CommandText;
datasource.DataBind();
break;
case "CANCELLED":
CommandText = "SELECT [ID], [DRNo], [DRDate], [PLNo], [CustNo], [DeliveredTo], [CustAddr], [TotalQty], [TotalAmt], [ItemStatus] FROM [DR] WHERE ynCancelled=1 ORDER BY DRDate DESC ";
datasource.SelectCommand = CommandText;
datasource.DataBind();
break;
//default:
// CommandText = "SELECT [ID], [DRNo], [DRDate], [PLNo], [CustNo], [DeliveredTo], [CustAddr], [TotalQty], [TotalAmt], [ItemStatus] FROM [DR] ";
// datasource.SelectCommand = CommandText;
// datasource.DataBind();
// break;
}
}
