protected void Page_Load(object sender, EventArgs e)
{
//判断权限
if (!CheckGrant(global::Common.Enum.TravelPermission.系统设置_同行平台栏目))
{
Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.系统设置_同行平台栏目, false);
return;
}
if (!IsPostBack)
{
//初始化ssBLL
EyouSoft.BLL.SiteStructure.SiteFriendLink ssBLL = new EyouSoft.BLL.SiteStructure.SiteFriendLink();
//初始化Model
EyouSoft.Model.SiteStructure.SiteFriendLink ssModel = new EyouSoft.Model.SiteStructure.SiteFriendLink();
//////////////修改时加载原有数据
if (Utils.GetQueryStringValue("type") == "modify")
{
//获取id
id = Utils.GetInt(Utils.GetQueryStringValue("tid"));
//获取Model
ssModel = ssBLL.GetSiteFriendLink(id, SiteUserInfo.CompanyID);
//友情链接文字
txt_LinkName.Text = ssModel.LinkName;
//友情连接URL
txt_linkURL.Text = ssModel.LinkUrl;
}
////////////////////////////////
}
}
private void Save()
{
//初始化Model
EyouSoft.Model.SiteStructure.SiteFriendLink ssModel = new EyouSoft.Model.SiteStructure.SiteFriendLink();
//初始化BLL
EyouSoft.BLL.SiteStructure.SiteFriendLink ssBLL = new EyouSoft.BLL.SiteStructure.SiteFriendLink();
//判断操作
if (Utils.GetQueryStringValue("type") == "modify")//修改操作
{
//获取id
id = Utils.GetInt(Utils.GetQueryStringValue("tid"));
//获取Model
ssModel = ssBLL.GetSiteFriendLink(id, SiteUserInfo.CompanyID);
}
else
{
//友情链接添加时间
ssModel.CreateTime = DateTime.Now;
}
//公司编号
ssModel.CompanyId = SiteUserInfo.CompanyID;
//判断友情链接文字是否为空
if (txt_LinkName.Text.Trim() == "")
{
MessageBox.ResponseScript(this, ";alert('友情链接文字不能为空!');");
}
//友情链接文字赋值
ssModel.LinkName = Utils.EditInputText(txt_LinkName.Text);
//友情链接URL
ssModel.LinkUrl = Utils.EditInputText(txt_linkURL.Text);
//友情链接类型
ssModel.LinkType = EyouSoft.Model.EnumType.SiteStructure.LinkType.文字;
//数据 保存是否成功，默认保存失败
bool res = false;
//判断添加或修改
if (id > 0)
{
res = ssBLL.UpdateFriendLink(ssModel);
}
else
{
res = ssBLL.AddFriendLink(ssModel);
}
//判断添加或修改成功否
if (res)
{
/////////////////////////保存成功
MessageBox.ResponseScript(this, string.Format(";alert('{0}');window.parent.Boxy.getIframeDialog('{1}').hide();{2}", "保存成功!", Utils.GetQueryStringValue("iframeId"), id > 0 ? "window.parent.location.reload();" : "window.parent.location.href='/systemset/ToGoTerrace/FriendshipLink.aspx';"));
////////////////////////////////////////////
}
else
{
MessageBox.ResponseScript(this, ";alert('保存失败!');");
}
}
/// <summary>
/// 添加友情链接
/// </summary>
/// <param name="SiteFriendLink"></param>
/// <returns></returns>
public bool AddFriendLink(EyouSoft.Model.SiteStructure.SiteFriendLink SiteFriendLink)
{
string SQL = "INSERT INTO [tbl_SiteFriendLink]([CompanyId],[LinkName],[LinkUrl],[FilePath],[LinkType],[SortId]) VALUES(@CompanyId,@LinkName,@LinkUrl,@FilePath,@LinkType,@SortId)";
DbCommand dc = this.DB.GetSqlStringCommand(SQL);
this.DB.AddInParameter(dc, "CompanyId", DbType.Int32, SiteFriendLink.CompanyId);
this.DB.AddInParameter(dc, "LinkUrl", DbType.String, SiteFriendLink.LinkUrl);
this.DB.AddInParameter(dc, "LinkName", DbType.String, SiteFriendLink.LinkName);
this.DB.AddInParameter(dc, "FilePath", DbType.String, SiteFriendLink.FilePath);
this.DB.AddInParameter(dc, "LinkType", DbType.Byte, (int)SiteFriendLink.LinkType);
this.DB.AddInParameter(dc, "SortId", DbType.Int32, SiteFriendLink.SortId);
return(DbHelper.ExecuteSql(dc, this.DB) > 0 ? true : false);
}
/// <summary>
/// 修改友情链接
/// </summary>
/// <param name="SiteFriendLink"></param>
/// <returns></returns>
public bool UpdateFriendLink(EyouSoft.Model.SiteStructure.SiteFriendLink SiteFriendLink)
{
string SQL = "UPDATE [tbl_SiteFriendLink] SET [LinkName]=@LinkName,[LinkUrl]=@LinkUrl,[FilePath]=@FilePath,[LinkType]=@LinkType,[SortId]=@SortId WHERE [LinkId]=@LinkId AND [CompanyId]=@CompanyId";
DbCommand dc = this.DB.GetSqlStringCommand(SQL);
this.DB.AddInParameter(dc, "LinkId", DbType.Int32, SiteFriendLink.Id);
this.DB.AddInParameter(dc, "CompanyId", DbType.Int32, SiteFriendLink.CompanyId);
this.DB.AddInParameter(dc, "LinkUrl", DbType.String, SiteFriendLink.LinkUrl);
this.DB.AddInParameter(dc, "LinkName", DbType.String, SiteFriendLink.LinkName);
this.DB.AddInParameter(dc, "FilePath", DbType.String, SiteFriendLink.FilePath);
this.DB.AddInParameter(dc, "LinkType", DbType.Byte, (int)SiteFriendLink.LinkType);
this.DB.AddInParameter(dc, "SortId", DbType.Int32, SiteFriendLink.SortId);
return(DbHelper.ExecuteSql(dc, this.DB) > 0 ? true : false);
}
private void Bind()
{
//友情链接BLL
EyouSoft.BLL.SiteStructure.SiteFriendLink ssBLL = new EyouSoft.BLL.SiteStructure.SiteFriendLink();
//友情链接Model
EyouSoft.Model.SiteStructure.SiteFriendLink ssModel = new EyouSoft.Model.SiteStructure.SiteFriendLink();
//获取友情链接列表
list = ssBLL.GetSiteFriendLink(SiteUserInfo.CompanyID, pageSize, pageIndex, ref recordCount);
//判断列表条数
if (list != null && list.Count > 0)
{
rptList.DataSource = list;
rptList.DataBind();
this.lblMsg.Visible = false;
}
else
{
this.ExporPageInfoSelect1.Visible = false;
this.lblMsg.Visible = true;
}
BindPage();
}
/// <summary>
/// 获得当前公司的友情链接列表
/// </summary>
/// <param name="companyId">专线公司编号</param>
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public IList <EyouSoft.Model.SiteStructure.SiteFriendLink> GetSiteFriendLink(int CompanyId, int pageSize, int pageIndex, ref int recordCount)
{
IList <EyouSoft.Model.SiteStructure.SiteFriendLink> items = new List <EyouSoft.Model.SiteStructure.SiteFriendLink>();
EyouSoft.Model.SiteStructure.SiteFriendLink item = null;
StringBuilder cmdQuery = new StringBuilder();
string tableName = "tbl_SiteFriendLink";
string primaryKey = "LinkId";
string orderByString = "SortId ASC";
StringBuilder fields = new StringBuilder();
#region 要查询的字段
fields.Append("LinkId,CompanyId,LinkType,LinkName,FilePath,LinkUrl,SortId,CreateTime");
#endregion
#region 拼接查询条件
cmdQuery.AppendFormat(" CompanyId={0}", CompanyId);
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader(this.DB, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields.ToString(), cmdQuery.ToString(), orderByString))
{
while (rdr.Read())
{
item = new EyouSoft.Model.SiteStructure.SiteFriendLink()
{
Id = rdr.GetInt32(rdr.GetOrdinal("LinkId")),
CompanyId = rdr.IsDBNull(rdr.GetOrdinal("CompanyId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("CompanyId")),
LinkName = rdr["LinkName"].ToString(),
LinkUrl = rdr["LinkUrl"].ToString(),
FilePath = rdr["FilePath"].ToString(),
LinkType = (EyouSoft.Model.EnumType.SiteStructure.LinkType)(rdr.IsDBNull(rdr.GetOrdinal("LinkType")) ? 0 : rdr.GetByte(rdr.GetOrdinal("LinkType"))),
SortId = rdr.IsDBNull(rdr.GetOrdinal("SortId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("SortId")),
CreateTime = rdr.IsDBNull(rdr.GetOrdinal("CreateTime")) ? System.DateTime.Now : rdr.GetDateTime(rdr.GetOrdinal("CreateTime"))
};
items.Add(item);
}
}
return(items);
}
/// <summary>
/// 获得友情链接实体信息
/// </summary>
/// <param name="companyId"></param>
/// <param name="Id"></param>
/// <returns></returns>
public EyouSoft.Model.SiteStructure.SiteFriendLink GetSiteFriendLink(int Id, int CompanyId)
{
EyouSoft.Model.SiteStructure.SiteFriendLink SiteFriendLink = null;
DbCommand dc = this.DB.GetSqlStringCommand(String.Format("SELECT * FROM [tbl_SiteFriendLink] WHERE [LinkId]={0} AND [CompanyId]={1}", Id, CompanyId));
using (IDataReader rdr = DbHelper.ExecuteReader(dc, this.DB))
{
while (rdr.Read())
{
SiteFriendLink = new EyouSoft.Model.SiteStructure.SiteFriendLink()
{
Id = rdr.GetInt32(rdr.GetOrdinal("LinkId")),
CompanyId = rdr.IsDBNull(rdr.GetOrdinal("CompanyId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("CompanyId")),
LinkName = rdr["LinkName"].ToString(),
LinkUrl = rdr["LinkUrl"].ToString(),
FilePath = rdr["FilePath"].ToString(),
LinkType = (EyouSoft.Model.EnumType.SiteStructure.LinkType)(rdr.IsDBNull(rdr.GetOrdinal("LinkType")) ? 0 : rdr.GetByte(rdr.GetOrdinal("LinkType"))),
SortId = rdr.IsDBNull(rdr.GetOrdinal("SortId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("SortId")),
CreateTime = rdr.IsDBNull(rdr.GetOrdinal("CreateTime")) ? System.DateTime.Now : rdr.GetDateTime(rdr.GetOrdinal("CreateTime"))
};
}
}
return(SiteFriendLink);
}
/// <summary>
/// 修改友情链接
/// </summary>
/// <param name="SiteFriendLink"></param>
/// <returns></returns>
public bool UpdateFriendLink(EyouSoft.Model.SiteStructure.SiteFriendLink SiteFriendLink)
{
if (SiteFriendLink == null || SiteFriendLink.CompanyId == 0 || SiteFriendLink.Id==0) return false;
return idal.UpdateFriendLink(SiteFriendLink);
}
