/// <summary> /// Get Attribute Instance /// </summary> /// <param name="M_AttributeSetInstance_ID">attribute set instance</param> /// <returns>Attribute Instance or null</returns> public MGenAttributeInstance GetCGenAttributeInstance(int C_GenAttributeSetInstance_ID) { MGenAttributeInstance retValue = null; String sql = "SELECT * " + "FROM C_GenAttributeInstance " + "WHERE C_GenAttribute_ID=" + GetC_GenAttribute_ID() + " AND C_GenAttributeSetInstance_ID=" + C_GenAttributeSetInstance_ID; DataSet ds = null; try { ds = 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 MGenAttributeInstance(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">value</param> /// <param name="value">id</param> public void SetCGenAttributeInstance(int M_AttributeSetInstance_ID, MGenAttributeValue value) { MGenAttributeInstance instance = GetCGenAttributeInstance(M_AttributeSetInstance_ID); if (instance == null) { if (value != null) { instance = new MGenAttributeInstance(GetCtx(), GetC_GenAttribute_ID(), M_AttributeSetInstance_ID, value.GetC_GenAttributeValue_ID(), value.GetName(), Get_TrxName()); // Cached !! } else { instance = new MGenAttributeInstance(GetCtx(), GetC_GenAttribute_ID(), M_AttributeSetInstance_ID, 0, null, Get_TrxName()); } } else { if (value != null) { instance.SetC_GenAttributeValue_ID(value.GetC_GenAttributeValue_ID()); instance.SetValue(value.GetName()); // Cached !! } else { instance.SetC_GenAttributeValue_ID(0); instance.SetValue(null); } } instance.Save(); }
/// <summary> /// Set Attribute Instance /// </summary> /// <param name="M_AttributeSetInstance_ID">id</param> /// <param name="value">string value</param> public void SetCGenAttributeInstance(int C_GenAttributeSetInstance_ID, String value) { MGenAttributeInstance instance = GetCGenAttributeInstance(C_GenAttributeSetInstance_ID); if (instance == null) { instance = new MGenAttributeInstance(GetCtx(), GetC_GenAttribute_ID(), C_GenAttributeSetInstance_ID, value, Get_TrxName()); } else { instance.SetValue(value); } instance.Save(); }
/// <summary> /// Set Attribute Instance /// </summary> /// <param name="M_AttributeSetInstance_ID">number value</param> /// <param name="value">id</param> public void SetCGenAttributeInstance(int M_AttributeSetInstance_ID, Decimal?value) { MGenAttributeInstance instance = GetCGenAttributeInstance(M_AttributeSetInstance_ID); if (instance == null) { instance = new MGenAttributeInstance(GetCtx(), GetC_GenAttribute_ID(), M_AttributeSetInstance_ID, value, Get_TrxName()); } else { instance.SetValueNumber(value); } instance.Save(); }
public void SetDescription() { // Make sure we have a Attribute Set GetCGenAttributeSet(); if (_mas == null) { SetDescription(""); return; } StringBuilder sb = new StringBuilder(); // Instance Attribute Values MGenAttribute[] attributes = _mas.GetCGenAttributes(true); for (int i = 0; i < attributes.Length; i++) { MGenAttributeInstance mai = attributes[i].GetCGenAttributeInstance(GetC_GenAttributeSetInstance_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.GetCGenAttributes(false); for (int i = 0; i < attributes.Length; i++) { MGenAttributeInstance mai = attributes[i].GetCGenAttributeInstance(GetC_GenAttributeSetInstance_ID()); if (attributes[i].GetAttributeValueType().Equals("N")) { if (mai != null && mai.GetValueNumber() != 0) { if (sb.Length > 0) { sb.Append("_"); } sb.Append(mai.GetValueNumber()); } } else { if (mai != null && mai.GetValue() != null) { if (sb.Length > 0) { sb.Append("_"); } sb.Append(mai.GetValue()); } } } SetDescription(sb.ToString()); }