//判断是否自动登录
void Autologin()
{
if (Daiv_OA.Utils.Cookie.GetValue("oa_user") != null)
{
if (Daiv_OA.Utils.Cookie.GetValue("oa_user", "ip") == Request.UserHostAddress)
{
Daiv_OA.Entity.UserEntity model = new Daiv_OA.Entity.UserEntity();
model = new Daiv_OA.BLL.UserBLL().GetEntity(Convert.ToInt32(Daiv_OA.Utils.Cookie.GetValue("oa_user", "id")));
int pid = model.Pid;
new BLL.UserBLL().UpdateTime(model.Uid);
switch (pid)
{
case 1:
Session["UserName"] = model.Uname;
Response.Redirect("Index.aspx");
break;
case 2:
Session["UserName"] = model.Uname;
Response.Redirect("Index.aspx");
break;
case 3:
Session["UserName"] = model.Uname;
Response.Redirect("Index.aspx");
break;
case 4:
Session["UserName"] = model.Uname;
Response.Redirect("Index.aspx");
break;
}
}
}
}
/// <summary>
/// 验证登陆
/// </summary>
private void chkLogin(string go2Url, int BackStep)
{
if (Daiv_OA.Utils.Cookie.GetValue("oa_user") != null)
{
UserId = Validator.StrToInt(Daiv_OA.Utils.Cookie.GetValue("oa_user", "id"), 0);
UserName = Daiv_OA.Utils.Cookie.GetValue("oa_user", "name");
if (UserId != 0 && UserName.Length != 0)
{
Daiv_OA.Entity.UserEntity model = new Daiv_OA.Entity.UserEntity();
model = new BLL.UserBLL().GetEntity(UserId);
if (model.Uipaddress.Length > 0)
{
if (Request.UserHostAddress != model.Uipaddress)
{
showErrMsg("非法IP地址登录", go2Url, BackStep);
return;
}
}
this.UserIsLogin = true;
UserPosition = model.Position;
UserPowerId = model.Pid;
UserDepartmentId = model.Did;
UserSetting = model.Setting;
}
}
}
//数据绑定
void Bind()
{
int uid = Str2Int(q("id"), 0);
Daiv_OA.Entity.UserEntity model = new Daiv_OA.Entity.UserEntity();
model = new Daiv_OA.BLL.UserBLL().GetEntity(uid);
this.txtUname.Text = model.Uname;
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Daiv_OA.Entity.UserEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [OA_User] set ");
strSql.Append("Pid=" + model.Pid + ",");
strSql.Append("Uname='" + model.Uname + "',");
strSql.Append("Did='" + model.Did + "',");
strSql.Append("Upwd='" + model.Upwd + "',");
strSql.Append("Position='" + model.Position + "',");
strSql.Append("Setting='" + model.Setting + "',");
strSql.Append("Uipaddress='" + model.Uipaddress + "',");
strSql.Append("UClassID=" + model.UClassID + ",");
strSql.Append("UClassName='" + model.UClassName + "',");
strSql.Append("Mphone='" + model.Mphone + "',");
strSql.Append("ULongName='" + model.ULongName + "'");
strSql.Append(" where Uid=" + model.Uid + " ");
DbHelperSQL.ExecuteSql(strSql.ToString());
}
/// <summary>
/// 构造实体对象
/// </summary>
/// <param name="dt"></param>
/// <param name="rowindex"></param>
/// <returns></returns>
public Daiv_OA.Entity.UserEntity ConvertModel(DataTable dt, int rowindex)
{
Daiv_OA.Entity.UserEntity model = new Daiv_OA.Entity.UserEntity();
try
{
if (dt.Rows[rowindex]["Uid"].ToString() != "")
{
model.Uid = int.Parse(dt.Rows[rowindex]["Uid"].ToString());
}
if (dt.Rows[rowindex]["Did"].ToString() != "")
{
model.Did = int.Parse(dt.Rows[rowindex]["Did"].ToString());
}
if (dt.Rows[rowindex]["Pid"].ToString() != "")
{
model.Pid = int.Parse(dt.Rows[rowindex]["Pid"].ToString());
}
model.Uname = dt.Rows[rowindex]["Uname"].ToString();
model.Upwd = dt.Rows[rowindex]["Upwd"].ToString();
model.Uipaddress = dt.Rows[rowindex]["Uipaddress"].ToString();
model.Position = dt.Rows[rowindex]["Position"].ToString();
model.Setting = dt.Rows[rowindex]["Setting"].ToString();
model.UClassName = dt.Rows[rowindex]["UClassName"].ToString();
model.Mphone = dt.Rows[rowindex]["Mphone"].ToString();
model.ULongName = dt.Rows[rowindex]["ULongName"].ToString();
if (dt.Rows[rowindex]["UClassID"].ToString() != "")
{
model.UClassID = int.Parse(dt.Rows[rowindex]["UClassID"].ToString());
}
if (dt.Rows[rowindex]["IsDeleted"].ToString() != "")
{
model.IsDeleted = int.Parse(dt.Rows[rowindex]["IsDeleted"].ToString());
}
}
catch (Exception ex)
{
log.Info("转换成用户对象失败！原因：" + ex.Message);
return(new Entity.UserEntity());
}
return(model);
}
//信息绑定
void Bind()
{
Daiv_OA.Entity.TaskEntity model = new Daiv_OA.Entity.TaskEntity();
model = new BLL.TaskBLL().GetEntity(Str2Int(q("id")));
if (model.Ttype == "锁定")
{
Response.Redirect("Locked.aspx");
}
Daiv_OA.Entity.UserEntity userEntity = new Daiv_OA.Entity.UserEntity();
userEntity = new BLL.UserBLL().GetEntity(model.Uid);
this.txtBegintime.Text = model.Nowtime.ToString();
this.txtEndtime.Text = model.Plantime.ToString();
this.txtTitle.Text = model.Tasktitle;
this.ddlWorker.SelectedValue = userEntity.Uid.ToString();
txt.Text = model.Content;
questext.Text = model.Question;
this.ddlWorker.Enabled = false;
this.classse.SelectedValue = model.Classse;
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Daiv_OA.Entity.UserEntity userEntity = new Daiv_OA.Entity.UserEntity();
//可以添加
Daiv_OA.Entity.MessageEntity message = new Daiv_OA.Entity.MessageEntity();
message.Content = this.kindeditor.Value;
message.FromUid = UserId;
message.Addtime = System.DateTime.Now;
message.Mtitle = this.txtTitle.Text;
if (mes != 0)
{
message.ToUid = _uid;
}
else
{
if (DropDownList1.SelectedValue == "-1")
{
System.Web.UI.Page page = (System.Web.UI.Page)System.Web.HttpContext.Current.Handler;
page.ClientScript.RegisterStartupScript(page.GetType(), "clientScript", "<script language='javascript'>alert('请选择收信人！');</script>");
return;
}
else
{
message.ToUid = Convert.ToInt32(DropDownList2.SelectedValue.ToString());
}
}
int i = new Daiv_OA.BLL.MessageBLL().Add(message);
if (i > 0)
{
Daiv_OA.BLL.OA_SysMessageIn.ADDsysMessage(0, "," + message.ToUid + ",", "新短信", Daiv_OA.Utils.Strings.Left(Daiv_OA.Utils.Strings.delhtml(txtTitle.Text.Trim()), 53), "Message_Show.aspx?id=" + i.ToString());
FinalMessage("短信发送成功", "Message_MySend.aspx", 0);
}
else
{
FinalMessage("短信发送失败", "Message_MySend.aspx", 0);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Daiv_OA.Entity.UserEntity GetEntity(int Uid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ");
strSql.Append(" Uid,Pid,Did,Uname,Upwd,Uipaddress,Position,Setting,UClassID,UClassName,Mphone,ULongName,IsDeleted ");
strSql.Append(" FROM [OA_User] ");
strSql.Append(" where Uid=" + Uid + " ");
Daiv_OA.Entity.UserEntity model = new Daiv_OA.Entity.UserEntity();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
//if (ds.Tables[0].Rows[0]["Uid"].ToString() != "")
//{
// model.Uid = int.Parse(ds.Tables[0].Rows[0]["Uid"].ToString());
//}
//if (ds.Tables[0].Rows[0]["Did"].ToString() != "")
//{
// model.Did = int.Parse(ds.Tables[0].Rows[0]["Did"].ToString());
//}
//if (ds.Tables[0].Rows[0]["Pid"].ToString() != "")
//{
// model.Pid = int.Parse(ds.Tables[0].Rows[0]["Pid"].ToString());
//}
//model.Uname = ds.Tables[0].Rows[0]["Uname"].ToString();
//model.Upwd = ds.Tables[0].Rows[0]["Upwd"].ToString();
//model.Uipaddress = ds.Tables[0].Rows[0]["Uipaddress"].ToString();
//model.Position = ds.Tables[0].Rows[0]["Position"].ToString();
//model.Setting = ds.Tables[0].Rows[0]["Setting"].ToString();
//return model;
return(ConvertModel(ds.Tables[0], 0));
}
else
{
return(null);
}
}
void showlist()
{
if (txtid.Text.Trim() != "")
{
qs.Visible = true;
Daiv_OA.Entity.TaskEntity model = new Daiv_OA.Entity.TaskEntity();
int id = Convert.ToInt32(txtid.Text.Trim());
model = new BLL.TaskBLL().GetEntity(id);
if (id == 4 || id == 8)
{
Workprogress.SelectedValue = model.Workprogress.ToString();
}
this.txtBegintime.Text = model.Nowtime.ToString();
this.txtEndtime.Text = model.Plantime.ToString();
this.txtTitle.Text = model.Tasktitle.ToString();
Daiv_OA.Entity.UserEntity userEntity = new Daiv_OA.Entity.UserEntity();
userEntity = new BLL.UserBLL().GetEntity(model.Uid);
Uidtxt.Text = userEntity.Uname.ToString();
}
else
{
qs.Visible = false;
}
}
//数据绑定
void Bind()
{
int uid = Str2Int(q("id"), 0);
department();
roless();
Daiv_OA.Entity.UserEntity model = new Daiv_OA.Entity.UserEntity();
model = new Daiv_OA.BLL.UserBLL().GetEntity(uid);
this.txtUname.Text = model.Uname;
this.txtUname.ReadOnly = true;
// this.txtPosition.Text = model.Position; //职位
this.txtIpaddress.Text = model.Uipaddress;
//this.UClassID.Text = model.UClassID.ToString();
this.ULongName.Text = model.ULongName;
//this.UClassName.Text = model.UClassName ;
this.Mphone.Text = model.Mphone;
string user_setting = "";
string[,] menu = null;
if (pidtxt.Text != "")
{
Entity.PowerEntity powerEntity = new BLL.PowerBLL().GetEntity(Convert.ToInt32(pidtxt.Text.Trim()));
user_setting = powerEntity.Setting;
int pid = Convert.ToInt32(pidtxt.Text);
if (depid.Text != "")
{
DropDownList1.SelectedValue = depid.Text.ToString();
}
else
{
DropDownList1.SelectedValue = model.Did.ToString();
}
DropDownList2.SelectedValue = pid.ToString();
if (pid == 1)
{
menu = powerMenu1();
}
if (pid == 2)
{
menu = powerMenu2();
}
else if (pid == 3)
{
menu = powerMenu3();
}
else if (pid == 4)
{
menu = powerMenu4();
}
}
else
{
DropDownList1.SelectedValue = model.Did.ToString();
DropDownList2.SelectedValue = model.Pid.ToString();
user_setting = model.Setting;
if (model.Pid == 1)
{
menu = powerMenu1();
}
if (model.Pid == 2)
{
menu = powerMenu2();
}
else if (model.Pid == 3)
{
menu = powerMenu3();
}
else if (model.Pid == 4)
{
menu = powerMenu4();
}
}
//绑定班级
Daiv_OA.BLL.GradeBLL dp = new Daiv_OA.BLL.GradeBLL();
DataSet ds = dp.GetList("");
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
ListItem listItem = new ListItem();
listItem.Text = ds.Tables[0].Rows[j]["Gname"].ToString();
listItem.Value = ds.Tables[0].Rows[j]["Gid"].ToString();
this.ddlGid.Items.Add(listItem);
}
this.ddlGid.SelectedValue = model.UClassID.ToString();
ds.Clear();
StringBuilder sb = new StringBuilder();
sb.Append("<table cellspacing=\"0\" width=\"100%\" cellpadding=\"0\" align=\"center\">");
for (int i = 0; i < menu.GetLength(0); i++)
{
sb.Append("<tr><td width=\"260\" align=\"right\"><strong>" + menu[i, 0] + "</strong></td>");
sb.Append("<td width=\"*\">");
for (int j = 1; j < menu.GetLength(1); j++)
{
if (menu[i, j] == null)
{
break;
}
string[] _split = menu[i, j].Split('|');
sb.Append("<span style='float:left;height:30px;margin-left:10px;padding-top:5px;' scope='col'><input id=\"user_setting_" + i + "_" + j + "\" type=checkbox class='checkbox' name=\"user_setting\" value=\"");
string tPower = _split[1];
sb.Append(tPower + "\"");
if (_split.Length > 2 && _split[2] == "1")
{
sb.Append(" onclick='if(!this.checked){this.checked=true;}else{this.checked=false;}'");
}
if (user_setting.Contains("," + tPower + ","))
{
sb.Append(" checked");
}
sb.Append("><label for=\"user_setting_" + i + "_" + j + "\">" + _split[0] + "</label>");
sb.Append("</span>\r\n");
}
sb.Append("</td></tr>");
}
sb.Append("</td></tr>");
sb.Append("</table>");
this.ltMasterSetting.Text = sb.ToString();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
// 记录其IP地址，下次登录时验证，IP为空则记录，IP不为空则验证
string uname = this.txtUserName.Text.Trim();
string upwd = this.txtUserPwd.Text.Trim();
string code = txtCode.Text.Trim();
if (uname.Equals("") || upwd.Equals(""))
{
lblTip.Visible = true;
lblTip.Text = "请输入用户名或密码";
return;
}
if (code.Equals(""))
{
lblTip.Visible = true;
lblTip.Text = "请输入验证码";
return;
}
if (Session[verify_code.SESSION_CODE] == null)
{
lblTip.Visible = true;
lblTip.Text = "系统找不到验证码";
return;
}
if (code.ToLower() != Session[verify_code.SESSION_CODE].ToString().ToLower())
{
lblTip.Visible = true;
lblTip.Text = "验证码输入不正确";
return;
}
string uid = new Daiv_OA.BLL.UserBLL().Existslongin(uname, Daiv_OA.Utils.MD5.Lower32(upwd));
if (uid != "")
{
Daiv_OA.Entity.UserEntity model = new Daiv_OA.Entity.UserEntity();
model = new Daiv_OA.BLL.UserBLL().GetEntity(int.Parse(uid));
if (model.Uipaddress != "")
{
if (model.Uipaddress != Page.Request.UserHostAddress)
{
Response.Write("<script>alert('非法IP，请在本机登陆！');</script>");
Response.End();
}
}
int iExpires = 0;
//设置Cookies
//System.Collections.Specialized.NameValueCollection myCol = new System.Collections.Specialized.NameValueCollection();
//myCol.Add("id", uid.ToString());
//myCol.Add("name", uname);
//myCol.Add("ip", Request.UserHostAddress);
//new BLL.UserBLL().UpdateTime(model.Uid);
int pid = model.Pid;
//myCol.Add("Powerid", pid.ToString());
//Daiv_OA.Utils.Cookie.SetObj("oa_user", 60 * 60 * 15 * iExpires, myCol, "", "/");
new BLL.UserBLL().SetUserCookies(model, Request.UserHostAddress, iExpires);
switch (pid)
{
case 1:
Session["UserName"] = uname;
Response.Redirect("Index.aspx"); //管理员
break;
case 2:
Session["UserName"] = uname;
Response.Redirect("Index.aspx"); //管理组织层
break;
case 3:
Session["UserName"] = uname;
Response.Redirect("Index.aspx"); //网站编辑
break;
case 4:
Session["UserName"] = uname;
Response.Redirect("Index.aspx"); //美工和程序员
break;
}
}
else
{
this.txtUserName.Text = "";
this.txtUserPwd.Text = "";
System.Web.UI.Page page = (System.Web.UI.Page)System.Web.HttpContext.Current.Handler;
page.ClientScript.RegisterStartupScript(page.GetType(), "clientScript", "<script language='javascript'>alert('请正确填写用户名和密码！');</script>");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Daiv_OA.Entity.UserEntity model)
{
if (Exists(model.Uname))//已经存在该用户
{
return(0);
}
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
strSql1.Append("Pid,");
strSql2.Append("" + model.Pid + ",");
strSql1.Append("Did,");
strSql2.Append("" + model.Did + ",");
if (model.Uname != null)
{
strSql1.Append("Uname,");
strSql2.Append("'" + model.Uname + "',");
}
if (model.Upwd != null)
{
strSql1.Append("Upwd,");
strSql2.Append("'" + model.Upwd + "',");
}
if (model.Uipaddress != null)
{
strSql1.Append("Uipaddress,");
strSql2.Append("'" + model.Uipaddress + "',");
}
if (model.Position != null)
{
strSql1.Append("Position,");
strSql2.Append("'" + model.Position + "',");
}
if (model.Setting != null)
{
strSql1.Append("Setting,");
strSql2.Append("'" + model.Setting + "',");
}
if (model.UClassID > 0)
{
strSql1.Append("UClassID,");
strSql2.Append("" + model.UClassID + ",");
}
if (model.Mphone != null)
{
strSql1.Append("Mphone,");
strSql2.Append("'" + model.Mphone + "',");
}
if (model.UClassName != null)
{
strSql1.Append("UClassName,");
strSql2.Append("'" + model.UClassName + "',");
}
if (model.ULongName != null)
{
strSql1.Append("ULongName,");
strSql2.Append("'" + model.ULongName + "',");
}
if (model.IsDeleted >= 0)
{
strSql1.Append("IsDeleted,");
strSql2.Append("" + model.IsDeleted + ",");
}
strSql.Append("insert into [OA_User](");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
object obj = DbHelperSQL.GetSingle(strSql.ToString());
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}