public NewsCategoryInfo GetInfo(int id)
{
NewsCategoryInfo info = null;
SqlParameter[] param =
{
new SqlParameter("@Id", id)
};
var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_NewsCategory_GetById", param);
if (r != null)
{
info = new NewsCategoryInfo();
while (r.Read())
{
info.Id = Int32.Parse(r["Id"].ToString());
info.Name = r["Name"].ToString();
info.Link = r["Link"].ToString();
info.Sort = Int32.Parse(r["Sort"].ToString());
info.Description = r["Description"].ToString();
info.MetaDescription = r["MetaDescription"].ToString();
info.MetaKeyword = r["MetaKeyword"].ToString();
info.MetaHeading = r["MetaHeading"].ToString();
info.Image = r["Image"].ToString();
info.TitleRewrite = r["TitleRewrite"].ToString();
info.ParentId = Int32.Parse(r["ParentId"].ToString());
}
r.Close();
r.Dispose();
}
return(info);
}
protected void Bind()
{
if (Request.QueryString["id"] != null)
{
if (Tools.TryParseMethod(Request.QueryString["id"].ToString()) != 0)
{
NewsCategoryInfo info = ncBLL.getAllById(id);
if (info.nc_fatherid != 0)
{
lbcategory.Text = ncBLL.getAllById(info.nc_id).nc_name;
}
lbName.Text = info.nc_name;
lbSorting.Text = info.nc_sorting.ToString();
img1.ImageUrl = Tools.GetAppSettings("NewsImageTruePath") + info.nc_image;
if (info.nc_show)
{
lbShow.Text = "顯示";
}
else
{
lbShow.Text = "不顯示";
}
}
}
}
public string getTitle(int id)
{
if (id == 0)
{
return("此為主類別");
}
NewsCategoryInfo info = ncBLL.getAllById(id);
return(info.nc_name);
}
private void SearchHierarchyVailNow(int fid)
{
NewsCategoryInfo info = getAllById(fid);
if (info.nc_id != 0)
{
HerichCountMath += 1;
SearchHierarchyVailNow(info.nc_fatherid);
}
}
public NewsCategoryInfo getAllById(int id)
{
NewsCategoryInfo info = new NewsCategoryInfo();
IDataReader reader = db.GetDataById(id).CreateDataReader();
while (reader.Read())
{
info = NewsCategoryInfo.Populate(reader);
}
return(info);
}
public List <NewsCategoryInfo> UpdataSorting(int fatherid, int sorting)
{
List <NewsCategoryInfo> infos = new List <NewsCategoryInfo>();
IDataReader reader = db.UpdataSorting(fatherid, sorting, lidValue).CreateDataReader();
while (reader.Read())
{
infos.Add(NewsCategoryInfo.Populate(reader));
}
return(infos);
}
/// <summary>
/// 取出所有Father與Lid符合的資料,並以Sort排序
/// </summary>
/// <param name="fatherId"></param>
/// <param name="lidvalue"></param>
/// <returns></returns>
public List <NewsCategoryInfo> GetDataByFatherIdAndLidOrderSorting(int fatherId, int lidvalue)
{
List <NewsCategoryInfo> infos = new List <NewsCategoryInfo>();
IDataReader reader = db.GetDataByFatherIdAndLidOrderSorting(fatherId, lidvalue).CreateDataReader();
while (reader.Read())
{
infos.Add(NewsCategoryInfo.Populate(reader));
}
return(infos);
}
public List <NewsCategoryInfo> getAll()
{
List <NewsCategoryInfo> infos = new List <NewsCategoryInfo>();
IDataReader reader = db.GetData().CreateDataReader();
while (reader.Read())
{
infos.Add(NewsCategoryInfo.Populate(reader));
}
return(infos);
}
public int GetDataByFatherIdAndLidOrderSortDESC(int fatherId, int lidvalue)
{
NewsCategoryInfo info = new NewsCategoryInfo();
IDataReader reader = db.GetDataByFatherIdAndLidOrderSortDESC(fatherId, lidvalue).CreateDataReader();
if (reader.Read())
{
info = NewsCategoryInfo.Populate(reader);
return(info.nc_sorting + 1);
}
return(1);
}
public bool SearchHierarchyEqualVail(int id, int Hierarchy)
{
NewsCategoryInfo info = getAllById(id);
if (info.nc_id != 0)
{
SearchHierarchyVailNow(info.nc_fatherid);
}
if (Hierarchy == HerichCountMath)
{
return(true);
}
return(false);
}
protected void InsertData()
{
NewsCategoryInfo info = new NewsCategoryInfo();
info.nc_fatherid = Tools.TryParseMethod(ddlCategory.SelectedValue);
info.nc_name = txtName.Text;
info.nc_image = Image1.AlternateText;
info.nc_show = bool.Parse(rbShow.SelectedValue);
info.l_id = lid;
if (ncBLL.Insert(info) > 0)
{
Response.Redirect("List.aspx?header=" + Getmessage("30009"));
}
}
public List <NewsCategoryInfo> GetList(int pageIndex, int pageSize, out int total)
{
List <NewsCategoryInfo> list = null;
var t = 0;
SqlParameter[] param =
{
new SqlParameter("@pageIndex", pageIndex),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@totalrow", DbType.Int32)
{
Direction = ParameterDirection.Output
}
};
SqlCommand comx;
var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_NewsCategory_GetList", param, out comx);
if (r != null)
{
list = new List <NewsCategoryInfo>();
while (r.Read())
{
var info = new NewsCategoryInfo();
info.Id = Int32.Parse(r["Id"].ToString());
info.Name = r["Name"].ToString();
info.Link = r["Link"].ToString();
info.Sort = Int32.Parse(r["Sort"].ToString());
info.Description = r["Description"].ToString();
info.MetaDescription = r["MetaDescription"].ToString();
info.MetaKeyword = r["MetaKeyword"].ToString();
info.MetaHeading = r["MetaHeading"].ToString();
info.Image = r["Image"].ToString();
info.TitleRewrite = r["TitleRewrite"].ToString();
info.ParentId = Int32.Parse(r["ParentId"].ToString());
list.Add(info);
}
r.Close();
r.Dispose();
t = int.Parse(comx.Parameters[2].Value.ToString());
}
total = t;
return(list);
}
public int Add(NewsCategoryInfo info)
{
SqlParameter[] param =
{
new SqlParameter("@Name", info.Name),
new SqlParameter("@Link", info.Link),
new SqlParameter("@Sort", info.Sort),
new SqlParameter("@Description", info.Description),
new SqlParameter("@MetaDescription", info.MetaDescription),
new SqlParameter("@MetaKeyword", info.MetaKeyword),
new SqlParameter("@MetaHeading", info.MetaHeading),
new SqlParameter("@Image", info.Image),
new SqlParameter("@TitleRewrite", info.TitleRewrite),
new SqlParameter("@ParentId", info.ParentId)
};
return(int.Parse(DataHelper.ExecuteScalar(Config.ConnectString, "usp_NewsCategory_Add", param).ToString()));
}
public void Bind()
{
if (Request.QueryString["id"] != null)
{
if (Tools.TryParseMethod(id.ToString()) != 0)
{
NewsCategoryInfo info = ncBLL.getAllById(id);
txtName.Text = info.nc_name;
ddlCategory.SelectedValue = info.nc_fatherid.ToString();
if (info.nc_fatherid == 0)
{
ddlCategory.Enabled = false;
}
Image1.ImageUrl = Tools.GetAppSettings("NewsImageTruePath") + info.nc_image;
Image1.AlternateText = info.nc_image;
rbShow.SelectedValue = info.nc_show.ToString().ToLower();
hfImg.Value = info.nc_image;
}
}
}
public int Update(NewsCategoryInfo info)
{
int check = 1;
NewsCategoryInfo ncinfo = getAllById(info.nc_id);
//1.限制選自己
if (info.nc_fatherid != info.nc_id)
{
//2.不可選自己的下一層
List <NewsCategoryInfo> checkinfos = GetallSortData(info.nc_id); //以自己為父,取出向下所有資料
foreach (NewsCategoryInfo ckinfo in checkinfos)
{
if (ckinfo.nc_id == info.nc_fatherid) //選取值FatherId 若等於 nc_id,即不可更新
{
check = 0;
}
}
if (check == 1)
{
if (info.nc_fatherid == ncinfo.nc_fatherid)
{
countmath = ncinfo.nc_sorting;
}
else
{
countmath = GetDataByFatherIdAndLidOrderSortDESC(info.nc_fatherid, lidValue);
result = UpdataSorting(ncinfo.nc_fatherid, ncinfo.nc_sorting);
foreach (NewsCategoryInfo sortinfo in result)
{
db.Update(sortinfo.nc_name, sortinfo.nc_fatherid, sortinfo.nc_image, sortinfo.nc_show, sortinfo.l_id, countmath, sortinfo.nc_id);
}
}
return(db.Update(info.nc_name, info.nc_fatherid, info.nc_image, info.nc_show, info.l_id, countmath, info.nc_id));
}
}
return(check);
}
private bool AddNewCate()
{
if (string.IsNullOrEmpty(txtCategoryname.Text) || string.IsNullOrEmpty(txtSort.Text))
{
ltrThongbao.Text = "Cần nhập đủ các trường!";
return(false);
}
var info = new NewsCategoryInfo();
info.Name = txtCategoryname.Text;
var nextId = UntilityFunction.nextId("NewsCategory");
info.Link = Rewrite.GenCate(info.Name, nextId, Rewrite.News);
info.Sort = int.Parse(txtSort.Text);
info.Description = txtMota.Text;
info.MetaDescription = txtMota.Text;
info.MetaHeading = "";
info.MetaKeyword = txtTukhoa.Text;
info.ParentId = 0;
info.TitleRewrite = "";
info.Image = "";
NewsCategoryImpl.Instance.Add(info);
return(true);
}
protected void Button1_Click(object sender, EventArgs e)
{
if (!Directory.Exists(Server.MapPath("NewsImageTruePath")))
{
System.IO.Directory.CreateDirectory(Server.MapPath("~/ImageCollection/news/"));
}
if (ncBLL.SearchHierarchyDownVail(Tools.TryParseMethod(ddlCategory.SelectedValue), id, int.Parse(UserInfoConfig.GetUserConfig("HierarchyNewsCategory"))))
{
if (hfImg.Value != Image1.AlternateText)
{
FileInfo file = new FileInfo(Server.MapPath(Image1.ImageUrl));
file.CopyTo(Server.MapPath(Tools.GetAppSettings("NewsImageTruePath") + Image1.AlternateText));
if (File.Exists(Server.MapPath(Tools.GetAppSettings("NewsImageTruePath") + hfImg.Value)))
{
File.Delete(Server.MapPath(Tools.GetAppSettings("NewsImageTruePath") + hfImg.Value));
}
}
NewsCategoryInfo info = ncBLL.getAllById(id);
info.nc_fatherid = Tools.TryParseMethod(ddlCategory.SelectedValue);
info.nc_name = txtName.Text;
info.nc_show = bool.Parse(rbShow.SelectedValue);
info.nc_image = Image1.AlternateText;
if (ncBLL.Update(info) > 0)
{
Response.Redirect("List.aspx?header=修改訊息完成!", true);
}
else
{
ShowMessage("更新失敗: 更新類別不可為自身、不可為自身以下的子類別");
}
}
else
{
ShowMessage("轉換類別超越階層限制數");
}
}
//NEW End
public int Insert(NewsCategoryInfo info)
{
int sortinfo = GetDataByFatherIdAndLidOrderSortDESC(info.nc_fatherid, info.l_id);
return(db.Insert(info.nc_name, info.nc_fatherid, info.nc_image, info.nc_show, info.l_id, sortinfo));
}
