private List <Treeview> GetMenuList(DataTable dtSource)
{
List <Treeview> rst = new List <Treeview>();
DataRow[] pArr = dtSource.Select("(parent_no='0' or parent_no='')", "ordno,menu_no");
foreach (DataRow dr in pArr)
{
Treeview pTr = new Treeview();
pTr.id = CommFunc.ConvertDBNullToString(dr["prog_id"]);
pTr.text = CommFunc.ConvertDBNullToString(dr["descr"]);
pTr.attributes = CommFunc.ConvertDBNullToInt32(dr["disabled"]);
pTr.nodes = new List <Treeview>();
this.GetMenuList(ref dtSource, ref pTr, CommFunc.ConvertDBNullToString(dr["menu_no"]));
rst.Add(pTr);
}
return(rst);
}
public List <Treeview> GetTreeListForAttrSet(string AttributeSetID)
{
List <Treeview> TreeListData = null;
try
{
using (SqlConnection con = _databaseFactory.GetDBConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Connection = con;
cmd.CommandText = "[GetAttributesforTreeUsingAttributeSet]";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = int.Parse(AttributeSetID);
using (SqlDataReader sdr = cmd.ExecuteReader())
{
if ((sdr != null) && (sdr.HasRows))
{
TreeListData = new List <Treeview>();
while (sdr.Read())
{
Treeview TreeviewObj = new Treeview();
{
TreeviewObj.ID = sdr["ID"].ToString();
TreeviewObj.ParentID = (sdr["ParentID"].ToString() != "" ? int.Parse(sdr["ParentID"].ToString()) : TreeviewObj.ParentID);
TreeviewObj.Name = sdr["Name"].ToString();
TreeviewObj.level = sdr["level"].ToString();
TreeviewObj.icon = sdr["icon"].ToString();
}
TreeListData.Add(TreeviewObj);
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(TreeListData);
}
private void RenderPlaceholderRecomendations()
{
var listOfSelectedRenderings = new List <Item>();
if (HttpContext.Current.Request.Form["__EVENTTARGET"] != null)
{
if (Treeview != null && HttpContext.Current.Request.Form["__EVENTTARGET"] == Treeview.ID)
{
if (Treeview.SelectedIDs.Any(q => !String.IsNullOrWhiteSpace(q)))
{
var selected = Treeview.GetSelectedItems();
if (selected != null)
{
var selectedrendering = selected.FirstOrDefault();
if (selectedrendering != null)
{
listOfSelectedRenderings.Add(selectedrendering);
}
}
}
}
if (RecommendedTreeview != null && HttpContext.Current.Request.Form["__EVENTTARGET"] == RecommendedTreeview.ID)
{
var rrSelected = RecommendedTreeview.GetSelectionItem();
if (rrSelected != null)
{
var selectedrendering = rrSelected.FirstOrDefault();
if (selectedrendering != null)
{
listOfSelectedRenderings.Add(selectedrendering);
}
}
}
if (listOfSelectedRenderings.Any())
{
RenderPlaceholderRecomendations(listOfSelectedRenderings.First());
}
else
{
RecommendedPlaceholders.InnerHtml = String.Empty;
}
}
}
private List <Treeview> GetPduTree(DataTable dtSource)
{
List <Treeview> rst = new List <Treeview>();
DataRow[] pArr = dtSource.Select("Parent_id=0", "Co_id");
foreach (DataRow dr in pArr)
{
Treeview pTr = new Treeview();
pTr.id = CommFunc.ConvertDBNullToString(dr["Co_id"]);
pTr.text = CommFunc.ConvertDBNullToString(dr["CoName"]);
//pTr.attributes = CommFunc.ConvertDBNullToInt32(dr["power"]);
pTr.nodes = new List <Treeview>();
this.GetPduTree(ref dtSource, ref pTr, CommFunc.ConvertDBNullToString(dr["Co_id"]));
rst.Add(pTr);
}
return(rst);
}
private List <Treeview> GetAreaTreeList(DataTable dtSource)
{
List <Treeview> rst = new List <Treeview>();
DataRow[] pArr = dtSource.Select("Parent_id=0", "Co_id");
foreach (DataRow dr in pArr)
{
int co_id = CommFunc.ConvertDBNullToInt32(dr["Co_id"]);
Treeview pTr = new Treeview();
pTr.id = co_id.ToString();
pTr.text = CommFunc.ConvertDBNullToString(dr["CoName"]);
pTr.attributes = 0; //;new { areaId = co_id, attrib = CoAttrib.Area, parent_id = 0 };
this.GetAreaTreeList(co_id, ref pTr, ref dtSource);
rst.Add(pTr);
}
return(rst);
}
private List <Treeview> GetMenuList2(DataTable dtSource, string power)
{
List <Treeview> rst = new List <Treeview>();
DataRow[] pArr = dtSource.Select("Parent_id=0", "CoNo");
string[] powers = power.Split(',');
foreach (DataRow dr in pArr)
{
Treeview pTr = new Treeview();
pTr.id = CommFunc.ConvertDBNullToString(dr["Co_id"]);
pTr.text = CommFunc.ConvertDBNullToString(dr["CoName"]);
pTr.attributes = powers.ToList().Exists(p => p.Trim().Equals(pTr.id));
pTr.nodes = new List <Treeview>();
this.GetMenuList2(ref dtSource, ref pTr, CommFunc.ConvertDBNullToString(dr["Co_id"]), ref powers);
rst.Add(pTr);
}
return(rst);
}
private void GetMenuList(ref DataTable dtSource, ref Treeview pTr, string Co_id)
{
DataRow[] pArr = dtSource.Select("Parent_id=" + Co_id, "Co_id");
int pRows = pArr.Count();
if (pRows > 0)
{
pTr.nodes = new List <Treeview>();
}
foreach (DataRow dr in pArr)
{
Treeview cTr = new Treeview();
cTr.id = CommFunc.ConvertDBNullToString(dr["Co_id"]);
cTr.text = CommFunc.ConvertDBNullToString(dr["CoName"]);
//cTr.attributes = CommFunc.ConvertDBNullToInt32(dr["power"]);
pTr.nodes.Add(cTr);
this.GetMenuList(ref dtSource, ref cTr, CommFunc.ConvertDBNullToString(dr["Co_id"]));
}
}
private void GetMenuList2(ref DataTable dtSource, ref Treeview pTr, string Bd_id, ref string[] powers)
{
DataRow[] pArr = dtSource.Select("Parent_id=" + Bd_id, "CoNo");
int pRows = pArr.Count();
if (pRows > 0)
{
pTr.nodes = new List <Treeview>();
}
foreach (DataRow dr in pArr)
{
Treeview cTr = new Treeview();
cTr.id = CommFunc.ConvertDBNullToString(dr["Co_id"]);
cTr.text = CommFunc.ConvertDBNullToString(dr["CoName"]);
cTr.attributes = powers.ToList().Exists(p => p.Trim().Equals(cTr.id));
pTr.nodes.Add(cTr);
this.GetMenuList2(ref dtSource, ref cTr, CommFunc.ConvertDBNullToString(dr["Co_id"]), ref powers);
}
}
static Treeview LoadTreeview(Stream fs)
{
var obj = new Treeview(ReadString(fs), ReadFont(fs), ReadInt(fs), ReadInt(fs), ReadInt(fs), ReadInt(fs))
{
Enabled = ReadBool(fs),
Visible = ReadBool(fs),
SelectedTextColor = ReadColor(fs),
TextColor = ReadColor(fs)
};
var len = ReadInt(fs);
for (var i = 0; i < len; i++)
{
obj.AddNode(LoadTreeviewNode(fs));
}
return(obj);
}
private void GetMenuList(ref DataTable dtSource, ref Treeview pTr, string menu_no)
{
DataRow[] pArr = dtSource.Select("parent_no='" + menu_no + "'", "menu_no");
int pRows = pArr.Count();
if (pRows > 0)
{
pTr.nodes = new List <Treeview>();
}
foreach (DataRow dr in pArr)
{
Treeview cTr = new Treeview();
cTr.id = CommFunc.ConvertDBNullToString(dr["prog_id"]);
cTr.text = CommFunc.ConvertDBNullToString(dr["descr"]);
cTr.attributes = CommFunc.ConvertDBNullToInt32(dr["power"]);
pTr.nodes.Add(cTr);
this.GetMenuList(ref dtSource, ref cTr, CommFunc.ConvertDBNullToString(dr["menu_no"]));
}
}
private void TreeView1_DragDrop(object sender, DragEventArgs e)
{
var rowToMove = e.Data.GetData(typeof(DataGridViewRow)) as DataGridViewRow;
var itemnumber = Convert.ToString(rowToMove.Cells[0].Value);
if (itemnumber == assynotxt.Text)
{
MessageBox.Show("Cannot add parent item as child", "SPM Conect", MessageBoxButtons.OK, MessageBoxIcon.Information);
itemnotxt.Clear();
return;
}
var description = Convert.ToString(rowToMove.Cells[1].Value);
var family = Convert.ToString(rowToMove.Cells[2].Value);
var oem = Convert.ToString(rowToMove.Cells[3].Value);
var oemitem = Convert.ToString(rowToMove.Cells[4].Value);
SearchNodes(itemnumber, Treeview.Nodes[0]);
if (itemexists != "yes")
{
bool isrevised = IsRevised();
var child = new TreeNode
{
Text = itemnumber + " - " + description + " (1)",
Tag = itemnumber + "][" + description + "][" + family + "][" + oem + "][" + oemitem + "][1][ ][" + (isrevised ? "1" : "0") + "][0"
};
child.BackColor = isrevised ? Color.LightYellow : Color.LightGreen;
root.Nodes.Add(child);
CallRecursive();
if (!root.IsExpanded)
{
Treeview.ExpandAll();
}
savbttn.Visible = true;
}
else
{
itemexists = null;
}
}
/// <summary>
/// 双击treeview
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tview_NodeMouseDoubleClick(object sender, TreeNodeMouseClickEventArgs e)
{
TreeNode node = Treeview.SelectedNode;
if (node.Level == 0)
{
node.Nodes.Clear();
getServers();
Treeview.ExpandAll();
}
else if (node.Level == 1)
{
node.Nodes.Clear();
getDatabaseinfo();
}
else if (node.Level == 4)
{
if (null != newcontentForm)
{
Connection conModel = _ConnectList.Find(delegate(Connection con) { return(con.ID.ToString().Equals(Treeview.SelectedNode.Parent.Parent.Parent.Tag.ToString())); });
if (conModel.DbType.Equals(DatabaseType.MongoDB.ToString()))
{
//todo
MongoDBTool.Connect(conModel.ConnectionString).GetList(node.Parent.Parent.Text, node.Text, "{\"find\":\"Account\", limit:20, sort:{AddTime:-1}}");
}
else
{
conConnectionString = Treeview.SelectedNode.Parent.Parent.Tag.ToString();
try
{
conModel.TableName = Treeview.SelectedNode.Text;
conModel.Database = Treeview.SelectedNode.Parent.Parent.Text;
conModel.IsView = Treeview.SelectedNode.Tag.ToString().Equals("V");
newcontentForm?.Invoke(conModel);
}
catch { }
}
}
}
}
private void GetAreaTreeList(int parent_id, ref Treeview pTr, ref DataTable dtSource)
{
DataRow[] pArr = dtSource.Select("Parent_id=" + parent_id, "Co_id");
int pRows = pArr.Count();
if (pRows > 0)
{
pTr.nodes = new List <Treeview>();
}
foreach (DataRow dr in pArr)
{
int co_id = CommFunc.ConvertDBNullToInt32(dr["Co_id"]);
Treeview cTr = new Treeview();
cTr.id = co_id.ToString();
cTr.text = CommFunc.ConvertDBNullToString(dr["CoName"]);
cTr.attributes = parent_id; // new { areaId = co_id, attrib = CoAttrib.Area, parent_id = parent_id };
pTr.nodes.Add(cTr);
this.GetAreaTreeList(co_id, ref cTr, ref dtSource);
}
}
public void FindPrevious()
{
if (SearchedItems != null && SearchedItems.Count > 0)
{
if (matchindex - 1 < SearchedItems.Count && matchindex != 0)
{
ApplyInline(SearchedItems[matchindex], false);
ApplyInline(SearchedItems[matchindex - 1], true);
Treeview.BringIntoView(SearchedItems[matchindex - 1]);
matchindex--;
}
else
{
ApplyInline(SearchedItems[matchindex], false);
matchindex = SearchedItems.Count - 1;
ApplyInline(SearchedItems[matchindex], true);
Treeview.BringIntoView(SearchedItems[matchindex]);
}
}
}
public void FindNext()
{
if (SearchedItems != null && SearchedItems.Count > 0)
{
ApplyInline(SearchedItems[matchindex], false);
if (matchindex + 1 < SearchedItems.Count)
{
ApplyInline(SearchedItems[matchindex + 1], true);
Treeview.BringIntoView(SearchedItems[matchindex + 1]);
matchindex++;
}
else
{
ApplyInline(SearchedItems[matchindex], false);
matchindex = 0;
ApplyInline(SearchedItems[0], true);
Treeview.BringIntoView(SearchedItems[0]);
}
}
}
public ActionResult Create([Bind(Include = "Id,Name")] Base @base)
{
if (ModelState.IsValid)
{
db.Bases.Add(@base);
db.SaveChanges();
var treeview = new Treeview {
Label = @base.Name, HierarchyTypeId = (int)Enums.Base, KeyOfThatHierarchy = @base.Id
};
treeview = db.Treeviews.Add(treeview);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(@base));
}
/// <summary>
/// Handles a click on the OK button.
/// </summary>
/// <param name="sender"/><param name="args"/>
/// <remarks>
/// When the user clicks OK, the dialog is closed by calling
/// the <see cref="M:Sitecore.Web.UI.Sheer.ClientResponse.CloseWindow">CloseWindow</see> method.
/// </remarks>
/// <contract><requires name="sender" condition="not null"/><requires name="args" condition="not null"/></contract>
protected override void OnOK(object sender, EventArgs args)
{
Assert.ArgumentNotNull(sender, "sender");
Assert.ArgumentNotNull((object)args, "args");
if (!string.IsNullOrEmpty(SelectedItemId))
{
SetDialogResult(ShortID.Parse(SelectedItemId).ToID().ToString());
}
else
{
Item selectionItem = Treeview.GetSelectionItem();
if (selectionItem != null && IsItemRendering(selectionItem))
{
SetDialogResult(selectionItem.ID.ToString());
}
else
{
SheerResponse.Alert("Please select a rendering item", new string[0]);
}
}
}
private static void ReturnSelection(Treeview tv1, Textbox txt1)
{
if (tv1.Nodes != null)
{
if (tv1.SelectedNode == null)
{
tv1.SelectedNode = tv1.Nodes[0];
}
_inputResult = Strings.NormalizeDirectory((string)tv1.SelectedNode.Tag) + txt1.Text;
if (_checkExist && File.Exists(_inputResult))
{
//_prompt = "Are you sure you wish to overwrite '" + _inputResult + "'?";
new Thread(DoCheck).Start();
return;
}
}
_activeBlock.Set();
}
private List <Treeview> GetMenuTreeList(DataTable dtSource)
{
List <Treeview> rst = new List <Treeview>();
DataRow[] pArr = dtSource.Select("(parent_no='0' or parent_no='') and attrib=0", "ordno,menu_no");
foreach (DataRow dr in pArr)
{
Treeview pTr = new Treeview();
pTr.id = CommFunc.ConvertDBNullToString(dr["menu_no"]);
pTr.text = CommFunc.ConvertDBNullToString(dr["descr"]);
pTr.icon = CommFunc.ConvertDBNullToString(dr["icon"]);
string child = this.GetPower(pTr.id, ref dtSource);
int isShow = (CommFunc.ConvertDBNullToInt32(dr["pass"]) > 0 ? 1 : 0);
pTr.nodes = new List <Treeview>();
int cc = this.GetMenuTreeList(ref dtSource, ref pTr);
isShow = cc == 1 ? 1 : isShow;
pTr.attributes = new { path = CommFunc.ConvertDBNullToString(dr["path"]), power = CommFunc.ConvertDBNullToString(dr["Power"]), show = isShow, child = child };
rst.Add(pTr);
}
return(rst);
}
private void ProcessSaveButton()
{
Treeview.SelectedNode = Treeview.Nodes[0];
if (Treeview.SelectedNode != null && Treeview.SelectedNode.Parent == null)
{
Treeview.PathSeparator = ".";
// Get the count of the child tree nodes contained in the SelectedNode.
var myNodeCount = Treeview.SelectedNode.GetNodeCount(true);
// MessageBox.Show(myNodeCount.ToString());
_ = (decimal)myNodeCount /
(decimal)Treeview.GetNodeCount(true) * 100;
if (myNodeCount > 0)
{
connectapi.Deleteassy(releaseLogNumber);
if (Itemstodiscard.Count > 0)
{
Performdiscarditem();
}
CheckItems();
if (itemcleartosave)
{
AddItems();
}
}
else
{
connectapi.Deleteassy(releaseLogNumber);
if (Itemstodiscard.Count > 0)
{
Performdiscarditem();
}
Lockdownsave();
// MessageBox.Show("Assembly list cannot be empty in order to save to AutoCad Catalog.", "SPM Connect", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
Itemstodiscard.Clear();
}
private void Fillrootnode()
{
try
{
Treeview.Nodes.Clear();
RemoveChildNodes(root);
Treeview.ResetText();
root.Text = assydesctxt.Text + " - " + releasetypetxt.Text;
root.Tag = jobnotxt.Text + "][" + wotxt.Text + "][" + releaselognotxt.Text + "][" + releasetypetxt.Text;
Setimageaccordingtofamily("AS", root);
Treeview.Nodes.Add(root);
PopulateTreeView(releaseLogNumber, root);
}
catch
{
Treeview.TopNode.Nodes.Clear();
Treeview.Nodes.Clear();
RemoveChildNodes(root);
Treeview.ResetText();
}
}
/// <summary>
/// 获取服务器列表
/// </summary>
private void getServers()
{
Treeview.Nodes.Clear();
Treeview.Nodes.Add("服务器", "数据库服务器", 0);
_ConnectList = UtilsHelper.GetConnectionList();
TreeNode node = Treeview.Nodes[0];
node.ContextMenuStrip = contextMenuStripTop;
foreach (Connection connection in _ConnectList)
{
TreeNode nnode = new TreeNode(connection.Name, 0, 0);
nnode.ContextMenuStrip = contextMenuStripDatabase;
nnode.Tag = connection.ID.ToString();
node.Nodes.Add(nnode);
}
Treeview.ExpandAll();
}
private int GetSelectObject(int parent_id, ref Treeview pTr, ref DataTable dtSource, ref DataTable dtMeter)
{
DataRow[] pArr = dtSource.Select("Parent_id=" + parent_id, "Co_id");
int pRows = pArr.Count();
pTr.nodes = new List <Treeview>();
int meterCnt = 0;
foreach (DataRow dr in pArr)
{
int co_id = CommFunc.ConvertDBNullToInt32(dr["Co_id"]);
int attrib = CommFunc.ConvertDBNullToInt32(dr["Attrib"]);
string type = attrib == (int)CoAttrib.Area ? "A" : attrib == (int)CoAttrib.Station ? "S" : "R";
Treeview cTr = new Treeview();
cTr.id = type + "-" + co_id.ToString();
cTr.text = CommFunc.ConvertDBNullToString(dr["CoName"]);
cTr.attributes = type;
pTr.nodes.Add(cTr);
this.GetSelectObject(co_id, ref cTr, ref dtSource, ref dtMeter);
if (attrib == (int)CoAttrib.Room)
{
#region 增加站点
DataRow[] meterArr = dtMeter.Select("Co_id=" + co_id, "Meter_id");
meterCnt = meterArr.Count();
cTr.nodes = new List <Treeview>();
foreach (DataRow drMeter in meterArr)
{
int mid = CommFunc.ConvertDBNullToInt32(drMeter["Meter_id"]);
Treeview mTr = new Treeview();
mTr.id = "M-" + mid;
mTr.text = CommFunc.ConvertDBNullToString(drMeter["MeterName"]);
mTr.attributes = "M";
}
#endregion
}
}
return(meterCnt);
}
private void Fillrootnode()
{
try
{
Treeview.Nodes.Clear();
RemoveChildNodes(root);
Treeview.ResetText();
Expandchk.Checked = false;
DataRow[] dr = treeTB.Select("[Parent] ='" + workOrder + "'");
if (dr.Length > 0)
{
if (isJob)
{
root.Text = "(" + dr[0]["JobNo"].ToString() + ") - " + assyNumber + " - " + dr[0]["JobDescription"].ToString();
root.Tag = treeTB.Rows.IndexOf(dr[0]);
Setimageaccordingtofamily("JOB", root);
Treeview.Nodes.Add(root);
PopulateTreeView(workOrder, root);
}
else
{
root.Text = "WO " + dr[0]["Parent"].ToString() + " - " + dr[0]["Description"].ToString() + " - " + dr[0]["AssyNo"].ToString();
root.Tag = treeTB.Rows.IndexOf(dr[0]);
Setimageaccordingtofamily("AS", root);
Treeview.Nodes.Add(root);
PopulateTreeViewFirst(workOrder, root);
}
}
}
catch
{
Treeview.TopNode.Nodes.Clear();
Treeview.Nodes.Clear();
RemoveChildNodes(root);
Treeview.ResetText();
}
}
public ActionResult Create([Bind(Include = "Id,Name,BaseId")] Division division)
{
if (ModelState.IsValid)
{
db.Divisions.Add(division);
db.SaveChanges();
int parentId = 0;
var parent = db.Treeviews.Where(i => i.HierarchyTypeId == (int)Enums.Base && i.KeyOfThatHierarchy == division.BaseId);
if (parent != null)
{
parentId = parent.FirstOrDefault().Id;
}
var treeview = new Treeview {
HierarchyTypeId = (int)Enums.Division, KeyOfThatHierarchy = division.Id, Label = division.Name, ParentId = parentId
};
db.Treeviews.Add(treeview);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BaseId = new SelectList(db.Bases, "Id", "Name", division.BaseId);
return(View(division));
}
/// <summary>
/// 获取支路信息
/// </summary>
/// <returns></returns>
public object GetTree()
{
List <Treeview> rst = new List <Treeview>();
DataTable dtPro = dal.GetProList();
DataTable dtSource = dal.GetBuildList();
foreach (DataRow dr in dtPro.Rows)
{
Treeview pro = new Treeview();
int co_id = CommFunc.ConvertDBNullToInt32(dr["Co_id"]);
pro.id = co_id.ToString();
pro.text = CommFunc.ConvertDBNullToString(dr["CoName"]);
pro.attributes = null;
rst.Add(pro);
this.GetTree(ref pro, ref dtSource, ref co_id);
}
//foreach (DataRow dr in dtSource.Select("IsAdd==0"))
//{
// dr["IsAdd"] = 1;
// int co_id = CommFunc.ConvertDBNullToInt32(dr["Co_id"]);
// Treeview tb = new Treeview();
// tb.id = co_id.ToString();
// tb.text = CommFunc.ConvertDBNullToString(dr["CoName"]);
// tb.attributes = new
// {
// Id = CommFunc.ConvertDBNullToInt32(dr["Co_id"]),
// BuildName = CommFunc.ConvertDBNullToString(dr["CoName"]),
// BuildAddr = CommFunc.ConvertDBNullToString(dr["CustAddr"]),
// TelNo = CommFunc.ConvertDBNullToString(dr["Mobile"]),
// Email = CommFunc.ConvertDBNullToString(dr["Email"]),
// Parent_id = CommFunc.ConvertDBNullToInt32(dr["Parent_id"]),
// };
// rst.Add(tb);
// this.GetTree(ref tb, ref dtSource, ref co_id);
//}
return(rst);
}
public ActionResult Create([Bind(Include = "Id,Name,UnionId")] Village village)
{
if (ModelState.IsValid)
{
db.Villages.Add(village);
db.SaveChanges();
int parentId = 0;
var parent = db.Treeviews.Where(i => i.HierarchyTypeId == (int)Enums.Union && i.KeyOfThatHierarchy == village.UnionId);
if (parent != null)
{
parentId = parent.FirstOrDefault().Id;
}
var treeview = new Treeview {
HierarchyTypeId = (int)Enums.Village, KeyOfThatHierarchy = village.Id, Label = village.Name, ParentId = parentId
};
db.Treeviews.Add(treeview);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UnionId = new SelectList(db.Unions, "Id", "Name", village.UnionId);
return(View(village));
}
/// <summary>
/// 获取对象选择树形列表
/// </summary>
/// <param name="total"></param>
/// <returns></returns>
public List <Treeview> GetSelectObject(out int total)
{
DataTable dtSource = dal.GetAreaList();
DataTable dtMeter = dal.GetMeterList();
total = dtSource.Rows.Count;
List <Treeview> rst = new List <Treeview>();
DataRow[] pArr = dtSource.Select("Parent_id=0", "Co_id");
foreach (DataRow dr in pArr)
{
int co_id = CommFunc.ConvertDBNullToInt32(dr["Co_id"]);
int attrib = CommFunc.ConvertDBNullToInt32(dr["Attrib"]);
string type = attrib == (int)CoAttrib.Area ? "A" : attrib == (int)CoAttrib.Station ? "S" : "R";
Treeview pTr = new Treeview();
pTr.id = type + "-" + co_id.ToString();
pTr.text = CommFunc.ConvertDBNullToString(dr["CoName"]);
pTr.attributes = type;
//
total = total + this.GetSelectObject(co_id, ref pTr, ref dtSource, ref dtMeter);
rst.Add(pTr);
}
return(rst);
}
private void Addbutton_Click(object sender, EventArgs e)
{
try
{
errorProvider1.Clear();
if (qtytxtbox.Text.Length > 0 && qtytxtbox.Text != "0" && itemnotxt.Text.Length > 0)
{
if (itemnotxt.Text == assynotxt.Text)
{
MessageBox.Show("Cannot add parent item as child", "SPM Conect", MessageBoxButtons.OK, MessageBoxIcon.Information);
itemnotxt.Clear();
return;
}
var iteminfo = new DataTable();
iteminfo.Clear();
iteminfo = connectapi.GetIteminfo(itemnotxt.Text);
var r = iteminfo.Rows[0];
if (iteminfo.Rows.Count > 0)
{
var _itemno = itemnotxt.Text;
var _description = r["Description"].ToString();
var _family = r["FamilyCode"].ToString();
var _oem = r["Manufacturer"].ToString();
var _manufacturer = r["ManufacturerItemNumber"].ToString();
var qty = qtytxtbox.Text;
var notes = itemnotestxt.Text;
SearchNodes(_itemno, Treeview.Nodes[0]);
if (itemexists != "yes")
{
bool isrevised = IsRevised();
var child = new TreeNode
{
Text = _itemno + " - " + _description + " (" + qty + ")",
Tag = _itemno + "][" + _description + "][" + _family + "][" + _manufacturer + "][" + _oem + "][" + qty + "][" + notes + "][" + (isrevised ? "1" : "0") + "][5445"
};
Treeview.SelectedNode = Treeview.Nodes[0];
child.BackColor = isrevised ? Color.LightYellow : Color.LightGreen;
root.Nodes.Add(child);
CallRecursive();
if (!root.IsExpanded)
{
Treeview.ExpandAll();
}
savbttn.Visible = true;
itemnotxt.Clear();
}
else
{
savbttn.Visible = false;
itemexists = null;
itemnotxt.Clear();
}
}
}
else
{
if (itemnotxt.Text.Length > 0)
{
errorProvider1.SetError(qtytxtbox, "Qty cannot be null");
}
else
{
errorProvider1.SetError(itemnotxt, "ItemNo cannot be null");
}
}
}
catch
{
return;
}
}
private void shareButton_Click(object sender, RoutedEventArgs e)
{
SQLDAL.SQLDAL.WriteListToDB(Treeview.GetSharedFileList(Treeview.GetCurrentDataGrid()));
}
