[HttpGet]//查询资产类别的信息
public List <List <string> > Get_Type(string type)
{
//从数据库获取类别信息并返回 获取到的元属性名称
List <string> zy_name = new List <string>();
List <string> kz_name = new List <string>();
List <string> key = new List <string>();
key.Add("ID");
Class_template old = new Class_template(type);
for (int i = 0; i < old.ZC_SX.Count; i++)
{
M_Db_Operate m_Db_Operate = new M_Db_Operate();
var collection = m_Db_Operate.database.GetCollection <YSX_Model>("Meta_attribute");
List <string> value = new List <string>();
value.Add(old.ZC_SX[i]);
var resu = m_Db_Operate.Inquire_Data(collection, key, value);
if (resu[0].Dimension_dic["资产类别维度"].Contains("专用集"))
{
zy_name.Add(resu[0].Name);
}
else if (resu[0].Dimension_dic["资产类别维度"].Contains("扩展集"))
{
kz_name.Add(resu[0].Name);
}
}
List <List <string> > data = new List <List <string> >();
data.Add(zy_name);
data.Add(kz_name);
return(data);
}
//资产类类别添加完成
public IActionResult addTYPE_OK(IFormCollection f)
{
var type_name = f["type_name"].ToString();
var F_name = f["F_name"].ToString();
try
{
Class_template old = new Class_template(F_name);
old.TPYE = type_name;
old.F_id = F_name;
M_Db_Operate m_Db_Operate = new M_Db_Operate();
var collection = m_Db_Operate.database.GetCollection <Class_template>("Class_templates");
m_Db_Operate.Insert_Data(collection, old);
return(View("../Home/add_OK"));
}
catch (InvalidCastException e)
{
ViewData["e"] = e.ToString();
return(View("../Home/add_ERROR"));
}
}
//资产类别修改完成
public IActionResult addZCTYPE_OK(IFormCollection f)
{
try
{
string Kindda, One_Class, type;
Kindda = f["Kindda"];
One_Class = f["One_Class"];
if (One_Class == "不选择--")
{
type = Kindda;
}
else if (One_Class == "-- 大类 -- ")
{
type = null;
}
else if (Kindda == "-- 门类 -- ")
{
type = null;
}
else
{
type = One_Class;
}
if (type == null)
{
ViewData["e"] = "类别错误";
return(View("../Home/add_ERROR"));
}
Class_template zc_type = new Class_template();
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");
int i = 1;
while (true)
{
var name = f["kz_key_" + i.ToString()];
if (name.ToString() == "")
{
break;
}
else
{
List <string> value = new List <string>();
value.Add(name);
var Result = m_Db_Operate.Inquire_Data(collection, key, value);
zc_type.ZC_SX.Add(Result[0].ID.ToString());
i++;
}
}
Class_template old = new Class_template();
old = new Class_template(type);
for (var j = 0; j < old.ZC_SX.Count; j++)
{
zc_type.ZC_SX.Add(old.ZC_SX[j]);
}
i = 1;
while (true)
{
var name = f["sc_key_" + i.ToString()];
if (name.ToString() == "")
{
break;
}
else
{
List <string> value = new List <string>();
value.Add(name);
var Result = m_Db_Operate.Inquire_Data(collection, key, value);
zc_type.ZC_SX.Remove(Result[0].ID.ToString());
while (zc_type.ZC_SX.Equals(Result[0].ID.ToString()))
{
zc_type.ZC_SX.Remove(Result[0].ID.ToString());
}
}
i++;
}
M_Db_Operate m_Db_Ct = new M_Db_Operate();
var coll = m_Db_Ct.database.GetCollection <Class_template>("Class_templates");
m_Db_Ct.Up_Data(coll, "TPYE", type, "ZC_SX", zc_type.ZC_SX);
return(View("../Home/add_OK"));
}
catch (InvalidCastException e)
{
ViewData["e"] = e.ToString();
return(View("../Home/add_ERROR"));
}
}
//按照管理者维度查找
//public IActionResult query_zc_3(IFormCollection f)
//{
// string guanlizhe = f["glz"];
// try
// {
// M_Db_Operate m_Db_Operate = new M_Db_Operate();
// var collection1 = m_Db_Operate.database.GetCollection<Dimension_Information_Model>("Dimension_Information");
// List<string> key1 = new List<string>();
// key1.Add("TYPE");
// List<string> value1 = new List<string>();
// value1.Add("管理者维度");
// var Result1 = m_Db_Operate.Inquire_Data(collection1, key1, value1);
// List<string> name = new List<string>();
// for (var i = 0; i < Result1.Count; i++)
// {
// name.Add(Result1[i].NAME);
// }
// ViewData["glz_list"] = name;
// //在这里查询数据库并整合数据
// var collection = m_Db_Operate.database.GetCollection<YSX_Model>("Meta_attribute");
// List<string> key = new List<string>();
// key.Add("Dimension_dic.管理者维度");
// List<string> value = new List<string>();
// value.Add(guanlizhe);
// var Result = m_Db_Operate.Inquire_Data(collection, key, value);
// List<string> results = new List<string>();
// for (var i = 0; i < Result.Count; i++)
// {
// results.Add(Result[i].Name);
// }
// List<string> value2 = new List<string>();
// value2.Add("默认管理者");
// Result = m_Db_Operate.Inquire_Data(collection, key, value2);
// for (var i = 0; i < Result.Count; i++)
// {
// results.Add(Result[i].Name);
// }
// var collection2 = m_Db_Operate.database.GetCollection<SJ_ZC_Model>("ZC_data");
// FilterDefinitionBuilder<SJ_ZC_Model> builderFilter = Builders<SJ_ZC_Model>.Filter;
// var result = collection2.FindSync<SJ_ZC_Model>(builderFilter.Empty).ToList();
// List<List<string>> ZC_datas = new List<List<string>>();
// for (var i = 0; i < result.Count; i++)
// {
// List<string> ZC_data = new List<string>();
// ZC_data.Add(sx_name[0] + ":" +result[i].SJZCFLBM.V.ToString());
// ZC_data.Add(sx_name[1] + ":" +result[i].SJZCFLMC.V.ToString());
// ZC_data.Add(sx_name[2] + ":" +result[i].ZCBM.V.ToString());
// ZC_data.Add(sx_name[3] + ":" +result[i].ZCMC.V.ToString());
// ZC_data.Add(sx_name[4] + ":" +result[i].YWMC.V.ToString());
// ZC_data.Add(sx_name[5] + ":" +result[i].SL.V.ToString());
// ZC_data.Add(sx_name[6] + ":" +result[i].JLDW.V.ToString());
// ZC_data.Add(sx_name[7] + ":" +result[i].ZMJZ.V.ToString());
// ZC_data.Add(sx_name[8] + ":" +result[i].JZLX.V.ToString());
// ZC_data.Add(sx_name[9] + ":" +result[i].BiZ.V.ToString());
// ZC_data.Add(sx_name[10] + ":" +result[i].GB.V.ToString());
// ZC_data.Add(sx_name[11] + ":" +result[i].QDRQ.V.ToString());
// ZC_data.Add(sx_name[12] + ":" +result[i].KSKYRQ.V.ToString());
// ZC_data.Add(sx_name[13] + ":" +result[i].YT.V.ToString());
// ZC_data.Add(sx_name[14] + ":" +result[i].SYZK.V.ToString());
// ZC_data.Add(sx_name[15] + ":" +result[i].SYFX.V.ToString());
// ZC_data.Add(sx_name[16] + ":" +result[i].QDFS.V.ToString());
// ZC_data.Add(sx_name[17] + ":" +result[i].KJPZH.V.ToString());
// ZC_data.Add(sx_name[18] + ":" +result[i].SYBM.V.ToString());
// ZC_data.Add(sx_name[19] + ":" +result[i].SYR.V.ToString());
// ZC_data.Add(sx_name[20] + ":" +result[i].BZ.V.ToString());
// string kz_sx = "";
// M_Db_Operate m_Db_ = new M_Db_Operate();
// var coll = m_Db_.database.GetCollection<YSX_Model>("Meta_attribute");
// List<string> key2 = new List<string>();
// key2.Add("ID");
// for (var j = 0; j < result[i].ZY_SX.Count; j++)
// {
// List<string> value3 = new List<string>();
// value3.Add(result[i].ZY_SX[j].mp.ToString());
// var su = m_Db_.Inquire_Data(coll, key2, value3);
// kz_sx += su[0].Name.ToString() + " : " + result[i].ZY_SX[j].V.ToString() + " ";
// }
// for (var j = 0; j < result[i].KJ_SX.Count; j++)
// {
// List<string> value3 = new List<string>();
// value3.Add(result[i].KJ_SX[j].mp.ToString());
// var su = m_Db_.Inquire_Data(coll, key2, value3);
// kz_sx += su[0].Name.ToString() + " : " + result[i].KJ_SX[j].V.ToString() + " ";
// }
// ZC_data.Add(kz_sx);
// ZC_datas.Add(ZC_data);
// }
// ViewData["ZC_datas"] = ZC_datas;
// ViewData["sx_name"] = sx_name;
// }
// catch (InvalidCastException e)
// {
// ViewData["e"] = e.ToString();
// return View("query_ERROR");
// }
// ViewData["glz"] = guanlizhe;
// ViewData["zc_name"] = null;
// ViewData["ysx_name"] = null;
// ViewData["ysx_value"] = null;
// return View("query_zc");
//}
//添加资产完成动作
public IActionResult addZC_OK(IFormCollection f)
{
string Kindda, One_Class;
Kindda = f["Kindda"];
One_Class = f["One_Class"];
//Two_Class = f["Two_Class"];
SJ_ZC_Model SJ_ZC = new SJ_ZC_Model();
for (int i = 1; i < ty_names.Count; i++)
{
SJ_SX_Model sJ_SX_ = new SJ_SX_Model();
sJ_SX_.V = f[ty_names[i - 1]];
if (i > 9)
{
sJ_SX_.mp = "00" + i.ToString();
}
else
{
sJ_SX_.mp = "000" + i.ToString();
}
SJ_ZC.ZC_SX.Add(sJ_SX_);
}
SJ_ZC.ZCBM = f["资产编码"];
Class_template old = new Class_template();
if (One_Class == "不选择--")
{
old = new Class_template(Kindda);
}
else
{
old = new Class_template(One_Class);
}
List <string> key = new List <string>();
key.Add("ID");
M_Db_Operate m_Db_Operate = new M_Db_Operate();
var collection = m_Db_Operate.database.GetCollection <YSX_Model>("Meta_attribute");
for (var i = 1; i < old.ZC_SX.Count; i++)
{
SJ_SX_Model sj_sx = new SJ_SX_Model();
List <string> value = new List <string>();
value.Add(old.ZC_SX[i].ToString());
var resu = m_Db_Operate.Inquire_Data(collection, key, value);
sj_sx.V = f[resu[0].Name];
sj_sx.mp = resu[0].ID.ToString();
SJ_ZC.ZC_SX.Add(sj_sx);
if (resu[0].Name == "文物标识")
{
var re_ww = m_Db_Operate.Inquire_Data(collection, new List <string> {
"Dimension_dic.应用特性维度"
}, new List <string> {
"文物信息"
});
for (int j = 0; j < re_ww.Count; j++)
{
sj_sx = new SJ_SX_Model();
sj_sx.V = f[re_ww[j].Name];
sj_sx.mp = re_ww[j].ID.ToString();
SJ_ZC.ZC_SX.Add(sj_sx);
}
}
else if (resu[0].Name == "是否包含物联网传感")
{
var re_ww = m_Db_Operate.Inquire_Data(collection, new List <string> {
"Dimension_dic.应用特性维度"
}, new List <string> {
"物联网信息"
});
for (int j = 0; j < re_ww.Count; j++)
{
sj_sx = new SJ_SX_Model();
sj_sx.V = f[re_ww[j].Name];
sj_sx.mp = re_ww[j].ID.ToString();
SJ_ZC.ZC_SX.Add(sj_sx);
}
}
else if (resu[0].Name == "陈列品标识")
{
var re_ww = m_Db_Operate.Inquire_Data(collection, new List <string> {
"Dimension_dic.应用特性维度"
}, new List <string> {
"标本信息"
});
for (int j = 0; j < re_ww.Count; j++)
{
sj_sx = new SJ_SX_Model();
sj_sx.V = f[re_ww[j].Name];
sj_sx.mp = re_ww[j].ID.ToString();
SJ_ZC.ZC_SX.Add(sj_sx);
}
}
}
try
{
M_Db_Operate m_Db = new M_Db_Operate();
var coll = m_Db.database.GetCollection <SJ_ZC_Model>("ZC_data");
coll.InsertOne(SJ_ZC);
return(View("../Home/add_OK"));
}
catch (InvalidCastException e)
{
ViewData["e"] = e.ToString();
return(View("../Home/add_ERROR"));
};
}
