protected void btnSave_Click(object sender, EventArgs e) { if (!txtOldPassword.Text.Equals(LoginUser.LoginUserPassword)) { AlertMessage("请输入正确密码!"); return; } if (txtNewPassword.Text != txtAgain.Text) { AlertMessage("二次输入密码不一致!"); return; } DirModel dml = new DirModel(); dml.Add("@user_password", txtAgain.Text); dml.Add("@user_no", LoginUser.LoginUser); UserLogic pageLogic = new UserLogic(); if (pageLogic.ChangeUserPassword(dml)) { if (Request.Cookies["xsCookie"] != null) { HttpCookie c*k = Request.Cookies["xsCookie"]; TimeSpan ts = new TimeSpan(-1, 0, 0, 0); c*k.Expires = DateTime.Now.Add(ts);//删除整个Cookie,只要把过期时间设置为现在 } AlertMessage("密码修改成功,需要重新登录才能生效."); } }
protected void btnSave_Click(object sender, EventArgs e) { DirModel dml = new DirModel(); //新增页面 string strid = "G" + DateTime.Now.ToString("yyyyMMddHHssmmm"); dml.Add("@group_id", strid); dml.Add("@group_name", txtgroupName.Text.Trim()); if (!pageLogic.ExistGroup(dml)) { dml.Add("@group_remark", txtgroupRemark.Text.Trim()); if (pageLogic.AddGroup(dml)) { AlertMessageAndGoTo("新增群组成功!", "/Page/P_System/Group.aspx"); } else { AlertMessageAndGoTo("新增群组失败!", "/Page/P_System/Group.aspx"); } } else { AlertMessage("群组已经存在!"); } }
/// <summary> /// 新增动态 /// </summary> /// <param name="dml"></param> /// <returns></returns> public bool InsertNew(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"insert into dbo.xs_new([new_title] ,[new_content] ,[create_time] ,[create_user] ,[update_user] ,[update_time] ,[new_type_id] ,[new_sort]) values (@new_title ,@new_content ,GETDATE() ,@create_user ,@create_user ,getdate() ,@new_type_id ,@new_sort)"; SqlHelper.Execute(sqlpara); return(true); }
/// <summary> /// 根据user绑定菜单 /// </summary> private void BindFunction() { MenuLogic logic = new MenuLogic(); DirModel dml = new DirModel(); dml.Add("@user_no", LoginUser.LoginUser); DataTable dtMenu = logic.QueryMenu(dml); StringBuilder strMenu = new StringBuilder(); DataRow[] drLevelones = dtMenu.Select("function_level=1", "function_sort asc"); foreach (DataRow drLevelone in drLevelones) { strMenu.Append(@"<li> <h4>" + drLevelone["function_name"].ToString() + @"</h4>"); DataRow[] drLeveltwos = dtMenu.Select("function_level=2 and function_parent_id='" + drLevelone["function_id"].ToString() + "'", "function_sort asc"); if (drLeveltwos.Length > 0) { strMenu.Append(@"<div class=""list-item none"">"); foreach (DataRow drLeveltwo in drLeveltwos) { strMenu.Append(@" <p> <a href=""" + drLeveltwo["function_url"].ToString() + @""" onclick="" return setUrl('" + drLeveltwo["function_url"].ToString() + @"')"">" + drLeveltwo["function_name"].ToString() + @"</a></p>"); } strMenu.Append(@" </div>"); } strMenu.Append(@" </li>"); } J_navlist.InnerHtml = strMenu.ToString(); }
private static DirContents FromDatabase(Credentials cr, MachineIdentity mid, DirIdentity did, bool downloadFilesContents = false) { List <FileContents> files = new List <FileContents>(); var c = cr.ToLib(); var m = mid.ToLib(); DirModel d = did.ToLib(); try { FileManipulator.GetFileList(c, m, d); foreach (FileModel f in d.Files) { if (downloadFilesContents) { //adding contents to 'f' FileManipulator.GetFileContent(c, m, d, f); } //adding new gui object to list files.Add(new FileContents(f)); } } catch (ActionException ex) { throw new ActionException("Unable to download directory contents.\n\n" + ex.Message + ".", ActionType.Directory, MemeType.Fuuuuu, ex); } catch (Exception ex) { throw new ActionException("Error while downloading directory contents.", ActionType.Directory, MemeType.Fuuuuu, ex); } //does not add local files, because this is supposed to happen in the constructor that // launches this static private method return(new DirContents(did, files, false)); }
DataTable dtHasAction = new DataTable(); //当前群组所拥有的群组 protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request["id"] != null) { string strGroupID = Request["id"].ToString(); DirModel dml = new DirModel(); dml.Add("@group_id", strGroupID); DataTable dt = pageLogic.QueryGroupByID(dml); if (dt.Rows.Count > 0) { lblName.Text = dt.Rows[0]["group_name"].ToString(); lblRemark.Text = dt.Rows[0]["group_remark"].ToString(); hidGroupID.Value = strGroupID; BindGrid(); } else { AlertMessageAndGoTo("页面错误", "/Page/P_System/Group.aspx"); } } else { AlertMessageAndGoTo("页面错误", "/Page/P_System/Group.aspx"); } } }
protected void btnSave_Click(object sender, EventArgs e) { DirModel dml = new DirModel(); dml.Add("@new_type_name", txtName.Text); dml.Add("@new_type_remark", txtRemark.Text); if (string.IsNullOrEmpty(ddlType.SelectedValue)) { //新增 dml.Add("@new_type_id", "NT" + DateTime.Now.ToString("yyyyMMddHHmmssfff")); if (pageLogic.InsertNewType(dml)) { AlertMessage("新增" + txtName.Text + "成功"); } else { AlertMessage("新增" + txtName.Text + "失败," + txtName.Text + "可能已经存在."); } } else { //维护 dml.Add("@new_type_id", ddlType.SelectedValue); if (pageLogic.UpdateNewType(dml)) { AlertMessage("更新" + txtName.Text + "成功"); } else { AlertMessage("更新" + txtName.Text + "失败"); } } BindType(); }
/// <summary> /// 通过id查询所有信息 /// </summary> /// <param name="dml"></param> /// <returns></returns> public DataTable QueryGroupByID(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"select * from [dbo].[xs_group] where [group_id]=@group_id"; return(SqlHelper.GetDataTable(sqlpara)); }
/// <summary> /// 是否存在群组名称 /// </summary> /// <param name="dml"></param> /// <returns></returns> public bool ExistGroup(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"select * from [dbo].[xs_group] where [group_id]<>@group_id and [group_name]=@group_name"; return(SqlHelper.Exist(sqlpara)); }
/// <summary> /// 判断用户存在 /// </summary> /// <param name="dml"></param> /// <returns></returns> public bool ExistUser(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"select * from [dbo].[xs_users] where [user_no]=@userid"; return(SqlHelper.Exist(sqlpara)); }
/// <summary> /// 招聘删除 /// </summary> /// <returns></returns> public bool DeleteHire(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"delete from [xs_hire] where [hire_id]=@hire_id"; SqlHelper.Execute(sqlpara); return(true); }
/// <summary> /// 更新群组 /// </summary> /// <returns></returns> public bool UpdateGroup(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"update [xs_group] set [group_name]=@group_name,[group_remark]=@group_remark where [group_id]=@group_id"; SqlHelper.Execute(sqlpara); return(true); }
/// <summary> /// 新增群组 /// </summary> /// <returns></returns> public bool AddGroup(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"insert into [xs_group]([group_id],[group_name],[group_remark])values(@group_id,@group_name,@group_remark)"; SqlHelper.Execute(sqlpara); return(true); }
/// <summary> /// 删除产品类别 /// </summary> /// <param name="dml"></param> /// <returns></returns> public bool DeleteProduct(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"delete from [dbo].[xs_product] where product_id=@product_id"; SqlHelper.Execute(sqlpara); return(true); }
/// <summary> /// 更新招聘模板 /// </summary> /// <returns></returns> public bool UpdateHireTemplate(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"update [xs_hire_template] set [hire_template_name]=@hire_template_name,[hire_template_content]=@hire_template_content where hire_template_id=@hire_template_id"; SqlHelper.Execute(sqlpara); return(true); }
/// <summary> /// 更新用户 /// </summary> /// <param name="dml"></param> /// <returns></returns> public bool UpdateUser(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"update [xs_users] set [user_name]=@userName where [user_no]=@userid update [xs_group_user] set [group_id]=@usergroup where [user_no]=@userid"; SqlHelper.Execute(sqlpara); return(true); }
/// <summary> /// 是否匹配账号密码 /// </summary> /// <param name="dml"></param> /// <returns></returns> public DataTable QueryUser(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"select u.user_no,u.user_name,u.[user_password],gu.group_id,g.group_name from xs_users u left join dbo.xs_group_user gu on gu.user_no=u.user_no left join dbo.xs_group g on g.group_id=gu.group_id where u.user_no=@user_no and u.user_password=@user_password"; return(SqlHelper.GetDataTable(sqlpara)); }
/// <summary> /// 新增招聘模板 /// </summary> /// <returns></returns> public bool AddHireTemplate(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"insert into [xs_hire_template]([hire_template_name],[hire_template_content]) values(@hire_template_name,@hire_template_content)"; SqlHelper.Execute(sqlpara); return(true); }
/// <summary> /// 删除用户 /// </summary> /// <param name="dml"></param> /// <returns></returns> public bool DeleteUser(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"delete from [xs_users]where [user_no]=@userid delete from [xs_group_user] where [user_no]=@userid"; SqlHelper.Execute(sqlpara); return(true); }
/// <summary> /// 更新招聘 /// </summary> /// <returns></returns> public bool UpdateHire(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"update [xs_hire] set [hire_name]=@hire_name,[hire_count]=@hire_count,[hire_place]=@hire_place ,[hire_remark]=@hire_remark where [hire_id]=@hire_id"; SqlHelper.Execute(sqlpara); return(true); }
/// <summary> /// 新增招聘 /// </summary> /// <returns></returns> public bool AddHire(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"insert into [dbo].[xs_hire]([hire_id],[hire_name],[hire_count],[hire_place],[hire_remark]) values (@hire_id ,@hire_name,@hire_count,@hire_place,@hire_remark)"; SqlHelper.Execute(sqlpara); return(true); }
/// <summary> /// 新增产品类别 /// </summary> /// <param name="dml"></param> /// <returns></returns> public bool InsertProductType(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"insert into xs_product_type([product_type_id],[product_type_name],[product_type_remark]) values(@producttype_id,@producttype_name,@producttype_remark)"; SqlHelper.Execute(sqlpara); return(true); }
/// <summary> /// 更新产品类别 /// </summary> /// <param name="dml"></param> /// <returns></returns> public bool UpdateProductType(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"update xs_product_type set [product_type_name]=@producttype_name,[product_type_remark]=@producttype_remark where [product_type_id]=@producttype_id"; SqlHelper.Execute(sqlpara); return(true); }
protected void lbtnDelete_Click(object sender, EventArgs e) { DirModel dml = new DirModel(); dml.Add("@product_id", (sender as LinkButton).CommandArgument); if (pageLogic.DeleteProduct(dml)) { AlertMessage("删除成功."); xsPage.RefreshPage(); } }
/// <summary> /// 删除动态类别 /// </summary> /// <param name="dml"></param> /// <returns></returns> public bool DeleteNewType(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"delete from dbo.xs_new_type where [new_type_id]=@new_type_id delete from dbo.xs_new where [new_type_id]=@new_type_id"; SqlHelper.Execute(sqlpara); return(true); }
/// <summary> /// 更新招聘 /// </summary> /// <returns></returns> public bool UpdateMain(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"update [xs_main] set [main_content]=@main_content,updateuser=@updateuser where [main_id]=@main_id "; SqlHelper.Execute(sqlpara); return(true); }
/// <summary> /// 判断用户存在 /// </summary> /// <param name="dml"></param> /// <returns></returns> public bool ChangeUserPassword(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"update dbo.xs_users set user_password=@user_password where user_no=@user_no"; SqlHelper.Execute(sqlpara); return(true); }
/// <summary> /// 删除群组 /// </summary> /// <returns></returns> public bool DeleteGroup(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"update [dbo].[xs_group_user] set [group_id]='G000' where [group_id]=@group_id delete from [xs_group] where [group_id]=@group_id delete from dbo.xs_group_user where [group_id]=@group_id delete from dbo.xs_group_function where [group_id]=@group_id "; SqlHelper.Execute(sqlpara); return(true); }
public ActionResult Browse() { string pathName = Request["PathName"]; string decodedPathName = MonoHelper.DecodeName(pathName); var root = new DirModel(decodedPathName); root.LoadSubDirs(); root.LoadFiles(); ViewData ["RootDir"] = root; return(View()); }
/// <summary> /// 新增用户 /// </summary> /// <param name="dml"></param> /// <returns></returns> public bool AddUser(DirModel dml) { xsSqlParameter sqlpara = new xsSqlParameter(); sqlpara.AddSqlParameter(dml); sqlpara.SqlConnectString = GlabalString.DBString; sqlpara.SQL = @"delete from [dbo].[xs_users] where [user_no]=@userid insert into [xs_users]([user_no],[user_name],[user_password]) values(@userid,@userName,@userpassword) delete from [dbo].[xs_group_user] where [user_no]=@userid insert into [xs_group_user]([group_id],[user_no]) values(@usergroup,@userid)"; SqlHelper.Execute(sqlpara); return(true); }
private void GenerateRandomNestedDirs() { #region 1st level for (int i = 0; i < 6; i++) { this.myDir = DirModel.GetDir("Dir", 1000); this.dirs.Add(this.myDir); } #endregion #region 2nd level foreach (DirModel dir in this.dirs) { for (int i = 0; i < 2; i++) { this.myDir = DirModel.GetDir("Sub-Dir", 1000); dir.SubDirs.Add(this.myDir); } } #endregion #region 3rd level foreach (DirModel dir in this.dirs) { foreach (DirModel subDir in dir.SubDirs) { for (int i = 0; i < 2; i++) { this.myDir = DirModel.GetDir("Sub-sub-Dir", 1000); subDir.SubDirs.Add(this.myDir); } } } #endregion #region 4th level foreach (DirModel dir in this.dirs) { foreach (DirModel subDir in dir.SubDirs) { foreach (DirModel subSubDir in subDir.SubDirs) { for (int i = 0; i < 2; i++) { this.myDir = DirModel.GetDir("Sub-sub-sub-Dir", 1000); subSubDir.SubDirs.Add(this.myDir); } } } } #endregion }
private void MoveThisDir(DirModel d) { if (d.IsSelected == true) { if (d.Parent == null) { this.dirs.Remove(d); this.processDirs.Add(d); } else { DirModel parent = d.Parent; parent.SubDirs.Remove(d); this.processDirs.Add(d); } } else if (d.IsSelected == null) { MessageBox.Show(d.DirDescription + " has sub-Dir not selected"); } else { MessageBox.Show("Please explicitly select " + d.DirDescription); } }