//新增供应商认证信息表
public void InsertPMSupplyCertificInfo(PMSupplyCertificinfo pMSupplyCertificinfo)
{
SqlParameter[] parm = new SqlParameter[10];
parm[0] = new SqlParameter("@PMSCI_Model ", SqlDbType.VarChar, 100);
parm[0].Value = pMSupplyCertificinfo.PMSCI_Model;
parm[1] = new SqlParameter("@PMSCI_CheckDepertment", SqlDbType.VarChar, 100);
parm[1].Value = pMSupplyCertificinfo.PMSCI_CheckDepertment;
parm[2] = new SqlParameter("@PMSCA_CertificApplyNum", SqlDbType.UniqueIdentifier);
parm[2].Value = pMSupplyCertificinfo.PMSCA_CertificApplyNum;
parm[3] = new SqlParameter("@PMSCI_CertificSchedule", SqlDbType.VarChar, 100);
parm[3].Value = pMSupplyCertificinfo.PMSCI_CertificSchedule;
parm[4] = new SqlParameter("@PMSCI_CertificResult", SqlDbType.VarChar, 400);
parm[4].Value = pMSupplyCertificinfo.PMSCI_CertificResult;
parm[5] = new SqlParameter("@PMSCI_Remark", SqlDbType.VarChar, 400);
parm[5].Value = pMSupplyCertificinfo.PMSCI_Remark;
parm[6] = new SqlParameter("@PMSCI_Accessory ", SqlDbType.Char, 2);
parm[6].Value = pMSupplyCertificinfo.PMSCI_Accessory;
parm[7] = new SqlParameter("@PMSCI_AccNum", SqlDbType.VarChar, 100);
parm[7].Value = pMSupplyCertificinfo.PMSCI_AccNum;
parm[8] = new SqlParameter("@PMSCI_AccName", SqlDbType.VarChar, 100);
parm[8].Value = pMSupplyCertificinfo.PMSCI_AccName;
parm[9] = new SqlParameter("@PMSCI_AccPath", SqlDbType.VarChar, 100);
parm[9].Value = pMSupplyCertificinfo.PMSCI_AccPath;
SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_I_PMSupplyCertificInfo", parm);
}
//查询某一供应商认证申请表
public DataSet SelectPMSupplyCertificApply_One(PMSupplyCertificinfo pMSupplyCertificinfo)
{
SqlParameter[] parm = new SqlParameter[1];
parm[0] = new SqlParameter("@PMSCA_CertificApplyNum", SqlDbType.UniqueIdentifier);
parm[0].Value = pMSupplyCertificinfo.PMSCA_CertificApplyNum;
return(SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_S_PMSupplyCertificApply_One", parm));
}
//删除认证会签部门
public void DeletePMSupplyCertificApplyCountersign(PMSupplyCertificinfo pMSupplyCertificinfo)
{
SqlParameter[] parm = new SqlParameter[1];
parm[0] = new SqlParameter("@PMSCAC_ID", SqlDbType.UniqueIdentifier);
parm[0].Value = pMSupplyCertificinfo.PMSCAC_ID;
SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Pro_D_PMSupplyCertificApplyCountersign", parm);
}
//新增认证申请会签表
public void InsertPMSupplyCertificApplyCountersign(PMSupplyCertificinfo pMSupplyCertificinfo)
{
SqlParameter[] parm = new SqlParameter[2];
parm[0] = new SqlParameter("@PMSCA_CertificApplyNum", SqlDbType.UniqueIdentifier);
parm[0].Value = pMSupplyCertificinfo.PMSCA_CertificApplyNum;
parm[1] = new SqlParameter("@PMSCAC_SignPartment", SqlDbType.VarChar, 200);
parm[1].Value = pMSupplyCertificinfo.PMSCAC_SignPartment;
SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_I_PMSupplyCertificApplyCountersign", parm);
}
//修改认证申请单申请状态
public void UpdatePMSCA_State(PMSupplyCertificinfo pMSupplyCertificinfo)
{
SqlParameter[] parm = new SqlParameter[2];
parm[0] = new SqlParameter("@PMSCA_CertificApplyNum ", SqlDbType.UniqueIdentifier);
parm[0].Value = pMSupplyCertificinfo.PMSCA_CertificApplyNum;
parm[1] = new SqlParameter("@PMSCA_State", SqlDbType.VarChar, 20);
parm[1].Value = pMSupplyCertificinfo.PMSCA_State;
SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_U_PMSCA_State", parm);
}
//修改认证申请会签表
public void UpdatePMSupplyCertificApplyCountersign(PMSupplyCertificinfo pMSupplyCertificinfo)
{
SqlParameter[] parm = new SqlParameter[4];
parm[0] = new SqlParameter("@PMSCAC_SignResult", SqlDbType.VarChar, 20);
parm[0].Value = pMSupplyCertificinfo.PMSCAC_SignResult;
parm[1] = new SqlParameter("@PMSCAC_SignOpinion", SqlDbType.VarChar, 400);
parm[1].Value = pMSupplyCertificinfo.PMSCAC_SignOpinion;
parm[2] = new SqlParameter("@PMSCAC_SignMan", SqlDbType.VarChar, 20);
parm[2].Value = pMSupplyCertificinfo.PMSCAC_SignMan;
parm[3] = new SqlParameter("@PMSCAC_ID", SqlDbType.UniqueIdentifier);
parm[3].Value = pMSupplyCertificinfo.PMSCAC_ID;
SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_U_PMSupplyCertificApplyCountersign", parm);
}
//总经理审核
public void InsertPMSCA_GMCheck(PMSupplyCertificinfo pMSupplyCertificinfo)
{
SqlParameter[] parm = new SqlParameter[4];
parm[0] = new SqlParameter("@PMSCA_CertificApplyNum ", SqlDbType.UniqueIdentifier);
parm[0].Value = pMSupplyCertificinfo.PMSCA_CertificApplyNum;
parm[1] = new SqlParameter("@PMSCA_GMCheckResult", SqlDbType.VarChar, 20);
parm[1].Value = pMSupplyCertificinfo.PMSCA_GMCheckResult;
parm[2] = new SqlParameter("@PMSCA_GMCheckOpinion", SqlDbType.VarChar, 400);
parm[2].Value = pMSupplyCertificinfo.PMSCA_GMCheckOpinion;
parm[3] = new SqlParameter("@PMSCA_GMCheckMan", SqlDbType.VarChar, 20);
parm[3].Value = pMSupplyCertificinfo.PMSCA_GMCheckMan;
SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_I_PMSCA_GMCheck", parm);
}
//修改认证申请表
public void UpdatePMSupplyCertificApply(PMSupplyCertificinfo pMSupplyCertificinfo)
{
SqlParameter[] parm = new SqlParameter[6];
parm[0] = new SqlParameter("@PMSCA_ApplyDepart", SqlDbType.VarChar, 200);
parm[0].Value = pMSupplyCertificinfo.PMSCA_ApplyDepart;
parm[1] = new SqlParameter("@PMSCA_MaterialName", SqlDbType.VarChar, 200);
parm[1].Value = pMSupplyCertificinfo.PMSCA_MaterialName;
parm[2] = new SqlParameter("@PMSI_ID", SqlDbType.UniqueIdentifier);
parm[2].Value = pMSupplyCertificinfo.PMSI_ID;
parm[3] = new SqlParameter("@PMSCA_ApplyAim", SqlDbType.VarChar, 400);
parm[3].Value = pMSupplyCertificinfo.PMSCA_ApplyAim;
parm[4] = new SqlParameter("@PMSCA_ApplyModifier", SqlDbType.VarChar, 20);
parm[4].Value = pMSupplyCertificinfo.PMSCA_ApplyModifier;
parm[5] = new SqlParameter("@PMSCA_CertificApplyNum ", SqlDbType.UniqueIdentifier);
parm[5].Value = pMSupplyCertificinfo.PMSCA_CertificApplyNum;
SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_U_PMSupplyCertificApply", parm);
}
public void UpdatePMSupplyCertificInfo(PMSupplyCertificinfo pMSupplyCertificinfo)
{
PRMP.UpdatePMSupplyCertificInfo(pMSupplyCertificinfo);
}
public void InsertPMSupplyCertificInfo(PMSupplyCertificinfo pMSupplyCertificinfo)
{
PRMP.InsertPMSupplyCertificInfo(pMSupplyCertificinfo);
}
public void DeletePMSupplyCertificApply(PMSupplyCertificinfo pMSupplyCertificinfo)
{
PRMP.DeletePMSupplyCertificApply(pMSupplyCertificinfo);
}
public void DeletePMSupplyCertificApplyCountersign(PMSupplyCertificinfo pMSupplyCertificinfo)
{
PRMP.DeletePMSupplyCertificApplyCountersign(pMSupplyCertificinfo);
}
public DataSet SelectPMSupplyCertificApplyCountersign_One(PMSupplyCertificinfo pMSupplyCertificinfo)
{
return(PRMP.SelectPMSupplyCertificApplyCountersign_One(pMSupplyCertificinfo));
}
public void InsertPMSCA_GMCheck(PMSupplyCertificinfo pMSupplyCertificinfo)
{
PRMP.InsertPMSCA_GMCheck(pMSupplyCertificinfo);
}
public void UpdatePMSCA_State(PMSupplyCertificinfo pMSupplyCertificinfo)
{
PRMP.UpdatePMSCA_State(pMSupplyCertificinfo);
}
public DataSet SelectPMSupplyCertificInfo_One(PMSupplyCertificinfo pMSupplyCertificinfo)
{
return(PRMP.SelectPMSupplyCertificInfo_One(pMSupplyCertificinfo));
}
//查找供应商
public void SelectPMSupply(PMSupplyCertificinfo pMSupplyCertificinfo)
{
SqlHelper.GetDataSet(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_S_PMSupply");
}
public void DeletePMSupplyCertificInfo_One(PMSupplyCertificinfo pMSupplyCertificinfo)
{
PRMP.DeletePMSupplyCertificInfo_One(pMSupplyCertificinfo);
}
public DataSet SelectPMSCA_DMCheckOpinion(PMSupplyCertificinfo pMSupplyCertificinfo)
{
return(PRMP.SelectPMSCA_DMCheckOpinion(pMSupplyCertificinfo));
}
public void InsertPMSCA_EDSign(PMSupplyCertificinfo pMSupplyCertificinfo)
{
PRMP.InsertPMSCA_EDSign(pMSupplyCertificinfo);
}
public void InsertPMSupplyCertificApplyCountersign(PMSupplyCertificinfo pMSupplyCertificinfo)
{
PRMP.InsertPMSupplyCertificApplyCountersign(pMSupplyCertificinfo);
}
public void SelectPMSupply(PMSupplyCertificinfo pMSupplyCertificinfo)
{
PRMP.SelectPMSupply(pMSupplyCertificinfo);
}
public void UpdatePMSupplyCertificApplyCountersign(PMSupplyCertificinfo pMSupplyCertificinfo)
{
PRMP.UpdatePMSupplyCertificApplyCountersign(pMSupplyCertificinfo);
}
