/// <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);
}
}
