public ActionResult Indexxiu()
{
HoseDBEntities db = new HoseDBEntities();
return(View());
}
public ActionResult Logins(string loginUsername, string loginPassword)
{
HoseDBEntities db = new HoseDBEntities();
var list = db.db_MANAGER.Where(p => p.ManagerName == loginUsername && p.ManagerPassword == loginPassword).ToList();
if (list.Count() > 0)
{
return(Content("999"));
}
else
{
return(Content("123"));
}
}
public ActionResult Exmpre()
{
string seach_name = Request["UserName"]; //获取input框中的条件
int pages = int.Parse(Request["page"]); //獲取前台頁數
int row = int.Parse(Request["limit"]); //获取前台行数
int ss = (pages * row) - row; //分页计算公式
HoseDBEntities db = new HoseDBEntities();
db.Configuration.ProxyCreationEnabled = false;//input数据库不循环遍历
var list = (from p in db.db_WORKER orderby p.WorkerID select p).ToList();
var listp = (from p in db.db_WORKER orderby p.WorkerID select p).Skip(ss).Take(row).ToList();
if (seach_name != null)
{
listp = (db.db_WORKER.Where(p => p.WorkerName.Contains(seach_name))).ToList();
}
return(Json(new { data = listp, total = list.Count }, JsonRequestBehavior.AllowGet));
}
public ActionResult AddExpress(string EName, string ENameNumber, decimal ENamePage, string password, string ENamePositon, string sex)
{
using (HoseDBEntities db = new HoseDBEntities()) {
db_WORKER list = new db_WORKER {
WorkerName = EName, WorkerIDNumber = ENameNumber, WorkerWage = ENamePage, WorkerPassword = password, WorkerPosition = ENamePositon, WorkerSex = sex
};
db.db_WORKER.Add(list);
if (db.SaveChanges() > 0)
{
return(Json(new{ msg = "哇，您又多了一位员工", code = 0 }));
}
else
{
return(Json(new { msg = "不要乱添加，哼", code = 1 }));
}
}
}
public ActionResult Detail(List <int> detail)
{
using (HoseDBEntities db = new HoseDBEntities())
{
foreach (var item in detail)
{
var list = db.db_WORKER.Find(item);
db.db_WORKER.Remove(list);
}
if (db.SaveChanges() > 0)
{
return(Json(new { code = 0, msg = "哇，好痛苦，您的员工走了" }));
}
else
{
return(Json(new { code = 1, msg = "不好意思，脑子出差了" }));
}
}
}
public ActionResult Edities(string EName, string ENameNumber, decimal ENamePage, string password, string ENamePositon, string sex, int EditID)
{
using (HoseDBEntities db = new HoseDBEntities())
{
var list = db.db_WORKER.Find(EditID);
list.WorkerName = EName;
list.WorkerIDNumber = ENameNumber;
list.WorkerWage = ENamePage;
list.WorkerPassword = password;
list.WorkerPosition = ENamePositon;
list.WorkerSex = sex;
if (db.SaveChanges() > 0)
{
return(Json(new { code = 0, msg = "您已经修改成功" }));
}
else
{
return(Json(new { code = 0, msg = "您修改失败喽" }));
}
}
}
public ActionResult AddCustomer(db_INPUT u)
{
HoseDBEntities db = new HoseDBEntities();
db_INPUT list = new db_INPUT {
CustomerName = u.CustomerName, CustomerIDNumber = u.CustomerIDNumber, CustomerInDate = u.CustomerInDate, CustomerOutDate = u.CustomerOutDate, CustomerPeoper = u.CustomerPeoper, CustomerSex = u.CustomerSex, CustomerPrice = u.CustomerPrice, CustomerAddress = u.CustomerAddress, WorkerID = u.WorkerID, RoomNID = u.RoomNID, CTypeID = u.CTypeID
};
db.db_INPUT.Add(list);
db.Configuration.ValidateOnSaveEnabled = false;
if (db.SaveChanges() > 0)
{
//var lists = db.db_ROOM.Find(u.RoomNID);
//db.Configuration.ValidateOnSaveEnabled - true;
return(Json(new { code = 0, msg = "可爱的顾客来了" }));
}
else
{
return(Json(new { code = 1, msg = "不好意思，脑子出差了" }));
}
}
