/// <summary> /// 用户登陆 /// </summary> /// <param name="userName">用户信息</param> /// <param name="userPass">用户密码</param> /// <param name="userId">返回用户Id</param> /// <returns>返回登陆成功或失败</returns> public int UserLoginCheck(string userName, string userPass, string m_ip, ref int userId) { try { Tunnel.BLL.Tunnel_menber tBll = new Tunnel.BLL.Tunnel_menber(); tBll.Exists(userName, userPass, m_ip, ref userId); if (userId > 0) { HttpCookie newCookie = new HttpCookie("userId"); newCookie.Value = userId.ToString(); Tunnel.Model.Tunnel_menber model = new Tunnel.Model.Tunnel_menber(); model = getUserModel(userId); UsbnLogin = model; if (model != null) { CreateCache(model); } } } catch (Exception ex) { throw ex; } return(userId); }
public string showShengRi() { string str2 = string.Empty; Tunnel.BLL.Tunnel_menber tm = new Tunnel.BLL.Tunnel_menber(); Tunnel.Model.Tunnel_menber tmm = new Tunnel.Model.Tunnel_menber(); List <Tunnel.Model.Tunnel_menber> tmList = new List <Tunnel.Model.Tunnel_menber>(); tmList = tm.GetModelList("1=1"); for (int i = 0; i < tmList.Count; i++) { string shengRi = tmList[i].m_birth.ToString(); string userName = tmList[i].m_name; for (int j = 0; j < 100; j++) { if (DateTime.Compare(Convert.ToDateTime(shengRi).AddYears(j), DateTime.Today) == 0) { str2 += userName + "<br/>"; } } } if (str2.Length > 0) { str2 = str2.Substring(0, str2.Length - 1); } return(str2); }
/// <summary> /// 获取管理员信息 /// </summary> /// <param name="userId">管理员ID</param> /// <returns>返回管理员信息</returns> public Tunnel.Model.Tunnel_menber GetUserBean(int userId) { Tunnel.Model.Tunnel_menber tempModel = new Tunnel.Model.Tunnel_menber(); if (userId > 0) { string acheKey = string.Format("{0}-CacheKey-{1}", CacheKey, userId); if (batmanCache[acheKey] != null) { tempModel = (Tunnel.Model.Tunnel_menber)batmanCache[acheKey]; } else { tempModel = getUserModel(Convert.ToInt64(userId)); } } else { if (HttpContext.Current != null && userId == 0) { HttpCookie newCookie = HttpContext.Current.Request.Cookies["userId"]; userId = Convert.ToInt32(newCookie.Value); } tempModel = getUserModel(Convert.ToInt64(userId)); } return(tempModel); }
public bool Save() { bool b = false; try { tmm = tm.GetModel(Convert.ToInt64(ul.LoginID)); tmm.m_id = Convert.ToInt64(ul.LoginID); tmm.m_idcard = txtIdKard.Text.Trim(); tmm.m_mail = txtMail.Text.Trim(); tmm.m_name = txtName.Text.Trim(); tmm.m_mobile = txtTel.Text.Trim(); tmm.m_login = txtUserName.Text.Trim(); if (!string.IsNullOrEmpty(txtBirth.Text)) { tmm.m_birth = Convert.ToDateTime(txtBirth.Text); } tm.Update(tmm); b = true; } catch (Exception) { b = false; throw; } return(b); }
public string ShowName(object o, int i) { string temp = string.Empty; string uid = o.ToString().Split('-')[2].ToString(); Tunnel.BLL.Tunnel_menber tm = new Tunnel.BLL.Tunnel_menber(); Tunnel.Model.Tunnel_menber tmm = new Tunnel.Model.Tunnel_menber(); tmm = tm.GetModel(Convert.ToInt64(uid)); if (tmm != null) { switch (i) { case 1: temp = tmm.m_login; break; case 2: temp = tmm.m_name; break; case 3: temp = Tunnel.Data.DESEncrypt.Decrypt(tmm.m_password); break; default: break; } } return(temp); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Tunnel.Model.Tunnel_menber menber = ul.GetUserBean(ul.LoginID); this.txtAuthor.Text = menber.m_name; } }
protected void Button4_Click(object sender, EventArgs e) { Tunnel.Model.Tunnel_menber tm = ul.GetUserBean(ul.LoginID); if (!Tunnel.Data.DESEncrypt.Encrypt(spPassword.Text.Trim()).Equals(tm.m_spassword)) { Tunnel.Common.Message.back("审批密码错误"); return; } else { //这里为存储当前步骤 mtb = btb.GetModel(int.Parse(Request.Params["bid"])); mf = bf.GetModel(mtb.b_sort); if (mtb.b_state == 3) { Tunnel.Common.Message.back("此流程己审批结束,请勿重复审批!"); return; } else { //将当前步骤存入数据库表:Tunnel_exam Tunnel.BLL.Tunnel_exam bte = new Tunnel.BLL.Tunnel_exam(); Tunnel.Model.Tunnel_exam mte = new Tunnel.Model.Tunnel_exam(); mte.e_bid = 0; mte.e_endtime = DateTime.Now; mte.e_gid = Convert.ToInt32(Request.Params["bid"]); mte.e_user = ul.LoginID; mte.e_nextbuser = m_value.Value; string lastendtime = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_endtime", "e_gid=" + Request.Params["bid"] + " order by e_id desc"); if (!string.IsNullOrEmpty(lastendtime)) { mte.e_time = Convert.ToDateTime(lastendtime);//取得上一步的最后执行时间 } else { mte.e_time = mtb.b_time; } mte.e_nextbid = 1; bte.Add(mte); string contents = FCKeditor1.Value; //添加审批意见 if (!string.IsNullOrEmpty(contents)) { Tunnel.BLL.Tunnel_Advice ta = new Tunnel.BLL.Tunnel_Advice(); Tunnel.Model.Tunnel_Advice ma = new Tunnel.Model.Tunnel_Advice(); ma.a_content = contents; ma.a_bid = Convert.ToInt32(mts.s_id); ma.a_gid = Convert.ToInt32(mtb.b_id); ma.a_time = DateTime.Now; ma.a_user = ul.LoginID; string count = Tunnel.Common.GetValue.getDataValue("Tunnel_Advice", "count(*)", "a_bid=1024 and a_gid=" + Request.Params["bid"]); ta.Add(ma); } Tunnel.Data.DbHelperSQL.ExecuteSql("UPDATE TUNNEL_BUMF SET B_STATE=3 WHERE B_ID=" + Request.Params["bid"]); //改变公文状态 Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=1 and m_touser="******" and m_typeid=" + mtb.b_id); //删除待办事项 Tunnel.Common.Message.Show("流程结束成功!", "../MyApply/Apply_Sp.aspx"); } } }
/// <summary> /// 创建缓存 /// </summary> /// <param name="ub">管理员信息</param> public void CreateCache(Tunnel.Model.Tunnel_menber ub) { string acheKey = string.Format("{0}-CacheKey-{1}", CacheKey, ub.m_id); onRemove = new CacheItemRemovedCallback(this.RemovedCallback); //batmanCache.Add(acheKey, ub, null, Cache.NoAbsoluteExpiration, new TimeSpan(0, 0, 10), CacheItemPriority.Normal, onRemove); batmanCache.Insert(acheKey, ub, null, DateTime.Now.AddMinutes(40), TimeSpan.Zero, CacheItemPriority.High, onRemove); CreateTicket(Convert.ToInt32(ub.m_id), ub.m_jiao); }
protected void Button1_Click(object sender, EventArgs e) { try { Tunnel.Model.Tunnel_menber tm = ul.GetUserBean(ul.LoginID); mtb = btb.GetModel(int.Parse(Request.Params["bid"])); //下一步骤ID string currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + mtb.b_sort + " and s_num=1"); string curruser = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_zid", "s_lid=" + mtb.b_sort + " and s_num=1"); //如果流程没有预设步骤 if ("".Equals(currbid)) { Tunnel.Common.Message.back("本流程未预设步骤,请与管理员联系!"); return; } //将当前步骤存入数据库表:Tunnel_exam Tunnel.BLL.Tunnel_exam bte = new Tunnel.BLL.Tunnel_exam(); Tunnel.Model.Tunnel_exam mte = new Tunnel.Model.Tunnel_exam(); mte.e_bid = 0; mte.e_endtime = DateTime.Now; mte.e_gid = Convert.ToInt32(mtb.b_id); mte.e_user = ul.LoginID; mte.e_time = DateTime.Now; mte.e_nextbuser = ""; mte.e_nextbid = Convert.ToInt32(currbid); bte.Add(mte); if (!string.IsNullOrEmpty(curruser)) { Tunnel.Model.Tunnel_Remind tr = new Tunnel.Model.Tunnel_Remind(); Tunnel.BLL.Tunnel_Remind br = new Tunnel.BLL.Tunnel_Remind(); string[] users = curruser.Split(','); foreach (string user in users) { if (!string.IsNullOrEmpty(user)) { tr.m_title = mtb.b_title + "<font color=red>(待审批)</font>"; tr.m_url = "N_WorkFlow/MyApply/Apply_zSp.aspx?bid=" + mtb.b_id; tr.m_touser = Convert.ToInt32(user); tr.m_time = DateTime.Now; tr.m_type = 1; tr.m_typeid = Convert.ToInt32(mtb.b_id); tr.m_bid = Convert.ToInt32(currbid); tr.m_callTime = Convert.ToDateTime("1800-1-1 00:00:00"); tr.m_isread = 0; long messge = br.Add(tr); } } } Tunnel.Data.DbHelperSQL.ExecuteSql("UPDATE TUNNEL_BUMF SET B_STATE=2 WHERE B_ID=" + mtb.b_id); //改变公文状态 Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=0 and m_typeid=" + mtb.b_id); //删除待办事项 Tunnel.Common.Message.Show("操作成功,审核通过!", "Apply_SP.aspx"); } catch { Tunnel.Common.Message.back("流程审核错误,请与管理员联系!"); } }
public Tunnel.Model.Tunnel_menber GetUserInfo() { Tunnel.BLL.UserLogin ul = new Tunnel.BLL.UserLogin(); Tunnel.Model.Tunnel_menber model = new Tunnel.Model.Tunnel_menber(); if (ul.LoginID > 0) { model = ul.GetUserBean(ul.LoginID); } return(model); }
public void PageBind() { Tunnel.Model.Tunnel_menber model = GetUserInfo(); if (model != null) { // Label1.Text = model.m_login + " [" + model.m_name + "]"; Label1.Text = model.m_name; } //else // Response.Write("<script>window.parent.location.href='Default.aspx?ReturnUrl=err'</script>"); }
public string GetUser(string str) { if (!string.IsNullOrEmpty(str)) { Tunnel.Model.Tunnel_menber men = ulBLL.GetUserBean(ulBLL.LoginID); return(men.m_name.ToString()); } else { return(""); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Response.Buffer = true; Response.ExpiresAbsolute = System.DateTime.Now.AddSeconds(-1); Response.Expires = 0; Response.CacheControl = "no-cache"; tmm = tm.GetModel(Convert.ToInt64(ul.LoginID)); bind(); } }
/// <summary> /// 获得数据列表 /// </summary> public List <Tunnel.Model.Tunnel_menber> DataTableToList(DataTable dt) { List <Tunnel.Model.Tunnel_menber> modelList = new List <Tunnel.Model.Tunnel_menber>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Tunnel.Model.Tunnel_menber model; for (int n = 0; n < rowsCount; n++) { model = new Tunnel.Model.Tunnel_menber(); model.m_id = Convert.ToInt64(dt.Rows[n]["m_id"].ToString()); model.m_login = dt.Rows[n]["m_login"].ToString(); model.m_name = dt.Rows[n]["m_name"].ToString(); model.m_password = dt.Rows[n]["m_password"].ToString(); model.m_mobile = dt.Rows[n]["m_mobile"].ToString(); if (dt.Rows[n]["m_mail"].ToString() != "") { model.m_mail = dt.Rows[n]["m_mail"].ToString(); } model.m_idcard = dt.Rows[n]["m_idcard"].ToString(); model.m_spassword = dt.Rows[n]["m_spassword"].ToString(); if (dt.Rows[n]["m_jiao"].ToString() != "") { model.m_jiao = int.Parse(dt.Rows[n]["m_jiao"].ToString()); } if (dt.Rows[n]["m_bum"].ToString() != "") { model.m_bum = Convert.ToInt32(dt.Rows[n]["m_bum"].ToString()); } if (dt.Rows[n]["m_duty"].ToString() != "") { model.m_duty = Convert.ToInt32(dt.Rows[n]["m_duty"].ToString()); } if (dt.Rows[n]["m_xjb"].ToString() != "") { model.m_xjb = dt.Rows[n]["m_xjb"].ToString(); } if (dt.Rows[n]["m_state"].ToString() != "") { model.m_state = int.Parse(dt.Rows[n]["m_state"].ToString()); } model.m_flag = dt.Rows[n]["m_flag"].ToString(); if (!string.IsNullOrEmpty(dt.Rows[n]["m_birth"].ToString())) { model.m_birth = Convert.ToDateTime(dt.Rows[n]["m_birth"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 显示用户真实姓名 /// </summary> /// <param name="Id">用户Id</param> /// <returns></returns> public string ShowUserName(string UserId) { Tunnel.BLL.Tunnel_menber mbll = new Tunnel.BLL.Tunnel_menber(); Tunnel.Model.Tunnel_menber model = new Tunnel.Model.Tunnel_menber(); model = mbll.GetModel(Convert.ToInt64(UserId)); string strTemp = string.Empty; if (model != null) { strTemp = model.m_name; } return(strTemp); }
public string ShowName(object o) { string a = string.Empty; Tunnel.BLL.Tunnel_menber tm = new Tunnel.BLL.Tunnel_menber(); Tunnel.Model.Tunnel_menber tmm = new Tunnel.Model.Tunnel_menber(); tmm = tm.GetModel(Convert.ToInt64(o.ToString())); if (tmm != null) { a = tmm.m_name; } return(a); }
public static string GetName(object o) { string temp = ""; Tunnel.BLL.Tunnel_menber tm = new Tunnel.BLL.Tunnel_menber(); if (!string.IsNullOrEmpty(Convert.ToString(o))) { Tunnel.Model.Tunnel_menber tmm = tm.GetModel(Convert.ToInt64(o.ToString())); if (tmm != null) { temp = tmm.m_name; } } return(temp); }
/// <summary> /// 得到所有权限 /// </summary> public Dictionary <int, string> getAllPermission() { Dictionary <int, string> allDic = new Dictionary <int, string>(); Tunnel.BLL.Tunnel_quanxian tq = new Tunnel.BLL.Tunnel_quanxian(); List <Tunnel.Model.Tunnel_quanxian> tqList = new List <Tunnel.Model.Tunnel_quanxian>(); if (ul.JiaoSe(ul.LoginID) == "系统管理员") { tqList = tq.GetModelList("1=1 order by q_rId asc "); foreach (Tunnel.Model.Tunnel_quanxian item in tqList) { allDic.Add(item.q_id, item.q_mark + "-->>" + item.q_name); } } else { Tunnel.BLL.Tunnel_menber tm = new Tunnel.BLL.Tunnel_menber(); Tunnel.Model.Tunnel_menber tmm = new Tunnel.Model.Tunnel_menber(); tmm = tm.GetModel(ul.LoginID); if (!string.IsNullOrEmpty(Convert.ToString(tmm.m_bum))) { Tunnel.BLL.Tunnel_byingshe tb = new Tunnel.BLL.Tunnel_byingshe(); Tunnel.Model.Tunnel_byingshe tbb = new Tunnel.Model.Tunnel_byingshe(); List <Tunnel.Model.Tunnel_byingshe> tbList = new List <Tunnel.Model.Tunnel_byingshe>(); tbList = tb.GetModelList("by_bid = " + tmm.m_bum + ""); if (tbList.Count > 0) { tbb = tbList[0]; string byList = tbb.by_list; if (byList.Length > 0) { string[] temp = byList.Split('|'); foreach (string item in temp) { Tunnel.Model.Tunnel_quanxian tqq = new Tunnel.Model.Tunnel_quanxian(); tqq = tq.GetModel(int.Parse(item)); if (tqq != null) { allDic.Add(tqq.q_id, tqq.q_mark + "-->>" + tqq.q_name); } } } } } } return(allDic); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["id"])) { uid = Request.QueryString["id"].ToString(); tmm = tm.GetModel(int.Parse(uid)); bind(); } else { Tunnel.Common.Message.Show("非法访问", "tunnel_userlist.aspx"); } } }
public void BindSource() { Tunnel.BLL.Tunnel_menber tm = new Tunnel.BLL.Tunnel_menber(); Tunnel.Model.Tunnel_menber tmm = new Tunnel.Model.Tunnel_menber(); string sid = null == Request.QueryString["uid"] ? "" : Request.QueryString["uid"].ToString().Trim(); if (sid != "") { sid = sid.Substring(0, sid.Length - 1); DataSet ds = tm.GetList(string.Format("m_id in ({0})", sid)); cbListUser.DataSource = ds; cbListUser.DataTextField = "m_name"; cbListUser.DataValueField = "m_id"; cbListUser.DataBind(); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Tunnel.Model.Tunnel_menber model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@m_id", SqlDbType.Int, 8), new SqlParameter("@m_login", SqlDbType.VarChar, 50), new SqlParameter("@m_name", SqlDbType.VarChar, 50), new SqlParameter("@m_password", SqlDbType.VarChar, 50), new SqlParameter("@m_mobile", SqlDbType.VarChar, 50), new SqlParameter("@m_mail", SqlDbType.VarChar, 50), new SqlParameter("@m_idcard", SqlDbType.VarChar, 50), new SqlParameter("@m_spassword", SqlDbType.VarChar, 50), new SqlParameter("@m_jiao", SqlDbType.Int, 4), new SqlParameter("@m_bum", SqlDbType.Int, 4), new SqlParameter("@m_duty", SqlDbType.Int, 4), new SqlParameter("@m_xjb", SqlDbType.VarChar, 200), new SqlParameter("@m_state", SqlDbType.Int, 4), new SqlParameter("@m_flag", SqlDbType.VarChar, 2000), new SqlParameter("@m_zdyqx", SqlDbType.Int, 4), new SqlParameter("@m_birth", SqlDbType.DateTime, 8), new SqlParameter("@m_KSID", SqlDbType.VarChar, 200) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.m_login; parameters[2].Value = model.m_name; parameters[3].Value = model.m_password; parameters[4].Value = model.m_mobile; parameters[5].Value = model.m_mail; parameters[6].Value = model.m_idcard; parameters[7].Value = model.m_spassword; parameters[8].Value = model.m_jiao; parameters[9].Value = model.m_bum; parameters[10].Value = model.m_duty; parameters[11].Value = model.m_xjb; parameters[12].Value = model.m_state; parameters[13].Value = model.m_flag; parameters[14].Value = model.m_zdyqx; parameters[15].Value = model.m_birth; parameters[16].Value = model.m_KSID; DbHelperSQL.RunProcedure("Tunnel_menber_ADD", parameters, out rowsAffected); int relt = Convert.ToInt32(parameters[0].Value); return(relt); }
protected void Page_Load(object sender, EventArgs e) { List <CacheItems> cList = new List <CacheItems>(); cList.Clear(); IDictionaryEnumerator dic = Cache.GetEnumerator(); while (dic.MoveNext()) { if (dic.Value.GetType().ToString() == "Tunnel.Model.Tunnel_menber") { cList.Add(new CacheItems(dic.Key.ToString(), dic.Value.GetType().ToString())); } } onLineUser = cList.Count; //string aaa=Cache["TunnelLogin-CacheKey-409"].ToString(); //string strsql = "select count(m_id) as onlineuser from tunnel_menber where m_online = 1"; //DataSet das = Tunnel.Data.DbHelperSQL.Query(strsql); //onLineUser = Convert.ToInt32(das.Tables[0].Rows[0]["onlineuser"]); if (!IsPostBack) { PageBind(); uid = ul.LoginID.ToString(); if (ul.LoginID > 0) { Tunnel.Model.Tunnel_menber model = ul.GetUserBean(ul.LoginID); Tunnel.BLL.Tunnel_bum bm = new Tunnel.BLL.Tunnel_bum(); if (model != null) { userbum = model.m_login + " | "; } if (model != null && model.m_bum > 0) { if (bm.GetModel(model.m_bum) != null) { userbum += bm.GetModel(model.m_bum).b_name; } } else { userbum += "部门未分组"; } } Label1.ToolTip = userbum; } }
public void bind() { tmm = tm.GetModel(Convert.ToInt64(Request.QueryString["updid"])); ddlBum.SelectedIndex = -1; ddlBum.Items.FindByValue(tmm.m_bum.ToString()).Selected = true; ddlDuty.SelectedIndex = -1; ddlDuty.Items.FindByValue(tmm.m_duty.ToString()).Selected = true; foreach (string item in tmm.m_xjb.ToString().Split('|')) { foreach (ListItem item1 in CheckBoxList3.Items) { if (item1.Value == item) { item1.Selected = true; } } } foreach (string item in tmm.m_KSID.ToString().Trim().Split(',')) { foreach (ListItem item1 in cbListKS.Items) { if (item1.Value == item) { item1.Selected = true; } } } if (tj.GetModelList("j_id=" + tmm.m_jiao + "").Count != 0) { DropDownList1.Items.FindByValue(tmm.m_jiao.ToString()).Selected = true; } txtPwd.Attributes["value"] = tmm.m_password; txtsPwd.Attributes["value"] = tmm.m_spassword; txtIdKard.Text = tmm.m_idcard; txtUserName.Text = tmm.m_login; txtMail.Text = tmm.m_mail; txtTel.Text = tmm.m_mobile; txtName.Text = tmm.m_name; rbState.Items.FindByValue(tmm.m_state.ToString()).Selected = true; txtBirth.Text = tmm.m_birth.ToShortDateString() == "1800-1-1" ? "" : tmm.m_birth.ToShortDateString(); }
/// <summary> /// 得到 类型ID 和 ID /// </summary> public void getIdtypeId(ref int tmpId, ref int typeId) { if (!string.IsNullOrEmpty(Request.QueryString["uid"])) { tmpId = Convert.ToInt32(Request.QueryString["uid"].ToString()); tempName = "用户管理"; Tunnel.BLL.Tunnel_menber menberBLL = new Tunnel.BLL.Tunnel_menber(); Tunnel.Model.Tunnel_menber menberModel = menberBLL.GetModel(tmpId); tempName_TypeName = menberModel.m_name; typeId = 1; if (!string.IsNullOrEmpty(Request.QueryString["uid"])) { GetUserAllPermission(int.Parse(Request.QueryString["uid"])); } } if (!string.IsNullOrEmpty(Request.QueryString["jid"])) { tmpId = Convert.ToInt32(Request.QueryString["jid"].ToString()); tempName = "角色管理"; Tunnel.BLL.Tunnel_jiaose jiaoseBLL = new Tunnel.BLL.Tunnel_jiaose(); Tunnel.Model.Tunnel_jiaose jiaoseModel = jiaoseBLL.GetModel(tmpId); tempName_TypeName = jiaoseModel.j_name; this.tmpSet.Visible = false; typeId = 2; } if (!string.IsNullOrEmpty(Request.QueryString["did"])) { tmpId = Convert.ToInt32(Request.QueryString["did"].ToString()); tempName = "职位管理"; Tunnel.BLL.Tunnel_duty dutyBLL = new Tunnel.BLL.Tunnel_duty(); Tunnel.Model.Tunnel_duty dutyModel = dutyBLL.GetModel(tmpId); tempName_TypeName = dutyModel.d_name; this.tmpSet.Visible = false; typeId = 3; } if (!string.IsNullOrEmpty(Request.QueryString["bid"])) { tmpId = Convert.ToInt32(Request.QueryString["bid"].ToString()); Tunnel.BLL.Tunnel_bum bumBLL = new Tunnel.BLL.Tunnel_bum(); Tunnel.Model.Tunnel_bum bumModels = bumBLL.GetModel(tmpId); tempName_TypeName = bumModels.b_name; tempName = "部门管理"; this.tmpSet.Visible = false; typeId = 4; } }
private void PageBind(int mailId) { Tunnel.BLL.Tunnel_mail mail = new Tunnel.BLL.Tunnel_mail(); Tunnel.Model.Tunnel_mail model = new Tunnel.Model.Tunnel_mail(); model = mail.GetModel(mailId); tb_Title.Text = "回复:" + model.m_title; tb_content.Text = "原信息内容:\n" + model.m_content.Replace(@"<br \>", "\n") + "\n" + model.m_time.ToString() + "\n-------------------------------\n"; Tunnel.BLL.Tunnel_menber menb = new Tunnel.BLL.Tunnel_menber(); Tunnel.Model.Tunnel_menber mmol = new Tunnel.Model.Tunnel_menber(); mmol = menb.GetModel(model.m_from); tb_toname.Text = mmol.m_name + ","; id_toValue.Value = model.m_from.ToString() + ","; string priv_name = mmol.m_name; long priv_id = mmol.m_id; char d = '"'; td_tomail.InnerHtml = priv_name + "<IMG id=" + priv_name + priv_id + " onclick=" + "'" + "removeimg(" + d + priv_name + d + "," + d + priv_id + d + ");" + "'" + " src=" + d + "../../image/remove.png" + d + ">,"; }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Tunnel.Model.Tunnel_menber model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@m_id", SqlDbType.BigInt, 8), new SqlParameter("@m_login", SqlDbType.VarChar, 50), new SqlParameter("@m_name", SqlDbType.VarChar, 50), new SqlParameter("@m_password", SqlDbType.VarChar, 50), new SqlParameter("@m_mobile", SqlDbType.VarChar, 50), new SqlParameter("@m_mail", SqlDbType.VarChar, 50), new SqlParameter("@m_idcard", SqlDbType.VarChar, 50), new SqlParameter("@m_spassword", SqlDbType.VarChar, 50), new SqlParameter("@m_jiao", SqlDbType.Int, 4), new SqlParameter("@m_bum", SqlDbType.Int, 4), new SqlParameter("@m_duty", SqlDbType.Int, 4), new SqlParameter("@m_xjb", SqlDbType.VarChar, 200), new SqlParameter("@m_state", SqlDbType.Int, 4), new SqlParameter("@m_flag", SqlDbType.VarChar, 2000), new SqlParameter("@m_zdyqx", SqlDbType.Int, 4), new SqlParameter("@m_birth", SqlDbType.DateTime, 8), new SqlParameter("@m_KSID", SqlDbType.VarChar, 200) }; parameters[0].Value = model.m_id; parameters[1].Value = model.m_login; parameters[2].Value = model.m_name; parameters[3].Value = model.m_password; parameters[4].Value = model.m_mobile; parameters[5].Value = model.m_mail; parameters[6].Value = model.m_idcard; parameters[7].Value = model.m_spassword; parameters[8].Value = model.m_jiao; parameters[9].Value = model.m_bum; parameters[10].Value = model.m_duty; parameters[11].Value = model.m_xjb; parameters[12].Value = model.m_state; parameters[13].Value = model.m_flag; parameters[14].Value = model.m_zdyqx; parameters[15].Value = model.m_birth; parameters[16].Value = model.m_KSID; DbHelperSQL.RunProcedure("Tunnel_menber_Update", parameters, out rowsAffected); }
public string GetBum(object o) { Tunnel.BLL.Tunnel_menber tm = new Tunnel.BLL.Tunnel_menber(); Tunnel.Model.Tunnel_menber tmm = new Tunnel_menber(); tmm = tm.GetModel(Convert.ToInt64(o.ToString())); string strTemp = string.Empty; if (tmm != null) { Tunnel_bum tbb = new Tunnel_bum(); Tunnel.BLL.Tunnel_bum tb = new Tunnel.BLL.Tunnel_bum(); tbb = tb.GetModel(Convert.ToInt64(tmm.m_bum.ToString())); if (tbb != null) { strTemp = tbb.b_name; } } return(strTemp); }
public bool Save() { bool b = false; try { tmm = tm.GetModel(Convert.ToInt64(ul.LoginID)); tmm.m_id = Convert.ToInt64(ul.LoginID); tmm.m_spassword = Tunnel.Data.DESEncrypt.Encrypt(TextBox3.Text.Trim()); tm.Update(tmm); b = true; } catch (Exception) { b = false; throw; } return(b); }
public void UserSave() { Tunnel.BLL.Tunnel_menber tm = new Tunnel.BLL.Tunnel_menber(); Tunnel.BLL.Tunnel_jiaose tj = new Tunnel.BLL.Tunnel_jiaose(); Tunnel.Model.Tunnel_jiaose tjj = new Tunnel_jiaose(); Tunnel.Model.Tunnel_menber tmm = new Tunnel.Model.Tunnel_menber(); Tunnel.BLL.Tunnel_uyingshe tu = new Tunnel.BLL.Tunnel_uyingshe(); Tunnel.Model.Tunnel_uyingshe tuu = new Tunnel_uyingshe(); tmm.m_login = txtName.Value.Trim(); tmm.m_name = txtName.Value.Trim(); tmm.m_password = Tunnel.Data.DESEncrypt.Encrypt(txtPwd.Text.Trim()); //tmm.m_mail = txtMail.Text.Trim(); //if (Tunnel.Common.RegexComm.IsValidEmail(tmm.m_mail)) //{ if (tm.GetModelList("m_login='******'").Count == 0) { tmm.m_spassword = Tunnel.Data.DESEncrypt.Encrypt("123456"); int i = tm.Add(tmm); if (i > 0) { tuu.uy_uid = i.ToString(); tuu.uy_list = ""; tu.Add(tuu); Tunnel.Common.Message.Show("添加用户成功,请继续完善资料,审批密码默认为123456,请尽快修改!", "tunnel_userupd.aspx?updid=" + i.ToString() + ""); } else { Tunnel.Common.Message.Show("注册失败"); } } else { Tunnel.Common.Message.Show("用户名已占用"); } //} //else //{ // Tunnel.Common.Message.Show("不是有效的邮箱名"); //} }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Response.Buffer = true; Response.ExpiresAbsolute = System.DateTime.Now.AddSeconds(-1); Response.Expires = 0; Response.CacheControl = "no-cache"; DropBind(); if (!string.IsNullOrEmpty(Request.QueryString["updid"])) { tmm = tm.GetModel(Convert.ToInt64(Request.QueryString["updid"].ToString())); bind(); } else { Tunnel.Common.Message.Show("用户不存在"); } } }