public void I_ProSeries(ProSeriesInfo_ProTypeInfo proSeriesInfo_ProTypeInfo)//插入新的产品系列
{
SqlParameter[] parm = new SqlParameter[1];
parm[0] = new SqlParameter("@PS_Name", SqlDbType.VarChar, 60);
parm[0].Value = proSeriesInfo_ProTypeInfo.PS_Name;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_ProSeries", parm);
}
public void U_ProType_new(ProSeriesInfo_ProTypeInfo proSeriesInfo_ProTypeInfo, string PT_Parameters, string PT_Code)//编辑产品型号_新
{
SqlParameter[] parm = new SqlParameter[10];
parm[0] = new SqlParameter("@PS_ID", SqlDbType.UniqueIdentifier);
parm[0].Value = proSeriesInfo_ProTypeInfo.PS_ID;
parm[1] = new SqlParameter("@PT_Name", SqlDbType.VarChar, 60);
parm[1].Value = proSeriesInfo_ProTypeInfo.PT_Name;
parm[2] = new SqlParameter("@PT_Special", SqlDbType.Char, 2);
parm[2].Value = proSeriesInfo_ProTypeInfo.PT_Special;
parm[3] = new SqlParameter("@BOM_ID", SqlDbType.UniqueIdentifier);
parm[3].Value = proSeriesInfo_ProTypeInfo.BOM_ID;
parm[4] = new SqlParameter("@PR_ID", SqlDbType.UniqueIdentifier);
parm[4].Value = proSeriesInfo_ProTypeInfo.PR_ID;
parm[5] = new SqlParameter("@PT_ID", SqlDbType.UniqueIdentifier);
parm[5].Value = proSeriesInfo_ProTypeInfo.PT_ID;
parm[6] = new SqlParameter("@PT_Man", SqlDbType.VarChar, 20);
parm[6].Value = proSeriesInfo_ProTypeInfo.PT_Man;
parm[7] = new SqlParameter("@PT_Parameters", SqlDbType.VarChar, 400);
parm[7].Value = PT_Parameters;
parm[8] = new SqlParameter("@PT_Code", SqlDbType.VarChar, 30);
parm[8].Value = PT_Code;
parm[9] = new SqlParameter("@PT_Note", SqlDbType.VarChar, 400);
parm[9].Value = proSeriesInfo_ProTypeInfo.PT_Note;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_U_ProType_new", parm);
}
public void U_ProSeries(ProSeriesInfo_ProTypeInfo proSeriesInfo_ProTypeInfo)//编辑产品系列名称
{
SqlParameter[] parm = new SqlParameter[2];
parm[0] = new SqlParameter("@PS_ID", SqlDbType.UniqueIdentifier);
parm[0].Value = proSeriesInfo_ProTypeInfo.PS_ID;
parm[1] = new SqlParameter("@PS_Name", SqlDbType.VarChar, 60);
parm[1].Value = proSeriesInfo_ProTypeInfo.PS_Name;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_U_ProSeries", parm);
}
public void U_ProProcessParameter(ProSeriesInfo_ProTypeInfo proSeriesInfo_ProTypeInfo)//编辑产品某个工序的工艺参数
{
SqlParameter[] parm = new SqlParameter[5];
parm[0] = new SqlParameter("@PT_ID", SqlDbType.UniqueIdentifier);
parm[0].Value = proSeriesInfo_ProTypeInfo.PT_ID;
parm[1] = new SqlParameter("@PBC_ID", SqlDbType.UniqueIdentifier);
parm[1].Value = proSeriesInfo_ProTypeInfo.PBC_ID;
parm[2] = new SqlParameter("@PPP_Note", SqlDbType.VarChar, 200);
parm[2].Value = proSeriesInfo_ProTypeInfo.PPP_Note;
parm[3] = new SqlParameter("@PPP_Parameter", SqlDbType.VarChar, 200);
parm[3].Value = proSeriesInfo_ProTypeInfo.PPP_Parameter;
parm[4] = new SqlParameter("@PPP_PassRate", SqlDbType.Decimal);
parm[4].Value = proSeriesInfo_ProTypeInfo.PPP_PassRate;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_U_ProProcessParameter", parm);
}
public void I_ProType(ProSeriesInfo_ProTypeInfo proSeriesInfo_ProTypeInfo)//新增产品型号
{
SqlParameter[] parm = new SqlParameter[6];
parm[0] = new SqlParameter("@PS_ID", SqlDbType.UniqueIdentifier);
parm[0].Value = proSeriesInfo_ProTypeInfo.PS_ID;
parm[1] = new SqlParameter("@PT_Name", SqlDbType.VarChar, 60);
parm[1].Value = proSeriesInfo_ProTypeInfo.PT_Name;
parm[2] = new SqlParameter("@PT_Special", SqlDbType.Char, 2);
parm[2].Value = proSeriesInfo_ProTypeInfo.PT_Special;
parm[3] = new SqlParameter("@BOM_ID", SqlDbType.UniqueIdentifier);
parm[3].Value = proSeriesInfo_ProTypeInfo.BOM_ID;
parm[4] = new SqlParameter("@PR_ID", SqlDbType.UniqueIdentifier);
parm[4].Value = proSeriesInfo_ProTypeInfo.PR_ID;
parm[5] = new SqlParameter("@PT_Man", SqlDbType.VarChar, 20);
parm[5].Value = proSeriesInfo_ProTypeInfo.PT_Man;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_ProType", parm);
}
public void I_ProProcessParameter(ProSeriesInfo_ProTypeInfo proSeriesInfo_ProTypeInfo)//编辑产品某个工序的工艺参数
{
pspt.I_ProProcessParameter(proSeriesInfo_ProTypeInfo);
}
public void U_ProType_new(ProSeriesInfo_ProTypeInfo proSeriesInfo_ProTypeInfo, string PT_Parameters, string PT_Code)//编辑产品型号_新
{
pspt.U_ProType_new(proSeriesInfo_ProTypeInfo, PT_Parameters, PT_Code);
}
public void U_ProType(ProSeriesInfo_ProTypeInfo proSeriesInfo_ProTypeInfo)//编辑产品型号
{
pspt.U_ProType(proSeriesInfo_ProTypeInfo);
}
public void I_ProType(ProSeriesInfo_ProTypeInfo proSeriesInfo_ProTypeInfo)//新增产品型号
{
pspt.I_ProType(proSeriesInfo_ProTypeInfo);
}
public void U_ProSeries(ProSeriesInfo_ProTypeInfo proSeriesInfo_ProTypeInfo)//编辑产品系列名称
{
pspt.U_ProSeries(proSeriesInfo_ProTypeInfo);
}
public void I_ProSeries(ProSeriesInfo_ProTypeInfo proSeriesInfo_ProTypeInfo)//插入新的产品系列
{
pspt.I_ProSeries(proSeriesInfo_ProTypeInfo);
}
