/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(CZZD.ERP.Model.BaseCompositionProductsProductionProcessTable model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_COMPOSITION_PRODUCTS_PRODUCTION_PROCESS set ");
strSql.Append("COMPOSITION_PRODUCTS_CODE=@COMPOSITION_PRODUCTS_CODE,");
strSql.Append("PRODUCTION_PROCESS_CODE=@PRODUCTION_PROCESS_CODE,");
strSql.Append("PRODUCTION_SEQUENCE=@PRODUCTION_SEQUENCE");
strSql.Append(" where COMPOSITION_PRODUCTS_CODE=@COMPOSITION_PRODUCTS_CODE and PRODUCTION_PROCESS_CODE=@PRODUCTION_PROCESS_CODE ");
SqlParameter[] parameters =
{
new SqlParameter("@COMPOSITION_PRODUCTS_CODE", SqlDbType.VarChar, 20),
new SqlParameter("@PRODUCTION_PROCESS_CODE", SqlDbType.VarChar, 20),
new SqlParameter("@PRODUCTION_SEQUENCE", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.COMPOSITION_PRODUCTS_CODE;
parameters[1].Value = model.PRODUCTION_PROCESS_CODE;
parameters[2].Value = model.ORDER;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(CZZD.ERP.Model.BaseCompositionProductsProductionProcessTable model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_COMPOSITION_PRODUCTS_PRODUCTION_PROCESS(");
strSql.Append("COMPOSITION_PRODUCTS_CODE,PRODUCTION_PROCESS_CODE,PRODUCTION_SEQUENCE)");
strSql.Append(" values (");
strSql.Append("@COMPOSITION_PRODUCTS_CODE,@PRODUCTION_PROCESS_CODE,@PRODUCTION_SEQUENCE)");
SqlParameter[] parameters =
{
new SqlParameter("@COMPOSITION_PRODUCTS_CODE", SqlDbType.VarChar, 20),
new SqlParameter("@PRODUCTION_PROCESS_CODE", SqlDbType.VarChar, 20),
new SqlParameter("@PRODUCTION_SEQUENCE", SqlDbType.Int, 9)
};
parameters[0].Value = model.COMPOSITION_PRODUCTS_CODE;
parameters[1].Value = model.PRODUCTION_PROCESS_CODE;
parameters[2].Value = model.ORDER;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
