public static List<Users> LoadOnlineUser()
{
var edm = new BaoXinEntities();
return edm.Users.Where(s => s.IsOnline == 1).ToList();
}
public static Users GetUserById(Guid uid)
{
var edm = new BaoXinEntities();
return edm.Users.FirstOrDefault(s => s.Id == uid);
}
/// <summary>
/// 创建 增加用户积分
/// </summary>
/// <param name="speechInfoEntity">实体</param>
/// <param name="tran">事务</param>
/// <returns>是否成功</returns>
public static bool Insert( SpeechInfoEntity speechInfoEntity , SqlTransaction tran)
{
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(SqlServerHelper.CreateInputParameter("@FromUser", SqlDbType.UniqueIdentifier, speechInfoEntity.FromUser));
parameters.Add(SqlServerHelper.CreateInputParameter("@SpeachContent", SqlDbType.NVarChar, speechInfoEntity.SpeachContent));
parameters.Add(SqlServerHelper.CreateInputParameter("@SpeechImage", SqlDbType.NVarChar, speechInfoEntity.SpeechImage));
parameters.Add(SqlServerHelper.CreateInputParameter("@IsVip", SqlDbType.TinyInt, speechInfoEntity.IsVip));
parameters.Add(SqlServerHelper.CreateInputParameter("@State", SqlDbType.TinyInt, speechInfoEntity.State));
parameters.Add(SqlServerHelper.CreateInputParameter("@SumbitTime", SqlDbType.DateTime, speechInfoEntity.SumbitTime));
parameters.Add(SqlServerHelper.CreateInputParameter("@City", SqlDbType.NVarChar, speechInfoEntity.City));
parameters.Add(SqlServerHelper.CreateInputParameter("@Sourcecity", SqlDbType.NVarChar, speechInfoEntity.SourceCity));
SqlServerHelper.ExecuteNonQuery(CommandType.Text, SqlInsert, parameters.ToArray());
var edm = new BaoXinEntities();
var user = edm.Users.FirstOrDefault(s => s.Id == speechInfoEntity.FromUser);
if (user != null)
{
user.RankCredits = user.RankCredits + 1;
edm.SaveChanges();
}
return true;
}
public static bool GetUser(string id)
{
SpeechInfoEntity entity= GetSpeechInfoEntityByID(new Guid(id),null);
if (entity != null)
{
var edm = new BaoXinEntities();
return edm.Users.FirstOrDefault(s => s.Id == entity.FromUser) != null;
}
return false;
}
public static List<SpeechInfo> GetSpeechList(string key,string city)
{
var edm = new BaoXinEntities();
var query= edm.SpeechInfo.Where(s=>s.IsDelete==
false);
if (!string.IsNullOrEmpty(key))
{
query = query.Where(s => s.SpeachContent.IndexOf(key) >= 0);
}
if (!string.IsNullOrEmpty(city))
{
query = query.Where(s => s.cityname.IndexOf(city) >= 0);
}
return query.ToList();
}
public static List<City> GetCitys()
{
var edm = new BaoXinEntities();
return edm.City.OrderByDescending(s=>s.orderid).ToList();
}
/// <summary>
/// 删除数据 2更新用户信息
/// </summary>
/// <param name="id"></param>
/// <param name="userid"></param>
/// <returns></returns>
public static bool Delete(Guid id, Guid userid)
{
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(SqlServerHelper.CreateInputParameter("@id", SqlDbType.UniqueIdentifier, id));
parameters.Add(SqlServerHelper.CreateInputParameter("@userid", SqlDbType.UniqueIdentifier, userid));
int rtn= SqlServerHelper.ExecuteNonQuery(CommandType.Text, SqlDelete, parameters.ToArray());
BaoXinEntities edm=new BaoXinEntities();
//1删除别人的人需要更新为已经删除
var user=edm.Users.FirstOrDefault(s => s.Id == userid);
if (user != null)
{
user.IsCanDel = true;
user.DelTime = DateTime.Now;
edm.SaveChanges();
}
//2被删除的人 需要更新为今天被删除
var spinfo = edm.SpeechInfo.FirstOrDefault(s => s.Id == id);
if (spinfo != null)
{
var buser = edm.Users.FirstOrDefault(s => s.Id == spinfo.FromUser);
if (buser != null)
{
buser.IsOtherDel = true;
buser.OtherDelTime = DateTime.Now;
edm.SaveChanges();
}
}
if (rtn > 0)
{
return true;
}
return false;
}
