//验证同级分类名称是否重复
public bool CheckNameDuplicate(string name, int excludeSysNo, ECCategoryLevel level, string companyCode, string channelID, string parentSysnoList)
{
//DataCommand cmd = DataCommandManager.GetDataCommand("ECCategory_CheckNameDuplicate");
//cmd.SetParameterValue("@ExcludeSysNo", excludeSysNo);
//cmd.SetParameterValue("@CategoryName", name);
//cmd.SetParameterValue("@Level", level);
//cmd.SetParameterValue("@CompanyCode", companyCode);
////TODO:添加渠道参数
//cmd.SetParameterValue("@parentSysnoList", parentSysnoList);
//return cmd.ExecuteScalar<int>() > 0;
CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("ECCategory_CheckNameDuplicate");
string expendStr = string.Format("AND cr.ParentSysno in ({0})", parentSysnoList);
if (level != ECCategoryLevel.Category1)
{
cmd.CommandText = cmd.CommandText.Replace("#parentSysnoList", expendStr);
}
else
{
cmd.CommandText = cmd.CommandText.Replace("#parentSysnoList", "");
}
cmd.SetParameterValue("@ExcludeSysNo", excludeSysNo);
cmd.SetParameterValue("@CategoryName", name);
cmd.SetParameterValue("@Level", level);
cmd.SetParameterValue("@CompanyCode", companyCode);
//TODO:添加渠道参数
return(cmd.ExecuteScalar <int>() > 0);
}
private void btnAddChild_Click(object sender, RoutedEventArgs e)
{
if (_currentVM != null)
{
//当前节点做为要创建子节点的父级节点
ECCategoryVM parent = _currentVM;
_currentVM = new ECCategoryVM();
//根据当前节点的Level确定其子级的level
ECCategoryLevel childLevel = ECCategoryLevel.Category1;
if (parent.Level == ECCategoryLevel.Category1)
{
childLevel = ECCategoryLevel.Category2;
}
else if (parent.Level == ECCategoryLevel.Category2)
{
childLevel = ECCategoryLevel.Category3;
}
_currentVM.Level = childLevel;
_currentVM.ChannelID = parent.ChannelID;
_currentVM.Parents.Add(parent);
_currentVM.ParentCount = _currentVM.Parents.Count;
ChangeToCreateMode(_currentVM);
}
}
/// <summary>
/// 查询前台分类可用的子类
/// </summary>
/// <param name="sysNo">子级level</param>
/// <returns>可用子类列表</returns>
public List <ECCategory> GetECCategoryChildren(ECCategoryLevel ecCategoryLevel)
{
DataCommand cmd = DataCommandManager.GetDataCommand("ECCategory_GetECCategoryChildren");
cmd.SetParameterValue("@Level", ecCategoryLevel);
return(cmd.ExecuteEntityList <ECCategory>());
}
private ECCategoryLevel GetParentLevel(ECCategoryLevel currentLevel)
{
switch (currentLevel)
{
case ECCategoryLevel.Category3:
return ECCategoryLevel.Category2;
case ECCategoryLevel.Category2:
return ECCategoryLevel.Category1;
default:
return ECCategoryLevel.Category1;
}
}
private ECCategoryLevel GetChildLevel(ECCategoryLevel currentLevel)
{
switch (currentLevel)
{
case ECCategoryLevel.Category2:
return ECCategoryLevel.Category3;
case ECCategoryLevel.Category1:
return ECCategoryLevel.Category2;
default:
return ECCategoryLevel.Category3;
}
}
public virtual ECCategoryChildView LoadECCategoryChildView(string id, string level, string rid)
{
int sysNo = int.Parse(id);
//层级关系表中的系统编号
int rSysNo = int.Parse(rid);
ECCategoryChildView view = new ECCategoryChildView();
ECCategoryLevel currentLevel = (ECCategoryLevel)Enum.Parse(typeof(ECCategoryLevel), level);
var childLevel = GetChildLevel(currentLevel);
view.ChildCategoryList = _ecCategoryQueryDA.GetECCategoryChildren(childLevel);
view.CurrentChildSysNoList = _ecCategoryQueryDA.GetECCategoryCurrentChildSysNos(sysNo, rSysNo);
return view;
}
public virtual ECCategoryParentView LoadECCategoryParentView(string id, string level)
{
int sysNo = int.Parse(id);
ECCategoryParentView view = new ECCategoryParentView();
if (sysNo > 0)
{
view.CurrentParentSysNoList = _ecCategoryQueryDA.GetECCategoryCurrentParentSysNos(sysNo);
}
ECCategoryLevel currentLevel = (ECCategoryLevel)Enum.Parse(typeof(ECCategoryLevel), level);
ECCategoryLevel parentLevel = GetParentLevel(currentLevel);
view.ParentCategoryList = _ecCategoryQueryDA.GetECCategoryParents(parentLevel);
return view;
}
public void LoadChildView(int sysNo, ECCategoryLevel currentLevel, int rSysNo, EventHandler <RestClientEventArgs <ECCategoryChildView> > callback)
{
string relativeUrl = "/MKTService/ECCategory/LoadChildView/" + sysNo.ToString() + "/" + currentLevel.ToString() + "/" + rSysNo.ToString();
restClient.Query <ECCategoryChildView>(relativeUrl, callback);
}