//删除 protected void GVItShift_RowDeleting(object sender, GridViewDeleteEventArgs e) { int rowid = e.RowIndex; int id = (int)gvItShift.DataKeys[rowid].Value; using (var mContext = new FavLinkEntities()) { var its = from p in mContext.tbl_itsupport_arrangment where p.id == id select p; if (its.Any()) { var obj = its.First(); mContext.tbl_itsupport_arrangment.DeleteObject(obj); } mContext.SaveChanges(); } BindGvItSupportArrangements(); }
//更新 protected void GVUsers_RowUpdating(object sender, GridViewUpdateEventArgs e) { int rowid = e.RowIndex; int id = (int)gvUsers.DataKeys[rowid].Value; using (var mContext = new FavLinkEntities()) { var persons = from p in mContext.tbl_user where p.id == id select p; foreach (var obj in persons) { var sVal = ((TextBox)(gvUsers.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim(); obj.IsValid = bool.Parse(sVal); //sVal = ((TextBox) (gvUsers.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim(); //obj.IsAdmin = bool.Parse(sVal); } mContext.SaveChanges(); } BindGvUser(); }
//更新 protected void GVItSupports_RowUpdating(object sender, GridViewUpdateEventArgs e) { int rowid = e.RowIndex; int id = (int)gvItSupports.DataKeys[rowid].Value; using (var mContext = new FavLinkEntities()) { var its = from p in mContext.tbl_itsupport where p.id == id select p; foreach (var obj in its) { var sVal = ((TextBox)(gvItSupports.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString().Trim(); obj.name = sVal; sVal = ((TextBox)(gvItSupports.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim(); obj.phone_number = sVal; } mContext.SaveChanges(); } BindGvItSupport(); e.Cancel = true; //!temp }
protected void btnLoginIn_Click(object sender, EventArgs e) { string ad = Request.Form["txUsername"]; string pwd = Request.Form["txPassword"]; string msg = ""; Business.CacheFactory.ClearCache(); UserBasicInfo domainUser = null; try { if (!UserState.IsLogin) { // 检查用户是否存在 tbl_user user = Common.GetUserInfoByAd(ad); if (user == null) { msg = "账号不存在,请先注册! \nLogin user not exist, please register first!"; alertMsg.Style[HtmlTextWriterStyle.Display] = ""; alertMsg.InnerText = msg; return; } //验证域密码 if (user != null) { domainUser = new UserBasicInfo(user); } if (user == null || false == Business.AppSettings.DebugRun) { domainUser = new ActiveDirectoryHelper().GetDomainUser(ad, pwd, out msg); if (domainUser == null) { alertMsg.Style[HtmlTextWriterStyle.Display] = ""; alertMsg.InnerText = msg; return; } if (user != null) { domainUser = new UserBasicInfo(user); } // 更新用户邮箱 if (user != null && string.IsNullOrEmpty(domainUser.Email) == false && domainUser.Email != user.Email) { user.Email = domainUser.Email; using (FavLinkEntities context = new FavLinkEntities()) { context.ObjectStateManager.ChangeObjectState(user, System.Data.EntityState.Modified); context.SaveChanges(); } } } // 帐号被停用 if (!user.IsValid) { msg = "账号已被停用. Your account was disabled."; alertMsg.Style[HtmlTextWriterStyle.Display] = ""; alertMsg.InnerText = msg; return; } } else { domainUser = UserState.GetLoginUser(); } UserState.Login(domainUser); Common.UpdateUserLoginTimeByAd(ad); if (!string.IsNullOrEmpty(ReUrl)) { Response.Redirect(ReUrl); } else { Response.Redirect(ResolveUrl("~/Default.aspx")); } } catch (Exception ex) { alertMsg.Style[HtmlTextWriterStyle.Display] = ""; alertMsg.InnerText = ex.Message; } }