protected void btnChangeSystemLevelCode_Click(object sender, EventArgs e) { using (BizDataContext context = new BizDataContext()) { StringBuilder sbSQL = new StringBuilder(); //将父部门字段值调整过来并先处理好顶级部门的层级码 sbSQL.AppendLine("update T_Department set SystemLevelCode = Convert(nvarchar(50),Department_ID)+'-' where Parent_ID is null"); context.ExecuteNonQuery(sbSQL.ToString()); var AllDepts = context.FetchAll <T_Department>(); var Depts = AllDepts.Where(p => !(p.Parent_ID == null)).ToList(); var DealedDepts = AllDepts.Where(p => p.Parent_ID == null).ToList(); while (Depts.Count > 0) { for (int i = Depts.Count - 1; i >= 0; i--) { var Child = Depts[i]; var FindParent = DealedDepts.FirstOrDefault(p => p.Department_ID == Child.Parent_ID); if (FindParent != null) { //当前未处理的这个是某个已处理的子部门,则处理当前这个,并把它从未处理中移走,加到已处理中。 Child.SystemLevelCode = FindParent.SystemLevelCode + Child.Department_ID + "-"; context.Update(Child); Depts.Remove(Child); DealedDepts.Add(Child); } } } } this.AjaxAlert("调整成功!"); }
public Task UpdateAsync(SysUser user) { using (BizDataContext context = new BizDataContext(true)) { context.Update(user); } return(Task.FromResult <int>(0)); }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { //保存文本 string OriginalTitleText = this.hcTemplate.Value; //翻译成模板文本 string TemplateTitleText = Server.HtmlDecode(OriginalTitleText); AllNodes.ToList().ForEach(p => { TemplateTitleText = TemplateTitleText.Replace(p.Value, p.Key); }); //保存文本 string OriginalContentText = this.hcTemplate.Text; //翻译成模板文本 string TemplateContentText = Server.HtmlDecode(OriginalContentText); AllNodes.ToList().ForEach(p => { TemplateContentText = TemplateContentText.Replace(p.Value, p.Key); }); using (BizDataContext context = new BizDataContext()) { SysProcessRemindTemplate model; if (TemplateId == null) { model = new SysProcessRemindTemplate(); model.TemplateId = context.GetNextIdentity(); model.State = 1; } else { model = context.FindById <SysProcessRemindTemplate>(TemplateId.Value); } model.TemplateName = this.tcTemplateName.Text; model.TemplateType = this.ccTemplateType.SelectedValue.ToInt(); model.ProcessEntityId = this.ccProcessEntityId.SelectedValue.ToLong(); model.ActivityEntityId = this.ccActivityEntityId.SelectedValue.ToLong(); model.UseTimeType = this.ccUseTimeType.SelectedValue.ToInt(); model.ResultType = this.ccResultType.SelectedValue.ToInt(); model.OriginalTitleText = OriginalTitleText; model.OriginalContentText = OriginalContentText; model.TemplateContentText = TemplateContentText; model.TemplateTitleText = TemplateTitleText; if (TemplateId == null) { context.Insert(model); } else { context.Update(model); } } Response.Redirect("~/SystemManagement/ProcessTemplateQuery.aspx"); }
/// <summary> /// 禁用 /// </summary> /// <param name="serser"></param> /// <param name="e"></param> protected void lbtnDisable_Click(object sender, EventArgs e) { using (BizDataContext context = new BizDataContext()) { int id = int.Parse((sender as LinkButton).CommandArgument); SysProcessProxy ProcessProxyData = context.FirstOrDefault <SysProcessProxy>(p => p.ProcessProxyId == id); ProcessProxyData.Status = (int)ProxyStatus.Disable; context.Update(ProcessProxyData); } Response.Redirect(Request.Url.ToString()); }
/// <summary> /// 禁用 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lbtnDisable_Click(object sender, EventArgs e) { string id = (sender as LinkButton).CommandArgument; if (!string.IsNullOrEmpty(id)) { using (BizDataContext context = new BizDataContext()) { var model = context.FindById <SysProcessRemindTemplate>(id.ToLong()); model.State = 2; context.Update(model); BindGrid(); } } }
public virtual void OnWorkItemCompleted(int wiBaseId, int wiId, string Id) { if (WebConfigAppSettings.UseSSOModel) { using (BizDataContext context = new BizDataContext(WebConfigAppSettings.HomeBizDBConnString, true)) { int num; if (int.TryParse(Id, out num)) { T_WorkItemBase base2 = context.FindById <T_WorkItemBase>(new object[] { num }); if (base2 != null) { base2.State = 1; context.Update(base2); } } } } }
protected void cbcForgetpwd_CallBack(object sender, CallBackEventArgs e) { try { string UserCode = Convert.ToString(e.Context["UserCode"]); string Email = Convert.ToString(e.Context["Email"]); if (string.IsNullOrWhiteSpace(UserCode) || string.IsNullOrWhiteSpace(Email)) { e.Result = "请输入用户名和邮箱!"; } else { using (BizDataContext context = new BizDataContext()) { var user = context.FirstOrDefault <T_User>(p => p.User_Code == UserCode && p.User_EMail == Email); if (user == null) { e.Result = "输入的用户名和邮箱不匹配!"; } else if (user.User_Status == (int)Enum.EffectiveFlagEnum.No) { e.Result = "此用户已经被禁用!"; } else { string NewPwd = new Random().Next(100000, 1000000).ToString(); user.User_Password = this.Md5(NewPwd); context.Update(user); //调用邮件接口 (new Drision.Framework.Manager.EmailManager(this.DataHelper)).SendEmail(user.User_EMail, string.Empty, "密码帮助", string.Format("新密码为:{0},请重新登录!", NewPwd)); e.Result = "已将新密码发到您的邮箱!"; } } } } catch (Exception ex) { e.Result = ex.Message; } }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { try { using (BizDataContext context = new BizDataContext()) { SysProcessProxy ProcessProxyData; if (Id == null) { ProcessProxyData = new SysProcessProxy() { ProcessProxyId = context.GetNextIdentity_Int(), ProcessId = ProcessId, OwnerId = Convert.ToInt32(this.scOwner.GetValue()), ProxyId = Convert.ToInt32(this.scProxy.GetValue()), StartTime = Convert.ToDateTime(this.dtcStartTime.GetValue()), EndTime = Convert.ToDateTime(this.dtcEndTime.GetValue()), CreateTime = DateTime.Now, Status = (int)ProxyStatus.Enable, }; context.Insert(ProcessProxyData); } else { ProcessProxyData = context.FindById <SysProcessProxy>(Id); ProcessProxyData.OwnerId = Convert.ToInt32(this.scOwner.GetValue()); ProcessProxyData.ProxyId = Convert.ToInt32(this.scProxy.GetValue()); ProcessProxyData.StartTime = Convert.ToDateTime(this.dtcStartTime.GetValue()); ProcessProxyData.EndTime = Convert.ToDateTime(this.dtcEndTime.GetValue()); context.Update(ProcessProxyData); } } Response.Redirect(ViewState["UrlReferrer"].ToString()); } catch (ApplicationException ex) { this.AjaxAlert(ex.Message); } }
protected void btnRead_Click(object sender, EventArgs e) { try { string idStr = (sender as LinkButton).CommandArgument; int id = Convert.ToInt32(idStr); using (BizDataContext context = new BizDataContext()) { var remind = context.FindById <SysRemind>(id); if (remind != null) { remind.State = (int)RemindStausEnum.Completed; context.Update(remind); BindRemind(); } } } catch (ApplicationException ex) { this.AjaxAlert(ex.Message); } }