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(); } }