/// <summary> /// Set Attribute Instance /// </summary> /// <param name="M_AttributeSetInstance_ID">value</param> /// <param name="value">id</param> public void SetMAttributeInstance(int M_AttributeSetInstance_ID, MAttributeValue value) { MAttributeInstance instance = GetMAttributeInstance(M_AttributeSetInstance_ID); if (instance == null) { if (value != null) { instance = new MAttributeInstance(GetCtx(), GetM_Attribute_ID(), M_AttributeSetInstance_ID, value.GetM_AttributeValue_ID(), value.GetName(), Get_TrxName()); // Cached !! } else { instance = new MAttributeInstance(GetCtx(), GetM_Attribute_ID(), M_AttributeSetInstance_ID, 0, null, Get_TrxName()); } } else { if (value != null) { instance.SetM_AttributeValue_ID(value.GetM_AttributeValue_ID()); instance.SetValue(value.GetName()); // Cached !! } else { instance.SetM_AttributeValue_ID(0); instance.SetValue(null); } } instance.Save(); }
/// <summary> /// Get Attribute Instance /// </summary> /// <param name="M_AttributeSetInstance_ID">attribute set instance</param> /// <returns>Attribute Instance or null</returns> public MAttributeInstance GetMAttributeInstance(int M_AttributeSetInstance_ID) { MAttributeInstance retValue = null; String sql = "SELECT * " + "FROM M_AttributeInstance " + "WHERE M_Attribute_ID=" + GetM_Attribute_ID() + " AND M_AttributeSetInstance_ID=" + M_AttributeSetInstance_ID; DataSet ds = null; try { ds = DataBase.DB.ExecuteDataset(sql, null, Get_TrxName()); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr = ds.Tables[0].Rows[i]; retValue = new MAttributeInstance(GetCtx(), dr, Get_TrxName()); } ds = null; } catch (Exception ex) { log.Log(Level.SEVERE, sql, ex); } ds = null; return(retValue); }
/// <summary> /// Set Attribute Instance /// </summary> /// <param name="M_AttributeSetInstance_ID">number value</param> /// <param name="value">id</param> public void SetMAttributeInstance(int M_AttributeSetInstance_ID, Decimal?value) { MAttributeInstance instance = GetMAttributeInstance(M_AttributeSetInstance_ID); if (instance == null) { instance = new MAttributeInstance(GetCtx(), GetM_Attribute_ID(), M_AttributeSetInstance_ID, value, Get_TrxName()); } else { instance.SetValueNumber(value); } instance.Save(); }
/** * Set Description. * - Product Values * - Instance Values * - SerNo = #123 * - Lot = \u00ab123\u00bb * - GuaranteeDate = 10/25/2003 */ public void SetDescription() { // Make sure we have a Attribute Set GetMAttributeSet(); if (_mas == null) { SetDescription(""); return; } StringBuilder sb = new StringBuilder(); // Instance Attribute Values MAttribute[] attributes = _mas.GetMAttributes(true); for (int i = 0; i < attributes.Length; i++) { MAttributeInstance mai = attributes[i].GetMAttributeInstance(GetM_AttributeSetInstance_ID()); if (mai != null && mai.GetValue() != null) { if (sb.Length > 0) { sb.Append("_"); } sb.Append(mai.GetValue()); } } // SerNo if (_mas.IsSerNo() && GetSerNo() != null) { if (sb.Length > 0) { sb.Append("_"); } sb.Append(_mas.GetSerNoCharStart()).Append(GetSerNo()).Append(_mas.GetSerNoCharEnd()); } // Lot if (_mas.IsLot() && GetLot() != null) { if (sb.Length > 0) { sb.Append("_"); } sb.Append(_mas.GetLotCharStart()).Append(GetLot()).Append(_mas.GetLotCharEnd()); } // GuaranteeDate if (_mas.IsGuaranteeDate() && GetGuaranteeDate() != null) { if (sb.Length > 0) { sb.Append("_"); } sb.Append(_dateFormat.Format(GetGuaranteeDate())); //MessageBox.Show("set date time formate cheak line"); //sb.Append(GetGuaranteeDate()); } // Product Attribute Values attributes = _mas.GetMAttributes(false); for (int i = 0; i < attributes.Length; i++) { MAttributeInstance mai = attributes[i].GetMAttributeInstance(GetM_AttributeSetInstance_ID()); if (mai != null && mai.GetValue() != null) { if (sb.Length > 0) { sb.Append("_"); } sb.Append(mai.GetValue()); } } SetDescription(sb.ToString()); }