/// <summary>
/// Attribute Listing Tree..
/// </summary>
/// <returns></returns>
public object createTreeAttributeName()
{
StringBuilder sql = new StringBuilder();
sql.Append(MRole.GetDefault(_ctx).AddAccessSQL("SELECT M_Attribute_id , Name FROM M_Attribute WHERE IsActive='Y'", "M_Attribute", true, true));
sql.Append("~");
sql.Append(MRole.GetDefault(_ctx).AddAccessSQL("SELECT ma.M_Attribute_id,mv.m_attributevalue_id, ma.Name as NameAttribute,mv.Name FROM M_Attribute ma inner JOIN m_attributevalue mv ON ma.M_Attribute_id=mv.M_Attribute_id", "M_Attribute", true, true));
SqlParamsIn sqlpar = new SqlParamsIn();
sqlpar.sql = sql.ToString();
sqlpar.pageSize = 0;
VIS.Helpers.SqlHelper sHelper = new VIS.Helpers.SqlHelper();
DataSet ds = sHelper.ExecuteDataSet(sqlpar);
if (ds == null || ds.Tables.Count < 1)
{
return(null);
}
VA005_TreeStructure tree = new VA005_TreeStructure();
tree.text = Msg.GetMsg(_ctx, "VA005_AttributeTree");
tree.NodeID = 0;
tree.items = new List <VA005_TreeStructure>();
LoadAttributeName(ds, tree);
List <VA005_TreeStructure> final = new List <VA005_TreeStructure>();
final.Add(tree);
return(final);
}
/// <summary>
/// USed to Create Tree. This is main function which intialize tree creation.
/// </summary>
public object CreateTree(string Expend)
{
exp = Expend;
StringBuilder sql = new StringBuilder();
sql.Append(MRole.GetDefault(_ctx).AddAccessSQL("SELECT m_attributeSet_ID , Name FROM m_attributeSet WHERE IsActive='Y' ORDER BY LOWER(Name),m_attributeSet_ID", "M_AttributeSet", true, true));
sql.Append("~");
sql.Append(MRole.GetDefault(_ctx).AddAccessSQL(@"SELECT m_attribute.m_attribute_ID,m_attribute.Name,m_attributeuse.m_attributeset_id,m_attribute.ATTRIBUTEVALUETYPE
FROM m_attributeuse
JOIN m_attribute
ON m_attributeuse.m_attribute_ID=m_attribute.m_attribute_ID WHERE m_attributeuse.IsActive='Y' AND m_attributeuse.IsActive='Y' ORDER BY m_attribute.Name,m_attribute.m_attribute_ID", "M_AttributeUse", true, true));
sql.Append("~");
sql.Append(MRole.GetDefault(_ctx).AddAccessSQL("SELECT m_attribute_ID , name, M_AttributeValue_ID FROM M_AttributeValue WHERE IsActive='Y' ORDER BY name,m_attribute_ID ", "M_AttributeValue", true, true));
sql.Append("~");
SqlParamsIn sqlpar = new SqlParamsIn();
sqlpar.sql = sql.ToString();
sqlpar.pageSize = 0;
VIS.Helpers.SqlHelper sHelper = new VIS.Helpers.SqlHelper();
DataSet ds = sHelper.ExecuteDataSet(sqlpar);
if (ds == null || ds.Tables.Count < 1)
{
return(null);
}
VA005_TreeStructure tree = new VA005_TreeStructure();
tree.text = Msg.GetMsg(_ctx, "VA005_AttributeSetListing");
tree.NodeID = 0;
//tree.ParentID = 0;
tree.expanded = true;
tree.visibility = "none";
tree.ShowInfo = "none";
tree.padding = "8px 10px 8px 10px";
tree.margin = "0 0 0 0";
//tree.ImageSource = "Areas/VA005/Images/1.png";
tree.items = new List <VA005_TreeStructure>();
LoadAttributeSet(ds, tree);
//hidden
List <VA005_TreeStructure> final = new List <VA005_TreeStructure>();
final.Add(tree);
return(final);
}
