//查询申请单详细内容 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); }