public UsersModel CheckByDName(string displayName, string newpassword) { //定义一个对象 UsersModel user = null; //构造要查询的sql语句 string sql = "SELECT UserName, DisplayName, PassWord FROM Users WHERE DisplayName=@DisplayName"; SqlParameter p = new SqlParameter("@DisplayName", displayName); //使用helper进行查询,得到结果 DataTable dt = MSSqlHelper.GetDataTable(sql, p); //判断是否查找到了 if (dt.Rows.Count > 0) { user = new UsersModel() { PassWord = dt.Rows[0]["PassWord"].ToString(), }; if (user.OK) { //构造Update语句 string Update = "UPDATE Users SET PassWord=@PassWord WHERE DisplayName=@DisplayName"; //构造sql语句的参数 SqlParameter[] ps = //使用数组初始化器 { new SqlParameter("@DisplayName", displayName), new SqlParameter("@PassWord", newpassword) }; //执行插入操作 MSSqlHelper.ExecuteNonQuery(Update, ps); } } return(user); }
public UsersModel CheckByName(string username, string displayName, string password) { //定义一个对象 UsersModel user = null; //构造要查询的sql语句 string sql = "SELECT UserName, DisplayName, PassWord FROM Users WHERE UserName=@UserName"; SqlParameter p = new SqlParameter("@UserName", username); //使用helper进行查询,得到结果 DataTable dt = MSSqlHelper.GetDataTable(sql, p); //判断是否查找到了 if (dt.Rows.Count == 0) { //构造insert语句 string INSERT = "INSERT INTO Users (UserName, DisplayName, PassWord) VALUES(@UserName,@DisplayName,@PassWord)"; //构造sql语句的参数 SqlParameter[] ps = //使用数组初始化器 { new SqlParameter("@UserName", username), new SqlParameter("@DisplayName", displayName), new SqlParameter("@PassWord", password), }; //执行插入操作 MSSqlHelper.ExecuteNonQuery(INSERT, ps); } return(user); }
/// <summary> /// 查询到列表 /// </summary> /// <param name="?"></param> /// <param name="dname"></param> /// <returns></returns> public List <WorkLogsModel> GetList(string dname) { //构造查询sql语句 string sql = "SELECT ID, DateTime, Name, ProductName, Version, Stage, Type, Task, Progress, Whours, TProgress, Workout, Problem FROM Works where Name=@Name"; //拼接查询条件 List <SqlParameter> P = new List <SqlParameter> { new SqlParameter("@Name", dname) }; //执行查询 DataTable dt = MSSqlHelper.GetDataTable(sql, P.ToArray()); //定义list,完成转存 List <WorkLogsModel> list = new List <WorkLogsModel>(); foreach (DataRow row in dt.Rows) { list.Add(new WorkLogsModel() { ID = Convert.ToInt32(row["ID"]), DateTime = Convert.ToDateTime(row["DateTime"]), Name = row["Name"].ToString(), ProductName = row["ProductName"].ToString(), Version = row["Version"].ToString(), Stage = row["Stage"].ToString(), Type = row["Type"].ToString(), Task = row["Task"].ToString(), Progress = row["Progress"].ToString(), Whours = Convert.ToInt32(row["Whours"]), TProgress = row["TProgress"].ToString(), Workout = row["Workout"].ToString(), Problem = row["Problem"].ToString() }); } return(list); }
public List <ProductsModel> GetList() { //构造查询sql语句 string sql = "SELECT ProductID, Product_E, Product_C FROM Products"; //执行查询 DataTable dt = MSSqlHelper.GetDataTable(sql); //定义list,完成转存 List <ProductsModel> list = new List <ProductsModel>(); foreach (DataRow row in dt.Rows) { list.Add(new ProductsModel() { ProductID = Convert.ToInt32(row["ProductID"]), Product_E = row["Product_E"].ToString(), Product_C = row["Product_C"].ToString(), }); } return(list); }
public UsersModel GetByName(string username) { //定义一个对象 UsersModel user = null; //构造要查询的sql语句 string sql = "SELECT UserName, DisplayName, PassWord FROM Users WHERE UserName=@UserName"; SqlParameter p = new SqlParameter("@UserName", username); //使用helper进行查询,得到结果 DataTable dt = MSSqlHelper.GetDataTable(sql, p); //判断是否查找到了 if (dt.Rows.Count > 0) { //用户名是存在的 user = new UsersModel() { UserName = username, DisplayName = dt.Rows[0]["DisplayName"].ToString(), PassWord = dt.Rows[0]["PassWord"].ToString(), }; } return(user); }