/// <summary> /// 插入旧料号数据 /// </summary> /// <param name="zl11"></param> /// <returns></returns> public bool InsertMro(VIEW_spare_All zl11) { //厂区 SqlParameter BUKRS = new SqlParameter("@BUKRS", SqlDbType.VarChar); BUKRS.Value = zl11.BUKRS; //料号 SqlParameter MATNR = new SqlParameter("@MATNR", SqlDbType.VarChar); MATNR.Value = zl11.MATNR; //申请人名字 SqlParameter CRNAME = new SqlParameter("@CRNAME", SqlDbType.VarChar); CRNAME.Value = zl11.CRNAME; //申请时间 SqlParameter CRDATE = new SqlParameter("@CRDATE", SqlDbType.VarChar); CRDATE.Value = zl11.CRDATE; //中文描述 SqlParameter MAKTX = new SqlParameter("@MAKTX", SqlDbType.NVarChar); MAKTX.Value = zl11.MAKTX; //Declitem SqlParameter DECLITEM = new SqlParameter("@DECLITEM", SqlDbType.VarChar); DECLITEM.Value = zl11.DECLITEM; //修改人工号 SqlParameter CHNAME = new SqlParameter("@CHNAME", SqlDbType.VarChar); CHNAME.Value = zl11.CHNAME; //修改时间 SqlParameter CHDATE = new SqlParameter("@CHDATE", SqlDbType.VarChar); CHDATE.Value = zl11.CHDATE; SqlParameter C3FLAG = new SqlParameter("@C3FLAG", SqlDbType.NVarChar); C3FLAG.Value = zl11.C3FLAG; SqlParameter C3REMARK = new SqlParameter("@C3REMARK", SqlDbType.NVarChar); C3REMARK.Value = zl11.C3REMARK; SqlParameter CELFLAG = new SqlParameter("@CELFLAG", SqlDbType.NVarChar); CELFLAG.Value = zl11.CELFLAG; SqlParameter[] parameters = new SqlParameter[] { BUKRS, MATNR, CRNAME, CRDATE, MAKTX, DECLITEM, CHNAME, CHDATE, C3FLAG, C3REMARK, CELFLAG }; try { _context.VIEW_spare_All.FromSqlRaw($"exec sp_sp_insertmro", parameters); return(true); } catch (Exception e) { return(false); } }
/// <summary> /// 插入归并数据 /// </summary> /// <param name="zl11"></param> /// <returns></returns> private bool InsertMro(VIEW_spare_All zl11) { bool flag1, flag2 = true; if (!string.IsNullOrEmpty(zl11.Type)) { flag1 = _zl11Repository.InsertMroNew(zl11); } else { flag1 = _zl11Repository.InsertCmro(zl11); flag2 = _zl11Repository.InsertMro(zl11); } return(flag1 && flag2); }
/// <summary> /// 插入旧料号项号 /// </summary> /// <param name="zl11"></param> /// <returns></returns> public bool InsertCmro(VIEW_spare_All zl11) { //抵账序号 SqlParameter DECLITEM = new SqlParameter("@DECLITEM", SqlDbType.VarChar); DECLITEM.Value = zl11.DECLITEM; //料号对应抵账序号 SqlParameter MA_MATNR = new SqlParameter("@MA_MATNR", SqlDbType.VarChar); MA_MATNR.Value = zl11.MA_MATNR; //数字化单位 SqlParameter ZGEWEI = new SqlParameter("@ZGEWEI", SqlDbType.VarChar); ZGEWEI.Value = zl11.ZGEWEI; //汉化单位 SqlParameter CGEWEI = new SqlParameter("@CGEWEI", SqlDbType.NVarChar); CGEWEI.Value = zl11.CGEWEI; //H.S.CODE SqlParameter TAX_CODE = new SqlParameter("@TAX_CODE", SqlDbType.VarChar); TAX_CODE.Value = zl11.TAX_CODE; //中文品名,关务需要 SqlParameter SMAKTX = new SqlParameter("@SMAKTX", SqlDbType.NVarChar); SMAKTX.Value = zl11.SMAKTX; //征税 SqlParameter BRGEW = new SqlParameter("@BRGEW", SqlDbType.NVarChar); BRGEW.Value = zl11.BRGEW; SqlParameter[] parameters = new SqlParameter[] { DECLITEM, MA_MATNR, ZGEWEI, CGEWEI, TAX_CODE, SMAKTX, BRGEW }; try { _context.VIEW_spare_All.FromSqlRaw($"exec sp_sp_insertcmro", parameters); return(true); } catch { return(false); } }