private void BindDate(string sql, params object[] param)
{
ViewState["sql"] = sql;
ViewState["param"] = param;
int pageCount = 0;
var bl = new DS_AlbumImg_Br();
var list = bl.Query(sql, "", (AspNetPager4.CurrentPageIndex - 1) * AspNetPager4.PageSize, AspNetPager4.PageSize, ref pageCount, param);
AspNetPager4.RecordCount = pageCount;
Repeater1.DataSource = list;
Repeater1.DataBind();
}
private void BindDate(string sql, params object[] param)
{
ViewState["sql"] = sql;
ViewState["param"] = param;
int pageCount = 0;
var bl = new DS_AlbumImg_Br();
var list = bl.Query(sql, "", (AspNetPager4.CurrentPageIndex - 1) * AspNetPager4.PageSize, AspNetPager4.PageSize, ref pageCount, param);
AspNetPager4.RecordCount = pageCount;
Repeater1.DataSource = list;
Repeater1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack) return;
int album_id=int.Parse(Request.QueryString["album_id"]);
int member_id = _vMember.ID;
var bl = new DS_AlbumImg_Br();
Repeater1.DataSource = bl.Query("albumid=@0","px",album_id);
Repeater1.DataBind();
var albbl = new DS_Album_Br();
var album = albbl.GetSingle(album_id);
ViewState["albumName"] = album.AlbumName.Length>6?album.AlbumName.Substring(0,6)+"..":album.AlbumName;
Repeater2.DataSource = albbl.Query("memberid=@0 and PictureNum>0 and Permissions!=@1", "updatedate desc", member_id, (byte)DS_Album_Br.Permissions.不公开);
Repeater2.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
var bl = new DS_AlbumImg_Br();
var albbl = new DS_Album_Br();
if (IsPostBack)
{
return;
}
//处理ajax动作
string act = Request.Form["action"];
if (!string.IsNullOrEmpty(act))
{
var json = new JavaScriptSerializer();
switch (act)
{
case "loadimgdata":
Response.Write(json.Serialize(bl.GetSingle(int.Parse(Request.Form["img_id"]))));
break;
case "save":
var img = bl.GetSingle(int.Parse(Request.Form["img_id"]));
img.ImgTitle = Request.Form["title"].Trim();
img.ImgDescript = Request.Form["des"].Trim();
bl.Update(img);
break;
}
Response.End();
return;
}
//设置左边菜单
var mst = this.Master as Member_Manage_MasterPage;
mst.SetMenuTitle("图片管家", "相册管理");
var md = bl.GetSingle(int.Parse(Request.QueryString["img_id"]));
var album = albbl.GetSingle(md.AlbumID);
ViewState["albname"] = album.AlbumName;
ViewState["albid"] = album.ID;
ViewState["imgtitle"] = md.ImgTitle;
ViewState["imgurl"] = "/Resource/" + md.ImgUrl + "/" + md.ImgName;
ViewState["FrontCover"] = string.IsNullOrEmpty(album.FrontCover)?"":album.FrontCover.Substring(album.FrontCover.LastIndexOf("/") + 1);
//绑定图片
Repeater1.DataSource = bl.Query("albumid=@0", "px", md.AlbumID);
Repeater1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
var bl = new DS_AlbumImg_Br();
string act = Request["action"];
if (!string.IsNullOrEmpty(act))
{
switch (act)
{
case "edit":
var json = new JavaScriptSerializer();
//Response.Write(Request.Form["imglist"]);
var imglist = json.Deserialize <List <img> >(Request.Form["imglist"]);
foreach (var item in imglist)
{
var md = bl.GetSingle(item.ID);
md.ImgTitle = Server.UrlDecode(item.Title);
md.ImgDescript = Server.UrlDecode(item.Descript);
bl.Update(md, item.FontConver);
break;
}
break;
}
Response.End();
return;
}
if (IsPostBack)
{
return;
}
//设置左边菜单
var mst = this.Master as Member_Manage_MasterPage;
mst.SetMenuTitle("图片管家", "上传图片");
//绑定上传的图片
int recordCount = 0;
var list = bl.Query("AlbumID=@0", "id desc", 0, int.Parse(Request.QueryString["fc"]), ref recordCount, int.Parse(Request.QueryString["albumid"]));
Repeater1.DataSource = list;
Repeater1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
int album_id = int.Parse(Request.QueryString["album_id"]);
int member_id = _vMember.ID;
var bl = new DS_AlbumImg_Br();
Repeater1.DataSource = bl.Query("albumid=@0", "px", album_id);
Repeater1.DataBind();
var albbl = new DS_Album_Br();
var album = albbl.GetSingle(album_id);
ViewState["albumName"] = album.AlbumName.Length > 6?album.AlbumName.Substring(0, 6) + "..":album.AlbumName;
Repeater2.DataSource = albbl.Query("memberid=@0 and PictureNum>0 and Permissions!=@1", "updatedate desc", member_id, (byte)DS_Album_Br.Permissions.公开);
Repeater2.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
var bl = new DS_AlbumImg_Br();
var albbl = new DS_Album_Br();
if (IsPostBack) return;
//处理ajax动作
string act=Request.Form["action"];
if (!string.IsNullOrEmpty(act)) {
var json = new JavaScriptSerializer();
switch (act) {
case "loadimgdata":
Response.Write(json.Serialize(bl.GetSingle(int.Parse(Request.Form["img_id"]))));
break;
case "save":
var img= bl.GetSingle(int.Parse(Request.Form["img_id"]));
img.ImgTitle=Request.Form["title"].Trim();
img.ImgDescript=Request.Form["des"].Trim();
bl.Update(img);
break;
}
Response.End();
return;
}
//设置左边菜单
var mst = this.Master as Member_Manage_MasterPage;
mst.SetMenuTitle("图片管家", "相册管理");
var md=bl.GetSingle(int.Parse(Request.QueryString["img_id"]));
var album = albbl.GetSingle(md.AlbumID);
ViewState["albname"] = album.AlbumName;
ViewState["albid"] = album.ID;
ViewState["imgtitle"] = md.ImgTitle;
ViewState["imgurl"] ="/Resource/"+ md.ImgUrl + "/" + md.ImgName;
ViewState["FrontCover"] = string.IsNullOrEmpty(album.FrontCover)?"":album.FrontCover.Substring(album.FrontCover.LastIndexOf("/")+1);
//绑定图片
Repeater1.DataSource = bl.Query("albumid=@0","px",md.AlbumID);
Repeater1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
var bl = new DS_AlbumImg_Br();
string act=Request["action"];
if (!string.IsNullOrEmpty(act))
{
switch (act)
{
case "edit":
var json = new JavaScriptSerializer();
//Response.Write(Request.Form["imglist"]);
var imglist = json.Deserialize<List<img>>(Request.Form["imglist"]);
foreach (var item in imglist)
{
var md = bl.GetSingle(item.ID);
md.ImgTitle = Server.UrlDecode(item.Title);
md.ImgDescript = Server.UrlDecode(item.Descript);
bl.Update(md, item.FontConver);
break;
}
break;
}
Response.End();
return;
}
if (IsPostBack) return;
//设置左边菜单
var mst = this.Master as Member_Manage_MasterPage;
mst.SetMenuTitle("图片管家", "上传图片");
//绑定上传的图片
int recordCount = 0;
var list = bl.Query("AlbumID=@0", "id desc", 0, int.Parse(Request.QueryString["fc"]), ref recordCount, int.Parse(Request.QueryString["albumid"]));
Repeater1.DataSource = list;
Repeater1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
HttpPostedFile file = Request.Files["FileData"];
string uploadpath = Server.MapPath(Request["folder"] + "\\");
if (file != null)
{
var ud = Session["UserData"] as UserData;
int albumID = int.Parse(Request.QueryString["albumID"]);
var bl = new DS_Album_Br();
string album = bl.GetDirByID(ud.Member.ID,albumID);
var pbl = new DS_AlbumImg_Br();
var md = pbl.CreateModel();
md.AlbumID = albumID;
md.ImgUrl = album;
md.ImgName = "";
md.ImgTitle = file.FileName.Substring(0,file.FileName.LastIndexOf('.'));
md.ImgDescript = "";
md.Px = 0;
pbl.Add(md);
md.ImgName = "A"+albumID+"_"+DateTime.Now.ToString("yyyyMMddhhmmss") + "_" + md.ID + file.FileName.Substring(file.FileName.LastIndexOf('.'));
pbl.Update(md);
uploadpath = Server.MapPath("~" + Common.Constant.WebConfig("AlbumRootPath") + album) + "\\";
if (!Directory.Exists(uploadpath))
{
Directory.CreateDirectory(uploadpath);
}
file.SaveAs(uploadpath + md.ImgName);
Response.Write(Common.Constant.WebConfig("AlbumRootPath")+md.ImgUrl+"/"+md.ImgName);
}
else
{
Response.Write("0");
}
}
protected void Page_Load(object sender, EventArgs e)
{
HttpPostedFile file = Request.Files["FileData"];
string uploadpath = Server.MapPath(Request["folder"] + "\\");
if (file != null)
{
var ud = Session["UserData"] as UserData;
int albumID = int.Parse(Request.QueryString["albumID"]);
var bl = new DS_Album_Br();
string album = bl.GetDirByID(ud.Member.ID, albumID);
var pbl = new DS_AlbumImg_Br();
var md = pbl.CreateModel();
md.AlbumID = albumID;
md.ImgUrl = album;
md.ImgName = "";
md.ImgTitle = file.FileName.Substring(0, file.FileName.LastIndexOf('.'));
md.ImgDescript = "";
md.Px = 0;
pbl.Add(md);
md.ImgName = "A" + albumID + "_" + DateTime.Now.ToString("yyyyMMddhhmmss") + "_" + md.ID + file.FileName.Substring(file.FileName.LastIndexOf('.'));
pbl.Update(md);
uploadpath = Server.MapPath("~" + Common.Constant.WebConfig("AlbumRootPath") + album) + "\\";
if (!Directory.Exists(uploadpath))
{
Directory.CreateDirectory(uploadpath);
}
file.SaveAs(uploadpath + md.ImgName);
Response.Write(Common.Constant.WebConfig("AlbumRootPath") + md.ImgUrl + "/" + md.ImgName);
}
else
{
Response.Write("0");
}
}
protected void Page_Load(object sender, EventArgs e)
{
var bl = new DS_AlbumImg_Br();
var albbl = new DS_Album_Br();
int rc = 0;
int pagesize = 16;
string act=Request["action"];
if (!string.IsNullOrEmpty(act)) {
switch (act) {
case "chgPage":
Repeater4.DataSource = bl.Query("AlbumID=@0", "", (int.Parse(Request["pgind"]) - 1) * pagesize, pagesize, ref rc, int.Parse(Request.QueryString["id"]));
Repeater4.DataBind();
break;
case "setcovert":
var album = albbl.GetSingle(int.Parse(Request.Form["albumid"]));
album.FrontCover=Request.Form["src"];
albbl.Update(album);
Response.End();
break;
case "del":
try
{
bl.Delete(Request.Form["id"].TrimEnd(','));
rc = bl.Query("AlbumID=@0", "", int.Parse(Request.Form["albumid"])).Count();
Response.Write((rc % pagesize).Equals(0) ? rc / pagesize : rc / pagesize + 1);
Response.End();
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (Exception ex)
{
if (ex.Message.Contains("FK_DS_AlbumImg_DS_Album"))
{
Response.Write("当前相册包含有图片，必须将图片删除或转移到其他相册后才能删除。");
}
else
Response.Write("删除图片出错。" + ex.Message);
Response.End();
}
break;
}
return;
}
if (IsPostBack) return;
//设置左边菜单
var mst = this.Master as Member_Manage_MasterPage;
mst.SetMenuTitle("图片管家", "相册管理");
//绑定访问权限
Repeater2.DataSource = Enum.GetValues(typeof(Com.DianShi.BusinessRules.Album.DS_Album_Br.Permissions));
Repeater2.DataBind();
//绑定当前相册属性
var alb= albbl.Query("id=@0", "",int.Parse(Request.QueryString["id"]));
Repeater3.DataSource =alb;
Repeater3.DataBind();
ViewState["albname"] = alb.Single().AlbumName;
//绑定图片列表
Repeater4.DataSource = bl.Query("AlbumID=@0", "", 0, pagesize, ref rc, int.Parse(Request.QueryString["id"]));
Repeater4.DataBind();
ViewState["pageCount"] = (rc % pagesize).Equals(0) ? rc / pagesize : rc / pagesize + 1;
ViewState["rc"] = rc;
}
protected void Page_Load(object sender, EventArgs e)
{
var bl = new DS_AlbumImg_Br();
var albbl = new DS_Album_Br();
int rc = 0;
int pagesize = 16;
string act = Request["action"];
if (!string.IsNullOrEmpty(act))
{
switch (act)
{
case "chgPage":
Repeater4.DataSource = bl.Query("AlbumID=@0", "", (int.Parse(Request["pgind"]) - 1) * pagesize, pagesize, ref rc, int.Parse(Request.QueryString["id"]));
Repeater4.DataBind();
break;
case "setcovert":
var album = albbl.GetSingle(int.Parse(Request.Form["albumid"]));
album.FrontCover = Request.Form["src"];
albbl.Update(album);
Response.End();
break;
case "del":
try
{
bl.Delete(Request.Form["id"].TrimEnd(','));
rc = bl.Query("AlbumID=@0", "", int.Parse(Request.Form["albumid"])).Count();
Response.Write((rc % pagesize).Equals(0) ? rc / pagesize : rc / pagesize + 1);
Response.End();
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (Exception ex)
{
if (ex.Message.Contains("FK_DS_AlbumImg_DS_Album"))
{
Response.Write("当前相册包含有图片，必须将图片删除或转移到其他相册后才能删除。");
}
else
{
Response.Write("删除图片出错。" + ex.Message);
}
Response.End();
}
break;
}
return;
}
if (IsPostBack)
{
return;
}
//设置左边菜单
var mst = this.Master as Member_Manage_MasterPage;
mst.SetMenuTitle("图片管家", "相册管理");
//绑定访问权限
Repeater2.DataSource = Enum.GetValues(typeof(Com.DianShi.BusinessRules.Album.DS_Album_Br.Permissions));
Repeater2.DataBind();
//绑定当前相册属性
var alb = albbl.Query("id=@0", "", int.Parse(Request.QueryString["id"]));
Repeater3.DataSource = alb;
Repeater3.DataBind();
ViewState["albname"] = alb.Single().AlbumName;
//绑定图片列表
Repeater4.DataSource = bl.Query("AlbumID=@0", "", 0, pagesize, ref rc, int.Parse(Request.QueryString["id"]));
Repeater4.DataBind();
ViewState["pageCount"] = (rc % pagesize).Equals(0) ? rc / pagesize : rc / pagesize + 1;
ViewState["rc"] = rc;
}
