private void InfoBind() { SpotSelectProblem SpotSelectProblem = db.SpotSelectProblem.FirstOrDefault(t => t.ID == ID); if (SpotSelectProblem != null) { this.txt_Problem.Text = SpotSelectProblem.Problem; this.txt_Order.Text = SpotSelectProblem.Order.ToString(); } }
protected void btn_Delete_Click(object sender, EventArgs e) { try { try { string ids = this.hf_CheckIDS.Value.ToString(); ids = ids.TrimEnd(',').TrimStart(','); foreach (string id in ids.Split(',')) { int iid = Convert.ToInt32(id); SpotSelectProblem SpotSelectProblem = db.SpotSelectProblem.FirstOrDefault(t => t.ID == iid); if (SpotSelectProblem == null) { ShowMessage("找不到选择的点检问题"); return; } SpotSelectProblem.IsDel = true; } db.SaveChanges(); new SysLogDAO().AddLog(LogType.操作日志_删除, "成功删除点检问题信息", UserID); } catch { ShowMessage("删除失败"); return; } } catch (Exception ex) { ShowMessage(ex.Message); new SysLogDAO().AddLog(LogType.系统日志, ex.Message, UserID); } DataListBind(); this.hf_CheckIDS.Value = ""; }
protected void btn_Sumbit_Click(object sender, EventArgs e) { try { using (TransactionScope ts = new TransactionScope()) { try { SpotSelectProblem SpotSelectProblem = db.SpotSelectProblem.FirstOrDefault(t => t.ID == ID); if (SpotSelectProblem == null) { SpotSelectProblem = new SpotSelectProblem(); SpotSelectProblem.Problem = txt_Problem.Text; if (string.IsNullOrEmpty(SpotSelectProblem.Problem)) { ShowMessage("请输入问题描述"); return; } if (db.SpotSelectProblem.FirstOrDefault(x => x.Problem == this.txt_Problem.Text.ToString()) != null) { ShowMessage("该问题已存在,请检查后重新添加"); return; } SpotSelectProblem.Order = Convert.ToInt32(txt_Order.Text); SpotSelectProblem.IsDel = false; db.SpotSelectProblem.Add(SpotSelectProblem); db.SaveChanges(); } else { SpotSelectProblem.Problem = txt_Problem.Text; if (string.IsNullOrEmpty(SpotSelectProblem.Problem)) { ShowMessage("请输入问题描述"); ts.Dispose(); return; } if (db.SpotSelectProblem.FirstOrDefault(x => x.Problem == this.txt_Problem.Text.ToString() && x.ID != SpotSelectProblem.ID) != null) { ShowMessage("该问题已存在,请检查后重新添加"); return; } SpotSelectProblem.Order = Convert.ToInt32(txt_Order.Text); db.SaveChanges(); } ShowMessage(); LogType log = (ID == -1 ? LogType.操作日志_添加 : LogType.操作日志_修改); new SysLogDAO().AddLog(log, (ID == -1 ? "增加" : "修改") + "点检问题信息"); ts.Complete(); } catch { ShowMessage("提交失败"); ts.Dispose(); } } } catch (Exception ex) { ShowMessage(ex.Message); new SysLogDAO().AddLog(LogType.系统日志, ex.Message, UserID); } }