protected void lnk_Delete_Click(object sender, System.EventArgs e) { if (!base.IsAuthorizedOp(ActionType.Delete.ToString())) { base.ShowAjaxMsg(this.UpdatePanel1, "Không có thẩm quyền"); } else { int @int = WebUtils.GetInt((sender as LinkButton).CommandArgument); LinksInfo dataById = Links.GetDataById(@int); if (dataById == null) { base.ShowAjaxMsg(this.UpdatePanel1, "Những thông tin này không được tìm thấy, các dữ liệu không tồn tại hoặc đã bị xóa"); } else if (Links.Delete(@int)) { this.BindData(); PageBase.log.AddEvent(base.LoginAccount.AccountName, "删除链接[" + dataById.LinkName + "] thành công"); base.ShowAjaxMsg(this.UpdatePanel1, "Thao tác thành công"); } else { base.ShowAjaxMsg(this.UpdatePanel1, "Thao tác thất bại"); } } }
private void UpdateLinksInfo() { UnionSubQuery unionSubQuery = Builder.ActiveUnionSubQuery; StringBuilder stringBuilder = new StringBuilder(); LinksInfo.DumpLinksInfoFromUnionSubQuery(stringBuilder, unionSubQuery); tbLinks.Text = stringBuilder.ToString(); }
private void InitForModify() { LinksInfo dataById = Links.GetDataById(base.OpID); this.TextBox1.Text = dataById.LinkName; this.TextBox2.Text = dataById.LinkUrl; this.TextBox3.Text = dataById.LinkImage; this.Image1.ImageUrl = dataById.LinkImage; this.Image1.Attributes.Add("data-original", dataById.LinkImage); }
private void btnNapDL_Click(object sender, EventArgs e) { for (int k = 0; k < this._ribbon.Pages.Count; k++) { RibbonPageGroupCollection pgColection = this._ribbon.Pages[k].Groups; string prID = this._ribbon.Pages[k].Name; // pgColection[k].Name.ToString(); string prName = this._ribbon.Pages[k].Text; for (int j = 0; j < pgColection.Count; j++) { if (pgColection[j].Name.Contains("_ck")) { continue; //bỏ qua những group tên có dạng _ck } RibbonPageGroupItemLinkCollection colection = pgColection[j].ItemLinks; for (int i = 0; i < colection.Count; i++) { if (colection[i].Item.Name.Contains("_ck")) { continue; //bỏ qua những item tên có dạng _ck vì ko có trong bảng danh mục chức năng } ChucNangInfor objChucNang = new ChucNangInfor(); objChucNang.ParentId = prID; objChucNang.ParentName = prName; objChucNang.MaChucNang = colection[i].Item.Name; objChucNang.TenChucNang = colection[i].Item.Caption; ChucNangDataProvider.InsertIfNotExist(objChucNang); if (colection[i].Item is BarSubItem) { LinksInfo linksInfo = ((BarSubItem)colection[i].Item).LinksPersistInfo; for (int l = 0; l < linksInfo.Count; l++) { if (linksInfo[l].Item.Name.Contains("_ck")) { continue; } ChucNangInfor objSubChucNang = new ChucNangInfor(); objSubChucNang.ParentId = objChucNang.MaChucNang; objSubChucNang.ParentName = objChucNang.TenChucNang; objSubChucNang.MaChucNang = linksInfo[l].Item.Name; objSubChucNang.TenChucNang = linksInfo[l].Item.Caption; ChucNangDataProvider.InsertIfNotExist(objSubChucNang); } } } } } LoadAllChucNang(); MessageBox.Show("Nạp dữ liệu thành công!"); }
public static int Add(LinksInfo entity) { int result; if (entity == null) { result = 0; } else { result = BizBase.dbo.InsertModel <LinksInfo>(entity); } return(result); }
protected void Page_Load(object sender, EventArgs e) { if (Tools.GetQueryString("action").ToLower() == "add") { string LinkType = Tools.GetForm("LinkType"); string SiteName = Tools.GetForm("SiteName"); string SiteDomain = Tools.GetForm("SiteDomain"); string LogoAddress = Tools.GetForm("LogoAddress"); string LogoWidth = Tools.GetForm("LogoWidth"); string LogoHeight = Tools.GetForm("LogoHeight"); if (SiteName == string.Empty) { ShowWindow(1, "系统提示", "请填写网站名称", null, true); } else if (SiteDomain == string.Empty) { ShowWindow(1, "系统提示", "请填写网站域名", null, true); } else if (LinkType == "2" && LogoAddress == string.Empty) { ShowWindow(1, "系统提示", "请填写Logo地址", null, true); } else if (LinkType == "2" && LogoWidth == string.Empty) { ShowWindow(1, "系统提示", "请填写Logo宽度", null, true); } else if (LinkType == "2" && LogoHeight == string.Empty) { ShowWindow(1, "系统提示", "请填写Logo高度", null, true); } else { LinksInfo LInfo = new LinksInfo(); LInfo.SiteName = SiteName; LInfo.SiteDomain = SiteDomain; LInfo.LogoAddress = LogoAddress; LInfo.LogoWidth = LogoWidth; LInfo.LogoHeight = LogoHeight; if (new BLL.Links.Links().Add(LInfo) != 0) { ShowWindow(3, "系统提示", "友情链接添加成功,点击 \\\"确定\\\" 按钮返回友情链接列表页面", "links.aspx", false); } else { ShowWindow(4, "系统提示", "友情链接添加失败", null, true); } } } }
public int Add(LinksInfo LInfo) { SqlParameter[] MyPar = new SqlParameter[5]; MyPar[0] = new SqlParameter("@SiteName", SqlDbType.NVarChar, 50); MyPar[0].Value = LInfo.SiteName; MyPar[1] = new SqlParameter("@SiteDomain", SqlDbType.NVarChar, 50); MyPar[1].Value = LInfo.SiteDomain; MyPar[2] = new SqlParameter("@LogoAddress", SqlDbType.NVarChar, 50); MyPar[2].Value = LInfo.LogoAddress; MyPar[3] = new SqlParameter("@LogoWidth", SqlDbType.NVarChar, 10); MyPar[3].Value = LInfo.LogoWidth; MyPar[4] = new SqlParameter("@LogoHeight", SqlDbType.NVarChar, 10); MyPar[4].Value = LInfo.LogoHeight; string sql = "insert into [" + Pre + "_Links]([SiteName],[SiteDomain],[LogoAddress],[LogoWidth],[LogoHeight]) values(@SiteName,@SiteDomain,@LogoAddress,@LogoWidth,@LogoHeight)"; return(SqlHelper.ExecuteNonQuery(ConnStr, CommandType.Text, sql, MyPar)); }
private IList <LinksInfo> DrRead(SqlDataReader dr) { IList <LinksInfo> LInfoList = new List <LinksInfo>(); while (dr.Read()) { LinksInfo LInfo = new LinksInfo(); LInfo.ID = Convert.ToInt32(dr["ID"]); LInfo.SiteName = Convert.ToString(dr["SiteName"]); LInfo.SiteDomain = Convert.ToString(dr["SiteDomain"]); LInfo.LogoAddress = Convert.ToString(dr["LogoAddress"]); LInfo.LogoWidth = Convert.ToString(dr["LogoWidth"]); LInfo.LogoHeight = Convert.ToString(dr["LogoHeight"]); LInfo.CreateDate = Convert.ToDateTime(dr["CreateDate"]); LInfoList.Add(LInfo); } dr.Close(); return(LInfoList); }
public int Save(LinksInfo LInfo) { SqlParameter[] MyPar = new SqlParameter[6]; MyPar[0] = new SqlParameter("@ID", SqlDbType.Int, 4); MyPar[0].Value = LInfo.ID; MyPar[1] = new SqlParameter("@SiteName", SqlDbType.NVarChar, 50); MyPar[1].Value = LInfo.SiteName; MyPar[2] = new SqlParameter("@SiteDomain", SqlDbType.NVarChar, 50); MyPar[2].Value = LInfo.SiteDomain; MyPar[3] = new SqlParameter("@LogoAddress", SqlDbType.NVarChar, 50); MyPar[3].Value = LInfo.LogoAddress; MyPar[4] = new SqlParameter("@LogoWidth", SqlDbType.NVarChar, 10); MyPar[4].Value = LInfo.LogoWidth; MyPar[5] = new SqlParameter("@LogoHeight", SqlDbType.NVarChar, 10); MyPar[5].Value = LInfo.LogoHeight; string sql = "update [" + Pre + "_Links] set [SiteName]=@SiteName,[SiteDomain]=@SiteDomain,[LogoAddress]=@LogoAddress,[LogoWidth]=@LogoWidth,[LogoHeight]=@LogoHeight where [ID]=@ID"; return(SqlHelper.ExecuteNonQuery(ConnStr, CommandType.Text, sql, MyPar)); }
public MyBar(BarManager manager, string name, BarDockStyle ADockStyle, BarOptionFlags AOptions, System.Drawing.Rectangle floatRect, LinksInfo linksInfo, System.Drawing.Point dockPos, int offset, BarCanDockStyle canDockStyle) : base(manager, name, ADockStyle, AOptions, floatRect, linksInfo, dockPos, offset, canDockStyle) { }
public MyBar(BarManager manager, string name, BarDockStyle ADockStyle, BarOptionFlags AOptions, System.Drawing.Rectangle floatRect, LinksInfo linksInfo) : base(manager, name, ADockStyle, AOptions, floatRect, linksInfo) { }
protected void Page_Load(object sender, EventArgs e) { try { ID = Convert.ToInt32(Tools.GetQueryString("id")); } catch { ShowWindow(4, "系统提示", "参数类型不正确", null, true); } LInfo = new BLL.Links.Links().GetByID(ID); if (Tools.GetQueryString("action").ToLower() == "save" && LInfo != null) { string LinkType = Tools.GetForm("LinkType"); string SiteName = Tools.GetForm("SiteName"); string SiteDomain = Tools.GetForm("SiteDomain"); string LogoAddress = Tools.GetForm("LogoAddress"); string LogoWidth = Tools.GetForm("LogoWidth"); string LogoHeight = Tools.GetForm("LogoHeight"); if (SiteName == string.Empty) { ShowWindow(1, "系统提示", "请填写网站名称", null, true); } else if (SiteDomain == string.Empty) { ShowWindow(1, "系统提示", "请填写网站域名", null, true); } else if (LinkType == "2" && LogoAddress == string.Empty) { ShowWindow(1, "系统提示", "请填写Logo地址", null, true); } else if (LinkType == "2" && LogoWidth == string.Empty) { ShowWindow(1, "系统提示", "请填写Logo宽度", null, true); } else if (LinkType == "2" && LogoHeight == string.Empty) { ShowWindow(1, "系统提示", "请填写Logo高度", null, true); } else { if (LinkType == "1") { LogoAddress = ""; LogoWidth = ""; LogoHeight = ""; } LInfo.SiteName = SiteName; LInfo.SiteDomain = SiteDomain; LInfo.LogoAddress = LogoAddress; LInfo.LogoWidth = LogoWidth; LInfo.LogoHeight = LogoHeight; if (new BLL.Links.Links().Save(LInfo) != 0) { ShowWindow(3, "系统提示", "友情链接保存成功,点击 \\\"确定\\\" 按钮返回", "links.aspx?p=" + Tools.GetQueryString("p"), false); } else { ShowWindow(4, "系统提示", "友情链接保存失败", null, true); } } } }
public int Save(LinksInfo LInfo) { return(dal.Save(LInfo)); }
protected void btnok_Click(object sender, System.EventArgs e) { if (base.Action.Equals(ActionType.Add.ToString()) && !base.IsAuthorizedOp(ActionType.Add.ToString())) { base.ShowMsg("Không có thẩm quyền"); } else if (base.Action.Equals(ActionType.Modify.ToString()) && !base.IsAuthorizedOp(ActionType.Modify.ToString())) { base.ShowMsg("Không có thẩm quyền"); } else { LinksInfo linksInfo = new LinksInfo(); if (base.IsEdit) { linksInfo = Links.GetDataById(base.OpID); } linksInfo.LinkName = WebUtils.GetString(this.TextBox1.Text); linksInfo.LinkUrl = WebUtils.GetString(this.TextBox2.Text); linksInfo.LinkImage = WebUtils.GetString(this.TextBox3.Text); linksInfo.LInkFlash = string.Empty; linksInfo.Sort = Links.MaxSort + 1; linksInfo.IsAudit = true; linksInfo.Lang = base.cultureLang; if (!string.IsNullOrEmpty(linksInfo.LinkImage)) { linksInfo.LinkType = "图片链接"; } else if (!string.IsNullOrEmpty(linksInfo.LInkFlash)) { linksInfo.LinkType = "flash链接"; } else { linksInfo.LinkType = "文字链接"; } if (string.IsNullOrEmpty(linksInfo.LinkName) || string.IsNullOrEmpty(linksInfo.LinkUrl)) { base.ShowMsg("请输入友链名称和友链地址"); } else { if (base.Action.Equals(ActionType.Add.ToString())) { linksInfo.AutoTimeStamp = System.DateTime.Now; if (Links.Add(linksInfo) > 0) { PageBase.log.AddEvent(base.LoginAccount.AccountName, "添加友链[" + linksInfo.LinkName + "] thành công"); base.Response.Redirect(string.Concat(new object[] { "FriendLink.aspx?CatalogID=", base.CurrentCatalogID, "&Module=", base.CurrentModuleCode, "&action=View" })); } else { base.ShowMsg("Thao tác thất bại"); } } if (base.Action.Equals(ActionType.Modify.ToString())) { if (Links.Update(linksInfo)) { PageBase.log.AddEvent(base.LoginAccount.AccountName, "修改友链[" + linksInfo.LinkName + "] thành công"); base.Response.Redirect(string.Concat(new object[] { "FriendLink.aspx?CatalogID=", base.CurrentCatalogID, "&Module=", base.CurrentModuleCode, "&action=View" })); } else { base.ShowMsg("Thao tác thất bại"); } } } } }
public static bool Update(LinksInfo entity) { return(entity != null && BizBase.dbo.UpdateModel <LinksInfo>(entity)); }
public MyBar(BarManager manager, string name, BarDockStyle ADockStyle, BarOptionFlags AOptions, System.Drawing.Rectangle floatRect, LinksInfo linksInfo, System.Drawing.Point dockPos, int offset, BarCanDockStyle canDockStyle, System.Drawing.Color backColor, System.Drawing.Image backImage, int barItemHorzIndent, int barItemVertIndent) : base(manager, name, ADockStyle, AOptions, floatRect, linksInfo, dockPos, offset, canDockStyle, backColor, backImage, barItemHorzIndent, barItemVertIndent) { }
private static BarEditItem AddTuyBienCot(BarManager barManager, LinksInfo linksInfo, string caption, GridView gridView, GridColumn[] excludeColumns, params string[] defaultColumns) { var repositoryItemCheckedCotHienThi = new RepositoryItemCheckedComboBoxEdit { AutoHeight = false, BestFitWidth = 180, Name = "repositoryItemCheckedCotHienThi" }; // // repositoryItemCheckedCotHienThi // // var barEditItemCotHienThi = new BarEditItem { Caption = string.IsNullOrEmpty(caption) ? "&Cột hiển thị" : caption, Edit = repositoryItemCheckedCotHienThi, Name = "barEditItem1", PaintStyle = BarItemPaintStyle.CaptionGlyph, Width = 200 }; // // barEditItemCotHienThi // // barManager.Items.Add(barEditItemCotHienThi); barManager.RepositoryItems.AddRange(new RepositoryItem[] { repositoryItemCheckedCotHienThi }); // linksInfo.Add(new LinkPersistInfo(barEditItemCotHienThi, true)); //Gán. các cột vào CheckedComboBox var columns = gridView.Columns.Cast<GridColumn>().OrderBy(cl => cl.Caption); if (excludeColumns == null || excludeColumns.Length == 0) { foreach (GridColumn column in columns) { //repositoryItemCheckedCotHienThi.Items.Add(column.Name, column.Caption); repositoryItemCheckedCotHienThi.Items.Add(column, !string.IsNullOrEmpty(column.CustomizationCaption) ? column.CustomizationCaption : column.Caption); } } else { var listExcludeCol = new List<GridColumn>(excludeColumns); foreach (GridColumn column in columns) { if (listExcludeCol.Any(c => c.Name == column.Name)) { column.Visible = false; column.OptionsColumn.AllowShowHide = false; continue; } //repositoryItemCheckedCotHienThi.Items.Add(column.Name, column.Caption); repositoryItemCheckedCotHienThi.Items.Add(column, !string.IsNullOrEmpty(column.CustomizationCaption) ? column.CustomizationCaption : column.Caption); } } //------------------------------- // repositoryItemCheckedCotHienThi.CloseUp += delegate(object sender, CloseUpEventArgs e) { var value = new StringBuilder(); foreach ( CheckedListBoxItem item in (sender as CheckedComboBoxEdit).Properties.Items) { if (item.CheckState == CheckState.Checked) { value.Append(" " + item.Description + (sender as CheckedComboBoxEdit). Properties.SeparatorChar. ToString()); ((GridColumn)item.Value).Visible = true; } else { ((GridColumn)item.Value).Visible = false; } } e.Value = value.Length > 0 ? value.ToString().Remove(value.Length - 1) : string.Empty; gridView.BestFitColumns(); }; // //Kiểm tra đã tồn tại layout cho gridView var str = new StringBuilder(FrameworkParams.currentUser.username); str.Append(gridView.GridControl.FindForm().Name + gridView.GridControl.Name + gridView.Name); var listFile = new List<FileInfo>(new DirectoryInfo(FrameworkParams.LAYOUT_FOLDER).GetFiles()); if (listFile.Exists(delegate(FileInfo e) { if (e.Name.Length >= str.Length) return String.CompareOrdinal(str.ToString(), e.Name.Substring(0, str.Length)) == 0; return false; })) { defaultColumns = null; gridView.GridControl.Load += delegate { var displayText = new StringBuilder(); var listDefaultColumn = (from GridColumn column in gridView.Columns where column.Visible || column.GroupIndex >= 0 select column.Name).ToList(); for (int i = 0; i < repositoryItemCheckedCotHienThi.Items.Count; i++) { var temp = (GridColumn)repositoryItemCheckedCotHienThi.Items[i].Value; if (listDefaultColumn.Contains(temp.Name)) { repositoryItemCheckedCotHienThi.Items[i].CheckState = CheckState.Checked; displayText.Append(" " + repositoryItemCheckedCotHienThi.Items[i] .Description + repositoryItemCheckedCotHienThi. SeparatorChar.ToString()); temp.Visible = true; } else temp.Visible = false; } if (displayText.ToString() != string.Empty) barEditItemCotHienThi.EditValue = displayText.ToString().Remove(displayText.Length - 1); repositoryItemCheckedCotHienThi. SynchronizeEditValueWithCheckedItems = false; }; } //------------------------------ //Set các cột hiển thị mặc định if (defaultColumns != null) { var listDefaultColumn = new List<string>(defaultColumns); var displayText = new StringBuilder(); for (int i = 0; i < repositoryItemCheckedCotHienThi.Items.Count; i++) { var temp = (GridColumn)repositoryItemCheckedCotHienThi.Items[i].Value; if (listDefaultColumn.Contains(temp.Name)) { repositoryItemCheckedCotHienThi.Items[i].CheckState = CheckState.Checked; displayText.Append(" " + repositoryItemCheckedCotHienThi.Items[i].Description + repositoryItemCheckedCotHienThi.SeparatorChar.ToString()); temp.Visible = true; } else temp.Visible = false; } if (displayText.ToString() != string.Empty) barEditItemCotHienThi.EditValue = displayText.ToString().Remove(displayText.Length - 1); repositoryItemCheckedCotHienThi.SynchronizeEditValueWithCheckedItems = false; // DisplayTheoTuyBienCot(gridView, repositoryItemCheckedCotHienThi); } gridView.ColumnPositionChanged += delegate(object sender, EventArgs e) { var col = (GridColumn)sender; CheckedListBoxItem item = repositoryItemCheckedCotHienThi.Items[col]; if (item == null) return; item.CheckState = col.Visible ? CheckState.Checked : CheckState.Unchecked; barEditItemCotHienThi.EditValue = repositoryItemCheckedCotHienThi.GetCheckedItems().ToString(); }; return barEditItemCotHienThi; }
public int Add(LinksInfo LInfo) { return(dal.Add(LInfo)); }