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