public static DataSet Retrieve(IItemTransferReport ItemTransfer, Int32 SearchOption) { SqlParameter[] _parameters = { new SqlParameter("@Code", ItemTransfer.Code) , new SqlParameter("@RefId", ItemTransfer.RefId) , new SqlParameter("@PLNo", ItemTransfer.PLNo) , new SqlParameter("@Parent", ItemTransfer.Parent) , new SqlParameter("@Production", ItemTransfer.Production) , new SqlParameter("@EqpId", ItemTransfer.EqpId) , new SqlParameter("@CargoId", ItemTransfer.CargoId) , new SqlParameter("@ItemCode", ItemTransfer.ItemCode) , new SqlParameter("@Description", ItemTransfer.Description) , new SqlParameter("@Model", ItemTransfer.Model) , new SqlParameter("@FromWhseCode", ItemTransfer.FromWhseCode) , new SqlParameter("@FromWhseLocation", ItemTransfer.FromWhseLocation) , new SqlParameter("@ToWhseCode", ItemTransfer.ToWhseCode) , new SqlParameter("@ToWhseLocation", ItemTransfer.ToWhseLocation) , new SqlParameter("@Remarks", ItemTransfer.Remarks) , new SqlParameter("@Result", ItemTransfer.Result) , new SqlParameter("@Status", ItemTransfer.Status) , new SqlParameter("@HasPrintOut", ItemTransfer.HasPrintOut) , new SqlParameter("@AutoTransfer", ItemTransfer.AutoTransfer) , new SqlParameter("@FromSysCreated", ItemTransfer.SysCreated) , new SqlParameter("@ToSysCreated", ItemTransfer.SysCreated2) , new SqlParameter("@SysCreator", ItemTransfer.SysCreator) , new SqlParameter("@FromSysModified", ItemTransfer.SysModified) , new SqlParameter("@ToSysModified", ItemTransfer.SysModified2) , new SqlParameter("@SysModifier", ItemTransfer.SysModifier) , new SqlParameter("@Shift", ItemTransfer.Shift) , new SqlParameter("@SearchOption", SearchOption) }; return(SqlHelper.ExecuteDataset(ConnectionString, "sp_ItemTransfers_Search", _parameters)); }
public static DataSet Retrieve(IItemTransferReport ItemTransfer) { SqlParameter[] _Parameters = { new SqlParameter("@FromCreatedDate", ItemTransfer.SysCreated) , new SqlParameter("@ToCreatedDate", ItemTransfer.SysCreated2) , new SqlParameter("@WhseCode", ItemTransfer.FromWhseCode) , new SqlParameter("@WhseLocation", ItemTransfer.FromWhseLocation) , new SqlParameter("@Shift", ItemTransfer.ShiftName) , new SqlParameter("@ItemCode", ItemTransfer.ItemCode) , new SqlParameter("@ResultId", ItemTransfer.Result) , new SqlParameter("@TransId", ItemTransfer.TransId) }; return(SqlHelper.ExecuteDataset(ConnectionString, "sp_ItemTransfers_SearchWithShift", _Parameters)); }