public List <SWKCNode> CreateNode(string code, int level)
{
List <SWKCNode> list = new List <SWKCNode>();
DataTable dt = db.GetAllInfo("", code, level);
switch (level)
{
case 0:
foreach (DataRow dr in dt.Rows)
{
SWKCNode model = new SWKCNode();
model.ID = Guid.NewGuid();
model.Code = dr["DLCODE"].ToString();
model.Name = dr["DLNAME"].ToString();
model.hasChildren = true;
list.Add(model);
}
break;
case 1:
foreach (DataRow dr in dt.Rows)
{
SWKCNode model = new SWKCNode();
model.ID = Guid.NewGuid();
model.Code = dr["ZLCODE"].ToString();
model.Name = dr["ZLNAME"].ToString();
model.hasChildren = true;
list.Add(model);
}
break;
case 2:
foreach (DataRow dr in dt.Rows)
{
SWKCNode model = new SWKCNode();
model.ID = Guid.NewGuid();
model.Code = dr["XLCODE"].ToString();
model.Name = dr["XLNAME"].ToString();
model.hasChildren = true;
list.Add(model);
}
break;
case 3:
foreach (DataRow dr in dt.Rows)
{
SWKCNode model = new SWKCNode();
model.ID = Guid.NewGuid();
model.Code = dr["PMCODE"].ToString();
model.Name = dr["PMNAME"].ToString();
model.Unit = dr["MEINS"].ToString();
model.Number = decimal.Parse(dr["GESME"].ToString());
model.Location = dr["LGORT_NAME"].ToString();
model.hasChildren = false;
list.Add(model);
}
break;
}
return(list);
}
public Dictionary <string, object> GetParentList(string MATKL, int page, int limit, int level)
{
Dictionary <string, object> r = new Dictionary <string, object>();
try
{
List <SWKCNode> list = new List <SWKCNode>();
DataTable dt = db.GetAllInfo(MATKL, "");
if (!string.IsNullOrEmpty(MATKL))
{
foreach (DataRow dr in dt.Rows)
{
SWKCNode model = new SWKCNode();
model.ID = Guid.NewGuid();
model.Code = dr["MATNR"].ToString();
model.Name = dr["MAKTX"].ToString();
model.Unit = dr["MEINS"].ToString();
model.Number = decimal.Parse(dr["GESME"].ToString());
model.Location = dr["LGORT_NAME"].ToString();
model.hasChildren = false;
list.Add(model);
}
}
else
{
foreach (DataRow dr in dt.Rows)
{
SWKCNode model = new SWKCNode();
model.ID = Guid.NewGuid();
model.Code = dr["DLCODE"].ToString();
model.Name = dr["DLNAME"].ToString();
model.hasChildren = true;
list.Add(model);
}
}
if (list.Count > 0)
{
r["code"] = 2000;
r["message"] = "成功！";
r["items"] = list.Skip((page - 1) * limit).Take(limit).ToList();
r["totoal"] = list.Count;
}
else
{
r["code"] = 2001;
r["message"] = "成功！但是没有数据";
r["items"] = new DataTable();
r["total"] = list.Count;
}
}
catch (Exception e)
{
r["code"] = -1;
r["message"] = e.Message;
}
return(r);
}
