//添加元属性页面
public IActionResult add_ysx()
{
var p = new YSX_Model("1");
ViewData["YSX_Model"] = p;
//维度信息查询
M_Db_Operate m_Db_Operate = new M_Db_Operate();
var collection = m_Db_Operate.database.GetCollection <Dimension_Information_Model>("Dimension_Information");
//查询维度
List <string> key = new List <string>();
key.Add("TYPE");
List <string> value = new List <string>();
value.Add("资产类别维度");
var type0 = m_Db_Operate.Inquire_Data(collection, key, value);
value[0] = "应用特性维度";
var type1 = m_Db_Operate.Inquire_Data(collection, key, value);
value[0] = "管理者维度";
var type2 = m_Db_Operate.Inquire_Data(collection, key, value);
value[0] = "自定义维度";
var type3 = m_Db_Operate.Inquire_Data(collection, key, value);
ViewData["type0"] = type0;
ViewData["type1"] = type1;
ViewData["type2"] = type2;
ViewData["type3"] = type3;
return(View());
}
//元属性修改完成动作
public IActionResult Up_Ysx_OK(IFormCollection f)
{
try
{
var p = new YSX_Model();
p.ID = f["ID"];
p.Name = f["One_Class"];
p.Length = f["Length"];
p.Unit = f["Unit"];
p.Remarks = f["Remarks"];
p.Edition = f["Edition"];
p.Data_Type = f["Data_Type"];
M_Db_Operate m_Db_Operate = new M_Db_Operate();
var coll = m_Db_Operate.database.GetCollection <YSX_Model>("Meta_attribute");
//m_Db_Operate.Up_Data(coll, "ID", p.ID, "ID", p.ID);
m_Db_Operate.Up_Data(coll, "ID", p.ID, "Length", p.Length);
m_Db_Operate.Up_Data(coll, "ID", p.ID, "Remarks", p.Remarks);
m_Db_Operate.Up_Data(coll, "ID", p.ID, "Unit", p.Unit);
m_Db_Operate.Up_Data(coll, "ID", p.ID, "Data_Type", p.Data_Type);
m_Db_Operate.Up_Data(coll, "ID", p.ID, "Edition", p.Edition);
//m_Db_Operate.Up_Data(coll, "ID", p.ID, "Dimension_dic", p.Dimension_dic);
}
catch
{
return(View("../Home/add_ERROR"));
}
return(View("../Home/add_OK"));
}
//元属性查询方式2：元属性名称查询
public IActionResult query_ysx_2(IFormCollection f)
{
string ysx_2 = f["ysx_name"];
var p = new YSX_Model();
try
{
//这里用来查询数据库，整合数据
M_Db_Operate m_Db_Operate = new M_Db_Operate();
var collection = m_Db_Operate.database.GetCollection <YSX_Model>("Meta_attribute");
List <string> key = new List <string>();
key.Add("Name");
List <string> value = new List <string>();
value.Add(ysx_2);
var Result = m_Db_Operate.Inquire_Data(collection, key, value);
string[] wd_name = new string[4];
wd_name[0] = "应用特性维度";
wd_name[1] = "管理者维度";
wd_name[2] = "扩展资产类别维度";
wd_name[3] = "自定义维度";
for (var i = 0; i < Result.Count; i++)
{
for (var j = 0; j < wd_name.Length; j++)
{
try
{
var a = Result[i].Dimension_dic[wd_name[j]];
}
catch
{
Result[i].Dimension_dic.Add(wd_name[j], "null");
};
}
}
ViewData["ysx_name"] = ysx_2;
ViewData["wd_name"] = null;
ViewData["f_l"] = null;
ViewData["wd_list"] = wd_name.ToList <string>();
ViewData["YSX_DATA"] = Result;
}
catch (InvalidCastException e)
{
ViewData["e"] = e.ToString();
return(View("query_ERROR"));
}
ViewData["YSX_Model"] = p;
return(View("query_ysx"));
}
//添加元属性完成动作
public IActionResult addYSX_OK(IFormCollection f)
{
var p = new YSX_Model();
p.ID = f["ID"];
p.Length = f["Length"];
p.Name = f["Name"];
p.Unit = f["Unit"];
p.Remarks = f["Remarks"];
p.Edition = f["Edition"];
p.Data_Type = f["Data_Type"];
List <string> keys = new List <string>();
List <string> value = new List <string>();
List <Dictionary <string, string> > WDs = new List <Dictionary <string, string> >();
int j = 0;
for (int i = 0; i < f.Count; i++)
{
if (f.Keys.ToArray()[i].Contains("ysx_wd_key_"))
{
keys.Add(f["ysx_wd_key_" + (j + 1).ToString()]);
value.Add(f["ysx_wd_value_" + (j + 1).ToString()]);
p.Dimension_dic[keys[j]] = value[j];
j++;
}
}
;
//在这里将数据插入数据库
try
{
M_Db_Operate m_Db_Operate = new M_Db_Operate();
var collection = m_Db_Operate.database.GetCollection <YSX_Model>("Meta_attribute");
m_Db_Operate.Insert_Data(collection, p);
return(View("../Home/add_OK"));
}
catch (InvalidCastException e)
{
ViewData["e"] = e.ToString();
return(View("../Home/add_ERROR"));
}
}
