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