/// <summary>
/// 保存删除
/// </summary>
/// <param name="pkids"></param>
private void DeleteRow(string pkids)
{
if (pkids.Length > 0)
{
//执行删除数据前获取到要删除文件的路径
string images = GetDelImg(TblName, PKField + " in(" + pkids + ")", "pic");
if (CSA.DAL.Util.deleteRecord(TblName, PKField + " in (" + pkids + ")") > 0)
{
string[] ids = pkids.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
foreach (string id in ids)
{
//删除图片节省空间
List <Bs_NewsAlbums> albumsList = new Bs_NewsAlbumsDao().GetList(id.Replace("'", ""), "product");
new Bs_NewsAlbumsDao().DeleteFile(albumsList); //删除图片
//删除图片关联表
CSA.DAL.DBAccess.ExecuteNonQuery("delete from Bs_NewsAlbums where new_pkid =" + id + " and type='product'");
//添加日志操作
BLL.Sys.AdminLog.AddLog(Request.QueryString["mid"], Header.Title, TblName, id.Replace("'", ""), "删除", "");
}
bindData();
//删除成功，执行清除文件，节省空间
DeleteImg(images, new string[] { "/upload/small/", "/upload/" });
JscriptMsg("删除成功！", "", "Success");
}
else
{
JscriptMsg("删除失败！", "", "Error");
}
}
else
{
JscriptMsg("请选择要删除的记录行！", "", "Error");
}
}
private void bindData()
{
string type = Request.QueryString["type"];
if (type.ToLower() == "mod" || type.ToLower() == "del")
{
this.PKID.Value = Request.QueryString["pkid"];
if (this.PKID.Value != "")
{
string sql = "select * from {0} where {1}='{2}'";
sql = string.Format(sql, TblName, PKField, this.PKID.Value);
using (DataTable dt = DBAccess.getRS(sql))
{
if (dt.Rows.Count > 0)
{
ControlHelper.bindControlByDataRow(divDtls, dt.Rows[0], null);
}
List <Bs_NewsAlbums> models = new Bs_NewsAlbumsDao().GetList(this.PKID.Value, "product");
LitAlbumList.Text = GetAlbumHtml(models, dt.Rows[0]["Photos"].ToString());
focus_photo.Value = dt.Rows[0]["Photos"].ToString();
}
}
}
}
