protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["UserID"] == null) //如果用户还没登陆跳到登陆页面
{
Response.Redirect("../login.aspx");
}
else
{
sr_User users = new sr_User();
ZQUSR.Model.sr_User model = users.GetModel(Session["UserID"].ToString());
Lb_UserID.Text = model.PK_UserID;
Lb_UserName.Text = model.UserName;
Lb_UserSex.Text = model.Sex;
Lb_UserUnit.Text = model.Unit;
Lb_UserEducation.Text = model.Education;
Lb_UserZhiCheng.Text = model.ZhiCheng;
Lb_UserTel.Text = model.Telephone;
int i = int.Parse(model.InOffice.ToString());
if (i == 1)
{
Lb_UserInOffice.Text = "在职";
}
else
{
Lb_UserInOffice.Text = "不在职";
}
Lb_UserEmail.Text = model.Email;
Lb_UserLoginTimes.Text = model.Logins.ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["UserID"] == null) //如果用户还没登陆跳到登陆页面
{
Response.Redirect("login.aspx");
}
else
{
sr_User users = new sr_User();
ZQUSR.Model.sr_User model = users.GetModel(Session["UserID"].ToString());
//TB_UserID.Text = Session["UserID"].ToString();
TB_UserID.Text = model.PK_UserID;
TB_UserName.Text = model.UserName;
DropDL_Sex.SelectedValue = model.Sex; //
TB_Unit.SelectedValue = model.Unit;
DropDL_Degree.SelectedValue = model.Education;
TB_ZhiCheng.SelectedValue = model.ZhiCheng;
TB_Telephone.Text = model.Telephone;
int i = int.Parse(model.InOffice.ToString());
if (i == 1)
{
DropDL_Job.SelectedValue = "在职";
}
else
{
DropDL_Job.SelectedValue = "不在职";
}
TB_Email.Text = model.Email;
}
}
}
private void BindData(string srid)
{
//得到对象实体
AchievementModel = AchievementBll.GetModel(srid);
UserModel = UserBll.GetModel(AchievementModel.FK_UserID);
//绑定数据到Label
lblUserName.Text = UserModel.UserName;
lblUserUnit.Text = UserModel.Unit;
lblSex.Text = UserModel.Sex;
lblZhiCheng.Text = UserModel.ZhiCheng;
lblBigSort.Text = AchievementModel.BigSort;
lblSchoolSign.Text = AchievementModel.SchoolSign;
lblRank.Text = (AchievementModel.Rank).ToString();
lblPopulation.Text = (AchievementModel.Population).ToString();
lblAllAuthor.Text = AchievementModel.AllAuthor;
lblRemark.Text = AchievementModel.Remark;
lblJiBie.Text = (AchievementModel.LevelFactor).ToString() + AchievementModel.JiBie;
lblPerScore.Text = (AchievementModel.PerScore).ToString();
string state = (AchievementModel.AuditState).ToString();
lblAuditState.Text = StateInfo.GetAuditState(state);
lblReason.Text = AchievementModel.Extra1;
if (state == "2" || state == "4" || state == "6")
{
PanelReasonVisible.Visible = true;
}
lblSRID.Text = AchievementModel.PK_AID;
lblType.Text = AchievementModel.Type;
lblTitle.Text = AchievementModel.Title;
lblSource.Text = AchievementModel.Source;
lblTime.Text = string.Format("{0:yyyy-MM-dd}", AchievementModel.PublishTime);
lblGrade.Text = AchievementModel.Grade;
//if (state == "1" || state == "3" || state == "5" || state == "7")
//{
// Button1.Enabled = false;
// Button2.Enabled = false;
//}
//if (state == "3" || state == "5" || state == "7")
//{
// Button3.Enabled = false;
// Button4.Enabled = false;
//}
//if (state == "5" || state == "7")
//{
// Button5.Enabled = false;
// Button6.Enabled = false;
//}
//if (state == "7")
//{
// Button7.Enabled = false;
// Button8.Enabled = false;
//}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ZQUSR.Model.sr_User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update sr_User set ");
strSql.Append("UserName=@UserName,");
strSql.Append("Password=@Password,");
strSql.Append("Sex=@Sex,");
strSql.Append("Unit=@Unit,");
strSql.Append("Education=@Education,");
strSql.Append("ZhiCheng=@ZhiCheng,");
strSql.Append("Telephone=@Telephone,");
strSql.Append("InOffice=@InOffice,");
strSql.Append("Email=@Email,");
strSql.Append("Logins=@Logins,");
strSql.Append("LastLogin=@LastLogin,");
strSql.Append("Status=@Status,");
strSql.Append("Extra1=@Extra1,");
strSql.Append("Extra2=@Extra2,");
strSql.Append("Extra3=@Extra3");
strSql.Append(" where PK_UserID=@PK_UserID ");
SqlParameter[] parameters =
{
new SqlParameter("@PK_UserID", SqlDbType.NVarChar, 10),
new SqlParameter("@UserName", SqlDbType.NVarChar, 10),
new SqlParameter("@Password", SqlDbType.NVarChar, 32),
new SqlParameter("@Sex", SqlDbType.Char, 2),
new SqlParameter("@Unit", SqlDbType.NVarChar, 20),
new SqlParameter("@Education", SqlDbType.NVarChar, 10),
new SqlParameter("@ZhiCheng", SqlDbType.NVarChar, 10),
new SqlParameter("@Telephone", SqlDbType.NVarChar, 15),
new SqlParameter("@InOffice", SqlDbType.TinyInt, 1),
new SqlParameter("@Email", SqlDbType.NVarChar, 30),
new SqlParameter("@Logins", SqlDbType.Int, 4),
new SqlParameter("@LastLogin", SqlDbType.DateTime),
new SqlParameter("@Status", SqlDbType.TinyInt, 1),
new SqlParameter("@Extra1", SqlDbType.NVarChar, 10),
new SqlParameter("@Extra2", SqlDbType.NVarChar, 10),
new SqlParameter("@Extra3", SqlDbType.NVarChar, 10)
};
parameters[0].Value = model.PK_UserID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.Password;
parameters[3].Value = model.Sex;
parameters[4].Value = model.Unit;
parameters[5].Value = model.Education;
parameters[6].Value = model.ZhiCheng;
parameters[7].Value = model.Telephone;
parameters[8].Value = model.InOffice;
parameters[9].Value = model.Email;
parameters[10].Value = model.Logins;
parameters[11].Value = model.LastLogin;
parameters[12].Value = model.Status;
parameters[13].Value = model.Extra1;
parameters[14].Value = model.Extra2;
parameters[15].Value = model.Extra3;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ZQUSR.Model.sr_User GetModel(string PK_UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 PK_UserID,UserName,Password,Sex,Unit,Education,ZhiCheng,Telephone,InOffice,Email,Logins,LastLogin,Status,Extra1,Extra2,Extra3 from sr_User ");
strSql.Append(" where PK_UserID=@PK_UserID ");
SqlParameter[] parameters =
{
new SqlParameter("@PK_UserID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = PK_UserID;
ZQUSR.Model.sr_User model = new ZQUSR.Model.sr_User();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.PK_UserID = ds.Tables[0].Rows[0]["PK_UserID"].ToString();
model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
model.Password = ds.Tables[0].Rows[0]["Password"].ToString();
model.Sex = ds.Tables[0].Rows[0]["Sex"].ToString();
model.Unit = ds.Tables[0].Rows[0]["Unit"].ToString();
model.Education = ds.Tables[0].Rows[0]["Education"].ToString();
model.ZhiCheng = ds.Tables[0].Rows[0]["ZhiCheng"].ToString();
model.Telephone = ds.Tables[0].Rows[0]["Telephone"].ToString();
if (ds.Tables[0].Rows[0]["InOffice"].ToString() != "")
{
model.InOffice = int.Parse(ds.Tables[0].Rows[0]["InOffice"].ToString());
}
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
if (ds.Tables[0].Rows[0]["Logins"].ToString() != "")
{
model.Logins = int.Parse(ds.Tables[0].Rows[0]["Logins"].ToString());
}
if (ds.Tables[0].Rows[0]["LastLogin"].ToString() != "")
{
model.LastLogin = DateTime.Parse(ds.Tables[0].Rows[0]["LastLogin"].ToString());
}
if (ds.Tables[0].Rows[0]["Status"].ToString() != "")
{
model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());
}
model.Extra1 = ds.Tables[0].Rows[0]["Extra1"].ToString();
model.Extra2 = ds.Tables[0].Rows[0]["Extra2"].ToString();
model.Extra3 = ds.Tables[0].Rows[0]["Extra3"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(ZQUSR.Model.sr_User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sr_User(");
strSql.Append("PK_UserID,UserName,Password,Sex,Unit,Education,ZhiCheng,Telephone,InOffice,Email,Logins,LastLogin,Status,Extra1,Extra2,Extra3)");
strSql.Append(" values (");
strSql.Append("@PK_UserID,@UserName,@Password,@Sex,@Unit,@Education,@ZhiCheng,@Telephone,@InOffice,@Email,@Logins,@LastLogin,@Status,@Extra1,@Extra2,@Extra3)");
SqlParameter[] parameters =
{
new SqlParameter("@PK_UserID", SqlDbType.NVarChar, 10),
new SqlParameter("@UserName", SqlDbType.NVarChar, 10),
new SqlParameter("@Password", SqlDbType.NVarChar, 32),
new SqlParameter("@Sex", SqlDbType.Char, 2),
new SqlParameter("@Unit", SqlDbType.NVarChar, 20),
new SqlParameter("@Education", SqlDbType.NVarChar, 10),
new SqlParameter("@ZhiCheng", SqlDbType.NVarChar, 10),
new SqlParameter("@Telephone", SqlDbType.NVarChar, 15),
new SqlParameter("@InOffice", SqlDbType.TinyInt, 1),
new SqlParameter("@Email", SqlDbType.NVarChar, 30),
new SqlParameter("@Logins", SqlDbType.Int, 4),
new SqlParameter("@LastLogin", SqlDbType.DateTime),
new SqlParameter("@Status", SqlDbType.TinyInt, 1),
new SqlParameter("@Extra1", SqlDbType.NVarChar, 10),
new SqlParameter("@Extra2", SqlDbType.NVarChar, 10),
new SqlParameter("@Extra3", SqlDbType.NVarChar, 10)
};
parameters[0].Value = model.PK_UserID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.Password;
parameters[3].Value = model.Sex;
parameters[4].Value = model.Unit;
parameters[5].Value = model.Education;
parameters[6].Value = model.ZhiCheng;
parameters[7].Value = model.Telephone;
parameters[8].Value = model.InOffice;
parameters[9].Value = model.Email;
parameters[10].Value = model.Logins;
parameters[11].Value = model.LastLogin;
parameters[12].Value = model.Status;
parameters[13].Value = model.Extra1;
parameters[14].Value = model.Extra2;
parameters[15].Value = model.Extra3;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
private void BindData(string srid)
{
//得到对象实体
AchievementModel = AchievementBll.GetModel(srid);
UserModel = UserBll.GetModel(AchievementModel.FK_UserID);
//绑定数据到Label
lblUserName.Text = UserModel.UserName;
lblUserUnit.Text = UserModel.Unit;
lblSex.Text = UserModel.Sex;
lblZhiCheng.Text = UserModel.ZhiCheng;
lblBigSort.Text = AchievementModel.BigSort;
lblSchoolSign.Text = AchievementModel.SchoolSign;
lblRank.Text = (AchievementModel.Rank).ToString();
lblPopulation.Text = (AchievementModel.Population).ToString();
lblAllAuthor.Text = AchievementModel.AllAuthor;
lblRemark.Text = AchievementModel.Remark;
lblJiBie.Text = (AchievementModel.LevelFactor).ToString() + AchievementModel.JiBie;
lblPerScore.Text = (AchievementModel.PerScore).ToString();
string state = (AchievementModel.AuditState).ToString();
lblAuditState.Text = StateInfo.GetAuditState(state);
lblSRID.Text = AchievementModel.PK_AID;
lblTitle.Text = AchievementModel.Title;
lblTime.Text = string.Format("{0:yyyy-MM-dd}", AchievementModel.PublishTime);
lblType.Text = AchievementModel.Type;
lblUnit.Text = AchievementModel.Unit;
lblReason.Text = AchievementModel.Extra1;
if (state == "2" || state == "4" || state == "6")
{
PanelReasonVisible.Visible = true;
}
//if (state == "1" || state == "3" || state == "5" || state == "7")
//{
// Button1.Enabled = false;
// Button2.Enabled = false;
//}
//if (state == "3" || state == "5" || state == "7")
//{
// Button3.Enabled = false;
// Button4.Enabled = false;
//}
//if (state == "5" || state == "7")
//{
// Button5.Enabled = false;
// Button6.Enabled = false;
//}
//if (state == "7")
//{
// Button7.Enabled = false;
// Button8.Enabled = false;
//}
}
protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
int index = e.NewSelectedIndex; //选中的行号
GridViewRow row = GridView1.Rows[index]; //在gridview中的行号
string uid = row.Cells[0].Text.Trim(); //gridview中的第0列字段内容
//sr_User users = new sr_User();
ZQUSR.Model.sr_User model = users.GetModel(uid);
TB_UserID.Text = model.PK_UserID;
TB_UserName.Text = model.UserName;
string sex = model.Sex.Trim().ToString();
string unit = model.Unit.Trim().ToString();
string TDegree = model.Education.Trim().ToString();
string ZhiCheng = model.ZhiCheng.Trim().ToString();
if (sex != "")
{
DropDL_Sex.SelectedValue = model.Sex;
}
if (unit != "")
{
TB_Unit.SelectedValue = model.Unit;
}
if (TDegree != "")
{
DropDL_Degree.SelectedValue = model.Education;
}
if (TDegree != "")
{
TB_ZhiCheng.SelectedValue = model.ZhiCheng;
}
TB_Telephone.Text = model.Telephone;
int i = int.Parse(model.InOffice.ToString());
if (i == 1)
{
DropDL_Job.SelectedValue = "在职";
}
else
{
DropDL_Job.SelectedValue = "不在职";
}
TB_Email.Text = model.Email;
int j = model.Status.Value;
if (j == 1)
{
DropStatus.SelectedValue = "可以登录";
}
else
{
DropStatus.SelectedValue = "禁止登录";
}
RePwd.Text = "";
this.Panel1.Visible = true;
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public ZQUSR.Model.sr_User GetModel(string PK_UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 PK_UserID,UserName,Password,Sex,Unit,Education,ZhiCheng,Telephone,InOffice,Email,Logins,LastLogin,Status,Extra1,Extra2,Extra3 from sr_User ");
strSql.Append(" where PK_UserID=@PK_UserID ");
SqlParameter[] parameters = {
new SqlParameter("@PK_UserID", SqlDbType.NVarChar,50)};
parameters[0].Value = PK_UserID;
ZQUSR.Model.sr_User model = new ZQUSR.Model.sr_User();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.PK_UserID = ds.Tables[0].Rows[0]["PK_UserID"].ToString();
model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
model.Password = ds.Tables[0].Rows[0]["Password"].ToString();
model.Sex = ds.Tables[0].Rows[0]["Sex"].ToString();
model.Unit = ds.Tables[0].Rows[0]["Unit"].ToString();
model.Education = ds.Tables[0].Rows[0]["Education"].ToString();
model.ZhiCheng = ds.Tables[0].Rows[0]["ZhiCheng"].ToString();
model.Telephone = ds.Tables[0].Rows[0]["Telephone"].ToString();
if (ds.Tables[0].Rows[0]["InOffice"].ToString() != "")
{
model.InOffice = int.Parse(ds.Tables[0].Rows[0]["InOffice"].ToString());
}
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
if (ds.Tables[0].Rows[0]["Logins"].ToString() != "")
{
model.Logins = int.Parse(ds.Tables[0].Rows[0]["Logins"].ToString());
}
if (ds.Tables[0].Rows[0]["LastLogin"].ToString() != "")
{
model.LastLogin = DateTime.Parse(ds.Tables[0].Rows[0]["LastLogin"].ToString());
}
if (ds.Tables[0].Rows[0]["Status"].ToString() != "")
{
model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());
}
model.Extra1 = ds.Tables[0].Rows[0]["Extra1"].ToString();
model.Extra2 = ds.Tables[0].Rows[0]["Extra2"].ToString();
model.Extra3 = ds.Tables[0].Rows[0]["Extra3"].ToString();
return model;
}
else
{
return null;
}
}
