如何在sql中为下面的代码执行程序 [英] how to strored procedure in sql for below code

问题描述

public override List<AttributeDTO> GetArray(List<int> values, List<int> values1)
{
    try
    {
        using (var context = new PICEntities())
        {
            var cnt = values.Count(); List<AttributeDTO> lst = null;
            List<AttributeDTO> lst1 = new List<AttributeDTO>();
            List<long> pids = context.pic_attr_value.Select(g => g.product_id).Distinct().ToList();
            foreach (var item in pids)
            {
                AttributeDTO attr = new AttributeDTO();

                for (var i = 0; i < cnt; i++)

                {

                    var productid = item;

                    var att = values[i];

                    var attl = values1[i];

                    //var count = context.pic_attr_value.Count(a => a.attr_id == att && a.attr_lov_id == attl && a.product_id == productid);
                    //if (count == 0) break;
                    //if (i == cnt - 1)
                    //{
                    var pavs = context.pic_attr_value.Where(a => a.attr_id == att && a.attr_lov_id == attl && a.product_id == productid).Select(g => g.product_id).Distinct().SingleOrDefault();
                    if (pavs!= 0)
                    {
                        var st = context.pic_product.SingleOrDefault(a => a.product_id == pavs);
                        if (st.part_number != null && st.part_description!=null)
                        {
                            attr.AttrName = st.part_number;
                            attr.temp = st.part_description;
                        }
                        if (attr != null && i == cnt - 1)
                        {
                            lst1.Add(attr);
                        }

                    }

                    //}

                }
            }
            return lst1;
        }
    }
    catch (Exception) { return new List<AttributeDTO>(); }
}

推荐答案

这篇关于如何在sql中为下面的代码执行程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！