//public MySqlDataReader Search(string SearchKey, string SortField, SortOption SortOrder)
//{
// try
// {
// if (SortField == string.Empty || SortField == null) SortField = "BranchTransferID";
// string SQL = SQLSelect() + "WHERE (BranchTransferNo LIKE @SearchKey or BranchTransferDate LIKE @SearchKey or SupplierCode LIKE @SearchKey " +
// "or SupplierContact LIKE @SearchKey or BranchCode LIKE @SearchKey or RequiredDeliveryDate LIKE @SearchKey) " +
// "ORDER BY " + SortField;
// if (SortOrder == SortOption.Ascending)
// SQL += " ASC";
// else
// SQL += " DESC";
// MySqlCommand cmd = new MySqlCommand();
// cmd.CommandType = System.Data.CommandType.Text;
// cmd.CommandText = SQL;
// MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey",MySqlDbType.String);
// prmSearchKey.Value = "%" + SearchKey + "%";
// cmd.Parameters.Add(prmSearchKey);
// MySqlDataReader myReader = base.ExecuteReader(cmd);
// return myReader;
// }
// catch (Exception ex)
// {
// throw base.ThrowException(ex);
// }
//}
//public MySqlDataReader Search(BranchTransferStatus branchtransferstatus, string SearchKey, string SortField, SortOption SortOrder)
//{
// try
// {
// if (SortField == string.Empty || SortField == null) SortField = "BranchTransferID";
// string SQL = SQLSelect() + "WHERE Status = @Status AND (BranchTransferNo LIKE @SearchKey or BranchTransferDate LIKE @SearchKey or SupplierCode LIKE @SearchKey " +
// "or SupplierContact LIKE @SearchKey or BranchCode LIKE @SearchKey or RequiredDeliveryDate LIKE @SearchKey or a.Remarks LIKE @SearchKey) " +
// "ORDER BY " + SortField;
// if (SortOrder == SortOption.Ascending)
// SQL += " ASC";
// else
// SQL += " DESC";
// MySqlCommand cmd = new MySqlCommand();
// cmd.CommandType = System.Data.CommandType.Text;
// cmd.CommandText = SQL;
// MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16);
// prmStatus.Value = branchtransferstatus.ToString("d");
// cmd.Parameters.Add(prmStatus);
// MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey",MySqlDbType.String);
// prmSearchKey.Value = "%" + SearchKey + "%";
// cmd.Parameters.Add(prmSearchKey);
// MySqlDataReader myReader = base.ExecuteReader(cmd);
// return myReader;
// }
// catch (Exception ex)
// {
// throw base.ThrowException(ex);
// }
//}
//public System.Data.DataTable SearchAsDataTable(BranchTransferStatus branchtransferstatus, string SearchKey, string SortField, SortOption SortOrder)
//{
// try
// {
// if (SortField == string.Empty || SortField == null) SortField = "BranchTransferID";
// string SQL = SQLSelect() + "WHERE Status = @Status AND (BranchTransferNo LIKE @SearchKey or BranchTransferDate LIKE @SearchKey or SupplierCode LIKE @SearchKey " +
// "or SupplierContact LIKE @SearchKey or BranchCode LIKE @SearchKey or RequiredDeliveryDate LIKE @SearchKey or a.Remarks LIKE @SearchKey) " +
// "ORDER BY " + SortField;
// if (SortOrder == SortOption.Ascending)
// SQL += " ASC";
// else
// SQL += " DESC";
// MySqlCommand cmd = new MySqlCommand();
// cmd.CommandType = System.Data.CommandType.Text;
// cmd.CommandText = SQL;
// MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16);
// prmStatus.Value = branchtransferstatus.ToString("d");
// cmd.Parameters.Add(prmStatus);
// MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey",MySqlDbType.String);
// prmSearchKey.Value = "%" + SearchKey + "%";
// cmd.Parameters.Add(prmSearchKey);
// string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
// base.MySqlDataAdapterFill(cmd, dt);
// return dt;
// }
// catch (Exception ex)
// {
// throw base.ThrowException(ex);
// }
//}
//public System.Data.DataTable SearchAsDataTable(BranchTransferStatus branchtransferstatus, DateTime OrderStartDate, DateTime OrderEndDate, DateTime PostingStartDate, DateTime PostingEndDate, string SearchKey, string SortField, SortOption SortOrder)
//{
// try
// {
// if (SortField == string.Empty || SortField == null) SortField = "BranchTransferID";
// string SQL = SQLSelect() + "WHERE Status = @Status ";
// if (SearchKey != string.Empty || SearchKey != null)
// SQL += "AND (BranchTransferNo LIKE @SearchKey " +
// "or b.BranchCode LIKE @SearchKey or c.BranchCode LIKE @SearchKey or a.Remarks LIKE @SearchKey) ";
// if (OrderStartDate != DateTime.MinValue) SQL += "AND BranchTransferDate >= @OrderStartDate ";
// if (OrderEndDate != DateTime.MinValue) SQL += "AND BranchTransferDate <= @OrderEndDate ";
// if (PostingStartDate != DateTime.MinValue) SQL += "AND BranchTransferDate >= @PostingStartDate ";
// if (PostingEndDate != DateTime.MinValue) SQL += "AND BranchTransferDate <= @PostingEndDate ";
// SQL += "ORDER BY " + SortField;
// if (SortOrder == SortOption.Ascending)
// SQL += " ASC";
// else
// SQL += " DESC";
// MySqlCommand cmd = new MySqlCommand();
// cmd.CommandType = System.Data.CommandType.Text;
// cmd.CommandText = SQL;
// cmd.Parameters.AddWithValue("@Status", branchtransferstatus.ToString("d"));
// if (SearchKey != string.Empty || SearchKey != null) cmd.Parameters.AddWithValue("@SearchKey", "%" + SearchKey + "%");
// if (OrderStartDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@OrderStartDate", OrderStartDate.ToString("yyyy-MM-dd HH:mm:ss"));
// if (OrderEndDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@OrderEndDate", OrderEndDate.ToString("yyyy-MM-dd HH:mm:ss"));
// if (PostingStartDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@PostingStartDate", PostingStartDate.ToString("yyyy-MM-dd HH:mm:ss"));
// if (PostingEndDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@PostingEndDate", PostingEndDate.ToString("yyyy-MM-dd HH:mm:ss"));
// string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
// base.MySqlDataAdapterFill(cmd, dt);
// return dt;
// }
// catch (Exception ex)
// {
// throw base.ThrowException(ex);
// }
//}
//public MySqlDataReader List(BranchTransferStatus branchtransferstatus, DateTime StartDate, DateTime EndDate)
//{
// try
// {
// string SQL = SQLSelect() + "WHERE Status = @Status AND DeliveryDate BETWEEN @StartDate AND @EndDate ORDER BY BranchTransferID ASC";
// MySqlCommand cmd = new MySqlCommand();
// cmd.CommandType = System.Data.CommandType.Text;
// cmd.CommandText = SQL;
// MySqlParameter prmStartDate = new MySqlParameter("@StartDate",MySqlDbType.DateTime);
// prmStartDate.Value = StartDate.ToString("yyyy-MM-dd HH:mm:ss");
// cmd.Parameters.Add(prmStartDate);
// MySqlParameter prmEndDate = new MySqlParameter("@EndDate",MySqlDbType.DateTime);
// prmEndDate.Value = EndDate.ToString("yyyy-MM-dd HH:mm:ss");
// cmd.Parameters.Add(prmEndDate);
// MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16);
// prmStatus.Value = branchtransferstatus.ToString("d");
// cmd.Parameters.Add(prmStatus);
// MySqlDataReader myReader = base.ExecuteReader(cmd);
// return myReader;
// }
// catch (Exception ex)
// {
// throw base.ThrowException(ex);
// }
//}
//public MySqlDataReader List(BranchTransferStatus branchtransferstatus, long SupplierID, DateTime StartDate, DateTime EndDate)
//{
// try
// {
// string SQL = SQLSelect() + "WHERE Status = @Status AND SupplierID = @SupplierID AND DeliveryDate BETWEEN @StartDate AND @EndDate ORDER BY BranchTransferID ASC";
// MySqlCommand cmd = new MySqlCommand();
// cmd.CommandType = System.Data.CommandType.Text;
// cmd.CommandText = SQL;
// cmd.Parameters.AddWithValue("@Status", branchtransferstatus.ToString("d"));
// cmd.Parameters.AddWithValue("@SupplierID", SupplierID);
// cmd.Parameters.AddWithValue("@StartDate", StartDate.ToString("yyyy-MM-dd HH:mm:ss"));
// cmd.Parameters.AddWithValue("@EndDate", EndDate.ToString("yyyy-MM-dd HH:mm:ss"));
// MySqlDataReader myReader = base.ExecuteReader(cmd);
// return myReader;
// }
// catch (Exception ex)
// {
// throw base.ThrowException(ex);
// }
//}
#endregion
#region Public Modifiers
public string LastTransactionNo()
{
try
{
string stRetValue = String.Empty;
ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction);
stRetValue = clsERPConfig.get_LastBranchTransferNo();
return stRetValue;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
