public int DeleteShiftBasket(BizEntity.Inventory.ShiftRequestItemInfo item)
{
DataCommand dc = DataCommandManager.GetDataCommand("DeleteShiftBasket");
dc.SetParameterValue("@SysNo", item.SysNo);
int result = dc.ExecuteNonQuery();
return(result);
}
public int UpdateShiftBasket(BizEntity.Inventory.ShiftRequestItemInfo item)
{
DataCommand dc = DataCommandManager.GetDataCommand("UpdateShiftBasket");
dc.SetParameterValue("@SysNo", item.SysNo);
dc.SetParameterValue("@ShiftQty", item.ShiftQuantity);
dc.SetParameterValue("@EditDate", DateTime.Now);
dc.SetParameterValueAsCurrentUserAcct("@EditUser");
return(dc.ExecuteNonQuery());
}
public bool IsExistSourceAndTargetStockInBasket(BizEntity.Inventory.ShiftRequestItemInfo item)
{
object o = null;
DataCommand dc = DataCommandManager.GetDataCommand("IsExistPAB");
dc.SetParameterValue("@ProductSysNo", item.ShiftProduct.SysNo);
dc.SetParameterValue("@StockSysNoA", item.SourceStock.SysNo);
dc.SetParameterValue("@StockSysNoB", item.TargetStock.SysNo);
dc.SetParameterValue("@CompanyCode", item.CompanyCode);
o = dc.ExecuteScalar();
return((o == null || o == DBNull.Value || Convert.ToInt32(o) == 0) ? false : true);
}
public int GetStockAvailableQtyGroupByProductSysNo(BizEntity.Inventory.ShiftRequestItemInfo item)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetStockAvailableQtyGroupByProductSysNo");
dc.SetParameterValue("@StockSysNo", item.SourceStock.SysNo);
dc.SetParameterValue("@ProductSysNo", item.ShiftProduct.SysNo);
dc.SetParameterValue("@CompanyCode", item.CompanyCode);
object o = dc.ExecuteScalar();
if (o == null || o == DBNull.Value)
{
return(0);
}
return(Convert.ToInt32(o));
}
public int CreateShiftBasket(BizEntity.Inventory.ShiftRequestItemInfo item)
{
DataCommand dc = DataCommandManager.GetDataCommand("InsertShiftBasket");
dc.SetParameterValue("@SysNo", item.SysNo);
dc.SetParameterValue("@ProductSysNo", item.ShiftProduct.SysNo);
dc.SetParameterValue("@StockSysNoA", item.SourceStock.SysNo);
dc.SetParameterValue("@StockSysNoB", item.TargetStock.SysNo);
dc.SetParameterValue("@ShiftQty", item.ShiftQuantity);
dc.SetParameterValue("@InDate", DateTime.Now);
dc.SetParameterValueAsCurrentUserAcct("@InUser");
dc.SetParameterValue("@EditDate", DateTime.Now);
dc.SetParameterValueAsCurrentUserAcct("@EditUser");
dc.SetParameterValue("@CompanyCode", item.CompanyCode);
int result = dc.ExecuteNonQuery();
item.SysNo = Convert.ToInt32(dc.GetParameterValue("@SysNo"));
return(result);
}
