public static List<string> getLoginInfo(string strUser, string strPass)
{
string strSql = "select UID,Name,Pass,Email,Phone,Tel,Address,IP,VIP.VName,VImg from [User],VIP where Name='" + strUser.Trim() + "' and Pass='******' and VIP.VID=[User].VID";
List<string> list = new List<string>();
SqlDataReader reader = new DAL.SqlHelper().GetDataReader(strSql);
while (reader.Read())
{
try { list.Add(reader["UID"].ToString()); }
catch{ }
try { list.Add(reader["Name"].ToString()); }
catch{ }
try {list.Add(reader["Pass"].ToString()); }
catch{ }
try {list.Add(reader["Email"].ToString()); }
catch{ }
try { list.Add(reader["Phone"].ToString()); }
catch{ }
try { list.Add(reader["Tel"].ToString()); }
catch{ }
try {list.Add(reader["Address"].ToString()); }
catch{ }
try { list.Add(reader["IP"].ToString()); }
catch{ }
try {list.Add(reader["VName"].ToString()); }
catch{ }
try { list.Add(reader["VImg"].ToString()); }
catch { }
}
return list;
}
public static List <string> getLoginInfo(string strUser, string strPass)
{
string strSql = "select UID,Name,Pass,Email,Phone,Tel,Address,IP,VIP.VName,VImg from [User],VIP where Name='" + strUser.Trim() + "' and Pass='******' and VIP.VID=[User].VID";
List <string> list = new List <string>();
SqlDataReader reader = new DAL.SqlHelper().GetDataReader(strSql);
while (reader.Read())
{
try { list.Add(reader["UID"].ToString()); }
catch { }
try { list.Add(reader["Name"].ToString()); }
catch { }
try { list.Add(reader["Pass"].ToString()); }
catch { }
try { list.Add(reader["Email"].ToString()); }
catch { }
try { list.Add(reader["Phone"].ToString()); }
catch { }
try { list.Add(reader["Tel"].ToString()); }
catch { }
try { list.Add(reader["Address"].ToString()); }
catch { }
try { list.Add(reader["IP"].ToString()); }
catch { }
try { list.Add(reader["VName"].ToString()); }
catch { }
try { list.Add(reader["VImg"].ToString()); }
catch { }
}
return(list);
}
/// <summary>
///
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public static List<string> getAllAdminInfoById(int ID)
{
List<string> list = new List<string>();
SqlDataReader reader = new DAL.SqlHelper().GetDataReader("select * from Admins where AdminID="+ID+"");
while (reader.Read())
{
list.Add(reader["AdminID"].ToString());
list.Add(reader["UName"].ToString());
list.Add(reader["UPass"].ToString());
}
return list;
}
/// <summary>
///
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public static List <string> getAllAdminInfoById(int ID)
{
List <string> list = new List <string>();
SqlDataReader reader = new DAL.SqlHelper().GetDataReader("select * from Admins where AdminID=" + ID + "");
while (reader.Read())
{
list.Add(reader["AdminID"].ToString());
list.Add(reader["UName"].ToString());
list.Add(reader["UPass"].ToString());
}
return(list);
}
public JsonResult ReturnJson()
{
string sql = "select AccountNumber,Name from [dbo].[SysUser]";
DAL.SqlHelper sqlHelper = new DAL.SqlHelper();
DataTable dataTable = sqlHelper.SqlConnectionInformation(sql);
var list = (
from d in dataTable.AsEnumerable()
where d.Field <string>("Name") == "许嵩"
select new User
{
Number = d.Field <string>("AccountNumber"),
Name = d.Field <string>("Name")
}
).ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
public BaseBll()
{
dal = new DAL.SqlHelper();
}
public BaseBll()
{
dal = new DAL.SqlHelper();
}
