Example #1
0
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            DAL.T_FGJHtmlDataDal Dti = new DAL.T_FGJHtmlDataDal();

            var Alltfg = Dti.LoadEntities(x => x.delflag != 1 || x.delflag == null).DefaultIfEmpty();
            var c      = Alltfg.Count();
            var t      = Alltfg.GroupBy(x => new { x.photo, x.FwMianji }).Where(g => g.Count() > 1);
            var tc     = t.Count();

            var ttc = t.Count();
            int i   = 0;

            foreach (var a in t)
            {
                var temp1 = Dti.LoadEntities(x => x.photo == a.Key.photo).FirstOrDefault();
                if (temp1 != null)
                {
                    var      del1 = Dti.LoadEntities(x => x.photo == a.Key.photo).DefaultIfEmpty();
                    DateTime dt   = del1.Max(x => x.FbTime);
                    foreach (var d in del1)
                    {
                        if (d.FbTime != dt)
                        {
                            d.delflag = 1;
                            Dti.EditEntity(d);
                        }
                    }
                }
                i++;
            }
            Dti.SaveChanges();
        }
Example #2
0
        private void SaveDataHTML(oaEntities ctx, List <newWORD.Class1> L_Class_, int p)
        {
            DAL.T_FGJHtmlDataDal Dti = new DAL.T_FGJHtmlDataDal();
            foreach (var da in L_Class_)
            {
                T_FGJHtmlData tf = new T_FGJHtmlData();

                tf.HLName     = da.TextName;
                tf.HLhref     = da.href;
                tf.PersonName = da.PersonName;
                tf.Address    = da.Address;
                tf.photo      = da.photo;
                tf.FbTime     = da.FbTime;
                tf.FbTime     = tf.FbTime > DateTime.Now ? new DateTime(2017, tf.FbTime.Month, tf.FbTime.Day, tf.FbTime.Hour, tf.FbTime.Minute, tf.FbTime.Second):tf.FbTime;
                if (da.FwSumMoney == null)
                {
                    continue;
                }
                else
                {
                    if (da.FwSumMoney.Trim().Length <= 0)
                    {
                        continue;
                    }
                }
                tf.FwSumMoney  = da.FwSumMoney;
                tf.FwHuXing    = da.FwHuXing;
                tf.FwMianji    = da.FwMianji;
                tf.FwLoucheng  = da.FwLoucheng;
                tf.FwZhuangxiu = da.FwZhuangxiu;
                tf.FwNianxian  = da.FwNianxian;
                tf.FwChaoxiang = da.FwChaoxiang;
                tf.bak         = da.bak;
                tf.Id_count    = int.Parse(da.Id_count == null ? "0" : da.Id_count);
                tf.Laiyuan     = da.Laiyuan;
                tf.Image_str   = da.Image_str;
                tf.CityID      = p;
                if (da.FwMianji != null)
                {
                    tf.MianjiID   = GeiMinji(da.FwMianji);
                    tf.Pingmi_int = GetPingmi_int(da.FwMianji);
                }
                if (da.FwSumMoney != null)
                {
                    tf.SumMoneyID = GetMoney(da.FwSumMoney);
                    tf.Money_int  = GetMoney_int(da.FwSumMoney);
                }
                if (da.FwHuXing != null)
                {
                    tf.HuXingID = GetHuxing(da.FwHuXing);
                }

                //如果数据库中出现该名称并且 时间在当前时间那么  该信息不写入数据库
                //如果有该数据那么修改数据库中的数据信息



                var isnull = Dti.LoadEntities(x => x.FwMianji == tf.FwMianji && x.photo == tf.photo).DefaultIfEmpty();

                if (isnull.ToList()[0] != null)
                {
                    var tm  = isnull.Max(x => x.FbTime);
                    var vtm = isnull.Where(x => x.FbTime == tm).First();
                    vtm.FbTime     = tf.FbTime;
                    vtm.Money_int  = tf.Money_int;
                    vtm.FwSumMoney = tf.FwSumMoney;
                    vtm.SumMoneyID = tf.SumMoneyID;
                    Dti.EditEntity(vtm);
                }
                else
                {
                    Dti.AddEntity(tf);
                }
            }
            Dti.SaveChanges();
        }