private void DelCat(int catid)
{
ClassInfoBll catbll = new ClassInfoBll();
var cat = new ClassInfoBll().getCat(catid);
if (cat == null)
return;
catbll.DelCat(cat);
}
protected void Page_Load(object sender, EventArgs e)
{
Master.breadcrumb = "<li class=\"active\">分类管理</li>";
siteData = new ClassInfoBll().GetSiteCatJson();
if (!IsPostBack && Request.QueryString["delId"] != null)
{
int delId;
if (!int.TryParse(Request.QueryString["delId"], out delId))
return;
DelCat(delId);
}
}
public string BingCat(int id,int catid)
{
var siteCat = GetCatById(id);
if (siteCat == null)
return "没找到商城分类 id:" + id;
var cat = new ClassInfoBll().getCat(catid);
if (cat == null)
return "没找到分类 catid:" + catid;
siteCat.BindClassId = catid;
siteCat.BindClassName = cat.CatName;
siteCat.IsBind = true;
var flag = new SiteClassInfoDB().BingCatInfo(siteCat);
if (flag)
return "绑定成功";
return "绑定失败";
}
/// <summary>
/// 添加分类
/// </summary>
private void addCat()
{
if (Request.Form.Count < 3 || string.IsNullOrEmpty(Request.Form["catName"]) ||
string.IsNullOrEmpty(Request.Form["parCatName"]))
return;
int parentId;
if (!int.TryParse(Request.Form["parCatName"], out parentId))
return;
int catSort;
int.TryParse(Request.Form["catSort"], out catSort);
ClassInfo cat = new ClassInfo();
cat.CatName = Request.Form["catName"];
cat.SpellWord = new WordCenter().GetPyString(cat.CatName);
cat.SEOWords = Request.Form["seoKey"];
cat.Sort = catSort;
cat.CreateDate = DateTime.Now;
cat.UpdateTime = DateTime.Now;
cat.HasChild = false;
cat.IsDel = false;
ClassInfoBll catbll = new ClassInfoBll();
if (parentId != 0)
{
ClassInfo parCat = catbll.getCat(parentId);
cat.ParentId = parCat.Id;
cat.Level = parCat.Level + 1;
cat.ParentName = parCat.CatName;
if (!string.IsNullOrEmpty(parCat.CatCrumbleIds))
{
cat.CatCrumbleIds = parCat.CatCrumbleIds + "," + parCat.Id;
cat.CatCrumbleNames = parCat.CatCrumbleNames + "," + parCat.CatName;
}
else
{
cat.CatCrumbleIds = parCat.Id.ToString(CultureInfo.InvariantCulture);
cat.CatCrumbleNames = parCat.CatName;
}
if (!parCat.HasChild)
{
parCat.HasChild = true;
catbll.UpdateCat(parCat);
}
}
else
{
cat.ParentId = 0;
cat.Level = 1;
cat.ParentName = "";
cat.CatCrumbleIds = "";
cat.CatCrumbleNames = "";
}
catbll.AddCat(cat);
}
private void UpdateChildCat(ClassInfo oldCat)
{
ClassInfoBll catbll = new ClassInfoBll();
var list = catbll.GetChildCatById(oldCat.Id);
foreach (var cat in list)
{
cat.Level = oldCat.Level + 1;
cat.ParentName = oldCat.CatName;
if (!string.IsNullOrEmpty(oldCat.CatCrumbleIds))
{
cat.CatCrumbleNames = oldCat.CatCrumbleNames + "," + oldCat.CatName;
cat.CatCrumbleIds = oldCat.CatCrumbleIds + "," + oldCat.Id;
}
else
{
cat.CatCrumbleIds = oldCat.Id.ToString(CultureInfo.InvariantCulture);
cat.CatCrumbleNames = oldCat.CatName;
}
cat.UpdateTime = DateTime.Now;
catbll.UpdateCat(cat);
if (cat.HasChild)
{
UpdateChildCat(cat);
}
}
}
private void UpdateCat(int catId)
{
int parentId;
if (!int.TryParse(Request.Form["parCatName"], out parentId))
return;
int catSort;
int.TryParse(Request.Form["catSort"], out catSort);
ClassInfoBll catbll = new ClassInfoBll();
var oldCat = new ClassInfoBll().getCat(catId);
if (oldCat == null)
return;
oldCat.UpdateTime = DateTime.Now;
oldCat.SpellWord = new WordCenter().GetPyString(oldCat.CatName);
oldCat.SEOWords = Request.Form["seoKey"];
oldCat.Sort = catSort;
if (oldCat.ParentId == parentId && oldCat.CatName == Request.Form["catName"])
{
catbll.UpdateCat(oldCat);
return;
}
oldCat.CatName = Request.Form["catName"];
if (parentId != 0)
{
ClassInfo parCat = catbll.getCat(parentId);
oldCat.ParentId = parCat.Id;
oldCat.Level = parCat.Level + 1;
oldCat.ParentName = parCat.CatName;
if (!string.IsNullOrEmpty(parCat.CatCrumbleIds))
{
oldCat.CatCrumbleIds = parCat.CatCrumbleIds + "," + parCat.Id;
oldCat.CatCrumbleNames = parCat.CatCrumbleNames + "," + parCat.CatName;
}
else
{
oldCat.CatCrumbleIds = parCat.Id.ToString(CultureInfo.InvariantCulture);
oldCat.CatCrumbleNames = parCat.CatName;
}
if (!parCat.HasChild)
{
parCat.HasChild = true;
catbll.UpdateCat(parCat);
}
}
else
{
oldCat.ParentId = 0;
oldCat.Level = 1;
oldCat.ParentName = "";
oldCat.CatCrumbleIds = "";
oldCat.CatCrumbleNames = "";
}
catbll.UpdateCat(oldCat);
if (oldCat.HasChild)
{
UpdateChildCat(oldCat);
}
}
private void BingOldCat(int catId)
{
var oldCat = new ClassInfoBll().getCat(catId);
if (oldCat == null)
return;
oldCatName = oldCat.CatName;
oldSeo = oldCat.SEOWords;
oldSort = oldCat.Sort == 0 ? "" : oldCat.Sort.ToString(CultureInfo.InvariantCulture);
ParCatId = oldCat.ParentId;
if (oldCat.IsHide)
{
oldHide = "checked='checked'";
}
}
/// <summary>
/// 下拉框分类绑定
/// </summary>
/// <param name="pid"></param>
private void BingNode(int pid)
{
SiteData = new ClassInfoBll().GetSiteCatJson();
var parList = catList.Where(p => p.ParentId == pid);
foreach (var item in parList)
{
string level = "";
for (int i = 1; i < item.Level; i++)
{
level += " ";
}
if (item.Id == ParCatId && ParCatId > 0)
ParaCatInfo.Append(string.Format(Mode1, item.Id, level + item.CatName));
else
ParaCatInfo.Append(string.Format(Mode, item.Id, level + item.CatName));
if (item.HasChild)
BingNode(item.Id);
}
}
/// <summary>
/// 批量添加分类
/// </summary>
/// <param name="catid"></param>
private void bathAddCat(string catid)
{
SiteClassBll bll = new SiteClassBll();
int siteClassId;
int parentId;
SiteClassInfo siteCat = new SiteClassInfo();
if (int.TryParse(catid, out siteClassId))
{
siteCat = bll.GetCatById(siteClassId);
SiteCatName = siteCat.ClassName.Replace(" ","");
}
if (!int.TryParse(Request.Form["parCatName"], out parentId))
return;
#region 添加分类
ClassInfo cat = new ClassInfo();
cat.CatName = SiteCatName;
cat.SpellWord = WordCenter.GetShortPinyin(cat.CatName);
cat.SEOWords = "";
cat.Sort = 0;
cat.CreateDate = DateTime.Now;
cat.UpdateTime = DateTime.Now;
cat.HasChild = false;
ClassInfoBll catbll = new ClassInfoBll();
if (parentId != 0)
{
ClassInfo parCat = catbll.getCat(parentId);
cat.ParentId = parCat.Id;
cat.Level = parCat.Level + 1;
cat.ParentName = parCat.CatName;
if (!string.IsNullOrEmpty(parCat.CatCrumbleIds))
{
cat.CatCrumbleIds = parCat.CatCrumbleIds + "," + parCat.Id;
cat.CatCrumbleNames = parCat.CatCrumbleNames + "," + parCat.CatName;
}
else
{
cat.CatCrumbleIds = parCat.Id.ToString(CultureInfo.InvariantCulture);
cat.CatCrumbleNames = parCat.CatName;
}
if (!parCat.HasChild)
{
parCat.HasChild = true;
catbll.UpdateCat(parCat);
}
}
else
{
cat.ParentId = 0;
cat.Level = 1;
cat.ParentName = "";
cat.CatCrumbleIds = "";
cat.CatCrumbleNames = "";
}
cat.Id = catbll.AddCat(cat);
#endregion
#region 添加子分类
AllSiteCat = bll.GetClassInfo(siteCat.SiteId);
addChildCat(siteCat.ClassId, cat);
#endregion
}
/// <summary>
/// 添加商城对应的子分类
/// </summary>
/// <param name="siteCatId"></param>
/// <param name="parCat"></param>
private void addChildCat(string siteCatId, ClassInfo parCat)
{
var ChildCat = AllSiteCat.Where(p => p.ParentClass == siteCatId);
foreach (var child in ChildCat)
{
ClassInfo cat = new ClassInfo();
cat.CatName = child.ClassName.Replace(" ","");
cat.SpellWord = WordCenter.GetShortPinyin(cat.CatName);
cat.SEOWords = "";
cat.Sort = 0;
cat.CreateDate = DateTime.Now;
cat.UpdateTime = DateTime.Now;
cat.HasChild = false;
ClassInfoBll catbll = new ClassInfoBll();
if (parCat != null)
{
cat.ParentId = parCat.Id;
cat.Level = parCat.Level + 1;
cat.ParentName = parCat.CatName;
if (!string.IsNullOrEmpty(parCat.CatCrumbleIds))
{
cat.CatCrumbleIds = parCat.CatCrumbleIds + "," + parCat.Id;
cat.CatCrumbleNames = parCat.CatCrumbleNames + "," + parCat.CatName;
}
else
{
cat.CatCrumbleIds = parCat.Id.ToString(CultureInfo.InvariantCulture);
cat.CatCrumbleNames = parCat.CatName;
}
if (!parCat.HasChild)
{
parCat.HasChild = true;
catbll.UpdateCat(parCat);
}
cat.Id = int.Parse(catbll.AddCat(cat).ToString());
if (AllSiteCat.Exists(p => p.ParentClass == child.ClassId))
{
addChildCat(child.ClassId, cat);
}
}
}
}
public void CaseInit(SpiderConfig config)
{
int error = 0;
do
{
try
{
RegProList = new RegProListBll().GetRegProList();
MessageCenter.ShowBox("正则数据导入完毕！", 2);
SiteClassList = new SiteClassBll().GetBingCat(config.ClassInfoId,config.SiteInfoId);
MessageCenter.ShowBox("更新数据导入完毕！", 2);
ClassList = new ClassInfoBll().GetAllCatInfo();
MessageCenter.ShowBox("分类数据导入完毕！", 2);
ProListCount = SiteClassList.Count;
break;
}
catch (Exception ex)
{
error++;
Thread.Sleep(60000);
LogServer.WriteLog(ex);
}
} while (error<5);
}
