/// <summary> /// Gets the detail for store transfer. /// </summary> /// <param name="PickListID">The pick list ID.</param> /// <returns></returns> public static DataView GetDetailForStoreTransfer(int PickListID) { Transfer transfer = new Transfer(); string query = HCMIS.Repository.Queries.Transfer.SelectGetDetailForStoreTransfer(PickListID); transfer.LoadFromRawSql(query); return transfer.DefaultView; }
/// <summary> /// Gets the transfer report. /// </summary> /// <returns></returns> public static DataView GetTransferReport() { Transfer transfer = new Transfer(); string query = HCMIS.Repository.Queries.Transfer.SelectGetTransferReport(); transfer.LoadFromRawSql(query); return transfer.DefaultView; }
/// <summary> /// Transfers to store. /// </summary> /// <param name="PicklistID">The picklist ID.</param> public static void TransferToStore(int PicklistID) { Transfer transfer = new Transfer(); string query = HCMIS.Repository.Queries.Transfer.SelectTransferToStore(PicklistID); transfer.LoadFromRawSql(query); }
/// <summary> /// Gets the detail for store transfer. /// </summary> /// <param name="PickListID">The pick list ID.</param> /// <returns></returns> public static DataView GetDetailForStoreTransfer(int PickListID) { Transfer transfer = new Transfer(); string query = HCMIS.Repository.Queries.Transfer.SelectGetDetailForStoreTransfer(PickListID); transfer.LoadFromRawSql(query); return(transfer.DefaultView); }
/// <summary> /// Gets the transfer report for store. /// </summary> /// <returns></returns> public static DataView GetTransferReportForStore() { Transfer transfer = new Transfer(); string query = HCMIS.Repository.Queries.Transfer.SelectGetTransferReportForStore(); transfer.LoadFromRawSql(query); return(transfer.DefaultView); }
/// <summary> /// Gets the store transfer. /// </summary> /// <param name="PicklistID">The picklist ID.</param> /// <returns></returns> public static DataRowView GetStoreTransfer(int PicklistID) { Transfer transfer = new Transfer(); string query = HCMIS.Repository.Queries.Transfer.SelectGetStoreTransfer(PicklistID); transfer.LoadFromRawSql(query); foreach (DataRowView drv in transfer.DefaultView) { return drv; } return null; }
/// <summary> /// Gets the store transfer. /// </summary> /// <param name="PicklistID">The picklist ID.</param> /// <returns></returns> public static DataRowView GetStoreTransfer(int PicklistID) { Transfer transfer = new Transfer(); string query = HCMIS.Repository.Queries.Transfer.SelectGetStoreTransfer(PicklistID); transfer.LoadFromRawSql(query); foreach (DataRowView drv in transfer.DefaultView) { return(drv); } return(null); }