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