protected void Page_Load(object sender, EventArgs e)
{
if (null != Common.Common.NoHtml(Request.QueryString["action"]))
{
strAction = Common.Common.NoHtml(Request.QueryString["action"]);
}
if (null != Common.Common.NoHtml(Request.QueryString["id"]))
{
strID = Common.Common.NoHtml(Request.QueryString["id"]);
}
AlbumDAL dal = new AlbumDAL();
int statein = 0;
try
{
statein = Convert.ToInt32(dal.GetAlbumValue("IsDel", strID));
}
catch (Exception)
{
statein = 0;
}
switch (statein)
{
case 0:
statein = 1;
break;
default:
statein = 0;
break;
}
PA_Album model = new PA_Album();
model.IsDel = statein;
model.ID = strID;
switch (strAction)
{
case "del":
if (dal.UpdateAlbum(model))
{
strMessage = "操作成功！";
}
else
{
strMessage = "操作失败！";
}
break;
default:
break;
}
Response.Write(strMessage);
Response.End();
}
public void ShowArticleInfo(string strID)
{
AlbumDAL dal = new AlbumDAL();
DataSet ds = dal.GetAlbumDetail(strID);
PA_Album model = DataConvert.DataRowToModel <PA_Album>(ds.Tables[0].Rows[0]);
this.hd_content.Value = model.Note;
this.ddlAlbumType.SelectedIndex = this.ddlAlbumType.Items.IndexOf(this.ddlAlbumType.Items.FindByValue(model.Type));
this.AlbumName.Text = model.Name;
this.img0.Src = "../../" + model.Photo;
if (strAction == "show")
{
this.btnReset.Visible = false;
this.btnSave.Visible = false;
}
}
/// <summary>
/// 修改相册信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateAlbum(PA_Album model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE PA_Album SET ");
if (!string.IsNullOrEmpty(model.Type))
{
strSql.Append("[Type]='" + model.Type + "',");
}
if (!string.IsNullOrEmpty(model.Name))
{
strSql.Append("[Name]='" + model.Name + "',");
}
if (!string.IsNullOrEmpty(model.Photo))
{
strSql.Append("[Photo]='" + model.Photo + "',");
}
if (!string.IsNullOrEmpty(model.Note))
{
strSql.Append("[Note]='" + model.Note + "',");
}
if (model.IsDel > 0)
{
strSql.Append("[IsDel]=" + model.IsDel + ",");
}
else
{
strSql.Append("[IsDel]=0,");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" WHERE ID ='" + model.ID + "' ");
int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
protected override void AddTempData(JinianNet.JNTemplate.TemplateContext context)
{
//取站点信息
DAL.SYS.AccountDAL dalAccount = new DAL.SYS.AccountDAL();
DAL.Album.AlbumDAL dalAlbum = new DAL.Album.AlbumDAL();
//取站点相册列表
DataSet dsAlbumList = dalAlbum.GetAlbumList(AlbumTypeID);
List <PA_Album> liAlbumList = new List <PA_Album>();
if (null != dsAlbumList && dsAlbumList.Tables.Count > 0 && dsAlbumList.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in dsAlbumList.Tables[0].Rows)
{
PA_Album model = DataConvert.DataRowToModel <PA_Album>(row);
liAlbumList.Add(model);
}
}
context.TempData["albumlist"] = liAlbumList;
}
/// <summary>
/// 添加相册
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool InsertAlbum(PA_Album model)
{
string sql = @"INSERT INTO [PA_Album]
([ID]
,[Type]
,[Name]
,[Photo]
,[Note]
,[IsDel])
VALUES
(@ID
,@Type
,@Name
,@Photo
,@Note
,@IsDel)";
System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@ID", model.ID),
new System.Data.SqlClient.SqlParameter("@Type", model.Type),
new System.Data.SqlClient.SqlParameter("@Name", model.Name),
new System.Data.SqlClient.SqlParameter("@Photo", model.Photo),
new System.Data.SqlClient.SqlParameter("@Note", model.Note),
new System.Data.SqlClient.SqlParameter("@IsDel", model.IsDel)
};
int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 单击"保存"按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
if (null == Session["strSiteName"] || null == Session["strSiteCode"] || null == Session["strLoginName"])
{
Response.Write("<script language=JavaScript>;parent.location.href='../Index.aspx';</script>");
Response.End();
}
//上传图像
string strIconFileName = string.Empty; //图像路径
string strIconSaveFileName = string.Empty; //网址路径
try
{
if (this.file0.PostedFile.FileName == "")
{
strIconSaveFileName = "";
}
else
{
if (!System.IO.Directory.Exists(Server.MapPath("~") + @"/Images"))
{
System.IO.Directory.CreateDirectory(Server.MapPath("~") + @"/Images");
}
if (!System.IO.Directory.Exists(String.Format(@"{0}/Images/{1}", Server.MapPath("~"), Session["strSiteCode"].ToString())))
{
System.IO.Directory.CreateDirectory(String.Format(@"{0}/Images/{1}", Server.MapPath("~"), Session["strSiteCode"].ToString()));
}
string orignalName = this.file0.PostedFile.FileName; //获取客户机上传文件的文件名
string extendName = orignalName.Substring(orignalName.LastIndexOf(".")); //获取扩展名
if (extendName != ".gif" && extendName != ".jpg" && extendName != ".jpeg" && extendName != ".png")
{
MessageBox.Show(this, "文件格式有误！");
return;
}//检查文件格式
string newName = String.Format("{0}_{1}{2}", DateTime.Now.Millisecond, file0.PostedFile.ContentLength, extendName);//对文件进行重命名
strIconFileName = String.Format(@"{0}Images/{1}/{2}", Server.MapPath("~"), Session["strSiteCode"].ToString(), newName);
strIconSaveFileName = String.Format(@"Images/{0}/{1}", Session["strSiteCode"].ToString(), newName);
file0.PostedFile.SaveAs(strIconFileName);
}
}
catch (Exception ex)
{
MessageBox.Show(this, "上传发生错误！原因是：" + ex.ToString());
}
AlbumDAL dal = new AlbumDAL();
PA_Album model = new PA_Album();
if (AlbumName.Text.Trim() != null && AlbumName.Text.Trim() != "")
{
model.Name = AlbumName.Text;
model.Note = hd_content.Value;
model.Photo = strIconSaveFileName;
model.Type = ddlAlbumType.SelectedValue;
model.ID = strID;
if (dal.UpdateAlbum(model))
{
MessageBox.Show(this, "修改成功！");
}
else
{
MessageBox.Show(this, "修改失败！");
}
}
else
{
MessageBox.Show(this, "请输入相应标题名称！");
}
}