生产入库、采购入库接口提交

yl

2023-06-13 d6502baa8e5610c04127fbee92ff6111e40956f8

 VueWebApi/DLL/DAL/AppQualityManagementDAL.cs

@@ -41,11 +41,23 @@
                    mes.data = null;
                    return mes;
                }
                //判断条码是否需要检验
                sql = @"select *  from TMateriel_Info where partcode=@partcode and is_incheck='N'";
                dynamicParams.Add("@partcode", data0.Rows[0]["hmaterialcode"].ToString());
                var data_0 = DapperHelper.selectdata(sql, dynamicParams);
                if (data_0.Rows.Count > 0)
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "此标签条码免检!";
                    mes.data = null;
                    return mes;
                }
                //判断条码是否检验
                sql = @"select *  from TStepCheckRecord where hbarcode=@labcode and check_type='InCheck'";
                dynamicParams.Add("@labcode", labcode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data0.Rows.Count > 0)
                if (data.Rows.Count > 0)
                {
                    mes.code = "300";
                    mes.count = 0;
@@ -67,7 +79,7 @@
                    //获取绑定的入厂质检方案、抽样方式、样本数
                    sql = @"select code as checkstandcode,name as checkstandname,sampmethod,sampscare   
                            from TStepCheckStandard
                            where PATINDEX('%;' + RTRIM(@partcode) + ';%',';' + suitpart + ';')>0 or PATINDEX('%;' + RTRIM(@stocktype_code) + ';%',';' + suitpart + ';')>0
                            where (PATINDEX('%,' + RTRIM(@partcode) + ',%',',' + suitpart + ',')>0 or PATINDEX('%,' + RTRIM(@stocktype_code) + ',%',',' + suitpart + ',')>0)
                            and checktype='InCheck'";
                    dynamicParams.Add("@partcode", data1.Rows[0]["partcode"].ToString());//物料编码
                    dynamicParams.Add("@stocktype_code", data1.Rows[0]["stocktype_code"].ToString());//存货类型编码
@@ -194,11 +206,11 @@
                }

                //循环标签个数
                for (int i = 1; i <= obj.Count; i++)
                for (int i = 0; i <obj.Count; i++)
                {
                    //写入检验记录主表
                    sql = @"insert into  TStepCheckRecord(hbarcode,wo_code,partcode,checkstaned_code,customer_code,check_user,check_type,check_typename,sampmethod,check_result,check_qty,good_qty,ng_qty,lm_user,lm_date) 
                                values(@hbarcode,@wo_code,@partcode,@checkstaned_code,@check_user,@check_type,@check_typename,@sampmethod,@check_result,@check_qty,@good_qty,@ng_qty,@lm_user,@lm_date)";
                                values(@hbarcode,@wo_code,@partcode,@checkstaned_code,@customer_code,@check_user,@check_type,@check_typename,@sampmethod,@check_result,@check_qty,@good_qty,@ng_qty,@lm_user,@lm_date)";
                    list.Add(new
                    {
                        str = sql,
@@ -223,26 +235,26 @@
                    });
                    //获取主表最大ID
                    sql = @"select ISNULL(IDENT_CURRENT('TStepCheckRecord')+@num,1) as id";
                    dynamicParams.Add("@num", i);
                    dynamicParams.Add("@num", i+1);
                    var dt = DapperHelper.selectdata(sql, dynamicParams);
                    //写入检验记录子表
                    for (int j = 0; j < arra.Count; j++)
                    {
                        sql = @"insert into  TStepCheckRecordSub(m_id,checknum,checkitem_seq,checkitem_code,checkitem_name,checkitem_descr,check_value,check_result,lm_user,lm_date) 
                                values(@m_id,@checkiem_seq,@checkitem_code,@checkitem_name,@checkitem_descr,@check_result,@lm_user,@lm_date)";
                                values(@m_id,@checknum,@checkiem_seq,@checkitem_code,@checkitem_name,@checkitem_descr,@check_value,@check_result,@lm_user,@lm_date)";
                        list.Add(new
                        {
                            str = sql,
                            parm = new
                            {
                                m_id = int.Parse(dt.Rows[0]["ID"].ToString()),
                                checknum = arra[i]["checknum"].ToString(),
                                checkiem_seq = arra[i]["checkiem_seq"].ToString(),
                                checkitem_code = arra[i]["checkitem_code"].ToString(),
                                checkitem_name = arra[i]["checkitem_name"].ToString(),
                                checkitem_descr = arra[i]["checkitem_descr"].ToString(),
                                check_value = arra[i]["check_value"].ToString(),
                                check_result = arra[i]["check_result"].ToString(),
                                checknum = arra[j]["checknum"].ToString(),
                                checkiem_seq = arra[j]["checkiem_seq"].ToString(),
                                checkitem_code = arra[j]["checkitem_code"].ToString(),
                                checkitem_name = arra[j]["checkitem_name"].ToString(),
                                checkitem_descr = arra[j]["checkitem_descr"].ToString(),
                                check_value = arra[j]["check_value"].ToString(),
                                check_result = arra[j]["check_result"].ToString(),
                                lm_user = username,
                                lm_date = datetime
                            }