//TODO:添加一些资产
        public IActionResult add_zc_ten()
        {
            M_Db_Operate m_Db_Ct = new M_Db_Operate();
            var          coll    = m_Db_Ct.database.GetCollection <Class_template>("Class_templates");
            M_Db_Operate zc_db   = new M_Db_Operate();
            var          zc_coll = zc_db.database.GetCollection <SJ_ZC_Model>("ZC_data");
            int          number  = zc_db.Inquire_Data(zc_coll, type: 2).Count;
            var          types   = m_Db_Ct.Inquire_Data(coll, type: 2);

            foreach (var type in types)
            {
                List <SJ_ZC_Model> sj_zc_s = new List <SJ_ZC_Model>();
                var res = m_Db_Ct.Get_Aggregate("Class_templates",
                                                new List <string>()
                {
                    "TPYE"
                },
                                                new List <string>()
                {
                    type.TPYE
                },
                                                new List <string>()
                {
                    "Meta_attribute"
                },
                                                new List <string>()
                {
                    "ZC_SX"
                },
                                                new List <string>()
                {
                    "ID"
                },
                                                new List <string>()
                {
                    "ZC_SX"
                })[0];
                for (int i = 0; i < 27273; i++)
                {
                    number++;
                    SJ_ZC_Model sJ_ZC = new SJ_ZC_Model(res, type.TPYE, number);
                    sj_zc_s.Add(sJ_ZC);
                }
                zc_coll.InsertMany(sj_zc_s);
            }
            //总条目数
            return(query_zc());
        }
Exemple #2
0
        [HttpGet]//根据资产ID获取一个资产的全部信息
        public List <Dictionary <string, SJ_SX_Model> > Get_ZC_XX(string ID)
        {
            try
            {
                List <Dictionary <string, SJ_SX_Model> > resu   = new List <Dictionary <string, SJ_SX_Model> >();
                Dictionary <string, SJ_SX_Model>         TY_SX  = new Dictionary <string, SJ_SX_Model>();
                Dictionary <string, SJ_SX_Model>         ZY_SX  = new Dictionary <string, SJ_SX_Model>();
                Dictionary <string, SJ_SX_Model>         KZ_SX  = new Dictionary <string, SJ_SX_Model>();
                Dictionary <string, SJ_SX_Model>         GZ_WW  = new Dictionary <string, SJ_SX_Model>();
                Dictionary <string, SJ_SX_Model>         GZ_WLW = new Dictionary <string, SJ_SX_Model>();
                Dictionary <string, SJ_SX_Model>         GZ_BB  = new Dictionary <string, SJ_SX_Model>();
                M_Db_Operate m_Db_Operate = new M_Db_Operate();
                var          collection   = m_Db_Operate.database.GetCollection <SJ_ZC_Model>("ZC_data");

                var result = m_Db_Operate.Get_Aggregate(
                    "ZC_data",
                    new List <string>()
                {
                    "ZCBM"
                },
                    new List <string>()
                {
                    ID
                },
                    new List <string>()
                {
                    "Meta_attribute"
                },
                    new List <string>()
                {
                    "ZC_SX.mp"
                },
                    new List <string>()
                {
                    "ID"
                },
                    new List <string>()
                {
                    "ZC_SXN"
                }
                    )[0];
                int j = 0;
                while (true)
                {
                    try
                    {
                        SJ_SX_Model sJ_SX_ = new SJ_SX_Model();
                        sJ_SX_.mp = result["ZC_SXN"][j]["ID"].ToString();
                        int u = 0;
                        while (true)
                        {
                            try
                            {
                                if (result["ZC_SX"][u]["mp"].ToString() == result["ZC_SXN"][j]["ID"].ToString())
                                {
                                    sJ_SX_.V = result["ZC_SX"][u]["V"].ToString();
                                    break;
                                }
                                u++;
                            }
                            catch
                            {
                                break;
                            }
                        }
                        if (result["ZC_SXN"][j]["Dimension_dic"]["资产类别维度"].ToString().Contains("通用集"))
                        {
                            TY_SX.Add(result["ZC_SXN"][j]["Name"].ToString(), sJ_SX_);
                        }
                        else if (result["ZC_SXN"][j]["Dimension_dic"]["资产类别维度"].ToString().Contains("专用集"))
                        {
                            ZY_SX.Add(result["ZC_SXN"][j]["Name"].ToString(), sJ_SX_);
                        }
                        else if (result["ZC_SXN"][j]["Dimension_dic"]["资产类别维度"].ToString().Contains("扩展集"))
                        {
                            if (result["ZC_SXN"][j]["Dimension_dic"]["应用特性维度"] == "文物信息")
                            {
                                GZ_WW.Add(result["ZC_SXN"][j]["Name"].ToString(), sJ_SX_);
                            }
                            else if (result["ZC_SXN"][j]["Dimension_dic"]["应用特性维度"] == "物联网信息")
                            {
                                GZ_WLW.Add(result["ZC_SXN"][j]["Name"].ToString(), sJ_SX_);
                            }
                            else if (result["ZC_SXN"][j]["Dimension_dic"]["应用特性维度"] == "标本信息")
                            {
                                GZ_BB.Add(result["ZC_SXN"][j]["Name"].ToString(), sJ_SX_);
                            }
                            else
                            {
                                KZ_SX.Add(result["ZC_SXN"][j]["Name"].ToString(), sJ_SX_);
                            }
                        }
                        j++;
                    }
                    catch
                    {
                        break;
                    }
                }
                resu.Add(ZY_SX);
                resu.Add(KZ_SX);
                resu.Add(TY_SX);
                resu.Add(GZ_WW);
                resu.Add(GZ_WLW);
                resu.Add(GZ_BB);
                return(resu);
            }
            catch
            {
                return(null);
            }
        }
 //资产修改完成动作result[0].SJZCFLBM
 public IActionResult Updata_zc_OK(IFormCollection f)
 {
     try
     {
         string id;
         if (f["zc_id"] == "-- 资产编码 --")
         {
             id = f["int_zc_"];
         }
         else
         {
             id = f["zc_id"];
         }
         List <SJ_SX_Model> new_ZC_SX    = new List <SJ_SX_Model>();
         M_Db_Operate       m_Db_Operate = new M_Db_Operate();
         var coll   = m_Db_Operate.database.GetCollection <SJ_ZC_Model>("ZC_data");
         var result = m_Db_Operate.Get_Aggregate(
             "ZC_data",
             new List <string>()
         {
             "ZCBM"
         },
             new List <string>()
         {
             id
         },
             new List <string>()
         {
             "Meta_attribute"
         },
             new List <string>()
         {
             "ZC_SX.mp"
         },
             new List <string>()
         {
             "ID"
         },
             new List <string>()
         {
             "ZC_SXN"
         }
             )[0];
         M_Db_Operate       m_Db       = new M_Db_Operate();
         var                collection = m_Db.database.GetCollection <YSX_Model>("Meta_attribute");
         int                j          = 0;
         int[]              flag       = { 1, 1, 1 };
         List <SJ_SX_Model> del_sx     = new List <SJ_SX_Model>();
         while (true)
         {
             try
             {
                 SJ_SX_Model sx = new SJ_SX_Model();
                 sx.V = f[result["ZC_SXN"][j]["ID"].ToString()];
                 int u = 0;
                 while (true)
                 {
                     try
                     {
                         if (result["ZC_SX"][u]["mp"].ToString() == result["ZC_SXN"][j]["ID"].ToString())
                         {
                             sx.mp = result["ZC_SX"][u]["mp"].ToString();
                             break;
                         }
                         u++;
                     }
                     catch
                     {
                         break;
                     }
                 }
                 //sx.mp = result["ZC_SX"][j]["mp"].ToString();
                 new_ZC_SX.Add(sx);
                 if (result["ZC_SXN"][j]["Name"].ToString() == "文物标识")
                 {
                     if (sx.V == "1")
                     {
                         var ww_resu = m_Db.Inquire_Data(collection, new List <string>()
                         {
                             "Dimension_dic.应用特性维度"
                         }, new List <string>()
                         {
                             "文物信息"
                         });
                         foreach (var ysx in ww_resu)
                         {
                             SJ_SX_Model ww_sx = new SJ_SX_Model();
                             ww_sx.V  = f[ysx.ID];
                             ww_sx.mp = ysx.ID;
                             new_ZC_SX.Add(ww_sx);
                         }
                     }
                     if (sx.V == "0")
                     {
                         var ww_resu = m_Db.Inquire_Data(collection, new List <string>()
                         {
                             "Dimension_dic.应用特性维度"
                         }, new List <string>()
                         {
                             "文物信息"
                         });
                         foreach (var ysx in ww_resu)
                         {
                             SJ_SX_Model ww_sx = new SJ_SX_Model();
                             ww_sx.V  = f[ysx.ID];
                             ww_sx.mp = ysx.ID;
                             del_sx.Add(ww_sx);
                         }
                     }
                 }
                 else if (result["ZC_SXN"][j]["Name"].ToString() == "是否包含物联网传感")
                 {
                     if (sx.V == "1")
                     {
                         var wlw_resu = m_Db.Inquire_Data(collection, new List <string>()
                         {
                             "Dimension_dic.应用特性维度"
                         }, new List <string>()
                         {
                             "物联网信息"
                         });
                         foreach (var ysx in wlw_resu)
                         {
                             SJ_SX_Model wlw_sx = new SJ_SX_Model();
                             wlw_sx.V  = f[ysx.ID];
                             wlw_sx.mp = ysx.ID;
                             new_ZC_SX.Add(wlw_sx);
                         }
                     }
                     if (sx.V == "0")
                     {
                         var wlw_resu = m_Db.Inquire_Data(collection, new List <string>()
                         {
                             "Dimension_dic.应用特性维度"
                         }, new List <string>()
                         {
                             "物联网信息"
                         });
                         foreach (var ysx in wlw_resu)
                         {
                             SJ_SX_Model wlw_sx = new SJ_SX_Model();
                             wlw_sx.V  = f[ysx.ID];
                             wlw_sx.mp = ysx.ID;
                             del_sx.Add(wlw_sx);
                         }
                     }
                 }
                 else if (result["ZC_SXN"][j]["Name"].ToString() == "陈列品标识")
                 {
                     if (sx.V == "1")
                     {
                         var bb_resu = m_Db.Inquire_Data(collection, new List <string>()
                         {
                             "Dimension_dic.应用特性维度"
                         }, new List <string>()
                         {
                             "标本信息"
                         });
                         foreach (var ysx in bb_resu)
                         {
                             SJ_SX_Model bb_sx = new SJ_SX_Model();
                             bb_sx.V  = f[ysx.ID];
                             bb_sx.mp = ysx.ID;
                             new_ZC_SX.Add(bb_sx);
                         }
                     }
                     if (sx.V == "0")
                     {
                         var bb_resu = m_Db.Inquire_Data(collection, new List <string>()
                         {
                             "Dimension_dic.应用特性维度"
                         }, new List <string>()
                         {
                             "标本信息"
                         });
                         foreach (var ysx in bb_resu)
                         {
                             SJ_SX_Model bb_sx = new SJ_SX_Model();
                             bb_sx.V  = f[ysx.ID];
                             bb_sx.mp = ysx.ID;
                             del_sx.Add(bb_sx);
                         }
                     }
                 }
                 j++;
             }
             catch
             {
                 foreach (var del in del_sx)
                 {
                     new_ZC_SX.Remove(del);
                     for (int i = 0; i < new_ZC_SX.Count; i++)
                     {
                         if (new_ZC_SX[i].mp == del.mp)
                         {
                             new_ZC_SX.RemoveAt(i);
                             break;
                         }
                     }
                 }
                 break;
             }
         }
         m_Db_Operate.Up_Data(coll, "ZCBM", f["0003"], "ZC_SX", new_ZC_SX);
         return(View("../Home/add_OK"));
     }
     catch (InvalidCastException e)
     {
         ViewData["e"] = e.ToString();
         return(View("../Home/add_ERROR"));
     };
 }
        //按照资产编码查找
        public IActionResult query_zc_2(IFormCollection f)
        {
            string zc_name = f["zc_name"];

            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           Result = m_Db_Operate.Inquire_Data(collection1, key1, value1);
                List <string> name   = new List <string>();
                for (var i = 0; i < Result.Count; i++)
                {
                    name.Add(Result[i].NAME);
                }
                ViewData["glz_list"] = name;
                //在这里查询数据库并整合数据

                var           collection = m_Db_Operate.database.GetCollection <SJ_ZC_Model>("ZC_data");
                List <string> key        = new List <string>();
                List <string> value      = new List <string>();
                key.Add("ZCBM");
                value.Add(zc_name.ToString());

                var result = m_Db_Operate.Get_Aggregate(
                    "ZC_data",
                    key,
                    value,
                    new List <string>()
                {
                    "Meta_attribute"
                },
                    new List <string>()
                {
                    "ZC_SX.mp"
                },
                    new List <string>()
                {
                    "ID"
                },
                    new List <string>()
                {
                    "ZC_SXN"
                }
                    );
                List <List <string> > ZC_datas = new List <List <string> >();
                for (var i = 0; i < result.Count; i++)
                {
                    List <string> ZC_data = new List <string>();
                    string        kz_sx   = "";
                    int           j       = 0;
                    while (true)
                    {
                        try
                        {
                            if (result[i]["ZC_SXN"][j]["Dimension_dic"]["资产类别维度"].ToString().Contains("通用集"))
                            {
                                string uu = result[i]["ZC_SXN"][j]["Name"].ToString() + ":";
                                int    k  = 0;
                                while (true)
                                {
                                    try
                                    {
                                        if (result[i]["ZC_SXN"][j]["ID"].ToString() == result[i]["ZC_SX"][k]["mp"].ToString())
                                        {
                                            uu += result[i]["ZC_SX"][k]["V"].ToString();
                                            break;
                                        }
                                        k++;
                                    }
                                    catch
                                    {
                                        ;
                                    }
                                }
                                ZC_data.Add(uu);
                            }
                            else
                            {
                                string uu = result[i]["ZC_SXN"][j]["Name"].ToString() + ":";
                                int    k  = 0;
                                while (true)
                                {
                                    try
                                    {
                                        if (result[i]["ZC_SXN"][j]["ID"].ToString() == result[i]["ZC_SX"][k]["mp"].ToString())
                                        {
                                            uu += result[i]["ZC_SX"][k]["V"].ToString();
                                            break;
                                        }
                                        k++;
                                    }
                                    catch
                                    {
                                        ;
                                    }
                                }
                                ZC_data.Add(uu);
                            }
                        }
                        catch
                        {
                            break;
                        }
                        j++;
                    }
                    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["wd_type"]   = null;
            ViewData["wd_xx"]     = null;
            ViewData["zc_name"]   = null;
            ViewData["ysx_name"]  = null;
            ViewData["ysx_value"] = null;

            return(View("query_zc"));
        }