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));
}
