/// <summary>
/// 修改一级菜单
/// </summary>
/// <param name="c"></param>
/// <param name="id"></param>
/// <returns></returns>
public async Task <int> CategoryOneAddAsync(CategoryOne c, int id)
{
var cOne = await OneAsync(id);
cOne.Name = c.Name;
cOne.url = c.url;
cOne.ImgUrl = c.ImgUrl;
cOne.Icon = c.Icon;
foreach (var item in c.SubCategory)
{
if (item.CategoryId == 0)
{
cOne.SubCategory.Add(item);
}
else
{
var vvv = cOne.SubCategory.SingleOrDefault(cc => cc.CategoryId == item.CategoryId);
if (vvv != null)
{
cOne.SubCategory[cOne.SubCategory.IndexOf(vvv)].Name = item.Name;
cOne.SubCategory[cOne.SubCategory.IndexOf(vvv)].url = item.url;
cOne.SubCategory[cOne.SubCategory.IndexOf(vvv)].ImgUrl = item.ImgUrl;
cOne.SubCategory[cOne.SubCategory.IndexOf(vvv)].Icon = item.Icon;
}
}
}
return(await _db.SaveChangesAsync());
}
public async Task <IActionResult> CategoryOneAddAsync(FormCategory c, List <FormCategory> SubCategorys)
{
var category = new CategoryOne()
{
CategoryOneId = c.Id, Icon = c.Icon, Name = c.Name, url = c.url
};
if (c.File != null)
{
category.ImgUrl = await FilesSave.FileSave(rootPath, @"\Upload\Category\", c.File);
}
else
{
category.ImgUrl = c.ImgUrl;
}
if (SubCategorys != null)
{
var SubC = new List <Category>();
foreach (var item in SubCategorys)
{
var cs = new Category()
{
CategoryId = item.Id, Icon = item.Icon, Name = item.Name, url = item.url
};
if (item.File != null)
{
cs.ImgUrl = await FilesSave.FileSave(rootPath, @"\Upload\Category\", item.File);
}
else
{
cs.ImgUrl = item.ImgUrl;
}
SubC.Add(cs);
}
category.SubCategory = SubC;
}
if (c.Id == 0)
{
await _CategoryText.CategoryOneAddAsync(category);
}
else
{
await _CategoryText.CategoryOneAddAsync(category, c.Id);
}
return(RedirectToAction("Index", "Home"));
}
/// <summary>
/// 添加一个主分类
/// </summary>
/// <param name="c"></param>
/// <returns></returns>
public async Task <int> CategoryOneAddAsync(CategoryOne c)
{
_db.CategoryOnes.Add(c);
return(await _db.SaveChangesAsync());
}
protected void Page_Load(object sender, EventArgs e)
{
//Check the session the ensure user is valid
if (Session["username"] == null)
{
Response.Redirect("index.aspx");
}
//Displays the username in the top navigation bar
lblUserName.Text = "" + Session["username"];
string CS = ConfigurationManager.ConnectionStrings["oacConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
if (!IsPostBack)
{
SqlCommand cmd = new SqlCommand("SELECT [ItemName] FROM [Handlers] WHERE Category LIKE '%City%'",
con);
con.Open();
City.DataSource = cmd.ExecuteReader();
City.DataTextField = "ItemName"; //Column name
City.DataValueField = "ItemName"; //column name
City.DataBind();
con.Close();
SqlCommand cmd2 = new SqlCommand("SELECT [OrgName], [OrgID] FROM [Organizations]", con);
con.Open();
OrgName.DataSource = cmd2.ExecuteReader();
OrgName.DataTextField = "OrgName"; //Column name
OrgName.DataValueField = "OrgID"; //column name
OrgName.DataBind();
con.Close();
SqlCommand cmdStreamOne =
new SqlCommand("SELECT [ItemName] FROM [Handlers] WHERE Category LIKE '%Stream%'", con);
con.Open();
StreamOne.DataSource = cmdStreamOne.ExecuteReader();
StreamOne.DataTextField = "ItemName"; //Column name
StreamOne.DataValueField = "ItemName"; //column name
StreamOne.DataBind();
con.Close();
SqlCommand cmdStreamTwo =
new SqlCommand("SELECT [ItemName] FROM [Handlers] WHERE Category LIKE '%Stream%'", con);
con.Open();
StreamTwo.DataSource = cmdStreamTwo.ExecuteReader();
StreamTwo.DataTextField = "ItemName"; //Column name
StreamTwo.DataValueField = "ItemName"; //column name
StreamTwo.DataBind();
con.Close();
SqlCommand cmdCategoryOne =
new SqlCommand("SELECT [ItemName] FROM [Handlers] WHERE Category LIKE '%Category%'", con);
con.Open();
CategoryOne.DataSource = cmdCategoryOne.ExecuteReader();
CategoryOne.DataTextField = "ItemName"; //Column name
CategoryOne.DataValueField = "ItemName"; //column name
CategoryOne.DataBind();
con.Close();
SqlCommand cmdCategoryTwo =
new SqlCommand("SELECT [ItemName] FROM [Handlers] WHERE Category LIKE '%Category%'", con);
con.Open();
CategoryTwo.DataSource = cmdCategoryTwo.ExecuteReader();
CategoryTwo.DataTextField = "ItemName"; //Column name
CategoryTwo.DataValueField = "ItemName"; //column name
CategoryTwo.DataBind();
con.Close();
SqlCommand cmdTargetOne =
new SqlCommand("SELECT [ItemName] FROM [Handlers] WHERE Category LIKE '%Target%'", con);
con.Open();
TargetOne.DataSource = cmdTargetOne.ExecuteReader();
TargetOne.DataTextField = "ItemName"; //Column name
TargetOne.DataValueField = "ItemName"; //column name
TargetOne.DataBind();
con.Close();
SqlCommand cmdTargetTwo =
new SqlCommand("SELECT [ItemName] FROM [Handlers] WHERE Category LIKE '%Target%'", con);
con.Open();
TargetTwo.DataSource = cmdTargetTwo.ExecuteReader();
TargetTwo.DataTextField = "ItemName"; //Column name
TargetTwo.DataValueField = "ItemName"; //column name
TargetTwo.DataBind();
con.Close();
}
}
}
