public JsonResult AddGuestSave(MODEL.T_DIC_Guest model) { BLL.T_DIC_Guest bll = new BLL.T_DIC_Guest(); bool result = bll.AddGuest(model); if (result) { MODEL.Message message = new MODEL.Message(); message.statusCode = "200"; message.message = "增加客户成功!"; message.navTabId = "GuestList"; message.rel = "GuestList"; message.forwardUrl = ""; message.callbackType = "closeCurrent"; return(Json(message)); } else { MODEL.Message message = new MODEL.Message(); message.statusCode = "300"; message.message = "增加客户失败!"; message.navTabId = "GuestList"; message.rel = "GuestList"; message.forwardUrl = ""; message.callbackType = "closeCurrent"; return(Json(message)); } }
public void slt_info(MODEL.Message mes) { string sql = "select id,psw,name,sex,college,grade,email,phone,major,guidance,Title,number from teacher where id = @id"; SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@id", mes.Id), }; DataTable dt = SqlDbHelper.ExecuteDataTable(sql.ToString(), CommandType.Text, paras); for (int i = 0; i < dt.Rows.Count; i++) { mes.Name = dt.Rows[i]["name"].ToString(); mes.Psd = dt.Rows[i]["psw"].ToString(); mes.Sex = dt.Rows[i]["sex"].ToString(); mes.College = dt.Rows[i]["college"].ToString(); mes.Grade = dt.Rows[i]["grade"].ToString(); mes.Email = dt.Rows[i]["email"].ToString(); mes.Phone = dt.Rows[i]["phone"].ToString(); mes.Major = dt.Rows[i]["major"].ToString(); mes.Gudiance = dt.Rows[i]["guidance"].ToString(); mes.Title = dt.Rows[i]["Title"].ToString(); mes.Number = int.Parse(dt.Rows[i]["number"].ToString()); } }
public bool insert(MODEL.Message mes) { string sql; if (!isExitence(mes)) { sql = "insert into teacher(id,name,sex,college,grade,email,phone,major,guidance,Title,number) values(@id,@name,@sex,@college,@grade,@email,@phone,@major,@guidance,@title,@number)"; } else { sql = "update teacher set name=@name,sex=@sex,college=@college,grade=@grade,email=@email,phone=@phone,major=@major,guidance=@guidance,Title=@title,number=@number where id=@id"; } SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@id", mes.Id), new SqlParameter("@name", mes.Name), new SqlParameter("@sex", mes.Sex), new SqlParameter("@college", mes.College), new SqlParameter("@grade", mes.Grade), new SqlParameter("@email", mes.Email), new SqlParameter("@phone", mes.Phone), new SqlParameter("@major", mes.Major), new SqlParameter("@guidance", mes.Gudiance), new SqlParameter("@title", mes.Title), new SqlParameter("@number", mes.Number) }; int count = SqlDbHelper.ExecuteNonQuery(sql.ToString(), CommandType.Text, paras); if (count == 1) { return(true); } return(false); }
//Guest删除功能 public JsonResult Delete(int uid) { BLL.T_DIC_Guest bll = new BLL.T_DIC_Guest(); bool result = bll.Delete(uid); if (result) { MODEL.Message message = new MODEL.Message(); message.statusCode = "200"; message.message = "删除客户成功!"; message.navTabId = "GuestList"; message.rel = "GuestList"; message.forwardUrl = ""; message.callbackType = " "; return(Json(message)); } else { MODEL.Message message = new MODEL.Message(); message.statusCode = "300"; message.message = "删除客户失败!"; message.navTabId = "GuestList"; message.rel = "GuestList"; message.forwardUrl = ""; message.callbackType = " "; return(Json(message)); } }
public ActionResult Delete(string ids) { Book.BLL.V_Stock_Out bll = new Book.BLL.V_Stock_Out(); Book.BLL.T_STOCK_OutBody bll2 = new Book.BLL.T_STOCK_OutBody(); //分离逗号的方法 string[] list = ids.Split(','); int flag = 0; for (int i = 0; i < list.Length; i++) { bool result = bll.DeleteList(list[i]); bool result2 = bll.DeleteStr(list[i]); if (result && result2) { flag++; } } if (flag > 0) { MODEL.Message message = BookProject.Public.U_CloseSMess("InList", "InList", "删除出库单成功!"); return(Json(message)); } else { MODEL.Message message = BookProject.Public.U_CloseFMess("InList", "InList", "删除入库单失败!"); return(Json(message)); } }
public static MODEL.Message LoginSuc() { MODEL.Message message = new MODEL.Message(); message.statusCode = "200"; message.message = "修改密码成功"; message.navTabId = "Exit"; message.rel = "Exit"; message.forwardUrl = "Exit"; message.callbackType = ""; return(message); }
public static MODEL.Message U_CloseFMess(string TabID, string Rel, string AlertMes) { MODEL.Message message = new MODEL.Message(); message.statusCode = "300"; message.message = AlertMes; message.navTabId = TabID; message.rel = Rel; message.forwardUrl = ""; message.callbackType = ""; return(message); }
public bool InsertMessage(MODEL.Message mess, out string msg) { if (dao_mess.insert(mess)) { msg = "更改成功"; } else { msg = "更改失败"; } return(true); }
public JsonResult AddBookSave(MODEL.T_DIC_Book book) { BLL.T_DIC_Book bll = new BLL.T_DIC_Book(); if (bll.AddBook(book)) { MODEL.Message message = BookProject.Public.T_CloseSMess("BookList", "BookList", "增加书籍成功!"); return(Json(message)); } else { MODEL.Message message = BookProject.Public.T_CloseSMess("BookList", "BookList", "增加书籍失败!"); return(Json(message)); } }
public JsonResult ChangePwdSave() { string pwd = Convert.ToString(Request.Form["Pwd"]); bool result = BookProject.Tools.XMLParser.ChangePwd(pwd); if (result) { MODEL.Message message = BookProject.Public.LoginSuc(); return Json(message); } else { return Json(""); } }
public JsonResult AddUserSave(MODEL.T_DIC_User user) { BLL.T_DIC_User bll = new BLL.T_DIC_User(); //if (bll.AddUser(user))//数据库操作 if (BookProject.Tools.XMLParser.AddUser(user))//XML文件操作 { MODEL.Message message = BookProject.Public.T_CloseSMess("UserList", "UserList", "注册用户成功!"); return(Json(message)); } else { MODEL.Message message = BookProject.Public.T_CloseFMess("UserList", "UserList", "注册用户失败!"); return(Json(message)); } }
public bool isExitence(MODEL.Message mes) { string sql = "select count(*) from teacher where id = @id"; SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@id", mes.Id), }; int count = (int)SqlDbHelper.ExecuteScalar(sql.ToString(), CommandType.Text, paras); if (count == 1) { return(true); } return(false); }
/// <summary> /// DeleteBook /// </summary> /// <param name="uid"></param> /// <returns></returns> public JsonResult Delete(int uid) { BLL.T_DIC_Book bll = new BLL.T_DIC_Book(); bool result = bll.Delete(uid); if (result) { MODEL.Message message = BookProject.Public.U_CloseSMess("BookList", "BookList", "删除书籍成功!"); return(Json(message)); } else { MODEL.Message message = BookProject.Public.U_CloseFMess("BookList", "BookList", "删除书籍失败!"); return(Json(message)); } }
public JsonResult EditBookSave(MODEL.T_DIC_Book book) { BLL.T_DIC_Book bll = new BLL.T_DIC_Book(); bool result = bll.Update(book); if (result) { MODEL.Message message = BookProject.Public.T_CloseSMess("BookList", "BookList", "编辑书籍成功!"); return(Json(message)); } else { MODEL.Message message = BookProject.Public.T_CloseSMess("BookList", "BookList", "编辑书籍失败!"); return(Json(message)); } }
public JsonResult EditUserSave(MODEL.T_DIC_User model) { BLL.T_DIC_User bll = new BLL.T_DIC_User(); //bool result=bll.Update(model); bool result = BookProject.Tools.XMLParser.EditSave(model); if (result) { MODEL.Message message = BookProject.Public.T_CloseSMess("UserList", "UserList", "编辑用户成功!"); return(Json(message)); } else { MODEL.Message message = BookProject.Public.T_CloseFMess("UserList", "UserList", "编辑用户失败!"); return(Json(message)); } }
/// <summary> /// DeleteUser /// </summary> /// <param name="uid"></param> /// <returns></returns> public JsonResult Delete(int uid) { BLL.T_DIC_User bll = new BLL.T_DIC_User(); //bool result = bll.Delete(uid); bool result = BookProject.Tools.XMLParser.DeleteUser(uid); if (result) { MODEL.Message message = BookProject.Public.U_CloseSMess("UserList", "UserList", "删除用户成功!"); return(Json(message)); } else { MODEL.Message message = BookProject.Public.U_CloseFMess("UserList", "UserList", "删除用户失败!"); return(Json(message)); } }
public JsonResult AddSave() { Book.Model.T_STOCK_OutHead head = new Book.Model.T_STOCK_OutHead(); head.CeateTime = Convert.ToDateTime(Request.Form["CreateName"]); head.OrderNumber = Convert.ToString(Request.Form["OrderNumber"]); head.GuestID = Convert.ToInt32(Request.Form["json.ID"]); head.GuestName = Convert.ToString(Request.Form["json.Name"]); head.UserID = 1; head.UserName = "******"; List <Book.Model.T_STOCK_OutBody> lst = new List <Book.Model.T_STOCK_OutBody>(); int i = 0; while (Request.Form["items[" + i + "].book.ID"] != null) { Book.Model.T_STOCK_OutBody body = new Book.Model.T_STOCK_OutBody(); string BookID = Request.Form["items[" + i + "].book.ID"]; BookID = BookID.Replace(",", ""); body.BookID = Convert.ToInt32(BookID); body.Discount = Convert.ToDecimal(Request.Form["items[" + i + "].book.Discount"]); body.InHeadID = 0; body.Num = Convert.ToInt32(Request.Form["items[" + i + "].book.Num"]); body.Price = Convert.ToDecimal(Request.Form["items[" + i + "].book.Price"]); lst.Add(body); i++; } BLL.T_Stock_Out bll = new BLL.T_Stock_Out(); bool result = bll.Add(head, lst); if (result) { MODEL.Message message = new MODEL.Message(); message = BookProject.Public.T_CloseSMess("OutList", "OutList", "添加出库单成功!"); return(Json(message)); } else { MODEL.Message message = new MODEL.Message(); message = BookProject.Public.T_CloseFMess("InList", "InList", "添加入库单失败!"); return(Json(message)); } }
public void select_info(MODEL.Message mess) { dao_mess.slt_info(mess); }