/// <summary>
/// 添加
/// </summary>
/// <param name="model">公告信息实体</param>
/// <returns>false:失败 true:成功</returns>
public virtual bool Add(EyouSoft.Model.SystemStructure.Affiche model)
{
DbCommand dc = this._database.GetSqlStringCommand(SQL_Affiche_INSERT);
this._database.AddInParameter(dc, "OperatorID", DbType.Int32, model.OperatorID);
this._database.AddInParameter(dc, "OperatorName", DbType.String, model.OperatorName);
this._database.AddInParameter(dc, "AfficheClass", DbType.Byte, (int)model.AfficheClass);
this._database.AddInParameter(dc, "AfficheTitle", DbType.String, model.AfficheTitle);
this._database.AddInParameter(dc, "AfficheInfo", DbType.String, model.AfficheInfo);
this._database.AddInParameter(dc, "Clicks", DbType.Int32, 0);
this._database.AddInParameter(dc, "IsHot", DbType.AnsiStringFixedLength, model.IsHot ? "1" : "0");
this._database.AddInParameter(dc, "IsPicNews", DbType.AnsiStringFixedLength, model.IsPicNews ? "1" : "0");
this._database.AddInParameter(dc, "PicPath", DbType.String, model.PicPath);
this._database.AddInParameter(dc, "IssueTime", DbType.DateTime, DateTime.Now);
object obj = DbHelper.GetSingle(dc, base.SystemStore);
if (obj == null)
{
return(false);
}
else
{
model.ID = Convert.ToInt32(obj);
return(Convert.ToInt32(obj) > 0 ? true : false);
}
}
/// <summary>
/// 获取新闻实体
/// </summary>
/// <param name="ID">主键编号</param>
/// <returns></returns>
public virtual EyouSoft.Model.SystemStructure.Affiche GetModel(int ID)
{
EyouSoft.Model.SystemStructure.Affiche model = null;
DbCommand dc = this._database.GetSqlStringCommand(SQL_Affiche_GETMODEL);
this._database.AddInParameter(dc, "ID", DbType.Int32, ID);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
if (dr.Read())
{
model = new EyouSoft.Model.SystemStructure.Affiche();
model.ID = dr.IsDBNull(dr.GetOrdinal("ID")) ? 0 : dr.GetInt32(dr.GetOrdinal("ID"));
if (!dr.IsDBNull(dr.GetOrdinal("AfficheClass")))
{
model.AfficheClass = (EyouSoft.Model.SystemStructure.AfficheType) int.Parse(dr.GetByte(dr.GetOrdinal("AfficheClass")).ToString());
}
model.AfficheTitle = dr.IsDBNull(dr.GetOrdinal("AfficheTitle")) ? "" : dr.GetString(dr.GetOrdinal("AfficheTitle"));
model.AfficheInfo = dr.IsDBNull(dr.GetOrdinal("AfficheInfo")) ? "" : dr.GetString(dr.GetOrdinal("AfficheInfo"));
model.IsHot = dr.IsDBNull(dr.GetOrdinal("IsHot")) ? false : (dr.GetString(dr.GetOrdinal("IsHot")) == "1" ? true : false);
model.IsPicNews = dr.IsDBNull(dr.GetOrdinal("IsPicNews")) ? false : (dr.GetString(dr.GetOrdinal("IsPicNews")) == "1" ? true : false);
model.PicPath = dr.IsDBNull(dr.GetOrdinal("PicPath")) ? "" : dr.GetString(dr.GetOrdinal("PicPath"));
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
model.OperatorID = dr.IsDBNull(dr.GetOrdinal("OperatorID")) ? 0 : dr.GetInt32(dr.GetOrdinal("OperatorID"));
model.OperatorName = dr.IsDBNull(dr.GetOrdinal("OperatorName"))?string.Empty:dr.GetString(dr.GetOrdinal("OperatorName"));
model.Clicks = dr.IsDBNull(dr.GetOrdinal("Clicks")) ? 0 : dr.GetInt32(dr.GetOrdinal("Clicks"));
}
}
return(model);
}
/// <summary>
/// 获取指定行数的新闻信息
/// </summary>
/// <param name="topNumber">需要返回的行数 =0返回全部</param>
/// <param name="affichType">新闻类别 =null返回全部</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.SystemStructure.Affiche> GetTopList(int topNumber, EyouSoft.Model.SystemStructure.AfficheType?affichType)
{
IList <EyouSoft.Model.SystemStructure.Affiche> list = new List <EyouSoft.Model.SystemStructure.Affiche>();
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(SQL_Affiche_GETTOPLIST, topNumber > 0 ? string.Format(" top {0} ", topNumber) : string.Empty,
affichType.HasValue ? string.Format(" where AfficheClass={0} ", (int)affichType.Value) : string.Empty);
DbCommand dc = this._database.GetSqlStringCommand(strSql.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
while (dr.Read())
{
EyouSoft.Model.SystemStructure.Affiche model = new EyouSoft.Model.SystemStructure.Affiche();
model.ID = dr.IsDBNull(dr.GetOrdinal("ID"))?0:dr.GetInt32(dr.GetOrdinal("ID"));
if (!dr.IsDBNull(dr.GetOrdinal("AfficheClass")))
{
model.AfficheClass = (EyouSoft.Model.SystemStructure.AfficheType) int.Parse(dr.GetByte(dr.GetOrdinal("AfficheClass")).ToString());
}
model.AfficheTitle = dr.IsDBNull(dr.GetOrdinal("AfficheTitle"))?"":dr.GetString(dr.GetOrdinal("AfficheTitle"));
model.AfficheInfo = dr.IsDBNull(dr.GetOrdinal("AfficheInfo")) ? "" : dr.GetString(dr.GetOrdinal("AfficheInfo"));
model.IsHot = dr.IsDBNull(dr.GetOrdinal("IsHot")) ? false : (dr.GetString(dr.GetOrdinal("IsHot")) == "1" ? true : false);
model.IsPicNews = dr.IsDBNull(dr.GetOrdinal("IsPicNews")) ? false : (dr.GetString(dr.GetOrdinal("IsPicNews")) == "1" ? true : false);
model.PicPath = dr.IsDBNull(dr.GetOrdinal("PicPath")) ? "" : dr.GetString(dr.GetOrdinal("PicPath"));
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
model.Clicks = dr.IsDBNull(dr.GetOrdinal("Clicks")) ? 0 : dr.GetInt32(dr.GetOrdinal("Clicks"));
list.Add(model);
model = null;
}
}
return(list);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">公告实体</param>
/// <returns>false:失败 true:成功</returns>
public bool Update(EyouSoft.Model.SystemStructure.Affiche model)
{
if (model == null)
{
return(false);
}
return(dal.Update(model));
}
protected void Page_Load(object sender, EventArgs e)
{
//初始化新闻类别
InitTypeList();
if (!string.IsNullOrEmpty(Utils.InputText(Context.Request.QueryString["EditID"])))
{
//修改操作
YuYingPermission[] parms2 = { YuYingPermission.新闻中心_管理该栏目, YuYingPermission.新闻中心_修改 };
//修改操作
//权限验证
if (!CheckMasterGrant(parms2))
{
Utils.ResponseNoPermit(YuYingPermission.新闻中心_修改, true);
return;
}
EditeID = Utils.GetInt(Context.Request.QueryString["EditID"]);
//初始化要修改的数据
if (!IsPostBack)
{
EyouSoft.Model.SystemStructure.Affiche Model = EyouSoft.BLL.SystemStructure.Affiche.CreateInstance().GetModel(EditeID);
if (Model != null)
{
this.txtIssuTime.Value = Model.IssueTime.ToString("yyyy-MM-dd hh:mm");
this.ddlType.SelectedValue = ((int)Model.AfficheClass).ToString();
this.txt_TitleName.Value = Model.AfficheTitle;
this.FCK_PlanTicketContent.Value = Model.AfficheInfo;
this.txtSendPeople.Value = Model.OperatorName;
if (!string.IsNullOrEmpty(Model.PicPath))
{
img_Path = string.Format("<a href=\"{0}\"target='_blank' title=\"点击查看\">{1}</a>", Domain.FileSystem + Model.PicPath, Model.PicPath.Substring(Model.PicPath.LastIndexOf('/') + 1));
hdfAgoImgPath.Value = Model.PicPath;
}
}
//释放资源
Model = null;
}
}
else
{
YuYingPermission[] parms = { YuYingPermission.新闻中心_管理该栏目, YuYingPermission.新闻中心_新增 };
//权限验证
if (!CheckMasterGrant(parms))
{
Utils.ResponseNoPermit(YuYingPermission.新闻中心_新增, true);
return;
}
this.tr_SendPeople.Visible = false;
this.tr_SendTime.Visible = false;
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">公告信息实体</param>
/// <returns>false:失败 true:成功</returns>
public virtual bool Update(EyouSoft.Model.SystemStructure.Affiche model)
{
DbCommand dc = this._database.GetSqlStringCommand(SQL_DELETEDFILE_UPDATEMOVE + SQL_Affiche_UPDATE);
this._database.AddInParameter(dc, "ID", DbType.Int32, model.ID);
this._database.AddInParameter(dc, "OperatorID", DbType.Int32, model.OperatorID);
this._database.AddInParameter(dc, "OperatorName", DbType.String, model.OperatorName);
this._database.AddInParameter(dc, "AfficheClass", DbType.Int16, model.AfficheClass);
this._database.AddInParameter(dc, "AfficheTitle", DbType.String, model.AfficheTitle);
this._database.AddInParameter(dc, "AfficheInfo", DbType.String, model.AfficheInfo);
this._database.AddInParameter(dc, "IsHot", DbType.AnsiStringFixedLength, model.IsHot ? "1" : "0");
this._database.AddInParameter(dc, "IsPicNews", DbType.AnsiStringFixedLength, model.IsPicNews ? "1" : "0");
this._database.AddInParameter(dc, "PicPath", DbType.String, model.PicPath);
//this._database.AddInParameter(dc, "IssueTime", DbType.DateTime, DateTime.Now);
return(DbHelper.ExecuteSql(dc, this._database) > 0 ? true : false);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string AfficheID = EyouSoft.Common.Utils.InputText(Request.QueryString["AfficheID"]);
if (!String.IsNullOrEmpty(AfficheID) && EyouSoft.Common.Utils.GetInt(AfficheID) != 0)
{
EyouSoft.Model.SystemStructure.Affiche model = EyouSoft.BLL.SystemStructure.Affiche.CreateInstance().GetModel(int.Parse(AfficheID));
if (model != null)
{
this.ltrAdvTitle.Text = model.AfficheTitle;
this.ltrAdvContent.Text = model.AfficheInfo;
}
model = null;
}
else
{
this.ltrAdvContent.Text = "对不起，未找到您要查看的广告信息!";
}
}
}
protected void BindListInfo()
{
string imgUrl = Domain.FileSystem;
EyouSoft.Model.SystemStructure.Affiche Model = EyouSoft.BLL.SystemStructure.Affiche.CreateInstance().GetModel(NewsID);
if (Model != null)
{
this.lbl_Time.Text = Model.IssueTime.ToString("yyyy年MM月dd日 hh:mm");
this.lbl_Title.Text = Model.AfficheTitle;
this.lit_Content.Text = Model.AfficheInfo;
if (Model.PicPath != "")
{
this.img_NewsPic.Src = imgUrl + Model.PicPath;
}
else
{
this.divShow.Visible = false;
}
titleName = Model.AfficheTitle;
}
Model = null;
#region 绑定航班类型,乘客类型
Array arr = Enum.GetValues(typeof(EyouSoft.Model.TicketStructure.VoyageType));
for (int i = 1; i < arr.Length; i++)
{
rdoType.Items.Add(new ListItem(Enum.GetName(typeof(EyouSoft.Model.TicketStructure.VoyageType), arr.GetValue(i)), arr.GetValue(i).ToString()));
}
arr = Enum.GetValues(typeof(EyouSoft.Model.TicketStructure.PeopleCountryType));
for (int i = 0; i < arr.Length; i++)
{
string showtext = arr.GetValue(i).ToString() == EyouSoft.Model.TicketStructure.PeopleCountryType.Foreign.ToString() ? "外宾" : "内宾";
rdoPassengerType.Items.Add(new ListItem(showtext, arr.GetValue(i).ToString()));
}
rdoType.Items[0].Selected = true;
rdoPassengerType.Items[0].Selected = true;
arr = null;
#endregion
}
/// <summary>
/// 分页获取新闻列表
/// </summary>
/// <param name="pageSize">每页显示条数</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="recordCount">总记录数</param>
/// <param name="affichType">新闻类别 =null返回全部</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.SystemStructure.Affiche> GetList(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.SystemStructure.AfficheType?affichType)
{
IList <EyouSoft.Model.SystemStructure.Affiche> list = new List <EyouSoft.Model.SystemStructure.Affiche>();
string tableName = "tbl_Affiche";
string fields = "ID,AfficheClass,AfficheTitle,AfficheInfo,IsHot,IsPicNews,PicPath,IssueTime,OperatorID,Clicks";
string primaryKey = "ID";
string orderByString = " IsHot DESC,IssueTime DESC ";
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" 1=1 ");
if (affichType.HasValue)
{
strWhere.AppendFormat(" and AfficheClass={0} ", (int)affichType.Value);
}
using (IDataReader dr = DbHelper.ExecuteReader(this._database, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields, strWhere.ToString(), orderByString))
{
while (dr.Read())
{
EyouSoft.Model.SystemStructure.Affiche model = new EyouSoft.Model.SystemStructure.Affiche();
model.ID = dr.IsDBNull(dr.GetOrdinal("ID")) ? 0 : dr.GetInt32(dr.GetOrdinal("ID"));
if (!dr.IsDBNull(dr.GetOrdinal("AfficheClass")))
{
model.AfficheClass = (EyouSoft.Model.SystemStructure.AfficheType) int.Parse(dr.GetByte(dr.GetOrdinal("AfficheClass")).ToString());
}
model.AfficheTitle = dr.IsDBNull(dr.GetOrdinal("AfficheTitle")) ? "" : dr.GetString(dr.GetOrdinal("AfficheTitle"));
model.AfficheInfo = dr.IsDBNull(dr.GetOrdinal("AfficheInfo")) ? "" : dr.GetString(dr.GetOrdinal("AfficheInfo"));
model.IsHot = dr.IsDBNull(dr.GetOrdinal("IsHot")) ? false : (dr.GetString(dr.GetOrdinal("IsHot")) == "1" ? true : false);
model.IsPicNews = dr.IsDBNull(dr.GetOrdinal("IsPicNews")) ? false : (dr.GetString(dr.GetOrdinal("IsPicNews")) == "1" ? true : false);
model.PicPath = dr.IsDBNull(dr.GetOrdinal("PicPath")) ? "" : dr.GetString(dr.GetOrdinal("PicPath"));
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
model.Clicks = dr.IsDBNull(dr.GetOrdinal("Clicks")) ? 0 : dr.GetInt32(dr.GetOrdinal("Clicks"));
list.Add(model);
model = null;
}
}
return(list);
}
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);
}
int NewsType = int.Parse(Utils.GetFormValue("ddlType"));
string NewTitle = Utils.GetFormValue("txt_TitleName", 80);
string NewsContent = Utils.EditInputText(this.FCK_PlanTicketContent.Value);
string SendNewsPeople = this.MasterUserInfo.UserName;
//必填验证
if (NewTitle == "")
{
strErr += "标题名称不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
#endregion
//实例化类的对象,保存数据
EyouSoft.Model.SystemStructure.Affiche Model = new EyouSoft.Model.SystemStructure.Affiche();
Model.AfficheClass = (EyouSoft.Model.SystemStructure.AfficheType)NewsType;
Model.AfficheInfo = NewsContent;
Model.AfficheTitle = NewTitle;
Model.Clicks = 0;
Model.IssueTime = DateTime.Now;
Model.OperatorID = this.MasterUserInfo.ID; //操作员编号
Model.OperatorName = SendNewsPeople;
Model.PicPath = picUrl;
if (EditeID != 0)
{
Model.ID = EditeID;
EyouSoft.BLL.SystemStructure.Affiche.CreateInstance().Update(Model);
MessageBox.ShowAndRedirect(this, "修改成功", "NewsInfoList.aspx");
}
else
{
YuYingPermission[] parms3 = { YuYingPermission.新闻中心_管理该栏目, YuYingPermission.新闻中心_修改 };
YuYingPermission[] parms4 = { YuYingPermission.新闻中心_管理该栏目, YuYingPermission.新闻中心_删除 };
EyouSoft.BLL.SystemStructure.Affiche.CreateInstance().Add(Model);
if (!CheckMasterGrant(parms3) && !CheckMasterGrant(parms4))
{
MessageBox.ShowAndRedirect(this, "新增成功", "OperatorNewsPage.aspx");
//Utils.ResponseNoPermit();
//return;
}
else
{
MessageBox.ShowAndRedirect(this, "新增成功", "NewsInfoList.aspx");
}
}
//释放资源
Model = null;
}
