/// <summary> /// 传入 唯一索引 及 记录名 /// </summary> public static void del_rec(Int64 id, string table_name) { if (MessageBox.Show("确定删除本条记录?", "警告!", MessageBoxButton.YesNo, MessageBoxImage.Warning, MessageBoxResult.No) == MessageBoxResult.No) { return; } using (jhbEntities ctx = new jhbEntities()) { switch (table_name) { case "wt": var e1 = (from g in ctx.WTs where g.问题编号 == id select g).First(); ctx.WTs.Remove(e1); ctx.SaveChanges(); break; case "pf": var e2 = (from g in ctx.PFs where g.派发编号 == id select g).First(); //删除派发, 记录站名,派发日期,存在问题 转去删除以派发日期为条件的tzd里面的 存在问题. var enTzd = (from g in ctx.TZDs where g.派单日期.Value == e2.派发日期.Value && g.站名 == e2.站名 orderby g.流水号 descending select g).First(); string tmp_wtdetail = enTzd.记录.Replace("\n" + "^" + e2.设备名称 + ": " + e2.存在问题, ""); if (tmp_wtdetail.Replace("\n", string.Empty) == string.Empty || tmp_wtdetail == null) { ctx.TZDs.Remove(enTzd); } else { ctx.Entry(enTzd).Entity.记录 = tmp_wtdetail; } ctx.PFs.Remove(e2); ctx.SaveChanges(); break; case "tzd": var e3 = (from g in ctx.TZDs where g.流水号 == id select g).First(); //根据tzd里面的站名和派单日期. 删除派发的记录项目. var enPf = from g in ctx.PFs where g.站名 == e3.站名 && g.派发日期.Value == e3.派单日期.Value && g.受理单位 == e3.受理单位 select g; foreach (var item in enPf) { ctx.PFs.Remove(item); } ctx.TZDs.Remove(e3); ctx.SaveChanges(); break; } } }
private void Button_Click(object sender, RoutedEventArgs e) { if (x2.Text == null || x2.Text == string.Empty) { Valid_Ani va = new Valid_Ani(); Ani_x2.BeginAnimation(SolidColorBrush.ColorProperty, va.color_Ani); return; } if (x3.Text == null || x2.Text == string.Empty) { Valid_Ani vb = new Valid_Ani(); Ani_x3.BeginAnimation(SolidColorBrush.ColorProperty, vb.color_Ani); return; } if (x4.SelectedDate == null || x4.Text == string.Empty) { Valid_Ani vc = new Valid_Ani(); Ani_x4.BeginAnimation(SolidColorBrush.ColorProperty, vc.color_Ani); return; } using (jhbEntities ctx = new jhbEntities()) { var wt = (from g in ctx.WTs where g.站名 == _zn && g.问题编号 == _wtid select g).Single(); ctx.Entry(wt).Entity.销记时间 = x4.SelectedDate.Value.Date; ctx.Entry(wt).Entity.完成情况 = x1.Text; ctx.Entry(wt).Entity.整治情况 = x2.Text; ctx.Entry(wt).Entity.整治负责人 = x3.Text; ctx.Entry(wt).Entity.lastEdit = myFuc.getNowDateHashcode(); ctx.Entry(wt).Entity.销记 = true; ctx.Entry(wt).Entity.OpTrack = "X"; g_var.g_xj_flag = true; //窗口返回... g_var.g_chg_wt = ctx.Entry(wt).Entity; var pf = from g in ctx.PFs where g.站名 == _zn && g.问题编号 == _wtid select g; foreach (var pfitem in pf) { ctx.Entry(pfitem).Entity.ver1 = x4.SelectedDate.Value.Date.ToString("M月d日"); //销记时间 ctx.Entry(pfitem).Entity.ver2 = x1.Text; //完成情况 ctx.Entry(pfitem).Entity.ver3 = x2.Text; //整治情况 ctx.Entry(pfitem).Entity.var4 = x3.Text; //负责人 } ctx.SaveChanges(); } this.Close(); }
public static WT g_chg_wt = new WT(); // 改变的行记录. 用于刷新 public static void tableValid() { using (jhbEntities ctx = new jhbEntities()) { Bar.Total = ctx.WTs.Count(); foreach (var item in ctx.WTs) { DateTime dtLast = DateTime.FromBinary(item.lastEdit.Value); DateTime dtNow = DateTime.FromBinary(myFuc.getNowDateHashcode()); int days = myFuc.diffDays(dtLast, dtNow); if (Math.Abs(days) > 30) { item.OpTrack = "•••"; } else { item.OpTrack = days.ToString(); } } ctx.SaveChanges(); } }