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));
}
