public Info_place_info GetAll2Root()
{
List <Info_place_info> list = this.Repository.Query().From <Tb_place_info>()
.ToSelect().EndSelect()
.ToOrderBy()
.ASC(Tb_place_info.Table.Place_Id)
.EndOrderBy()
.ToQuery()
.ToList <Info_place_info>();
var rootQuery = from item in list
where item.Level == 0
select item;
Info_place_info root = null;
foreach (var v in rootQuery)
{
root = v;
break;
}
GetChildren(list, root);
return(root);
}
public override bool Update(Info_place_info tNew, Info_place_info tOld)
{
return(this.Repository.Update <Tb_place_info>()
.Set()
.Field(Model.Tb_place_info.Table.Place_Name, tNew.Place_Name)
.EndSet()
.Where().And(Tb_place_info.Table.Place_Id, tNew.Place_Id)
.EndWhere()
.Save() > 0 ? true : false);
}
private void BtnUseDefault_Click(object sender, EventArgs e)
{
Model.Tb_default_adress info = defaultAdressManager.FindThe();
if (info == null)
{
return;
}
Info_place_info placeInfo = Cache.LogicCache.DicPlaces[info.Place_Id];
placeInfo.DetailAdress = info.Detail_Adress;
SetDataSource(placeInfo);
}
private void GetChildren(List <Info_place_info> list, Info_place_info parent)
{
var queryChild = from item in list
where item.Parent_Id == parent.Place_Id
select item;
foreach (var v in queryChild)
{
parent.Children.Add(v);
v.Parent = parent;
GetChildren(list, v);
}
}
private void LoadTreeNode(TreeNode parentNode, Info_place_info root)
{
if (root.Children.Count > 0)
{
foreach (var v in root.Children)
{
TreeNode node = new TreeNode(v.Place_Name);
node.ImageIndex = v.Level;
node.Tag = v;
parentNode.Nodes.Add(node);
if (v.Children.Count > 0)
{
LoadTreeNode(node, v);
}
}
}
}
public override bool Remove(Info_place_info t)
{
ExeBatchTrans batchTrans = this.BatchTrans();
batchTrans.Append <long>((r, id) => {
if (r.Remove <Tb_place_info>().Where()
.And(Model.Tb_place_info.Table.Place_Id, id)
.EndWhere().Save() < 1)
{
return(false);
}
return(true);
}, t.Place_Id);
AddDeleteBatch(batchTrans, t);
return(batchTrans.Save());
}
private void AddDeleteBatch(ExeBatchTrans batchTrans, Info_place_info t)
{
if (t.Children.Count > 0)
{
batchTrans.Append <long>((r, id) => {
if (r.Remove <Tb_place_info>().Where()
.And(Model.Tb_place_info.Table.Parent_Id, id)
.EndWhere().Save() < 1)
{
return(false);
}
return(true);
}, t.Place_Id);
foreach (var v in t.Children)
{
AddDeleteBatch(batchTrans, v);
}
}
}
private void SetCurrentValue(Info_place_info placeInfo)
{
base.SetDataSource(placeInfo);
this.selectValue = placeInfo;
}
public override bool Add(Info_place_info t)
{
t.Place_Id = NewId();
return(this.Add(Repository, t));
}
