随着机房重构进度的逐渐深入,我发现机房这个系统远远没有想象的那么难,我们只需要理清逻辑,查懂一些语法,其余都是大同小异的,每个层所承担的内容和格式大概都是一致的。
比如说D层,就是实例化一下数据库,进行一些SQL语句操作,然后通过接口,传回返回值。
如:
//学生上机
public int studentonline(string UserName)
{
string State = "上机";
sqlHelper sqlhelper = new sqlHelper();
SqlParameter[] sqlParames ={new SqlParameter ("@cardNo",UserName),
new SqlParameter ("@Ondate",DateTime.Now.ToShortDateString ()),
new SqlParameter ("@Ontime",DateTime.Now.ToShortTimeString ()),
new SqlParameter ("@state",State)};
string sql = @"insert into Online_Info(cardNo,OnDate,OnTime,Type)values(@cardNo,@Ondate,@Ontime,@state)";
int studenton = sqlhelper.ExecuteNonQuery(sql, sqlParames, CommandType.Text);
return studenton;
}
//判断账号是否存在
public DataTable selectuser(Entity.userEntity Eselect)
{
sqlHelper sqlhelper = new sqlHelper();
SqlParameter[] sqlParames = { new SqlParameter("@userID", Eselect.userID) };
string sql6 = @"SELECT*FROM [User_Info] Where userID=@userID";
DataTable table6 = sqlhelper.ExecuteQuery(sql6, sqlParames, CommandType.Text);
return table6;
}
//判断是否正在上机
public DataTable nowonline(Entity.OnlineEntity Eonline)
{
sqlHelper sqlhelper = new sqlHelper();
SqlParameter[] sqlParmes = { new SqlParameter("@userID", Eonline.userID) };
string sql8 = @"SELECT * FROM [Online_Info] WHERE cardNo=@userID";
DataTable table = sqlhelper.ExecuteQuery(sql8, sqlParmes, CommandType.Text);
return table;
}
很显然,这就是就操作数据库,传回一些返回值的三个方法,所以我们不要害怕,努力的接触+了解,相信自己一定能行。