protected void btnsearch_Click(object sender, EventArgs e) { DQDocEntities dQDocEntities = new DQDocEntities(); DateTime begindate, enddate; if (!DateTime.TryParse(btnbegindate.InnerText, out begindate)) { begindate = DateTime.Now.AddDays(-30); } else { begindate = begindate.AddDays(-1); } if (!DateTime.TryParse(btnenddate.InnerText, out enddate)) { enddate = DateTime.Now.AddDays(1); } else { enddate = enddate.AddDays(1); } Tasks.DataSource = dQDocEntities.OATasks.Where(o => o.CreateTime > begindate && o.CreateTime <= enddate).ToList(); Tasks.DataBind(); }
protected void btnsave1_Click(object sender, EventArgs e) { var taskname = txttaskname.Value; var taskremark = txttaskremark.Value; var taskcreator = txttaskcreator.Value; DQDocEntities dQDocEntities = new DQDocEntities(); dQDocEntities.OATasks.Add(new OATask { Id = Guid.NewGuid(), Status = "新建", PurchaseId = Guid.Parse(purchaseidhide.Value), TaskName = taskname, Remark = taskremark, CreateTime = DateTime.Now, Excutor = taskcreator }); dQDocEntities.SaveChanges(); Purchasers = dQDocEntities.Purchasers.ToList(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DQDocEntities dQDocEntities = new DQDocEntities(); Purchasers = dQDocEntities.Purchasers.ToList(); } var action = Request["action"]; switch (action) { default: break; } }
protected void btnsave1_Click(object sender, EventArgs e) { DQDocEntities dQDocEntities = new DQDocEntities(); Guid taskid = Guid.Parse(hidTaskid.Value); var task = dQDocEntities.OATasks.FirstOrDefault(o => o.Id == taskid); DateTime dt = DateTime.Now; if (DateTime.TryParse(hidstartdate.Value, out dt)) { task.StartTime = dt; if (dt < DateTime.Now) { task.Status = "已开始"; } } if (DateTime.TryParse(hidenddate.Value, out dt)) { task.EndTime = dt; if (dt < DateTime.Now) { task.Status = "已结束"; } } if (!string.IsNullOrEmpty(txttaskname.Value)) { task.TaskName = txttaskname.Value; } if (!string.IsNullOrEmpty(txttaskremark.Value)) { task.Remark = txttaskremark.Value; } if (!string.IsNullOrEmpty(txttaskcreator.Value)) { task.Excutor = txttaskcreator.Value; } dQDocEntities.SaveChanges(); RefreshTaskInfo(taskid); }
private void RefreshTaskInfo(Guid taskid) { DQDocEntities dQDocEntities = new DQDocEntities(); var task = dQDocEntities.OATasks.FirstOrDefault(o => o.Id == taskid); hidTaskid.Value = task.Id.ToString(); titleh1.InnerText = task.TaskName; txttaskname.Value = task.TaskName; txttaskremark.Value = task.Remark; txttaskcreator.Value = task.Excutor; if (task.StartTime.HasValue) { btnstartdate.InnerText = string.Format("{0:yyyy-MM-dd}", task.StartTime.Value); hidstartdate.Value = btnstartdate.InnerText; } if (task.EndTime.HasValue) { btnenddate.InnerText = string.Format("{0:yyyy-MM-dd}", task.EndTime.Value); hidenddate.Value = btnenddate.InnerText; } }