public void I_PMP(ProductionPlanInfo productionPlanInfo)//插入生产月计划 { SqlParameter[] para = { new SqlParameter("@SMSMPM_ID", SqlDbType.UniqueIdentifier) { Value = productionPlanInfo.SMSMPM_ID }, new SqlParameter("@PMP_Year", SqlDbType.SmallInt) { Value = productionPlanInfo.PMP_Year }, new SqlParameter("@PMP_Month", SqlDbType.TinyInt) { Value = productionPlanInfo.PMP_Month }, new SqlParameter("@PMP_STime", SqlDbType.Date) { Value = productionPlanInfo.PMP_STime }, new SqlParameter("@PMP_ETime", SqlDbType.Date) { Value = productionPlanInfo.PMP_ETime }, new SqlParameter("@PMP_Man", SqlDbType.VarChar, 20) { Value = productionPlanInfo.PMP_Man }, new SqlParameter("@line", SqlDbType.Int) { Value = productionPlanInfo.Proline } }; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_PMP", para); }
public void U_SMSalesMonthPlanDetail_PMPDetail(ProductionPlanInfo productionPlanInfo)//制定生产月详细计划 { SqlParameter[] parm = new SqlParameter[3]; parm[0] = new SqlParameter("@SMSMPD_ID", SqlDbType.UniqueIdentifier); parm[0].Value = productionPlanInfo.SMSMPD_ID; parm[1] = new SqlParameter("@SMSMPD_PMPNum", SqlDbType.Int); parm[1].Value = productionPlanInfo.SMSMPD_PMPNum; parm[2] = new SqlParameter("@SMSMPD_PMPNote", SqlDbType.VarChar, 200); parm[2].Value = productionPlanInfo.SMSMPD_PMPNote; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_SMSalesMonthPlanDetail_PMPDetail", parm); }
public void U_PMP_Review(ProductionPlanInfo productionPlanInfo)//审核生产月计划 { SqlParameter[] parm = new SqlParameter[5]; parm[0] = new SqlParameter("@pmpid", SqlDbType.UniqueIdentifier); parm[0].Value = productionPlanInfo.PMP_ID; parm[1] = new SqlParameter("@man", SqlDbType.VarChar, 20); parm[1].Value = productionPlanInfo.PMP_RMan; parm[2] = new SqlParameter("@view", SqlDbType.VarChar, 200); parm[2].Value = productionPlanInfo.PMP_RSuggstion; parm[3] = new SqlParameter("@result", SqlDbType.VarChar, 20); parm[3].Value = productionPlanInfo.PMP_State; parm[4] = new SqlParameter("@pmpcid", SqlDbType.UniqueIdentifier); parm[4].Value = productionPlanInfo.PMPC_ID; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_PMP_Review", parm); }
public void U_PMP(ProductionPlanInfo productionPlanInfo)//编辑生产月计划 { SqlParameter[] parm = new SqlParameter[4]; parm[0] = new SqlParameter("@PMP_ID", SqlDbType.UniqueIdentifier); parm[0].Value = productionPlanInfo.PMP_ID; parm[1] = new SqlParameter("@PMP_STime", SqlDbType.Date); parm[1].Value = productionPlanInfo.PMP_STime; parm[2] = new SqlParameter("@PMP_ETime", SqlDbType.Date); parm[2].Value = productionPlanInfo.PMP_ETime; parm[3] = new SqlParameter("@PMP_Man", SqlDbType.VarChar, 20); parm[3].Value = productionPlanInfo.PMP_Man; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_PMP", parm); }
public void I_PMPDetail(ProductionPlanInfo productionPlanInfo)//插入生产月详细计划 { SqlParameter[] parm = new SqlParameter[5]; parm[0] = new SqlParameter("@PMP_ID", SqlDbType.UniqueIdentifier); parm[0].Value = productionPlanInfo.PMP_ID; parm[1] = new SqlParameter("@PMPD_ProdType", SqlDbType.VarChar, 60); parm[1].Value = productionPlanInfo.PMPD_ProdType; parm[2] = new SqlParameter("@PMPD_PSName", SqlDbType.VarChar, 60); parm[2].Value = productionPlanInfo.PMPD_PSName; parm[3] = new SqlParameter("@PMPD_MPNum", SqlDbType.Int); parm[3].Value = productionPlanInfo.PMPD_MPNum; parm[4] = new SqlParameter("@PMPD_Note", SqlDbType.VarChar, 100); parm[4].Value = productionPlanInfo.PPMPD_Note; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_PMPDetail", parm); }