/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(CZZD.ERP.Model.BaseCompositionProductsSpecificationTable model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_COMPOSITION_PRODUCTS_SPECIFICATION set ");
strSql.Append("COMPOSITION_PRODUCTS_CODE=@COMPOSITION_PRODUCTS_CODE,");
strSql.Append("SPECIFICATION_CODE=@SPECIFICATION_CODE");
strSql.Append(" where COMPOSITION_PRODUCTS_CODE=@COMPOSITION_PRODUCTS_CODE and SPECIFICATION_CODE=@SPECIFICATION_CODE ");
SqlParameter[] parameters =
{
new SqlParameter("@COMPOSITION_PRODUCTS_CODE", SqlDbType.VarChar, 20),
new SqlParameter("@SPECIFICATION_CODE", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.COMPOSITION_PRODUCTS_CODE;
parameters[1].Value = model.SPECIFICATION_CODE;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CZZD.ERP.Model.BaseCompositionProductsSpecificationTable GetModel(string COMPOSITION_PRODUCTS_CODE, string SPECIFICATION_CODE)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 COMPOSITION_PRODUCTS_CODE,COMPOSITION_PRODUCTS_NAME,SPECIFICATION_CODE,SPECIFICATION_NAME from base_composition_products_specifition ");
strSql.Append(" where COMPOSITION_PRODUCTS_CODE=@COMPOSITION_PRODUCTS_CODE and SPECIFICATION_CODE=@SPECIFICATION_CODE ");
SqlParameter[] parameters =
{
new SqlParameter("@COMPOSITION_PRODUCTS_CODE", SqlDbType.VarChar, 50),
new SqlParameter("@SPECIFICATION_CODE", SqlDbType.VarChar, 50)
};
parameters[0].Value = COMPOSITION_PRODUCTS_CODE;
parameters[1].Value = SPECIFICATION_CODE;
CZZD.ERP.Model.BaseCompositionProductsSpecificationTable model = new CZZD.ERP.Model.BaseCompositionProductsSpecificationTable();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.COMPOSITION_PRODUCTS_CODE = ds.Tables[0].Rows[0]["COMPOSITION_PRODUCTS_CODE"].ToString();
model.COMPOSITION_PRODUCTS_NAME = ds.Tables[0].Rows[0]["COMPOSITION_PRODUCTS_NAME"].ToString();
model.SPECIFICATION_CODE = ds.Tables[0].Rows[0]["SPECIFICATION_CODE"].ToString();
model.SPECIFICATION_NAME = ds.Tables[0].Rows[0]["SPECIFICATION_NAME"].ToString();
return(model);
}
else
{
return(null);
}
}
