public static POSItem Search(string itemBarcode, string locationCode, bool isKitOrder, int isFirstOrder, ref string dbMessage) { try { POSItem item = null; DBParameterList dbParamList = new DBParameterList(); List <POSItem> itemList = new List <POSItem>(); dbParamList.Add(new DBParameter("@itemBarcode", itemBarcode, DbType.String)); dbParamList.Add(new DBParameter("@inputParam", locationCode, DbType.String)); dbParamList.Add(new DBParameter("@isKitOrder", isKitOrder, DbType.Boolean)); dbParamList.Add(new DBParameter("@isFirstOrder", isFirstOrder, DbType.Int32)); dbParamList.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); using (DataTaskManager dtManager = new DataTaskManager()) { DataSet ds = dtManager.ExecuteDataSet(SP_BarcodeItems_Search, dbParamList); if (ds != null) { DataRow[] rows = ds.Tables[0].Select(); item = CreateItem(rows[0]); } } return(item); } catch (Exception ex) { throw ex; } }
private static void AddHierarchyChildren(POSItem item, DataSet ds, DataTable dt, int max) { DataRow[] rows = dt.Select("ParentId=" + item.Id); if (rows.Length == 0) { if (item.Level == max) { //ADD ITEMS HERE AddItemChildrem(item, ds.Tables[2]); } } else { for (int i = 0; i < rows.Length; i++) { //ADD HIERARCHIES - CHILDREN POSItem item1 = CreateItem(rows[i]); AddHierarchyChildren(item1, ds, ds.Tables[1], max); if (item1.POSItems.Count > 0) { item.POSItems.Add(item1); } } } }
private static void AddItemChildrem(POSItem item, DataTable dataTable) { DataRow[] rows = dataTable.Select("ParentId = " + item.Id); for (int i = 0; i < rows.Length; i++) { POSItem item1 = CreateItem(rows[i]); item.POSItems.Add(item1); } }
public static List <POSItem> Search(string locationCode, bool isKitOrder, int isFirstOrder, ref string dbMessage) { try { DBParameterList dbParamList = new DBParameterList(); List <POSItem> itemList = new List <POSItem>(); dbParamList.Add(new DBParameter("@inputParam", locationCode, DbType.String)); dbParamList.Add(new DBParameter("@isKitOrder", isKitOrder, DbType.Boolean)); dbParamList.Add(new DBParameter("@isFirstOrder", isFirstOrder, DbType.Int32)); dbParamList.Add(new DBParameter("@forSkinCareItem", Common.ForSkinCareItem, DbType.Boolean)); dbParamList.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); using (DataTaskManager dtManager = new DataTaskManager()) { DataSet ds = dtManager.ExecuteDataSet(SP_ITEMS_SEARCH, dbParamList); if (ds != null) { if (ds.Tables.Count > 2) { int min = Convert.ToInt32(ds.Tables[0].Rows[0]["Min"]); int max = Convert.ToInt32(ds.Tables[0].Rows[0]["Max"]); DataRow[] rows = ds.Tables[1].Select("Level = " + min); for (int i = 0; i < rows.Length; i++) { POSItem item = CreateItem(rows[i]); AddHierarchyChildren(item, ds, ds.Tables[1], max); if (item.POSItems.Count > 0) { itemList.Add(item); } } } } } return(itemList); } catch (Exception ex) { throw ex; } }