//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); } }