/// <summary> /// 得到一个对象实体 /// </summary> public SmartLaw.Model.SysUser DataRowToModel(DataRow row) { SmartLaw.Model.SysUser model=new SmartLaw.Model.SysUser(); if (row != null) { if(row["UserID"]!=null) { model.UserID=row["UserID"].ToString(); } if(row["Password"]!=null) { model.Password=row["Password"].ToString(); } if(row["EmployeeID"]!=null) { model.EmployeeID=row["EmployeeID"].ToString(); } if(row["UserName"]!=null) { model.UserName=row["UserName"].ToString(); } if(row["IsValid"]!=null && row["IsValid"].ToString()!="") { if((row["IsValid"].ToString()=="1")||(row["IsValid"].ToString().ToLower()=="true")) { model.IsValid=true; } else { model.IsValid=false; } } } return model; }
/// <summary> /// 得到一条数据 /// </summary> public SmartLaw.Model.SysUser GetModel(string UserID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select UserID,Password,EmployeeID,UserName,IsValid from SysUser "); strSql.Append(" where UserID=@UserID limit 1"); MySqlParameter[] parameters = { new MySqlParameter("@UserID", MySqlDbType.VarChar,50) }; parameters[0].Value = UserID; SmartLaw.Model.SysUser model=new SmartLaw.Model.SysUser(); DataSet ds=DbHelperMySQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }