public ActionResult AddShop(string name, string type)
{
decimal cur_user = (Session["UserMessage"] as UserMessage).id; //!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
//!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
//!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
TB_MANAGE tb_manage = new TB_MANAGE();
TB_STORE tb_store = new TB_STORE();
TB_STORE_TYPE tb_store_type = new TB_STORE_TYPE();
name = Request.Form[("NAME")];
type = Request.Form[("TYPE")];
if (ModelState.IsValid)
{
foreach (TB_STORE myStore in db2.TB_STORE)
{
if (myStore.NAME == name)
{
return View();
}
}
foreach (TB_MANAGE myMag in db1.TB_MANAGE)
{
if (myMag.U_ID == cur_user && myMag.AUTHORITY == true)
{
return View();
}
}
tb_store.NAME = name;
tb_store.QUALITY_RATING = 0;
db2.TB_STORE.Add(tb_store);
db2.SaveChanges();
foreach (TB_STORE myStore in db2.TB_STORE)
{
if (myStore.NAME == name)
{
tb_manage.U_ID = cur_user;
tb_manage.S_ID = myStore.ID;
tb_manage.AUTHORITY = true;
db1.TB_MANAGE.Add(tb_manage);
db1.SaveChanges();
tb_store_type.ID = myStore.ID;
tb_store_type.TYPE = type;
db3.TB_STORE_TYPE.Add(tb_store_type);
db3.SaveChanges();
return RedirectToAction("Myshop");
}
}
}
return View();
}
public ActionResult DeleteManages(string _name)
{
decimal managerID = -1;
foreach (var userItem in db4.TB_USER)
{
if (_name == userItem.NAME)
{
managerID = userItem.ID;
break;
}
}
decimal storeID = -1;
decimal cur_userid = (Session["UserMessage"] as UserMessage).id;
foreach (TB_MANAGE myMag in db1.TB_MANAGE)
{
if ((myMag.U_ID == cur_userid) && (myMag.AUTHORITY == true))
{
storeID = myMag.S_ID;
break;
}
}
TB_MANAGE manageDel = new TB_MANAGE();
manageDel.U_ID = managerID;
manageDel.S_ID = storeID;
string sql = "delete from TB_MANAGE where S_ID=" + manageDel.S_ID.ToString() + " and U_ID=" + manageDel.U_ID.ToString();
db1.Database.ExecuteSqlCommand(sql);
db1.SaveChanges();
return RedirectToAction("MyShop");
}
public ActionResult MyShop(String _name)
{
_name = Request.Form["MANAGERNAME"];
TB_MANAGE tempUser = new TB_MANAGE();
int tempFound = 0;
foreach (var userItem in db4.TB_USER)
{
if (_name == userItem.NAME)
{
tempFound = 1;
//获取Mystore；
decimal cur_userid = (Session["UserMessage"] as UserMessage).id;
foreach (TB_MANAGE myMag in db1.TB_MANAGE)
{
if ((myMag.U_ID == cur_userid) && (myMag.AUTHORITY == true))
{
MyStore = myMag.S_ID;
break;
}
}
tempUser.U_ID = userItem.ID;
tempUser.S_ID = MyStore;
tempUser.AUTHORITY = false;
db1.TB_MANAGE.Add(tempUser);
db1.SaveChanges();
}
}
if (tempFound == 0)
{
return View(en_user_st.c_man_st); //没有该管理员
}
return RedirectToAction("MyShop");
}
//显示我的店铺，我是店主
// GET: CreateStore
public ActionResult MyShop()
{
//ViewData["uid"] = cur_userid;
decimal cur_userid = (Session["UserMessage"] as UserMessage).id;
en_user_st.c_man_st = new List<thismanagestore>();
en_user_st.deci_user = cur_userid;
foreach (TB_MANAGE myMag in db1.TB_MANAGE)
{
if (myMag.U_ID == cur_userid)
{
thismanagestore newitem = new thismanagestore();
newitem.db_manage = new TB_MANAGE();
newitem.managers = new List<string>();
TB_MANAGE tempUser = new TB_MANAGE();
newitem.db_manage.U_ID = myMag.U_ID;
newitem.db_manage.S_ID = myMag.S_ID;
newitem.db_manage.AUTHORITY = myMag.AUTHORITY;
if (myMag.AUTHORITY == true)
{
MyStore = myMag.S_ID;
setManageList(myMag.S_ID, newitem.managers);
}
searchstore(newitem, myMag.S_ID);
en_user_st.c_man_st.Add(newitem);
}
}
return View(en_user_st.c_man_st);
}