protected void UpdateSortID(int id, int sortid)
{
TInformation tinfo = infobll.GetInfo(id);
tinfo.SortID = sortid;
infobll.UpdateInfo(tinfo, id);
}
protected void Button2_Click(object sender, EventArgs e)
{
TInformation tinfo = InitInfo(true);
InfoBLL infobll = new InfoBLL();
int lastid = infobll.UpdateInfo(tinfo, tinfo.InfoID);
CommonLibrary.RunJs.PageReplace("Info_UpdateManage.aspx?LastID=" + tinfo.InfoID + "&cid=" + tinfo.InfoCateID);
}
protected void Button1_Click(object sender, EventArgs e)
{
TInformation tinfo = InitInfo(false);
tinfo.ModifyBy = this.LoginUser.Admin_ID;
tinfo.ModifyTime = DateTime.Now;
InfoBLL infobll = new InfoBLL();
int lastid = infobll.UpdateInfo(tinfo, tinfo.InfoID);
CommonLibrary.RunJs.PageReplace("Info_UpdateManage.aspx?LastID=" + tinfo.InfoID + "&cid=" + tinfo.InfoCateID);
}
protected void DeleteInfo(int id)
{
TInformation tinfo = infobll.GetInfo(id);
#region 逻辑删除 注释掉删除物理图片
if (tinfo.InfoPic.Trim() != "")
{
if (tinfo.InfoPic.Trim().Substring(0, 4) != "http")
{
CommonLibrary.CommOperate.DeleteFile(Server.MapPath(tinfo.InfoPic));
}
}
ImageOperate.DeleteMemoImage(tinfo.InfoMemo);
#endregion
infobll.DeleteInfo(id, LoginUser.Admin_ID);
}
/// <summary>
/// 添加信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int AddInfo(TInformation info)
{
#region 变量
NameValueCollection nvc = new NameValueCollection();
nvc.Add("@InfoTitle", info.InfoTitle);
nvc.Add("@InfoSubMemo", info.InfoSubMemo);
nvc.Add("@InfoMemo", info.InfoMemo);
nvc.Add("@InfoPic", info.InfoPic);
nvc.Add("@InfoType", info.InfoType.ToString());
nvc.Add("@BrandID", info.BrandID.ToString());
nvc.Add("@ShopID", info.ShopID.ToString());
nvc.Add("@InfoStartTime", info.InfoStartTime);
nvc.Add("@InfoEndTime", info.InfoEndTime);
nvc.Add("@InfoFrom", info.InfoFrom);
nvc.Add("@InfoAddTime", info.InfoAddTime.ToString());
nvc.Add("@InfoAdder", info.InfoAdder);
nvc.Add("@InfoClicks", info.InfoClicks.ToString());
nvc.Add("@IsRecom", info.IsRecom.ToString());
nvc.Add("@SortID", info.SortID.ToString());
nvc.Add("@IsHtml", false.ToString());//默认没有生成html
nvc.Add("@HtmlPath", info.HtmlPath);
nvc.Add("@IsRemote", info.IsRemote.ToString());
nvc.Add("@IsCheck", info.IsCheck.ToString());
nvc.Add("@InfoCateID", info.InfoCateID.ToString());
nvc.Add("@InfoETitle", info.InfoETitle);
nvc.Add("@InfoTag", info.InfoTag);
#endregion
string cmdtxt = @"Insert into T_InfoList (InfoTitle,InfoSubMemo,InfoMemo,InfoPic,InfoType,BrandID,ShopID,InfoStartTime,InfoEndTime,InfoFrom,InfoAddTime,InfoAdder,InfoClicks,IsRecom,SortID,IsHtml,HtmlPath,IsRemote,IsCheck,InfoCateID,InfoETitle,InfoTag,IsDelete)
values
(@InfoTitle,@InfoSubMemo,@InfoMemo,@InfoPic,@InfoType,@BrandID,@ShopID,@InfoStartTime,@InfoEndTime,@InfoFrom,@InfoAddTime,@InfoAdder,@InfoClicks,@IsRecom,@SortID,@IsHtml,@HtmlPath,@IsRemote,@IsCheck,@InfoCateID,@InfoETitle,@InfoTag,0);
";
dh.Open();
int stat = dh.ExecuteNonQuery(CommandType.Text, cmdtxt, nvc);
dh.Close();
return(stat);
}
/// <summary>
/// 通过指定id获取信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public TInformation GetInfo(int id)
{
TInformation tinfo = new TInformation();
string cmdtxt = "Select InfoTitle,InfoSubMemo,InfoMemo,BrandID,InfoPic,InfoType,ShopID,InfoStartTime,InfoEndTime,InfoFrom,InfoAddTime,InfoAdder,InfoClicks,IsRecom,SortID,IsHtml,HtmlPath,IsRemote,IsCheck,InfoCateID,InfoETitle,InfoTag from T_InfoList where InfoID=@InfoID";
NameValueCollection nvc = new NameValueCollection();
nvc.Add("@InfoID", id.ToString());
dh.Open();
using (DbDataReader dr = dh.ExecuteReader(CommandType.Text, cmdtxt, nvc))
{
if (dr.HasRows)
{
dr.Read();
#region 变量赋值
tinfo.InfoID = id;
tinfo.InfoTitle = dr["InfoTitle"].ToString();
tinfo.InfoSubMemo = dr["InfoSubMemo"].ToString();
tinfo.InfoMemo = dr["InfoMemo"].ToString();
int BrandID = 0;
Int32.TryParse(dr["BrandID"].ToString(), out BrandID);
tinfo.BrandID = BrandID;
tinfo.InfoPic = dr["InfoPic"].ToString().Trim();
int infotype = 0;
Int32.TryParse(dr["InfoType"].ToString(), out infotype);
tinfo.InfoType = infotype;
int ShopID = 0;
Int32.TryParse(dr["ShopID"].ToString(), out ShopID);
tinfo.ShopID = ShopID;
tinfo.InfoStartTime = dr["InfoStartTime"].ToString();
tinfo.InfoEndTime = dr["InfoEndTime"].ToString();
tinfo.InfoFrom = dr["InfoFrom"].ToString();
DateTime addtime;
DateTime.TryParse(dr["InfoAddTime"].ToString(), out addtime);
tinfo.InfoAddTime = addtime;
tinfo.InfoAdder = dr["InfoAdder"].ToString();
int InfoClicks = 0;
Int32.TryParse(dr["InfoClicks"].ToString(), out InfoClicks);
bool IsRecom = false;
bool.TryParse(dr["IsRecom"].ToString(), out IsRecom);
tinfo.IsRecom = IsRecom;
int SortID = 0;
Int32.TryParse(dr["SortID"].ToString(), out SortID);
tinfo.SortID = SortID;
bool IsHtml = false;
bool.TryParse(dr["IsHtml"].ToString(), out IsHtml);
tinfo.IsHtml = IsHtml;
tinfo.HtmlPath = dr["HtmlPath"].ToString();
bool IsRemote = false;
bool.TryParse(dr["IsRemote"].ToString(), out IsRemote);
tinfo.IsRemote = IsRemote;
bool IsCheck = false;
bool.TryParse(dr["IsCheck"].ToString(), out IsCheck);
tinfo.IsCheck = IsCheck;
int InfoCateID = 0;
Int32.TryParse(dr["InfoCateID"].ToString(), out InfoCateID);
tinfo.InfoCateID = InfoCateID;
tinfo.InfoETitle = dr["InfoETitle"].ToString();
tinfo.InfoTag = dr["InfoTag"].ToString();
#endregion
}
}
dh.Close();
return(tinfo);
}
/// <summary>
/// 修改信息
/// </summary>
/// <param name="info"></param>
/// <param name="id"></param>
/// <returns></returns>
public int UpdateInfo(TInformation info, int id)
{
#region 变量
NameValueCollection nvc = new NameValueCollection();
nvc.Add("@InfoTitle", info.InfoTitle);
nvc.Add("@InfoSubMemo", info.InfoSubMemo);
nvc.Add("@InfoMemo", info.InfoMemo);
nvc.Add("@InfoPic", info.InfoPic);
nvc.Add("@InfoType", info.InfoType.ToString());
nvc.Add("@BrandID", info.BrandID.ToString());
nvc.Add("@ShopID", info.ShopID.ToString());
nvc.Add("@InfoStartTime", info.InfoStartTime);
nvc.Add("@InfoEndTime", info.InfoEndTime);
nvc.Add("@InfoFrom", info.InfoFrom);
nvc.Add("@InfoAddTime", info.InfoAddTime.ToString("yyyy-MM-dd hh:mm:ss"));
nvc.Add("@InfoAdder", info.InfoAdder);
nvc.Add("@InfoClicks", info.InfoClicks.ToString());
nvc.Add("@IsRecom", info.IsRecom.ToString());
nvc.Add("@SortID", info.SortID.ToString());
nvc.Add("@IsHtml", false.ToString());//默认没有生成html
nvc.Add("@HtmlPath", info.HtmlPath);
nvc.Add("@IsRemote", info.IsRemote.ToString());
nvc.Add("@IsCheck", info.IsCheck.ToString());
nvc.Add("@InfoCateID", info.InfoCateID.ToString());
nvc.Add("@InfoETitle", info.InfoETitle);
nvc.Add("@InfoTag", info.InfoTag);
nvc.Add("@ModifyBy", info.ModifyBy.ToString());
nvc.Add("@ModifyTime", info.ModifyTime.ToString("yyyy-MM-dd hh:mm:ss"));
nvc.Add("@InfoID", id.ToString());
#endregion
string cmdtxt = @"update T_InfoList set
InfoTitle=@InfoTitle,
InfoSubMemo=@InfoSubMemo,
InfoMemo=@InfoMemo,
InfoPic=@InfoPic,
InfoType=@InfoType,
BrandID=@BrandID,
ShopID=@ShopID,
InfoStartTime=@InfoStartTime,
InfoEndTime=@InfoEndTime,
InfoFrom=@InfoFrom,
InfoAddTime=@InfoAddTime,
InfoAdder=@InfoAdder,
InfoClicks=@InfoClicks,
IsRecom=@IsRecom,
SortID=@SortID,
IsHtml=@IsHtml,
HtmlPath=@HtmlPath,
IsRemote=@IsRemote,
IsCheck=@IsCheck,
InfoCateID=@InfoCateID,
InfoETitle=@InfoETitle,
InfoTag=@InfoTag,
ModifyBy=@ModifyBy,
ModifyTime=@ModifyTime
where InfoID=@InfoID
";
dh.Open();
int stat = dh.ExecuteNonQuery(CommandType.Text, cmdtxt, nvc);
dh.Close();
return(stat);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int infoid = 0;
Int32.TryParse(CommonLibrary.CommOperate.GetStrFromRequestQueryString("id"), out infoid);
TInformation tinfo = new TInformation();
InfoBLL infobll = new InfoBLL();
AdminBLL adinbll = new AdminBLL();
tinfo = infobll.GetInfo(infoid);
tbx_title.Text = tinfo.InfoTitle;
Tbx_SubMemo.Text = tinfo.InfoSubMemo;
ContentHolder.Value = tinfo.InfoMemo;
#region 图片列表
L_selpic.Text = ImageOperate.GetImageSelect(tinfo.InfoMemo, tinfo.InfoPic);
#endregion
#region 信息类型
if (tinfo.InfoType == 1)
{
L_selinfotype.Text = "<select id='sel_SelInfoType' name='sel_SelInfoType' > <option value=\"1\" selected=selected> 新闻 </option> <option value=\"2\"> 产品 </option></select>";
}
else if (tinfo.InfoType == 2)
{
L_selinfotype.Text = "<select id='sel_SelInfoType' name='sel_SelInfoType' > <option value=\"1\" > 新闻 </option> <option value=\"2\" selected=selected> 产品</option></select>";
//Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "InitInfoType", "$('.dazhe').hide();", true);
L_js.Text = @"<script type='text/javascript'>
$(document).ready( function()
{ $('.dazhe').hide();}
);
</script>";
}
#endregion
#region 商家id
int shopid = tinfo.ShopID;
L_shopid.Text = "<input type=\"hidden\" id=\"h_shopid\" name=\"h_shopid\" value=\"" + shopid + "\"/>";
if (shopid == -1)
{
tbx_ShopID.Text = "暂无商家";
}
else
{
ShopBLL shopbll = new ShopBLL();
tbx_ShopID.Text = shopbll.GetShop(shopid).ShopTitle;
}
#endregion
#region 品牌信息
int brandid = tinfo.BrandID;
L_brandid.Text = "<input type=\"hidden\" id=\"h_brandid\" name=\"h_brandid\" value=\"" + brandid + "\"/>";
if (brandid == -1)
{
tbx_brand.Text = "暂无品牌信息";
}
else
{
BrandBLL brandbll = new BrandBLL();
tbx_brand.Text = brandbll.GetBrandByID(brandid).BrandName;
}
#endregion
tbx_SortId.Text = tinfo.SortID.ToString();
tbx_Etitle.Text = tinfo.InfoETitle;
Tbx_modifier.Text = this.LoginUser.Admin_RealName;
H_Modifier.Value = LoginUser.Admin_ID.ToString();
Tbx_modifytime.Text = tinfo.ModifyTime.ToString("yyyy-MM-dd hh:mm:ss");
//Tbx_Adder.Text = this.LoginUser.Admin_RealName;
//H_Adder.Value = LoginUser.Admin_ID.ToString();
int Adder = 0;
Int32.TryParse(tinfo.InfoAdder, out Adder);
Tbx_Adder.Text = adinbll.GetAdmin(Adder).Admin_RealName;
H_Adder.Value = Adder.ToString();
Tbx_BeginTime.Text = tinfo.InfoStartTime;
Tbx_EndTime.Text = tinfo.InfoEndTime;
Tbx_from.Text = tinfo.InfoFrom;
Tbx_Addtime.Text = tinfo.InfoAddTime.ToString("yyyy-MM-dd hh:mm:ss");
Tbx_clicknum.Text = tinfo.InfoClicks.ToString();
if (tinfo.IsRecom == true)
{
L_IsRecoom.Text = "<input type=\"checkbox\" id=\"Chk_tuijian\" name=\"Chk_tuijian\" Checked=Checked value=\"true\" />";
}
else
{
L_IsRecoom.Text = "<input type=\"checkbox\" id=\"Chk_tuijian\" name=\"Chk_tuijian\" value=\"true\" />";
}
if (tinfo.IsRemote == true)
{
L_isRemote.Text = "<input type=\"checkbox\" id=\"Chk_Remote\" name=\"Chk_Remote\" value=\"true\" Checked=Checked />";
}
else
{
L_isRemote.Text = "<input type=\"checkbox\" id=\"Chk_Remote\" name=\"Chk_Remote\" value=\"true\" />";
}
Tbx_tag.Text = tinfo.InfoTag;
NodeBLL nodebll = new NodeBLL();
DataTable dt = nodebll.GetAllNode();
L_CateTree.Text = "<select id='sel' name='sel'><option value='-1'>请选择类别...</option>";
if (dt.Rows.Count > 0)
{
L_CateTree.Text += tool.NodeTree.GetNodeTree(dt, 0, 0, tinfo.InfoCateID);
}
L_CateTree.Text += "</Select>";
}
}
/// <summary>
/// 初始化变量
/// </summary>
/// <param name="ischeck">是否初始化</param>
/// <returns></returns>
private TInformation InitInfo(bool ischeck)
{
#region 变量
int infoid = 0;
Int32.TryParse(CommonLibrary.CommOperate.GetStrFromRequestQueryString("id"), out infoid);
string InfoTitle = string.Empty; //信息标题
InfoTitle = tbx_title.Text.Trim();
string InfoSubMemo = string.Empty; //内容简介
InfoSubMemo = Tbx_SubMemo.Text.Trim();
string InfoMemo = string.Empty; //信息内容
InfoMemo = ContentHolder.Value;
string InfoPic = string.Empty; //信息封面图片
InfoPic = CommonLibrary.CommOperate.GetStrFromRequestForm("CatePic");
int InfoType = 0; //信息类型（1衣2食3住4行）
//Int32.TryParse(CommonLibrary.CommOperate.GetStrFromRequestForm("h_brandid"), out InfoType);
Int32.TryParse(CommonLibrary.CommOperate.GetStrFromRequestForm("sel_SelInfoType"), out InfoType);
int BrandID = 0; //品牌ID
Int32.TryParse(CommonLibrary.CommOperate.GetStrFromRequestForm("h_brandid"), out BrandID);
int ShopID = 0; //商家ID
Int32.TryParse(CommonLibrary.CommOperate.GetStrFromRequestForm("h_shopid"), out ShopID);
string InfoStartTime = string.Empty; //活动开始时间
InfoStartTime = Tbx_BeginTime.Text.Trim();
string InfoEndTime = string.Empty; //活动截止时间
InfoEndTime = Tbx_EndTime.Text.Trim();
string InfoFrom = string.Empty; //信息来源
InfoFrom = Tbx_from.Text.Trim();
DateTime InfoAddTime;
DateTime.TryParse(Tbx_Addtime.Text, out InfoAddTime);
string InfoAdder = string.Empty; //添加人
InfoAdder = H_Adder.Value.Trim();
int InfoClicks = 0; //点击数
Int32.TryParse(Tbx_clicknum.Text, out InfoClicks);
bool IsRecom = false; //是否推荐 默认为否
bool.TryParse(CommonLibrary.CommOperate.GetStrFromRequestForm("Chk_tuijian"), out IsRecom);
int SortID = 0; //排序号
Int32.TryParse(tbx_SortId.Text, out SortID);
bool IsHtml = false; //是否生成html
string HtmlPath = string.Empty; //生成html路径
bool IsRemote = false; //是否远程存图
bool.TryParse(CommonLibrary.CommOperate.GetStrFromRequestForm("Chk_Remote"), out IsRemote);
bool IsCheck = ischeck; //是否通过验证
int InfoCateID = 0; //信息类别ID
Int32.TryParse(CommonLibrary.CommOperate.GetStrFromRequestForm("sel"), out InfoCateID);
if (InfoCateID == -1)
{
CommonLibrary.RunJs.AlertAndBack("请选择类别");
}
string InfoETitle = string.Empty;//英文标题
InfoETitle = tbx_Etitle.Text.Trim();
string InfoTag = Tbx_tag.Text.Trim();
#endregion
TInformation tinfo = new TInformation();
#region 初始化变量
tinfo.InfoID = infoid;
tinfo.InfoTitle = InfoTitle;
tinfo.InfoSubMemo = InfoSubMemo;
if (IsRemote == true)
{
tinfo.InfoMemo = ImageOperate.GetRemoteImage(InfoMemo, "/uploadfile/remote/");
}
else
{
tinfo.InfoMemo = InfoMemo;
}
tinfo.InfoPic = InfoPic;
tinfo.InfoType = InfoType;
tinfo.BrandID = BrandID;
tinfo.ShopID = ShopID;
tinfo.InfoStartTime = InfoStartTime;
tinfo.InfoEndTime = InfoEndTime;
tinfo.InfoFrom = InfoFrom;
tinfo.InfoAddTime = InfoAddTime;
tinfo.InfoAdder = InfoAdder;
tinfo.InfoClicks = InfoClicks;
tinfo.IsRecom = IsRecom;
tinfo.SortID = SortID;
tinfo.IsHtml = IsHtml;
tinfo.HtmlPath = HtmlPath;
tinfo.IsRemote = IsRemote;
tinfo.IsCheck = IsCheck;
tinfo.InfoCateID = InfoCateID;
tinfo.InfoETitle = InfoETitle;
tinfo.InfoTag = InfoTag;
tinfo.ModifyBy = LoginUser.Admin_ID;
tinfo.ModifyTime = DateTime.Now;
#endregion
return(tinfo);
}
/// <summary>
/// 修改信息
/// </summary>
/// <param name="info"></param>
/// <param name="id"></param>
/// <returns></returns>
public int UpdateInfo(TInformation info, int id)
{
return(InfoOperate.UpdateInfo(info, id));
}
/// <summary>
/// 添加信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int AddInfo(TInformation info)
{
return(InfoOperate.AddInfo(info));
}
