protected void Page_Load(object sender, EventArgs e)
{
//权限判断
YuYingPermission[] parms = { YuYingPermission.平台管理_管理该栏目, YuYingPermission.平台管理_战略合作伙伴 };
if (!CheckMasterGrant(parms))
{
Utils.ResponseNoPermit(YuYingPermission.平台管理_战略合作伙伴, true);
return;
}
if (!string.IsNullOrEmpty(Utils.InputText(Context.Request.QueryString["EditID"])))
{
//修改操作
EditeID = Utils.GetInt(Context.Request.QueryString["EditID"]);
//初始化要修改的数据
if (!IsPostBack)
{
EyouSoft.Model.SystemStructure.SysFriendLink LinkModel = EyouSoft.BLL.SystemStructure.SysFriendLink.CreateInstance().GetSysFriendLinkModel(EditeID);
if (LinkModel != null)
{
this.txtWordRemark.Value = LinkModel.LinkName;
this.txtAddress.Value = LinkModel.LinkAddress;
if (!string.IsNullOrEmpty(LinkModel.ImgPath))
{
img_Path = string.Format("<a href=\"{0}\"target='_blank' title=\"点击查看\">{1}</a>", Domain.FileSystem + LinkModel.ImgPath, LinkModel.ImgPath.Substring(LinkModel.ImgPath.LastIndexOf('/') + 1));
hdfAgoImgPath.Value = LinkModel.ImgPath;
}
}
//释放资源
LinkModel = null;
}
}
}
/// <summary>
/// 新增友情链接
/// </summary>
/// <param name="model">友情链接实体</param>
/// <returns>返回新友情链接的ID</returns>
public virtual int AddSysFriendLink(EyouSoft.Model.SystemStructure.SysFriendLink model)
{
if (model == null)
{
return(0);
}
if (string.IsNullOrEmpty(model.ImgPath))
{
model.ImgPath = string.Empty;
}
DbCommand dc = base.SystemStore.GetSqlStringCommand(Sql_SysFriendLink_Add);
#region 参数赋值
base.SystemStore.AddInParameter(dc, "LinkType", DbType.Int16, (int)model.LinkType);
base.SystemStore.AddInParameter(dc, "LinkName", DbType.String, model.LinkName);
base.SystemStore.AddInParameter(dc, "LinkAddress", DbType.String, model.LinkAddress);
base.SystemStore.AddInParameter(dc, "ImgPath", DbType.String, model.ImgPath);
base.SystemStore.AddInParameter(dc, "IsChecked", DbType.AnsiStringFixedLength, model.IsChecked ? "1" : "0");
base.SystemStore.AddInParameter(dc, "IssueTime", DbType.DateTime, DateTime.Now);
#endregion
object obj = DbHelper.GetSingle(dc, base.SystemStore);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 修改友情链接
/// </summary>
/// <param name="model">友情链接实体</param>
/// <returns>返回受影响的行数</returns>
public virtual int UpdateSysFriendLink(EyouSoft.Model.SystemStructure.SysFriendLink model)
{
if (model == null)
{
return(0);
}
if (string.IsNullOrEmpty(model.ImgPath))
{
model.ImgPath = string.Empty;
}
DbCommand dc = base.SystemStore.GetSqlStringCommand(SQL_DELETEDFILE_UPDATEMOVE + Sql_SysFriendLink_Update);
#region 参数赋值
base.SystemStore.AddInParameter(dc, "LinkType", DbType.Byte, model.LinkType);
base.SystemStore.AddInParameter(dc, "LinkName", DbType.String, model.LinkName);
base.SystemStore.AddInParameter(dc, "LinkAddress", DbType.String, model.LinkAddress);
base.SystemStore.AddInParameter(dc, "ImgPath", DbType.String, model.ImgPath);
base.SystemStore.AddInParameter(dc, "ID", DbType.Int32, model.ID);
#endregion
return(DbHelper.ExecuteSql(dc, base.SystemStore));
}
protected void Page_Load(object sender, EventArgs e)
{
//权限判断
YuYingPermission[] parms = { YuYingPermission.平台管理_管理该栏目, YuYingPermission.平台管理_友情链接 };
if (!CheckMasterGrant(parms))
{
Utils.ResponseNoPermit(YuYingPermission.平台管理_友情链接, true);
return;
}
if (Context.Request.QueryString["linkType"] != null)
{
LinkType = Utils.GetInt(Context.Request.QueryString["linkType"]);
}
if (!string.IsNullOrEmpty(Utils.InputText(Context.Request.QueryString["EditID"])))
{
//修改操作
EditeID = Utils.GetInt(Context.Request.QueryString["EditID"]);
if (!IsPostBack)
{
//初始化要修改的数据
EyouSoft.Model.SystemStructure.SysFriendLink LinkModel = EyouSoft.BLL.SystemStructure.SysFriendLink.CreateInstance().GetSysFriendLinkModel(EditeID);
if (LinkModel != null)
{
this.txtLinkWords.Value = LinkModel.LinkName;
this.txtLinkAddress.Value = LinkModel.LinkAddress;
LinkType = (int)LinkModel.LinkType;
}
//释放资源
LinkModel = null;
}
}
}
/// <summary>
/// 根据ID获取友情链接信息
/// </summary>
/// <param name="FriendLinkId">友情链接ID</param>
/// <returns>友情链接实体</returns>
public virtual EyouSoft.Model.SystemStructure.SysFriendLink GetSysFriendLinkModel(int FriendLinkId)
{
if (FriendLinkId <= 0)
{
return(null);
}
Model.SystemStructure.SysFriendLink model = new EyouSoft.Model.SystemStructure.SysFriendLink();
string strWhere = Sql_SysFriendLink_Select + " where ID = @ID ";
DbCommand dc = base.SystemStore.GetSqlStringCommand(strWhere);
base.SystemStore.AddInParameter(dc, "ID", DbType.Int32, FriendLinkId);
DataTable dt = DbHelper.DataTableQuery(dc, base.SystemStore);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
if (!string.IsNullOrEmpty(dr["ID"].ToString()))
{
model.ID = int.Parse(dr["ID"].ToString());
}
if (!string.IsNullOrEmpty(dr["LinkType"].ToString()))
{
model.LinkType = (Model.SystemStructure.FriendLinkType) int.Parse(dr["LinkType"].ToString());
}
model.LinkName = dr["LinkName"].ToString();
model.LinkAddress = dr["LinkAddress"].ToString();
model.ImgPath = dr["ImgPath"].ToString();
if (!string.IsNullOrEmpty(dr["IsChecked"].ToString()))
{
if (dr["IsChecked"].ToString() == "1")
{
model.IsChecked = true;
}
else
{
model.IsChecked = false;
}
}
if (!string.IsNullOrEmpty(dr["IssueTime"].ToString()))
{
model.IssueTime = DateTime.Parse(dr["IssueTime"].ToString());
}
}
}
if (dt != null)
{
dt.Dispose();
}
dt = null;
return(model);
}
/// <summary>
/// 根据ID获取友情链接信息
/// </summary>
/// <param name="FriendLinkId">友情链接ID</param>
/// <returns>友情链接实体</returns>
public EyouSoft.Model.SystemStructure.SysFriendLink GetSysFriendLinkModel(int FriendLinkId)
{
if (FriendLinkId <= 0)
{
return(null);
}
EyouSoft.Model.SystemStructure.SysFriendLink model = dal.GetSysFriendLinkModel(FriendLinkId);
return(model);
}
protected void btn_Save_Click(object sender, EventArgs e)
{
#region 获取表单信息
string picUrl = "";
string strErr = "";
if (!string.IsNullOrEmpty(Utils.GetFormValue("SingleFileUpload1$hidFileName")))
{
picUrl = Utils.GetFormValue("SingleFileUpload1$hidFileName");
}
else
{
picUrl = Utils.GetFormValue(hdfAgoImgPath.UniqueID);
}
string WordsRemark = Utils.GetFormValue("txtWordRemark", 30);
string PicAddress = Utils.GetFormValue("txtAddress", 245);
//必填验证
if (picUrl == "")
{
strErr += "请选择要上传的图片！\\n";
}
if (PicAddress == "")
{
strErr += "链接地址不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
#endregion
//实例化bll
EyouSoft.Model.SystemStructure.SysFriendLink linkModel = new EyouSoft.Model.SystemStructure.SysFriendLink();
linkModel.LinkName = WordsRemark;
linkModel.LinkAddress = PicAddress;
linkModel.IssueTime = DateTime.Now;
linkModel.ImgPath = picUrl;
linkModel.LinkType = EyouSoft.Model.SystemStructure.FriendLinkType.战略合作;
if (EditeID != 0)
{
linkModel.ID = EditeID;
EyouSoft.BLL.SystemStructure.SysFriendLink.CreateInstance().UpdateSysFriendLink(linkModel);
MessageBox.ShowAndRedirect(this, "修改成功", "PartnersInfo.aspx");
}
else
{
EyouSoft.BLL.SystemStructure.SysFriendLink.CreateInstance().AddSysFriendLink(linkModel);
MessageBox.ShowAndRedirect(this, "新增成功", "PartnersInfo.aspx");
}
//释放资源
linkModel = null;
}
/// <summary>
/// 根据查询命令返回友情链接实体集合
/// </summary>
/// <param name="dc">查询命令</param>
/// <returns>友情链接实体集合</returns>
private IList <EyouSoft.Model.SystemStructure.SysFriendLink> GetQueryList(DbCommand dc)
{
IList <EyouSoft.Model.SystemStructure.SysFriendLink> list = new List <EyouSoft.Model.SystemStructure.SysFriendLink>();
using (IDataReader dr = DbHelper.ExecuteReader(dc, base.SystemStore))
{
EyouSoft.Model.SystemStructure.SysFriendLink model = null;
while (dr.Read())
{
model = new EyouSoft.Model.SystemStructure.SysFriendLink();
if (!string.IsNullOrEmpty(dr["ID"].ToString()))
{
model.ID = int.Parse(dr["ID"].ToString());
}
if (!string.IsNullOrEmpty(dr["LinkType"].ToString()))
{
model.LinkType = (Model.SystemStructure.FriendLinkType) int.Parse(dr["LinkType"].ToString());
}
model.LinkName = dr["LinkName"].ToString();
model.LinkAddress = dr["LinkAddress"].ToString();
model.ImgPath = dr["ImgPath"].ToString();
if (!string.IsNullOrEmpty(dr["IsChecked"].ToString()))
{
if (dr["IsChecked"].ToString() == "1")
{
model.IsChecked = true;
}
else
{
model.IsChecked = false;
}
}
if (!string.IsNullOrEmpty(dr["IssueTime"].ToString()))
{
model.IssueTime = DateTime.Parse(dr["IssueTime"].ToString());
}
list.Add(model);
}
model = null;
}
return(list);
}
protected void btn_Save_Click(object sender, EventArgs e)
{
string strErr = "";
//获取表单数据
string LinkWords = Utils.GetFormValue("txtLinkWords", 30);
string LinkAddress = Utils.GetFormValue("txtLinkAddress", 245);
//必填验证
if (LinkWords == "")
{
strErr += "链接文字不能为空！\\n";
}
if (LinkAddress == "")
{
strErr += "链接地址不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
EyouSoft.Model.SystemStructure.SysFriendLink linkModel = new EyouSoft.Model.SystemStructure.SysFriendLink();
linkModel.LinkName = LinkWords;
linkModel.LinkAddress = LinkAddress;
linkModel.LinkType = (EyouSoft.Model.SystemStructure.FriendLinkType)Enum.Parse(typeof(EyouSoft.Model.SystemStructure.FriendLinkType), LinkType.ToString());
linkModel.IssueTime = DateTime.Now;
if (EditeID != 0)
{
linkModel.ID = EditeID;
if (linkModel.LinkType == (EyouSoft.Model.SystemStructure.FriendLinkType)Enum.Parse(typeof(EyouSoft.Model.SystemStructure.FriendLinkType), LinkType.ToString()))
{
linkModel.ImgPath = string.Empty;
}
EyouSoft.BLL.SystemStructure.SysFriendLink.CreateInstance().UpdateSysFriendLink(linkModel);
MessageBox.ShowAndRedirect(this, "修改成功", string.Format("LinksInfo.aspx?linkType={0}", LinkType));
}
else
{
EyouSoft.BLL.SystemStructure.SysFriendLink.CreateInstance().AddSysFriendLink(linkModel);
MessageBox.ShowAndRedirect(this, "新增成功", string.Format("LinksInfo.aspx?linkType={0}", LinkType));
}
//释放资源
linkModel = null;
}
/// <summary>
/// 修改友情链接
/// </summary>
/// <param name="model">友情链接实体</param>
/// <returns>0:Error;1:Success</returns>
public int UpdateSysFriendLink(EyouSoft.Model.SystemStructure.SysFriendLink model)
{
if (model == null)
{
return(0);
}
int Result = 0;
Result = dal.UpdateSysFriendLink(model);
if (Result > 0)
{
//清空缓存
EyouSoft.Cache.Facade.EyouSoftCache.Remove(EyouSoft.CacheTag.System.SystemFriendLink + model.LinkType.ToString());
return(1);
}
else
{
return(0);
}
}
/// <summary>
/// 获取友情链接
/// </summary>
/// <param name="PageSize">每页条数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="RecordCount">总记录数</param>
/// <param name="OrderIndex">排序索引:0/1添加时间升/降序</param>
/// <param name="LinkType">类型</param>
/// <returns>返回友情链接实体集合</returns>
public virtual IList <EyouSoft.Model.SystemStructure.SysFriendLink> GetSysFriendLinkList(int PageSize, int PageIndex
, ref int RecordCount, int OrderIndex, EyouSoft.Model.SystemStructure.FriendLinkType?LinkType)
{
IList <EyouSoft.Model.SystemStructure.SysFriendLink> list = new List <EyouSoft.Model.SystemStructure.SysFriendLink>();
string strFiles = " [ID],[LinkType],[LinkName],[LinkAddress],[ImgPath],[IsChecked],[IssueTime] ";
string strWhere = string.Empty;
string strOrder = string.Empty;
if (LinkType != null)
{
strWhere += string.Format(" [LinkType] = {0} ", (int)LinkType);
}
switch (OrderIndex)
{
case 0: strOrder = " [IssueTime] asc "; break;
case 1: strOrder = " [IssueTime] desc "; break;
default: strOrder = " [IssueTime] desc "; break;
}
using (IDataReader dr = DbHelper.ExecuteReader(base.SystemStore, PageSize, PageIndex, ref RecordCount, "tbl_SysFriendLink", "ID", strFiles, strWhere, strOrder))
{
EyouSoft.Model.SystemStructure.SysFriendLink model = null;
while (dr.Read())
{
model = new EyouSoft.Model.SystemStructure.SysFriendLink();
if (!string.IsNullOrEmpty(dr["ID"].ToString()))
{
model.ID = int.Parse(dr["ID"].ToString());
}
if (!string.IsNullOrEmpty(dr["LinkType"].ToString()))
{
model.LinkType = (Model.SystemStructure.FriendLinkType) int.Parse(dr["LinkType"].ToString());
}
model.LinkName = dr["LinkName"].ToString();
model.LinkAddress = dr["LinkAddress"].ToString();
model.ImgPath = dr["ImgPath"].ToString();
if (!string.IsNullOrEmpty(dr["IsChecked"].ToString()))
{
if (dr["IsChecked"].ToString() == "1")
{
model.IsChecked = true;
}
else
{
model.IsChecked = false;
}
}
if (!string.IsNullOrEmpty(dr["IssueTime"].ToString()))
{
model.IssueTime = DateTime.Parse(dr["IssueTime"].ToString());
}
list.Add(model);
}
model = null;
}
return(list);
}
