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