public static WhsInfo GetWhsItemInfo(string itemCode, string whsCode)
{
var recordsSet = B1Helper.DiCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset) as SAPbobsCOM.Recordset;
try
{
StringBuilder query = new StringBuilder("SELECT ISNULL(OnHand, 0) + ISNULL(IsCommited, 0) AS AvailableValue, ISNULL(WhsCode, '') AS WhsCode ");
query.Append("FROM OITW ");
query.Append("WHERE ItemCode ='{0}' AND WhsCode = '{1}'");
recordsSet.DoQuery(string.Format(query.ToString(), itemCode, whsCode));
WhsInfo wareHouseInfo = new WhsInfo();
if (recordsSet.RecordCount > 0)
{
recordsSet.MoveFirst();
wareHouseInfo.AvailableValue = Convert.ToDecimal(recordsSet.Fields.Item("AvailableValue").Value);
wareHouseInfo.WhsCode = recordsSet.Fields.Item("WhsCode").Value.ToString();
}
return(wareHouseInfo);
}
catch (Exception ex)
{
return(null);
}
finally
{
recordsSet.ReleaseObject();
}
}
public static List <WhsInfo> GetWhsInfoPerItem(string itemCode)
{
var recordsSet = B1Helper.DiCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset) as SAPbobsCOM.Recordset;
try
{
StringBuilder query = new StringBuilder("SELECT ISNULL(OnHand, 0) + ISNULL(IsCommited, 0) AS AvailableValue, ISNULL(WhsCode, '') AS WhsCode ");
query.Append("FROM OITW ");
query.Append("WHERE ItemCode ='{0}' AND IsCommited + OnHand <> 0");
recordsSet.DoQuery(string.Format(query.ToString(), itemCode));
var wareHousesList = new List <WhsInfo>();
recordsSet.MoveFirst();
while (!recordsSet.EoF)
{
WhsInfo wareHouseInfo = new WhsInfo();
wareHouseInfo.AvailableValue = Convert.ToDecimal(recordsSet.Fields.Item("AvailableValue").Value);
wareHouseInfo.WhsCode = recordsSet.Fields.Item("WhsCode").Value.ToString();
wareHousesList.Add(wareHouseInfo);
recordsSet.MoveNext();
}
return(wareHousesList);
}
catch (Exception ex)
{
return(new List <WhsInfo>());
}
finally
{
recordsSet.ReleaseObject();
}
}
public static WhsInfo GetWhsItemInfo(string itemCode, string whsCode)
{
var recordsSet = B1Helper.DiCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset) as SAPbobsCOM.Recordset;
try
{
StringBuilder query = new StringBuilder("SELECT ISNULL(OnHand, 0) + ISNULL(IsCommited, 0) AS AvailableValue, ISNULL(WhsCode, '') AS WhsCode ");
query.Append("FROM OITW ");
query.Append("WHERE ItemCode ='{0}' AND WhsCode = '{1}'");
recordsSet.DoQuery(string.Format(query.ToString(), itemCode, whsCode));
WhsInfo wareHouseInfo = new WhsInfo();
if (recordsSet.RecordCount > 0)
{
recordsSet.MoveFirst();
wareHouseInfo.AvailableValue = Convert.ToDecimal(recordsSet.Fields.Item("AvailableValue").Value);
wareHouseInfo.WhsCode = recordsSet.Fields.Item("WhsCode").Value.ToString();
}
return wareHouseInfo;
}
catch (Exception ex)
{
return null;
}
finally
{
recordsSet.ReleaseObject();
}
}
public static List<WhsInfo> GetWhsInfoPerItem(string itemCode)
{
var recordsSet = B1Helper.DiCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset) as SAPbobsCOM.Recordset;
try
{
StringBuilder query = new StringBuilder("SELECT ISNULL(OnHand, 0) + ISNULL(IsCommited, 0) AS AvailableValue, ISNULL(WhsCode, '') AS WhsCode ");
query.Append("FROM OITW ");
query.Append("WHERE ItemCode ='{0}' AND IsCommited + OnHand <> 0");
recordsSet.DoQuery(string.Format(query.ToString(), itemCode));
var wareHousesList = new List<WhsInfo>();
recordsSet.MoveFirst();
while(!recordsSet.EoF)
{
WhsInfo wareHouseInfo = new WhsInfo();
wareHouseInfo.AvailableValue = Convert.ToDecimal(recordsSet.Fields.Item("AvailableValue").Value);
wareHouseInfo.WhsCode = recordsSet.Fields.Item("WhsCode").Value.ToString();
wareHousesList.Add(wareHouseInfo);
recordsSet.MoveNext();
}
return wareHousesList;
}
catch (Exception ex)
{
return new List<WhsInfo>();
}
finally
{
recordsSet.ReleaseObject();
}
}
