public bool Add(MODEL.T_DIC_User user) { SqlConnection co = new SqlConnection(); co.ConnectionString = "server=10.132.239.215;uid=10jb;pwd=10jb;database=13110033246_Book"; co.Open(); SqlCommand cm = new SqlCommand(); cm.CommandText = "insert into t_dic_user (LoginName,Pwd,Phone,LastLoginTime,VisitCount,Status) values (@LoginName,@Pwd,@Phone,@LastLoginTime,@VisitCount,@Status)"; cm.Parameters.AddWithValue("@LoginName", user.LoginName); cm.Parameters.AddWithValue("@Pwd", "123"); cm.Parameters.AddWithValue("@Phone", user.Phone); cm.Parameters.AddWithValue("@LastLoginTime", System.DateTime.Now); cm.Parameters.AddWithValue("@VisitCount", 3); cm.Parameters.AddWithValue("@Status", user.Status); cm.Connection = co; int result = cm.ExecuteNonQuery(); co.Close(); if (result >= 1) { return(true); } else { return(false); } }
public List <MODEL.T_DIC_User> Get(string where) { List <MODEL.T_DIC_User> lst = new List <MODEL.T_DIC_User>(); SqlConnection co = new SqlConnection(); co.ConnectionString = "server=10.132.239.215;uid=10jb;pwd=10jb;database=13110033246_Book"; co.Open(); SqlCommand cm = new SqlCommand(); cm.CommandText = "select * from T_DIC_User where " + where; cm.Connection = co; SqlDataReader dr = cm.ExecuteReader(); while (dr.Read()) { MODEL.T_DIC_User item = new MODEL.T_DIC_User(); item.ID = Convert.ToInt32(dr["ID"]); item.LoginName = Convert.ToString(dr["LoginName"]); item.Pwd = Convert.ToString(dr["Pwd"]); item.Phone = Convert.ToString(dr["Phone"]); item.LastLoginTime = Convert.ToDateTime(dr["LastLoginTime"]); item.VisitCount = Convert.ToInt32(dr["VisitCount"]); item.Status = Convert.ToInt32(dr["Status"]); lst.Add(item); } dr.Close(); co.Close(); return(lst); }
public List <MODEL.T_DIC_User> GetByPage(int PageSize, int PageIndex) { List <MODEL.T_DIC_User> lst = new List <MODEL.T_DIC_User>(); SqlConnection co = new SqlConnection(); co.ConnectionString = "server=10.132.239.215;uid=10jb;pwd=10jb;database=13110033246_Book"; co.Open(); SqlCommand cm = new SqlCommand(); cm.CommandText = string.Format("select top {0} * from T_DIC_User where id not in (select top {1} id from t_dic_user)", PageSize, (PageIndex - 1) * PageSize); cm.Connection = co; SqlDataReader dr = cm.ExecuteReader(); while (dr.Read()) { MODEL.T_DIC_User item = new MODEL.T_DIC_User(); item.ID = Convert.ToInt32(dr["ID"]); item.LoginName = Convert.ToString(dr["LoginName"]); item.Pwd = Convert.ToString(dr["Pwd"]); item.Phone = Convert.ToString(dr["Phone"]); item.LastLoginTime = Convert.ToDateTime(dr["LastLoginTime"]); item.VisitCount = Convert.ToInt32(dr["VisitCount"]); item.Status = Convert.ToInt32(dr["Status"]); lst.Add(item); } dr.Close(); co.Close(); return(lst); }
public bool Update(MODEL.T_DIC_User model) { SqlConnection co = new SqlConnection(); co.ConnectionString = "server=10.132.239.215;uid=10jb;pwd=10jb;database=13110033246_Book"; co.Open(); SqlCommand cm = new SqlCommand(); cm.CommandText = "update t_dic_user set LoginName=@LoginName,Pwd=@Pwd,Phone=@Phone,LastLoginTime=@LastLoginTime,VisitCount=@VisitCount,Status=@Status where id=@ID"; cm.Parameters.AddWithValue("@ID", model.ID); cm.Parameters.AddWithValue("@Pwd", model.Pwd); cm.Parameters.AddWithValue("@LoginName", model.LoginName); cm.Parameters.AddWithValue("@Phone", model.Phone); cm.Parameters.AddWithValue("@LastLoginTime", model.LastLoginTime); cm.Parameters.AddWithValue("@VisitCount", model.VisitCount); cm.Parameters.AddWithValue("@Status", model.Status); cm.Connection = co; int result = cm.ExecuteNonQuery(); co.Close(); if (result >= 1) { return(true); } else { return(false); } }
/// <summary> /// EditUser /// </summary> /// <param name="uid"></param> /// <returns></returns> public ActionResult EditUser(int uid) { BLL.T_DIC_User bll = new BLL.T_DIC_User(); //MODEL.T_DIC_User model = bll.GetModel(uid); MODEL.T_DIC_User model = BookProject.Tools.XMLParser.EditUser(uid); ViewBag.lst = model; return(View()); }
public MODEL.T_DIC_User GetModel(int uid) { DAL.T_DIC_User dal = new DAL.T_DIC_User(); string where; where = "ID=" + uid; MODEL.T_DIC_User model = dal.Get(where)[0]; return(model); }
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 static bool AddUser(MODEL.T_DIC_User model) { XmlDocument xml = new XmlDocument(); string path = HttpContext.Current.Server.MapPath("~/Tools/XML_User.xml"); xml.Load(path); XmlElement person = xml.CreateElement("Person"); XmlAttribute ID = xml.CreateAttribute("ID"); int id = Convert.ToInt32(xml.GetElementsByTagName("LastID")[0].ChildNodes[0].InnerText); xml.GetElementsByTagName("LastID")[0].ChildNodes[0].InnerText = (id + 1).ToString(); ID.Value = Convert.ToString(id + 1); XmlElement LoginName = xml.CreateElement("LoginName"); LoginName.InnerText = Convert.ToString(model.LoginName); XmlElement PWD = xml.CreateElement("Pwd"); PWD.InnerText = Convert.ToString(model.Pwd); XmlElement Phone = xml.CreateElement("Phone"); Phone.InnerText = Convert.ToString(model.Phone); XmlElement LastLoginTime = xml.CreateElement("LastLoginTime"); LastLoginTime.InnerText = Convert.ToString(string.Format("{0:yyyy-MM-dd}", model.LastLoginTime)); XmlElement Status = xml.CreateElement("Status"); Status.InnerText = Convert.ToString(model.Status); XmlElement VisitCount = xml.CreateElement("VisitCount"); VisitCount.InnerText = Convert.ToString(model.VisitCount); person.Attributes.Append(ID); person.AppendChild(LoginName); person.AppendChild(PWD); person.AppendChild(Phone); person.AppendChild(LastLoginTime); person.AppendChild(VisitCount); person.AppendChild(Status); xml.DocumentElement.AppendChild(person); xml.Save(path); return(true); }
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)); } }
public static bool EditSave(MODEL.T_DIC_User model) { XmlDocument xml = new XmlDocument(); string path = HttpContext.Current.Server.MapPath("~/Tools/XML_User.xml"); xml.Load(path); XmlNode root = xml.DocumentElement; XmlNode node = root.SelectSingleNode("/User/Person[@ID=\"" + model.ID + "\"]"); node.ChildNodes[0].InnerText = model.LoginName; node.ChildNodes[1].InnerText = model.Pwd; node.ChildNodes[2].InnerText = Convert.ToString(model.Phone); node.ChildNodes[3].InnerText = Convert.ToString(model.LastLoginTime); node.ChildNodes[4].InnerText = Convert.ToString(model.VisitCount); node.ChildNodes[5].InnerText = Convert.ToString(model.Status); xml.Save(path); return(true); }
//修改用户 public static MODEL.T_DIC_User EditUser(int uid) { XmlDocument xml = new XmlDocument(); string path = HttpContext.Current.Server.MapPath("~/Tools/XML_User.xml"); xml.Load(path); XmlNode root = xml.DocumentElement; XmlNode node = root.SelectSingleNode("/User/Person[@ID=\"" + uid + "\"]"); MODEL.T_DIC_User model = new MODEL.T_DIC_User(); model.ID = Convert.ToInt32(node.Attributes[0].Value); model.LoginName = node.ChildNodes[0].InnerText; model.Pwd = node.ChildNodes[1].InnerText; model.Phone = Convert.ToString(node.ChildNodes[2].InnerText); model.LastLoginTime = Convert.ToDateTime(node.ChildNodes[3].InnerText); model.Status = Convert.ToInt32(node.ChildNodes[5].InnerText); model.VisitCount = Convert.ToInt32(node.ChildNodes[4].InnerText); return(model); }
//XML文件列表的展示 public static List <MODEL.T_DIC_User> GetUser(int PageSize, int PageIndex, string keywords) { //构建XML文件 XmlDocument xml = new XmlDocument(); string path = HttpContext.Current.Server.MapPath("~/Tools/XML_User.xml"); xml.Load(path); List <MODEL.T_DIC_User> lst = new List <MODEL.T_DIC_User>(); XmlNodeList Nodes = xml.SelectNodes("/User/Person[LoginName" + keywords + "]"); int n = 1; foreach (XmlNode node in Nodes) { MODEL.T_DIC_User model = new MODEL.T_DIC_User(); model.ID = Convert.ToInt32(node.Attributes[0].Value); model.LoginName = Convert.ToString(node.ChildNodes[0].InnerText); model.Pwd = Convert.ToString(node.ChildNodes[1].InnerText); model.Phone = Convert.ToString(node.ChildNodes[2].InnerText); model.LastLoginTime = Convert.ToDateTime(node.ChildNodes[3].InnerText); model.VisitCount = Convert.ToInt32(node.ChildNodes[4].InnerText); model.Status = Convert.ToInt32(node.ChildNodes[5].InnerText);//将数据转化成模型中的列表 n++; if (n > PageSize * (PageIndex - 1) + 1) { lst.Add(model); if (lst.Count > PageSize - 1) { break; } } } return(lst); }
public bool Update(MODEL.T_DIC_User model) { DAL.T_DIC_User dal = new DAL.T_DIC_User(); return(dal.Update(model)); }
public bool AddUser(MODEL.T_DIC_User user) { DAL.T_DIC_User dal = new DAL.T_DIC_User(); return(dal.Add(user)); }