第一步：新建一个格式化下拉列表的公共类文件
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading.Tasks;
using System.Web.Mvc; namespace GmkGM.Infrastructure
{
public class Common
{
/// <summary>
/// 获取下拉列表（有层级结构）
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public static IList<SelectListItem> GetDropdownList(IList listInfo,int? Id,string name)
{
DataTable ds = Common.ToDataSet(listInfo).Tables[]; if (null != ds && ds.Rows.Count > )
{
//添加一列
ds.Columns.Add("Level", typeof(int));
// 克隆dt 的结构，包括所有 dt 架构和约束,并无数据
DataTable newDT = ds.Clone();
DataTable catelist = Common.GetTreeList(ds, newDT, , );
if (catelist.Rows.Count > )
{
IList<SelectListItem> list = new List<SelectListItem>();
foreach (DataRow row in catelist.Rows)
{
SelectListItem item = new SelectListItem();
item.Value = Convert.ToString(row["ID"]);
string pri = "----";
var rt = row["Level"];
item.Text = row[name] == DBNull.Value ? string.Empty : Common.StringRepeat(pri, Convert.ToInt32(row["Level"]) + ) + Convert.ToString(row[name]); if (Id == Convert.ToInt32(item.Value))
{
item.Selected = true;
} list.Add(item);
}
SelectListItem first = new SelectListItem();
first.Text = "--父类--";
first.Value = "";
list.Insert(, first);
return list;
}
}
return null;
}
//无层级结构
public static IList<SelectListItem> GetDropdownList2(IList listInfo, int? Id, string name)
{
if (listInfo.Count > )
{
DataTable ds = Common.ToDataSet(listInfo).Tables[]; if (null != ds && ds.Rows.Count > )
{
IList<SelectListItem> list = new List<SelectListItem>();
foreach (DataRow row in ds.Rows)
{
SelectListItem item = new SelectListItem();
item.Value = Convert.ToString(row["ID"]);
item.Text = row[name] == DBNull.Value ? string.Empty : Convert.ToString(row[name]); if (Id == Convert.ToInt32(item.Value))
{
item.Selected = true;
} list.Add(item);
}
SelectListItem first = new SelectListItem();
first.Text = "--父类--";
first.Value = "";
list.Insert(, first);
return list;
}
return null;
}
return null;
}
/// <summary>
/// 生成树形结构
/// </summary>
/// <param name="dt">数据源表</param>
/// <param name="newDT">返回的结果表</param>
/// <param name="Pid">父类ID值</param>
/// <param name="level">层级</param>
/// <returns></returns>
public static DataTable GetTreeList(DataTable dt, DataTable newDT, int Pid, int level = )
{
for (int i = ; i < dt.Rows.Count; i++)
{
if (Convert.ToInt32(dt.Rows[i]["Pid"]) == Pid)
{
//用来标记这个分类是第几级的
dt.Rows[i]["Level"] = level;
newDT.Rows.Add(dt.Rows[i].ItemArray);
//找子分类
DataTable innerDT = GetTreeList(dt, newDT, Convert.ToInt32(dt.Rows[i]["Id"]), level + );
}
}
return newDT;
} /// <param name="str">字符串</param>
/// <param name="n">重复次数</param>
public static string StringRepeat(string str, int n)
{
if (String.IsNullOrEmpty(str) || n <= )
return str;
StringBuilder sb = new StringBuilder();
while (n > )
{
sb.Append(str);
n--;
}
return sb.ToString();
}
// list转换为DataSet
public static DataSet ToDataSet(IList p_List)
{
DataSet result = new DataSet();
DataTable _DataTable = new DataTable();
if (p_List.Count > )
{
PropertyInfo[] propertys = p_List[].GetType().GetProperties();
foreach (PropertyInfo pi in propertys)
{
_DataTable.Columns.Add(pi.Name, pi.PropertyType);
} for (int i = ; i < p_List.Count; i++)
{
ArrayList tempList = new ArrayList();
foreach (PropertyInfo pi in propertys)
{
object obj = pi.GetValue(p_List[i], null);
tempList.Add(obj);
}
object[] array = tempList.ToArray();
_DataTable.LoadDataRow(array, true);
}
}
result.Tables.Add(_DataTable);
return result;
}
/// <summary>
/// 找出一个分类所有子分类的ID
/// </summary>
/// <param name="catId"></param>
///
/// <returns></returns>
public static DataTable GetChildren(DataTable dt, int catId)
{
//定义一个表存放保存找到的子分类的id
DataTable newDT = new DataTable();
//添加一列
newDT.Columns.Add("CID", typeof(int));
if (dt != null && dt.Rows.Count > )
{
//循环所有的分类找子类
for (int i = ; i < dt.Rows.Count; i++)
{
if (Convert.ToInt32(dt.Rows[i]["PID"]) == catId)
{
newDT.Rows.Add((Object)dt.Rows[i]["Id"]);
//再找这个$v的子分类
GetChildren(dt, Convert.ToInt32(dt.Rows[i]["Id"]));
}
}
}
return newDT;
}
}
}
第二步：服务层调用
public IList List2()
{
return db.Whse_Stock_List().ToList();
} public IList<SelectListItem> GetProductDropdownList(int? Id)
{
return Common.GetDropdownList2(List2(), Id, "ProductName");
} public IList List()
{
return db.Whse_Location_List().ToList();
} public IList<SelectListItem> GetLocationDropdownList(int? Id)
{
return Common.GetDropdownList(List(), Id,"Code");
}
第三步：控制器调用
// GET: Inventory/Create
public ActionResult Create()
{
#region 产品下拉列表
ViewBag.ProductTypes = new InventoryService().GetProductDropdownList(null);
#endregion #region 仓库位置下拉列表
ViewBag.LocationTypes = new InventoryService().GetLocationDropdownList(null);
#endregion return View();
}
[ValidateAntiForgeryToken]
[HttpPost]
public ActionResult Create(Inventory model)
{
try
{
#region 产品下拉列表
ViewBag.ProductTypes = new InventoryService().GetProductDropdownList(model.StockID);
#endregion #region 仓库位置下拉列表
ViewBag.LocationTypes = new InventoryService().GetLocationDropdownList(model.LocationID);
#endregion //验证模型是否有效
if (ModelState.IsValid)
{
bool res = new InventoryService().Insert(model);
if (!res)
{
TempData[LastMessageInfoKey.LastErrorMessageTempDataKey] = "创建失败!";
return View(model);
}
TempData[LastMessageInfoKey.LastSuccessMessageTempDataKey] = "创建成功!";
return RedirectToAction("Index");
}
else
{
return View(model);
}
}
catch (Exception ex)
{
TempData[LastMessageInfoKey.LastErrorMessageTempDataKey] = ex.Message;
return View(model);
}
}
// GET: Inventory/Edit/5
public ActionResult Edit(int StockID, int LocationID)
{
InventoryModel Inventory = service.Get(StockID,LocationID); #region 产品下拉列表
ViewBag.ProductTypes = new InventoryService().GetProductDropdownList(StockID);
#endregion #region 仓库位置下拉列表
ViewBag.LocationTypes = new InventoryService().GetLocationDropdownList(LocationID);
#endregion return View(Inventory);
} [ValidateAntiForgeryToken]
[HttpPost]
public ActionResult Edit(Inventory model)
{
try
{
#region 产品下拉列表
ViewBag.ProductTypes = new InventoryService().GetProductDropdownList(model.StockID);
#endregion #region 仓库位置下拉列表
ViewBag.LocationTypes = new InventoryService().GetLocationDropdownList(model.LocationID);
#endregion //验证模型是否有效
if (ModelState.IsValid)
{
bool res = service.Update(model);
if (!res)
{
TempData[LastMessageInfoKey.LastErrorMessageTempDataKey] = "编辑失败!";
return View(model);
}
TempData[LastMessageInfoKey.LastSuccessMessageTempDataKey] = "编辑成功!";
return RedirectToAction("Index");
}
else
{
return View(model);
}
}
catch (Exception ex)
{
TempData[LastMessageInfoKey.LastErrorMessageTempDataKey] = ex.Message;
return View(model);
}
}
第四步：前端页面调用
@model GmkGM.Whse.Model.Inventory
@{
ViewBag.Title = "Create";
} @section styles{
@Styles.Render("~/bundles/form/css")
} @section scripts{
@Scripts.Render("~/bundles/form/js")
} @using (Html.BeginForm(null, null, FormMethod.Post, new { @class = "form-horizontal", role = "form" }))
{
@Html.AntiForgeryToken() <div class="row">
<div class="col-xs-12">
<fieldset>
@Html.LabelFor(model => model.StockID)（必填）
@if (ViewBag.ProductTypes != null)
{
@Html.DropDownList("StockID", ViewBag.ProductTypes as IEnumerable<SelectListItem>, new { @class = "form-control" })
}
else
{
<select id="StockID" name="StockID" class="form-control"></select>
}
</fieldset>
<fieldset>
@Html.LabelFor(model => model.LocationID)（必填）
@if (ViewBag.LocationTypes != null)
{
@Html.DropDownList("LocationID", ViewBag.LocationTypes as IEnumerable<SelectListItem>, new { @class = "form-control" })
}
else
{
<select id="LocationID" name="LocationID" class="form-control"></select>
}
</fieldset> <fieldset>
@Html.LabelFor(model => model.Balance)（必填）
@Html.EditorFor(model => model.Balance, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Balance, "", new { @Style = "color:red" })
</fieldset>
</div>
</div>
<div class="form-actions center">
<button class="btn btn-sm btn-success" type="submit">
提交
<i class="ace-icon fa fa-arrow-right icon-on-right bigger-110"></i>
</button> <a class="btn btn-sm btn-warning" href="@Url.Action("Index")">
返回
<i class="ace-icon fa fa-undo bigger-110"></i>
</a>
</div>
}