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