public int U_PWP(ProductionWeekPlanInfo productionweekPlanInfo) //编辑生产周计划
{
SqlParameter[] parm = new SqlParameter[4];
parm[0] = new SqlParameter("@PWP_ID", SqlDbType.UniqueIdentifier);
parm[0].Value = productionweekPlanInfo.PWP_ID;
parm[1] = new SqlParameter("@PWP_STime", SqlDbType.Date);
parm[1].Value = productionweekPlanInfo.PWP_STime;
parm[2] = new SqlParameter("@PWP_ETime", SqlDbType.Date);
parm[2].Value = productionweekPlanInfo.PWP_ETime;
parm[3] = new SqlParameter("@PWP_Man", SqlDbType.VarChar, 20);
parm[3].Value = productionweekPlanInfo.PWP_Man;
int a
= SqlHelper.ExecuteNonQuery(
SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure,
"Proc_U_PWP", parm);
return(a);
}
public void U_PWP_Review(ProductionWeekPlanInfo productionWeekPlanInfo) //审核生产周计划
{
SqlParameter[] parm = new SqlParameter[5];
parm[0] = new SqlParameter("@pwpid", SqlDbType.UniqueIdentifier);
parm[0].Value = productionWeekPlanInfo.PWP_ID;
parm[1] = new SqlParameter("@man", SqlDbType.VarChar, 20);
parm[1].Value = productionWeekPlanInfo.PWP_RMan;
parm[2] = new SqlParameter("@view", SqlDbType.VarChar, 400);
parm[2].Value = productionWeekPlanInfo.PWP_Suggstion;
parm[3] = new SqlParameter("@result", SqlDbType.VarChar, 20);
parm[3].Value = productionWeekPlanInfo.PWP_State;
parm[4] = new SqlParameter("@pwpcid", SqlDbType.UniqueIdentifier);
parm[4].Value = productionWeekPlanInfo.PWPCID;
SqlHelper.ExecuteNonQuery(
SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure,
"Proc_U_PWP_Review", parm);
}
public void I_PWP(ProductionWeekPlanInfo productionweekPlanInfo) //插入生产周计划
{
SqlParameter[] parm = new SqlParameter[7];
parm[0] = new SqlParameter("@SMSWPM_ID", SqlDbType.UniqueIdentifier);
parm[0].Value = productionweekPlanInfo.SMSWPM_ID;
parm[1] = new SqlParameter("@PWP_Year", SqlDbType.SmallInt);
parm[1].Value = productionweekPlanInfo.PWP_Year;
parm[2] = new SqlParameter("@PWP_Month", SqlDbType.TinyInt);
parm[2].Value = productionweekPlanInfo.PWP_Month;
parm[3] = new SqlParameter("@PWP_STime", SqlDbType.Date);
parm[3].Value = productionweekPlanInfo.PWP_STime;
parm[4] = new SqlParameter("@PWP_ETime", SqlDbType.Date);
parm[4].Value = productionweekPlanInfo.PWP_ETime;
parm[5] = new SqlParameter("@PWP_Man", SqlDbType.VarChar, 20);
parm[5].Value = productionweekPlanInfo.PWP_Man;
parm[6] = new SqlParameter("@linenum", SqlDbType.Int);
parm[6].Value = productionweekPlanInfo.Linenum;
SqlHelper.ExecuteNonQuery(
SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure,
"Proc_I_PWP", parm);
}
