private void BindGvUser()
{
using (var mContext = new FavLinkEntities())
{
var users = (from x in mContext.tbl_user select x);
gvUsers.DataSource = users;
gvUsers.DataKeyNames = new string[] { "id" };
gvUsers.DataBind();
}
}
private void BindGvItSupport()
{
using (var mContext = new FavLinkEntities())
{
var items = (from x in mContext.tbl_itsupport select x);
gvItSupports.DataSource = items;
gvItSupports.DataKeyNames = new string[] { "id" };
gvItSupports.DataBind();
ddlItSupportUsers.DataSource = items;
ddlItSupportUsers.DataTextField = "name";
ddlItSupportUsers.DataValueField = "id";
ddlItSupportUsers.DataBind();
}
}
private void BindGvItSupportArrangements()
{
using (var mContext = new FavLinkEntities())
{
var items = from x in mContext.tbl_itsupport_arrangment
select new TItSupportArrangement()
{
id = x.id,
ITSupportName = x.tbl_itsupport.name,
project = x.project,
shift = x.shift.HasValue ? x.shift.Value : 0,
month = x.month.HasValue ? x.month.Value : 0
};
gvItShift.DataSource = items;
gvItShift.DataKeyNames = new string[] { "id" };
gvItShift.DataBind();
}
}
//删除
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();
}
/// <summary>
/// 获取当前用户的完整信息
/// </summary>
//public static Entity.Sys_UserEntity GetLoginUserUserInfo() {
// var currentUser = GetLoginUser();
// if(currentUser == null) { return null; }
// return Business.SysUser.SelectByAD(currentUser.UserName);
//}
public static tbl_user GetLoginUserUserInfo()
{
var currEmail = UserEmail;
if (string.IsNullOrEmpty(currEmail))
{
return(null);
}
using (FavLinkEntities context = new FavLinkEntities())
{
var people = from p in context.tbl_user
where (0 == String.Compare(p.Email, currEmail, StringComparison.InvariantCultureIgnoreCase))
select p;
if (people.Any())
{
return(people.First());
}
}
return(null);
}
//更新
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;
}
}
