//查询申请单详细内容
public DataSet SelectPMPurchaseApplyDetail(PMPurchaseingApplyRuleinfo pMPurchaseingApplyRuleinfo)
{
SqlParameter[] parm = new SqlParameter[1];
parm[0] = new SqlParameter("@PMPAM_ID ", SqlDbType.UniqueIdentifier);
parm[0].Value = pMPurchaseingApplyRuleinfo.PMPAM_ID;
return(SqlHelper.GetDataSet(EquipmentMangementAjax.DBUtility.SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_S_PMPurchaseApplyDetail", parm));
}
//填写物料价格
public void UpdatePMPMaterial_Price(PMPurchaseingApplyRuleinfo pMPurchaseingApplyRuleinfo)
{
SqlParameter[] para = new SqlParameter[2];
para[0] = new SqlParameter("@IMMBD_MaterialID", SqlDbType.UniqueIdentifier);
para[0].Value = pMPurchaseingApplyRuleinfo.IMMBD_MaterialID;
para[1] = new SqlParameter("@IMMBD_Price", SqlDbType.Decimal);
para[1].Value = pMPurchaseingApplyRuleinfo.IMMBD_Price;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_PMPMaterial_Price", para);
}
//确认紧急采购订单
public void UpdatePMPAM_EmergencyPur(PMPurchaseingApplyRuleinfo pMPurchaseingApplyRuleinfo)
{
SqlParameter[] parm = new SqlParameter[1];
parm[0] = new SqlParameter("@PMPAM_ID", SqlDbType.UniqueIdentifier);
parm[0].Value = pMPurchaseingApplyRuleinfo.PMPAM_ID;
SqlHelper.GetDataSet(EquipmentMangementAjax.DBUtility.SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_U_PMPAM_EmergencyPur", parm);
}
//新增采购申请单
public void InsertPMPurchaseingApplyMain(PMPurchaseingApplyRuleinfo pMPurchaseingApplyRuleinfo)
{
SqlParameter[] parm = new SqlParameter[3];
parm[0] = new SqlParameter("@PMPAM_Department", SqlDbType.VarChar, 20);
parm[0].Value = pMPurchaseingApplyRuleinfo.PMPAM_Department;
parm[1] = new SqlParameter("@PMPAM_ApplyMan", SqlDbType.VarChar, 20);
parm[1].Value = pMPurchaseingApplyRuleinfo.PMPAM_ApplyMan;
parm[2] = new SqlParameter("@PMPAM_State", SqlDbType.VarChar, 20);
parm[2].Value = pMPurchaseingApplyRuleinfo.PMPAM_State;
SqlHelper.GetDataSet(EquipmentMangementAjax.DBUtility.SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_I_PMPurchaseingApplyMain", parm);
}
//技术副总审核
public void UpdatePMPAM_PersonalCheck(PMPurchaseingApplyRuleinfo pMPurchaseingApplyRuleinfo)
{
SqlParameter[] parm = new SqlParameter[5];
parm[0] = new SqlParameter("@PMPAM_ID", SqlDbType.UniqueIdentifier);
parm[0].Value = pMPurchaseingApplyRuleinfo.PMPAM_ID;
parm[1] = new SqlParameter("@PMPAM_PersonnalCheckResult", SqlDbType.VarChar, 20);
parm[1].Value = pMPurchaseingApplyRuleinfo.PMPAM_PersonnalCheckResult;
parm[2] = new SqlParameter("@PMPAM_PersonnalCheckOpinion", SqlDbType.VarChar, 400);
parm[2].Value = pMPurchaseingApplyRuleinfo.PMPAM_PersonnalCheckOpinion;
parm[3] = new SqlParameter("@PMPAM_State", SqlDbType.VarChar, 20);
parm[3].Value = pMPurchaseingApplyRuleinfo.PMPAM_State;
parm[4] = new SqlParameter("@PMPAM_PersonnalCheckMan", SqlDbType.VarChar, 20);
parm[4].Value = pMPurchaseingApplyRuleinfo.PMPAM_PersonnalCheckMan;
SqlHelper.GetDataSet(EquipmentMangementAjax.DBUtility.SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_U_PMPAM_PersonnalCheck ", parm);
}
//新增采购申请单详细表
public void InsertPMPurchaseingApply(PMPurchaseingApplyRuleinfo pMPurchaseingApplyRuleinfo)
{
SqlParameter[] parm = new SqlParameter[8];
parm[0] = new SqlParameter("@PMPAD_Require", SqlDbType.VarChar, 400);
parm[0].Value = pMPurchaseingApplyRuleinfo.PMPAD_Require;
parm[1] = new SqlParameter("@IMMBD_MaterialID", SqlDbType.UniqueIdentifier);
parm[1].Value = pMPurchaseingApplyRuleinfo.IMMBD_MaterialID;
parm[2] = new SqlParameter("@PMPAD_Num", SqlDbType.Decimal);
parm[2].Value = pMPurchaseingApplyRuleinfo.PMPAD_Num;
parm[3] = new SqlParameter("@PMPAM_ID", SqlDbType.UniqueIdentifier);
parm[3].Value = pMPurchaseingApplyRuleinfo.PMPAM_ID;
parm[4] = new SqlParameter("@PMPAD_NeedTime", SqlDbType.DateTime);
parm[4].Value = pMPurchaseingApplyRuleinfo.PMPAD_NeedTime;
parm[5] = new SqlParameter("@IMUC_ID", SqlDbType.UniqueIdentifier);
parm[5].Value = pMPurchaseingApplyRuleinfo.IMUC_ID;
parm[6] = new SqlParameter("@PMPAD_Remark", SqlDbType.VarChar, 400);
parm[6].Value = pMPurchaseingApplyRuleinfo.PMPAD_Remark;
parm[7] = new SqlParameter("@PMPAD_PriceIndication", SqlDbType.Decimal);
parm[7].Value = pMPurchaseingApplyRuleinfo.PMPAD_PriceIndication;
SqlHelper.GetDataSet(EquipmentMangementAjax.DBUtility.SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_I_PMPurchaseingApply", parm);
}
public void UpdatePMPAM_CFOCheck(PMPurchaseingApplyRuleinfo pMPurchaseingApplyRuleinfo)
{
PRMP.UpdatePMPAM_CFOCheck(pMPurchaseingApplyRuleinfo);
}
public void UpdatePMPMaterial_Price(PMPurchaseingApplyRuleinfo pMPurchaseingApplyRuleinfo)
{
pp.UpdatePMPMaterial_Price(pMPurchaseingApplyRuleinfo);
}
public void UpdatePMPAM_DesignMangCheck(PMPurchaseingApplyRuleinfo pMPurchaseingApplyRuleinfo)
{
PRMP.UpdatePMPAM_DesignMangCheck(pMPurchaseingApplyRuleinfo);
}
public void UpdatePMPAM_EmergencyPur(PMPurchaseingApplyRuleinfo pMPurchaseingApplyRuleinfo)
{
PRMP.UpdatePMPAM_EmergencyPur(pMPurchaseingApplyRuleinfo);
}
public void DeletePMPurchaseApplyMain(PMPurchaseingApplyRuleinfo pMPurchaseingApplyRuleinfo)
{
PRMP.DeletePMPurchaseApplyMain(pMPurchaseingApplyRuleinfo);
}
public DataSet SelectPMPurchaseApplyOne(PMPurchaseingApplyRuleinfo pMPurchaseingApplyRuleinfo)
{
return(PRMP.SelectPMPurchaseApplyOne(pMPurchaseingApplyRuleinfo));
}
public void InsertPMPurchaseingApplyMain(PMPurchaseingApplyRuleinfo pMPurchaseingApplyRuleinfo)
{
PRMP.InsertPMPurchaseingApplyMain(pMPurchaseingApplyRuleinfo);
}
public DataSet SelectPMPAM_CheckOpinion(PMPurchaseingApplyRuleinfo pMPurchaseingApplyRuleinfo)
{
return(PRMP.SelectPMPAM_CheckOpinion(pMPurchaseingApplyRuleinfo));
}
public void UpdatePMPAM_AppDepartMang(PMPurchaseingApplyRuleinfo pMPurchaseingApplyRuleinfo)
{
PRMP.UpdatePMPAM_AppDepartMang(pMPurchaseingApplyRuleinfo);
}
public void UpdatePMPurchaseApplySate(PMPurchaseingApplyRuleinfo pMPurchaseingApplyRuleinfo)
{
PRMP.UpdatePMPurchaseApplySate(pMPurchaseingApplyRuleinfo);
}
public void DeletePMPurchaseApplyDetail(PMPurchaseingApplyRuleinfo pMPurchaseingApplyRuleinfo)
{
PRMP.DeletePMPurchaseApplyDetail(pMPurchaseingApplyRuleinfo);
}
public void UpdatePMPurchaseingApplyMain_ID(PMPurchaseingApplyRuleinfo pMPurchaseingApplyRuleinfo)
{
PRMP.UpdatePMPurchaseingApplyMain_ID(pMPurchaseingApplyRuleinfo);
}