C# (CSharp) SQL_da_IM_Item Examples

Example #1

        public List <IM_Item> IM_Item_GetAllByKeyWord(string KeyWord)
        {
            var rst = SQL_da_IM_Item.GetAll();

            if (rst != null && rst.Count > 0)
            {
                rst = rst.FindAll(x => x.SKU.Contains(KeyWord) || x.SKUDESC.Contains(KeyWord) || x.SPEC.Contains(KeyWord) || x.ITEMCLASS == KeyWord);
            }
            else
            {
                rst = new List <IM_Item>();
            }
            return(rst);
        }

Example #2

 public IM_Item IM_Item_GetOneBySku(string Sku)
 {
     return(SQL_da_IM_Item.GetOneBySku(Sku));
 }

Example #3

 public List <IM_Item> IM_Item_GetAllByContainerID(string containerId)
 {
     return(SQL_da_IM_Item.GetAllByContainerID(containerId));
 }

Example #4

 public bool IM_Item_DeleteOne(string Sku)
 {
     return(SQL_da_IM_Item.DeleteOne(Sku));
 }

Example #5

 public bool IM_Item_UpdateOne(IM_Item t_new)
 {
     return(SQL_da_IM_Item.UpdateOne(t_new));
 }

Example #6

 public bool IM_Item_InsertOne(IM_Item t_new)
 {
     return(SQL_da_IM_Item.InsertNew(t_new));
 }

Example #7

 public List <IM_Item> IM_Item_GetAll()
 {
     return(SQL_da_IM_Item.GetAll());
 }