public static Int32 Insert(IItemTransfer ItemTransfer)
{
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("@ItemCode", ItemTransfer.ItemCode)
, new SqlParameter("@FromWhseCode", ItemTransfer.FromWhseCode)
, new SqlParameter("@FromWhseLocation", ItemTransfer.FromWhseLocation)
, new SqlParameter("@ToWhseCode", ItemTransfer.ToWhseCode)
, new SqlParameter("@ToWhseLocation", ItemTransfer.ToWhseLocation)
, new SqlParameter("@Quantity", ItemTransfer.Quantity)
, new SqlParameter("@UOM", ItemTransfer.UOM)
, new SqlParameter("@Result", ItemTransfer.Result)
, new SqlParameter("@Repairable", ItemTransfer.Repairable)
, new SqlParameter("@ReasonCode", ItemTransfer.ReasonCode)
, new SqlParameter("@HasPrintOut", ItemTransfer.HasPrintOut)
, new SqlParameter("@AutoTransfer", ItemTransfer.AutoTransfer)
, new SqlParameter("@Remarks", ItemTransfer.Remarks)
, new SqlParameter("@SysCreator", ItemTransfer.SysCreator)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, "sp_ItemTransfers_Insert", _parameters)));
}
public static DataSet Retrieve(IItemTransfer 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 void Fulfill(IItemTransfer ItemTransfer)
{
SqlParameter[] _parameters =
{
new SqlParameter("@CargoId", ItemTransfer.CargoId)
};
SqlHelper.ExecuteNonQuery(ConnectionString, "sp_ItemTransfers_Fulfill", _parameters);
}
public static DataSet Retrieve(IItemTransfer ItemTransfer)
{
SqlParameter[] _parameters =
{
new SqlParameter("@ToWhseCode", ItemTransfer.ToWhseCode)
, new SqlParameter("@ToWhseLocation", ItemTransfer.ToWhseLocation)
};
return(SqlHelper.ExecuteDataset(ConnectionString, "sp_ItemTransfers_Search", _parameters));
}
public static void Cancel(IItemTransfer ItemTransfer)
{
SqlParameter[] _parameters =
{
new SqlParameter("@CargoId", ItemTransfer.CargoId)
, new SqlParameter("@SysModifier", ItemTransfer.SysModifier)
, new SqlParameter("@Remarks", ItemTransfer.Remarks)
};
SqlHelper.ExecuteNonQuery(ConnectionString, "sp_ItemTransfers_Cancel", _parameters);
}
public static void Confirm(IItemTransfer ItemTransfer)
{
SqlParameter[] _parameters =
{
new SqlParameter("@CargoId", ItemTransfer.CargoId)
, new SqlParameter("@ToWhseCode", ItemTransfer.ToWhseCode)
, new SqlParameter("@ToWhseLocation", ItemTransfer.ToWhseLocation)
, new SqlParameter("@SysModifier", ItemTransfer.SysModifier)
};
SqlHelper.ExecuteNonQuery(ConnectionString, "sp_ItemTransfers_Confirm", _parameters);
}
