private void BindData(string ID) { DataClasses1DataContext db = new DataClasses1DataContext(); var result = from item in db.TbRight where item.ID.ToString() == ID select item; if (result.Count() <= 0) { return; } txtRightName.Text = result.ToList()[0].PageDes.ToString().Trim(); txtRightCode.Text = result.ToList()[0].PageName.ToString().Trim(); ddlUp.SelectedValue = result.ToList()[0].Nodelevel.ToString().Trim(); txtShunXu.Text = result.ToList()[0].XianShiShunXu.ToString().Trim(); if (result.ToList()[0].XianShiFlag.ToString().Trim() == "1") { chkXianShi.Checked = true; } else { chkXianShi.Checked = false; } }
public static int getFangWenLZong() { DataClasses1DataContext db = new DataClasses1DataContext(); var result = (from item in db.TbLog select item.IP + item.YongHuLeiXing).Distinct(); return result.Count(); }
public static int getFangWenLToDay() { DataClasses1DataContext db = new DataClasses1DataContext(); var result =( from item in db.TbLog where item.ShiJian >=Convert.ToDateTime( DateTime.Now.ToShortDateString()) && item.ShiJian<=DateTime.Now select item.IP +item.YongHuLeiXing).Distinct(); return result.Count(); }
public static List<TbLegalUrl_Cfg> getTbLegal() { DataClasses1DataContext db = new DataClasses1DataContext(); var result = from item in db.TbLegalUrl_Cfg select item; return result.ToList(); }
/// <summary> /// 用户类型统计 /// </summary> /// <returns></returns> public static List<ClsYongHuLX> getYongHuLX() { DataClasses1DataContext db = new DataClasses1DataContext(); var query = from item in db.TbUser group item by item.YongHuLeiXing into g select new ClsYongHuLX { Key = g.Key, Count = g.Count() }; return query.ToList<ClsYongHuLX>(); }
public static string getIPCountry(string strIP) { DataClasses1DataContext db = new DataClasses1DataContext(); long ip = (long)Dot2LongIP(strIP); var query = from item in db.IPTABLE where item.StartIPNum <= ip && item.EndIPNum >= ip select item; if (query.Count() <= 0) { return ""; } return query.ToList()[0].Country; }
public static TbIP getTbIP(string _strIp) { try { DataClasses1DataContext db = new DataClasses1DataContext(); var result = from item in db.TbIP where item.IP.Equals(_strIp) select item; return result.First(); } catch (Exception ex) { return null; } }
private void BindDdlUp() { DataClasses1DataContext db = new DataClasses1DataContext(); var result = from item in db.TbRight where item.Nodelevel == 0 select item; ddlUp.Items.Clear(); ddlUp.Items.Add("请选择"); ddlUp.Items[0].Value = "-1"; ddlUp.Items.Add("根目录"); ddlUp.Items[1].Value = "0"; for (int i = 0; i < result.Count(); i++) { ddlUp.Items.Add(result.ToList()[i].PageDes); ddlUp.Items[i +2].Value = result.ToList()[i].ID.ToString(); } }
protected void LinkButtonSave_Click(object sender, EventArgs e) { if (TextBoxTrueName.Text.ToString().Trim().Length > 50) { MSG.AlertMsg(Page, "您输入的姓名格式错误,请检查后输入!"); return; } if (Session["UserID"] != null) { using (DataClasses1DataContext db = new DataClasses1DataContext()) { db.Log = Console.Out; //取出 var user = db.TbUser.SingleOrDefault<TbUser>(s => s.ID.ToString() == Session["UserID"].ToString().Trim()); if (user == null) { return; } user.RealName = TextBoxTrueName.Text.ToString().Trim(); user.LianXiDianHua = TextBoxTel.Text.ToString().Trim(); user.ShouJi = TextBoxMobile.Text.ToString().Trim(); user.TongXinDiZhi = TextBoxAdds.Text.ToString().Trim(); user.EMail = txtEmail.Text.ToString().Trim(); /// user.EMail = txtYouXiang.Text.ToString().Trim(); /// if (TextBoxPassword.Text != "") { user.UserPWD = TextBoxPassword.Text.ToString().Trim(); } //执行更新操作 db.SubmitChanges(); Session["UserInfo"] = user; } } MSG.AlertMsg(Page, "修改成功!"); //PanelView.Visible = false; //PanelResult.Visible = true; }
public static bool TbIpUp(string IP, int flag) { bool bRs = false; try { using (DataClasses1DataContext db = new DataClasses1DataContext()) { var tb = db.TbIP.First(o => o.IP == IP); tb.flag = flag; db.SubmitChanges(); } bRs = true; } catch (Exception ex) { bRs = false; } return bRs; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string ID=Request.QueryString["ID"]; if(System.String.IsNullOrEmpty(ID)) { return; } DataClasses1DataContext db = new DataClasses1DataContext(); var result = from item in db.TbZhuZhiJGDMZ where item.UserID == int.Parse(ID) select item; if (result.Count() <= 0) { return; } Response.Redirect("ZZJGDMZ/" + result.ToList()[0].Path.ToString().Trim()); } }
public static List<TbSendMailLog> QuerySendMailLog(string ShouJianRen, string dateStart, string dateEnd) { DataClasses1DataContext db = new DataClasses1DataContext(); var result = from item in db.TbSendMailLog where item.ShouJianRen.Contains(ShouJianRen) select item; DateTime dStart = new DateTime(); DateTime dEnd = new DateTime(); try { dStart = Convert.ToDateTime(dateStart); } catch (Exception ex) { } try { dEnd = Convert.ToDateTime(dateEnd); dEnd = dEnd.AddDays(1); } catch (Exception ex) { } if (dateStart != "") { result = result.Where(a => a.FaSongShiJian >= dStart); } if (dateEnd != "") { result = result.Where(a => a.FaSongShiJian < dEnd); } return result.ToList(); }
public string RegUserinfo(string userid, string psd,string username,string email) { DataSet ds = new DataSet(); TbUser user = new TbUser(); string usertype = userid.Substring(4, 1); user.UserName = userid.Trim(); user.UserPWD = psd.Trim(); user.RealName = username; user.YongHuLeiXing = usertype; user.EMail = email.Trim(); user.DepartMentID = 0; user.SHFlag = 0; DataTable dt = new DataTable(); string sql = "select * from tbuser where username='******'"; dt = DBA.SqlDbAccess.GetDataTable(CommandType.Text, sql, null); using (DataClasses1DataContext db = new DataClasses1DataContext()) { db.Log = Console.Out; db.TbUser.InsertOnSubmit(user); db.SubmitChanges(); } if (dt.Rows.Count > 0) return "1"; string sqlShouCang = "insert into TLC_Albums (UserId,ParentId,Title,live,isdel,isparent) values('" + user.ID.ToString().Trim() + "',0,'收藏夹',0,0,0)"; string cusertype = ""; if (DBA.DbAccess.ExecNoQuery(CommandType.Text, sqlShouCang) < 0) { return "-1"; } switch (usertype) { case "0": cusertype = "个人"; break; case "1": cusertype = "企业"; break; case "2": cusertype = "事业单位"; break; case "3": cusertype = "政府机关"; break; case "4": cusertype = "社会团体"; break; case "5": cusertype = "其他类型单位"; break; case "9": cusertype = "简易账户"; break; } sqlShouCang = "select * from TbRole where rolename='" + cusertype + "'"; dt = DBA.SqlDbAccess.GetDataTable(CommandType.Text, sqlShouCang, null); if (dt.Rows.Count == 0) { return "-1"; } string roleid = dt.Rows[0]["ID"].ToString(); sqlShouCang = "insert into UserRole (roleid,userid) values ('" + roleid + "','" + user.ID.ToString() + "') "; if (DBA.SqlDbAccess.ExecNoQuery(CommandType.Text, sqlShouCang, null) < 0) { return "-1"; } return "1"; }
public static void TbIpInsert(string IP, int flag) { TbIP tb = new TbIP(); tb.IP = IP; tb.CreateDate = DateTime.Now; tb.flag = flag; using (DataClasses1DataContext db = new DataClasses1DataContext()) { db.TbIP.InsertOnSubmit(tb); db.SubmitChanges(); } }
private static bool TbLegalInsert(string GuoBie, string Des, string Url) { DataClasses1DataContext db = new DataClasses1DataContext(); TbLegalUrl_Cfg tb = new TbLegalUrl_Cfg(); tb.CO = GuoBie; tb.Des = Des; tb.LegUrl = Url; try { db.TbLegalUrl_Cfg.InsertOnSubmit(tb); db.SubmitChanges(); } catch (Exception ex) { return false; } return true; }
private string UserUpdate(string ID) { string sql = ""; DataSet ds = new DataSet(); bool RoleFlag = false; if (this.txtUserName.Text.ToString().Trim() == "") { return "请输入登录名称!"; } if (this.txtRealName.Text.ToString().Trim() == "") { return "请输入真实姓名!"; } if (txtPWD.Text.ToString().Trim().Length > 50) { return "密码超长,请重新输入!"; } if (txtPWD.Text.ToString().Trim() == "") { if (hfPWD.Value != "") { txtPWD.Text = hfPWD.Value; } else { return "请输入密码"; } } if (hfUserLeiXing.Value.ToString().Trim() != "企业") { sql = "Delete From UserRole Where UserID='" + ID + "'"; DBA.DbAccess.ExecNoQuery(CommandType.Text, sql); for (int i = 0; i < chkRole.Items.Count; i++) { if (chkRole.Items[i].Selected) { sql = "Insert Into UserRole(RoleID,UserID) Values('" + chkRole.Items[i].Value.ToString().Trim() + "','" + ID + "'); "; DBA.DbAccess.ExecNoQuery(CommandType.Text, sql); RoleFlag = true; } } if (!RoleFlag) { return "请给用户分配至少一个角色!"; } } using (DataClasses1DataContext db = new DataClasses1DataContext()) { db.Log = Console.Out; //取出 var user = db.TbUser.SingleOrDefault<TbUser>(s => s.ID.ToString() == ID); if (user == null) { return "未查询到符合条件的数据!"; } user.UserName = txtUserName.Text.ToString().Trim(); user.UserPWD = txtPWD.Text.ToString().Trim(); user.RealName = txtRealName.Text.ToString().Trim(); user.YongHuLeiXing = ddlYongHuLX.SelectedValue.ToString().Trim(); user.LianXiDianHua = txtDianHua.Text.ToString().Trim(); user.ShouJi = txtShouJi.Text.ToString().Trim(); user.TongXinDiZhi = txtDiZhi.Text.ToString().Trim(); user.EMail = txtYouXiang.Text.ToString().Trim(); user.SHFlag = 1; user.QiYeMingCheng = txtQiYeMingCheng.Text.ToString().Trim(); //执行更新操作 db.SubmitChanges(); } return ""; }
private void BindData(string ID) { //txtPWD.Enabled = false; //txtRealName.Enabled = false; txtUserName.Enabled = false; DataSet ds = new DataSet(); DataClasses1DataContext db = new DataClasses1DataContext(); var result = from item in db.TbUser where item.ID.ToString().Trim() == ID select item; if (result.Count() <= 0) { return; } txtUserName.Text = result.ToList()[0].UserName; txtRealName.Text = result.ToList()[0].RealName; txtPWD.Text = result.ToList()[0].UserPWD; hfPWD.Value = result.ToList()[0].UserPWD; ddlYongHuLX.SelectedValue = result.ToList()[0].YongHuLeiXing.ToString().Trim(); txtDianHua.Text = result.ToList()[0].LianXiDianHua; txtShouJi.Text = result.ToList()[0].ShouJi; txtDiZhi.Text = result.ToList()[0].TongXinDiZhi; txtYouXiang.Text = result.ToList()[0].EMail; txtQiYeMingCheng.Text = result.ToList()[0].QiYeMingCheng; var result2 = from item2 in db.UserRole where item2.UserID == Convert.ToInt32(ID) select item2; for (int i = 0; i < result2.Count(); i++) { for (int j = 0; j < chkRole.Items.Count; j++) { if (result2.ToList()[i].RoleID.ToString().Trim() == chkRole.Items[j].Value.ToString().Trim()) { chkRole.Items[j].Selected = true; } } } if (result2.Count() == 0) { for (int j = 0; j < chkRole.Items.Count; j++) { if (chkRole.Items[j].Text.ToString().Trim() == "注册用户") { chkRole.Items[j].Selected = true; } } } }
/// <summary> /// 取得企业用户的上级 /// </summary> /// <param name="ID"></param> /// <returns></returns> public static int getDepID(int ID) { DataClasses1DataContext db = new DataClasses1DataContext(); var result = from item in db.TbUser where item.DepartMentID == ID select item; if (result.Count() <= 0) { return 0; } return result.ToList()[0].ID; }
/// <summary> /// 栏目访问日志 /// </summary> /// <param name="LanMu"></param> public static void LogInsertLanMu(string LanMu) { TbLog tb = new TbLog(); tb.ShiJian = DateTime.Now; tb.LanMu = LanMu; using (DataClasses1DataContext db = new DataClasses1DataContext()) { db.Log = Console.Out; db.TbLog.InsertOnSubmit(tb); db.SubmitChanges(); } }
public static void SendMailLogInsert(string ShouJianRen, string YouJianMingCheng, string ZhuanLiQuYu, string FaSongZhuangTai) { TbSendMailLog tb = new TbSendMailLog(); tb.ShouJianRen = ShouJianRen; tb.YouJianMingCheng = YouJianMingCheng; tb.ZhuanLiQuYu = ZhuanLiQuYu; tb.FaSongShiJian = DateTime.Now; tb.FaSongZhuangTai = FaSongZhuangTai; using (DataClasses1DataContext db = new DataClasses1DataContext()) { db.Log = Console.Out; db.TbSendMailLog.InsertOnSubmit(tb); db.SubmitChanges(); } }
/// <summary> /// 记录栏目的访问日志 /// </summary> /// <param name="IP"></param> /// <param name="UserName"></param> /// <param name="YongHuLeiXing"></param> /// <param name="LanMu"></param> public static void LogInsert(string IP, string UserName, string YongHuLeiXing, string LanMu) { try { TbLog tb = new TbLog(); tb.ShiJian = DateTime.Now; tb.IP = IP; tb.UserName = UserName; tb.YongHuLeiXing = YongHuLeiXing; tb.LanMu = LanMu; string[] subIP = IP.Split('.'); if (subIP.Length == 4) { tb.DiQu = Stat.GetLocal(IP); } using (DataClasses1DataContext db = new DataClasses1DataContext()) { db.Log = Console.Out; db.TbLog.InsertOnSubmit(tb); db.SubmitChanges(); } } catch (Exception ex) { } }
public static bool TbLegalDel(string GuoBie) { DataClasses1DataContext db = new DataClasses1DataContext(); var tb = db.TbLegalUrl_Cfg.SingleOrDefault(o => o.CO == GuoBie); if (tb == null) { return false; } try { db.TbLegalUrl_Cfg.DeleteOnSubmit(tb); db.SubmitChanges(); } catch (Exception ex) { return false; } return true; }
public static bool TbLegalOperate(string GuoBie, string Des, string Url) { bool flag = false; DataClasses1DataContext db = new DataClasses1DataContext(); var result = from item in db.TbLegalUrl_Cfg where item.CO==GuoBie select item; if (result.Count() <= 0) { flag= TbLegalInsert(GuoBie, Des, Url); } else { flag= TbLegalUpdate(GuoBie, Des, Url); } return flag; }
public static List<TbIP> getTbIP() { DataClasses1DataContext db = new DataClasses1DataContext(); var result = from item in db.TbIP where item.IP != "glbalIpKey" select item; return result.ToList(); }
public static List<TbLog> QueryLog(string dateStart, string dateEnd ,string YongHuLX,string UserName) { DateTime dtStart = new DateTime(); DateTime dtEnd = new DateTime(); try { dtStart = Convert.ToDateTime(dateStart); } catch (Exception ex) { } try { dtEnd = Convert.ToDateTime(dateEnd); dtEnd = dtEnd.AddDays(1); } catch (Exception ex) { } DataClasses1DataContext db = new DataClasses1DataContext(); var result = from item in db.TbLog where item.YongHuLeiXing.Contains(YongHuLX) && item.UserName.Contains(UserName ) select item; if (dateStart != "") { result = result.Where(a => a.ShiJian >= dtStart); } if (dateEnd != "") { result = result.Where(a => a.ShiJian < dtEnd); } result = result.OrderByDescending(a => a.ID); return result.ToList(); }
/// <summary> /// 取得用户详细信息 /// </summary> /// <param name="UserID"></param> /// <returns></returns> public static TbUser getUserInfo(string UserID) { DataClasses1DataContext db = new DataClasses1DataContext(); Table<TbUser> tb = db.TbUser; var result = from item in tb where item.ID == Convert.ToInt32(UserID) select item; TbUser TbUser = result.First(); if (TbUser.DepartMentID == 0) { TbUser.QiYeID = TbUser.ID; } else { TbUser.QiYeID = TbUser.DepartMentID; } return TbUser; }
private string UserInsert() { string sql = ""; DataSet ds = new DataSet(); bool RoleFlag = false; if (this.txtUserName.Text.ToString().Trim() == "") { return "请输入登录名称!"; } if (this.txtRealName.Text.ToString().Trim() == "") { return "请输入真实姓名!"; } if (txtPWD.Text.ToString().Trim().Length > 50) { return "密码超长,请重新输入!"; } if (this.txtPWD.Text.ToString().Trim() == "") { return "请输入密码"; } sql = "Select * From TbUser Where UserName='******' "; ds = DBA.DbAccess.GetDataSet(CommandType.Text, sql); if (ds.Tables[0].Rows.Count > 0) { return "您录入的登录名已存在,请重新输入!"; } string sqlInsert = ""; //插入数据库项目名称,并返回当前插入行的ID if (false && hfUserLeiXing.Value.ToString().Trim() == "企业") { } else { for (int i = 0; i < chkRole.Items.Count; i++) { if (chkRole.Items[i].Selected) { sqlInsert += "Insert Into UserRole(RoleID,UserID) Values('" + chkRole.Items[i].Value.ToString().Trim() + "','@@@'); "; RoleFlag = true; } } if (!RoleFlag) { return "请给用户分配至少一个角色"; } } TbUser user = new TbUser(); user.UserName = txtUserName.Text.ToString().Trim(); user.UserPWD = txtPWD.Text.ToString().Trim(); user.RealName = txtRealName.Text.ToString().Trim(); user.YongHuLeiXing = ddlYongHuLX.SelectedValue.ToString().Trim(); user.LianXiDianHua = txtDianHua.Text.ToString().Trim(); user.ShouJi = txtShouJi.Text.ToString().Trim(); user.TongXinDiZhi = txtDiZhi.Text.ToString().Trim(); user.EMail = txtYouXiang.Text.ToString().Trim(); user.DepartMentID = 0; user.SHFlag = 1; user.QiYeMingCheng = txtQiYeMingCheng.Text.ToString().Trim(); //插入数据库项目名称,并返回当前插入行的ID if (hfUserLeiXing.Value.ToString().Trim() == "企业") { user.DepartMentID = Convert.ToInt32(Session["UserID"].ToString().Trim()); user.YongHuLeiXing = "企业"; } string DepID = UserRight.getDepartMentID(Session["UserID"].ToString()); if (DepID != "0") { user.DepartMentID = int.Parse(DepID); } using (DataClasses1DataContext db = new DataClasses1DataContext()) { db.Log = Console.Out; db.TbUser.InsertOnSubmit(user); db.SubmitChanges(); } // 企业用户新建出的用户角色 if (false && hfUserLeiXing.Value.ToString().Trim() == "企业") { DataClasses1DataContext db = new DataClasses1DataContext(); var result = from item in db.UserRole where item.UserID.ToString().Trim() == Session["UserID"].ToString().Trim() select item; foreach (var item in result) { UserRole userrole = new UserRole(); userrole.RoleID = item.RoleID; userrole.UserID = user.ID; db.UserRole.InsertOnSubmit(userrole); db.SubmitChanges(); } } else//系统用户建出的用户的角色 { sqlInsert = sqlInsert.Replace("@@@", user.ID.ToString().Trim()); DBA.DbAccess.ExecNoQuery(CommandType.Text, sqlInsert); } if (ddlYongHuLX.SelectedValue.ToString().Trim() == "企业") { string sqlZTK = "insert into ZtDbList(ztDbName,dbType,createUserId) values('企业在线数据库','1','" + user.ID + "')"; DBA.DbAccess.ExecNoQuery(CommandType.Text, sqlZTK); } string sqlShouCang = "insert into TLC_Albums (UserId,ParentId,Title,live,isdel,isparent) values('" + user.ID + "',0,'收藏夹',0,0,0)"; DBA.DbAccess.ExecNoQuery(CommandType.Text, sqlShouCang); return ""; }
public static void TbIpDel(int ID) { using (DataClasses1DataContext db = new DataClasses1DataContext()) { var tb = db.TbIP.Where(o => o.ID == ID); db.TbIP.DeleteAllOnSubmit(tb); db.SubmitChanges(); } }
public UserAccount Register(RegisterInf registerInf) { UserAccount userAccount = new UserAccount(); userAccount.isLogin = false; userAccount.haveMsg = false; if (registerInf == null) { userAccount.errorMsg = "注册信息不完整,请查看!"; } else { if (registerInf.txtUserName.Trim().Equals("")) { userAccount.errorMsg = "请输入登录名称!"; return userAccount; } string sql = "Select * From TbUser Where UserName='******'"; DataSet ds = DBA.DbAccess.GetDataSet(CommandType.Text, sql); if (ds.Tables[0].Rows.Count > 0) { userAccount.errorMsg = "您录入的登录名已存在,请重新输入!"; return userAccount; } if (registerInf.txtRealName.Trim() == "") { userAccount.errorMsg = "请输入真实姓名!"; return userAccount; } if (registerInf.txtPWD.Trim() == "") { userAccount.errorMsg = "请输入密码"; return userAccount; } if (registerInf.txtPWD.Trim().Length > 50) { userAccount.errorMsg = "密码超长,请重新输入!"; return userAccount; } //if (txtPWD.Text.ToString().Trim() != txtQueRen.Text.ToString().Trim()) //{ // return "您两次输入的密码不一致,请重新输入!"; //} if (registerInf.txtYouXiang.Trim() == "") { userAccount.errorMsg = "请输入您的邮箱地址!"; return userAccount; } TbUser user = new TbUser(); user.UserName = registerInf.txtUserName.Trim(); user.UserPWD = registerInf.txtPWD.Trim(); user.RealName = registerInf.txtRealName.Trim(); user.YongHuLeiXing = "个人"; user.LianXiDianHua = registerInf.txtDianHua.Trim(); user.ShouJi = registerInf.txtShouJi.Trim(); user.TongXinDiZhi = registerInf.txtDiZhi.Trim(); user.EMail = registerInf.txtYouXiang.Trim(); user.DepartMentID = 0; user.SHFlag = 0; using (DataClasses1DataContext db = new DataClasses1DataContext()) { db.Log = Console.Out; db.TbUser.InsertOnSubmit(user); db.SubmitChanges(); } string sqlShouCang = "insert into TLC_Albums (UserId,ParentId,Title,live,isdel,isparent) values('" + user.ID.ToString().Trim() + "',0,'收藏夹',0,0,0)"; DBA.DbAccess.ExecNoQuery(CommandType.Text, sqlShouCang); userAccount.isLogin = true; userAccount.userId = user.ID.ToString().Trim(); userAccount.userName = user.RealName.ToString().Trim(); } return userAccount; }
private static bool TbLegalUpdate(string GuoBie, string Des, string Url) { DataClasses1DataContext db = new DataClasses1DataContext(); var tb = db.TbLegalUrl_Cfg.SingleOrDefault(o => o.CO == GuoBie); if (tb == null) { return false; } tb.Des = Des; tb.LegUrl = Url; try { db.SubmitChanges(); } catch (Exception ex) { return false; } return true; }