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("调整成功!");
 }
示例#2
0
 public Task UpdateAsync(SysUser user)
 {
     using (BizDataContext context = new BizDataContext(true))
     {
         context.Update(user);
     }
     return(Task.FromResult <int>(0));
 }
示例#3
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");
        }
示例#4
0
 /// <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();
                }
            }
        }
示例#6
0
 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);
                 }
             }
         }
     }
 }
示例#7
0
        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;
            }
        }
示例#8
0
 /// <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);
     }
 }
示例#9
0
 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);
     }
 }