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"]);
}
AlbumTypeDAL dal = new AlbumTypeDAL();
int statein = 0;
try
{
statein = Convert.ToInt32(dal.GetAlbumTypeValue("IsDel", strID));
}
catch (Exception)
{
statein = 0;
}
switch (statein)
{
case 0:
statein = 1;
break;
default:
statein = 0;
break;
}
PA_AlbumType model = new PA_AlbumType();
model.ID = strID;
model.IsDel = statein;
switch (strAction)
{
case "del":
if (dal.UpdateAlbumType(model))
{
strMessage = "操作成功！";
}
else
{
strMessage = "操作失败！";
}
break;
default:
break;
}
Response.Write(strMessage);
Response.End();
}
/// <summary>
/// 修改相册类别
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateAlbumType(PA_AlbumType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE PA_AlbumType SET ");
if (!string.IsNullOrEmpty(model.SiteCode))
{
strSql.Append("[SiteCode]='" + model.SiteCode + "',");
}
if (!string.IsNullOrEmpty(model.Name))
{
strSql.Append("[Name]='" + model.Name + "',");
}
if (!string.IsNullOrEmpty(model.Cover))
{
strSql.Append("[Cover]='" + model.Cover + "',");
}
if (!string.IsNullOrEmpty(model.Content))
{
strSql.Append("[Content]='" + model.Content + "',");
}
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 dsAlbumType = dalAlbum.GetAlbumTypeList(SiteCode);
List <PA_AlbumType> liAlbumType = new List <PA_AlbumType>();
if (null != dsAlbumType && dsAlbumType.Tables.Count > 0 && dsAlbumType.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in dsAlbumType.Tables[0].Rows)
{
PA_AlbumType model = DataConvert.DataRowToModel <PA_AlbumType>(row);
liAlbumType.Add(model);
}
}
context.TempData["AlbumTypelist"] = liAlbumType;
}
public void ShowArticleInfo(string strID)
{
AlbumTypeDAL dal = new AlbumTypeDAL();
DataSet ds = dal.GetAlbumTypeDetail(strID);
PA_AlbumType model = DataConvert.DataRowToModel <PA_AlbumType>(ds.Tables[0].Rows[0]);
this.hd_content.Value = model.Content;
this.AlbumTypeName.Text = model.Name;
this.img0.Src = "../../" + model.Cover;
if (model.IsDel == 0)
{
isstateyes.Checked = true;
}
else
{
isstateno.Checked = true;
}
if (strAction == "show")
{
this.btnReset.Visible = false;
this.btnSave.Visible = false;
}
}
/// <summary>
/// 添加相册类别
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddAlbumType(PA_AlbumType model)
{
string sql = @"INSERT INTO [PA_AlbumType]
([ID]
,[SiteCode]
,[Name]
,[Cover]
,[Content]
,[IsDel])
VALUES
(@ID
,@SiteCode
,@Name
,@Cover
,@Content
,@IsDel)";
System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@ID", model.ID),
new System.Data.SqlClient.SqlParameter("@SiteCode", model.SiteCode),
new System.Data.SqlClient.SqlParameter("@Name", model.Name),
new System.Data.SqlClient.SqlParameter("@Cover", model.Cover),
new System.Data.SqlClient.SqlParameter("@Content", model.Content),
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());
}
AlbumTypeDAL dal = new AlbumTypeDAL();
PA_AlbumType model = new PA_AlbumType();
if (AlbumTypeName.Text.Trim() != null && AlbumTypeName.Text.Trim() != "")
{
model.Name = AlbumTypeName.Text;
model.Content = hd_content.Value;
model.Cover = strIconSaveFileName;
model.SiteCode = Session["strSiteCode"].ToString();
model.ID = strID;
model.IsDel = isstateyes.Checked ? 0 : 1;
if (dal.UpdateAlbumType(model))
{
MessageBox.Show(this, "修改成功！");
}
else
{
MessageBox.Show(this, "修改失败！");
}
}
else
{
MessageBox.Show(this, "请输入相应标题名称！");
}
}