protected void GetView()
{
int Tid = 0;
if (string.IsNullOrEmpty(TMailList.SelectedNodeID))
{
Tid = 0;
}
else
{
Tid = int.Parse(TMailList.SelectedNodeID);
}
Maticsoft.BLL.tPicture BLL = new Maticsoft.BLL.tPicture();
if (Tid == 0)
{
Grid.RecordCount = BLL.GetRecordCount("");
Grid.DataSource = BLL.GetListByPage("", " Sort desc,Id desc ", Grid.PageIndex * Grid.PageSize, (Grid.PageIndex + 1) * Grid.PageSize);
}
else
{
Grid.RecordCount = BLL.GetRecordCount(" PicTyID=" + Tid);
Grid.DataSource = BLL.GetListByPage(" PicTyID=" + Tid, " Sort desc, Id desc ", Grid.PageIndex * Grid.PageSize, (Grid.PageIndex + 1) * Grid.PageSize);
}
Grid.DataBind();
}
protected void btnSelect_Click(object sender, EventArgs e)
{
string txtVal = this.txtValue.Text.Trim();
if (txtVal == "")
{
GetView();
}
int Tid = 0;
if (string.IsNullOrEmpty(TMailList.SelectedNodeID))
{
Tid = 0;
}
else
{
Tid = int.Parse(TMailList.SelectedNodeID);
}
Maticsoft.BLL.tPicture BLL = new Maticsoft.BLL.tPicture();
if (Tid == 0)
{
Grid.RecordCount = BLL.GetRecordCount(String.Format(" Name like '%{0}%' ", txtVal));
Grid.DataSource = BLL.GetListByPage(String.Format(" Name like '%{0}%' ", txtVal), " Sort desc,Id desc ", Grid.PageIndex * Grid.PageSize, (Grid.PageIndex + 1) * Grid.PageSize);
}
else
{
Grid.RecordCount = BLL.GetRecordCount(String.Format(" Name like '%{0}%' and PicTyID=" + Tid, txtVal));
Grid.DataSource = BLL.GetListByPage(String.Format(" Name like '%{0}%' and PicTyID=" + Tid, txtVal), " Sort desc, Id desc ", Grid.PageIndex * Grid.PageSize, (Grid.PageIndex + 1) * Grid.PageSize);
}
Grid.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
btnClose.OnClientClick = ActiveWindow.GetHideReference();
BindGrid();
if (!String.IsNullOrEmpty(Request.QueryString["tyId"]))
{
ddlfatherId.SelectedValue = Request.QueryString["tyId"];
ddlfatherId.Enabled = false;
}
if (!String.IsNullOrEmpty(Request.QueryString["Id"]))
{
ddlfatherId.Enabled = true;
Maticsoft.BLL.tPicture bll = new Maticsoft.BLL.tPicture();
Maticsoft.Model.tPicture model = bll.GetModel(int.Parse(Request.QueryString["Id"]));
txtTile.Text = model.Name;
txtRemark.Text = model.Remark;
ddlfatherId.SelectedValue = model.PicTyID.ToString();
txtSort.Text = model.Sort.ToString();
hfEditorInitValue.Text = "<img src=" + "'" + model.Code + "'" + "/>";
}
}
}
protected void BindGridByTid(int Tid)
{
Maticsoft.BLL.tPicture BLL = new Maticsoft.BLL.tPicture();
if (Tid == 0)
{
Grid.RecordCount = BLL.GetRecordCount("");
Grid.DataSource = BLL.GetListByPage("", " Sort desc,Id desc ", Grid.PageIndex * Grid.PageSize, (Grid.PageIndex + 1) * Grid.PageSize);
}
else
{
Grid.RecordCount = BLL.GetRecordCount(" PicTyID=" + Tid);
Grid.DataSource = BLL.GetListByPage(" PicTyID=" + Tid, " Sort desc, Id desc ", Grid.PageIndex * Grid.PageSize, (Grid.PageIndex + 1) * Grid.PageSize);
}
Grid.DataBind();
}
public string GetPic(int tid, int top)
{
Maticsoft.BLL.tPicture BLL = new Maticsoft.BLL.tPicture();
DataTable dt = BLL.GetListByPage(" PicTyID=" + tid, " Sort desc,Id desc ", 0, top).Tables[0];
StringBuilder sb = new StringBuilder();
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<li>");
sb.Append("<img src=" + dt.Rows[i]["Code"].ToString().Replace("~/", "../") + " />");
sb.Append("</li>");
}
return(sb.ToString());
}
protected void Grid_RowCommand(object sender, GridCommandEventArgs e)
{
int artId = GetSelectedDataKeyID(Grid);
if (e.CommandName == "Delete")
{
Maticsoft.BLL.tPicture BLL = new Maticsoft.BLL.tPicture();
Maticsoft.Model.tPicture model = BLL.GetModel(artId);
string directoryPath = Server.MapPath(model.Code);
File.Delete(directoryPath);
BLL.Delete(artId);
GetView();
}
if (e.CommandName == "Edit")
{
PageContext.RegisterStartupScript(Window1.GetShowReference("PicturesEdit.aspx?Id=" + artId));
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Maticsoft.BLL.tPicture bll = new Maticsoft.BLL.tPicture();
string content = Request.Form["editor1"] == null ? "" : Request.Form["editor1"];
if (string.IsNullOrEmpty(content))
{
Alert.ShowInTop("图片为空！"); return;
}
string[] picList = GetHtmlImageUrlList(content);
if (picList.Length <= 0)
{
Alert.ShowInTop("图片为空！"); return;
}
if (!String.IsNullOrEmpty(Request.QueryString["tyId"]))
{
int k = 0;
for (int i = 0; i < picList.Length; i++)
{
Maticsoft.Model.tPicture model = new Maticsoft.Model.tPicture();
model.Code = picList[i];
model.Name = txtTile.Text;
model.Remark = txtRemark.Text;
model.ImageUrl = txtUrl.Text;
model.PicTyID = int.Parse(ddlfatherId.SelectedValue);
model.Sort = int.Parse(txtSort.Text);
if (bll.Add(model) > 0)
{
k++;
}
}
if (k > 0)
{
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
else
{
Alert.ShowInTop("添加失败！"); return;
}
}
if (!String.IsNullOrEmpty(Request.QueryString["Id"]))
{
if (picList.Length > 1)
{
Alert.ShowInTop("请上传一张图片！"); return;
}
Maticsoft.Model.tPicture model = bll.GetModel(int.Parse(Request.QueryString["Id"]));
if (picList[0] != model.Code)
{
string directoryPath = Server.MapPath(model.Code);
File.Delete(directoryPath);
}
model.Code = picList[0];
model.Name = txtTile.Text;
model.Remark = txtRemark.Text;
model.ImageUrl = txtUrl.Text;
model.PicTyID = int.Parse(ddlfatherId.SelectedValue);
model.Sort = int.Parse(txtSort.Text);
bll.Update(model);
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
}
