public ActionResult Save(SpeechInfoEntity model)
{
try
{
SpeechInfoBLL bll = new SpeechInfoBLL();
IPScaner objScan = new IPScaner();
string ip = Request.UserHostAddress.ToString();
objScan.DataPath = Server.MapPath("/App_data/qqwry.Dat");
objScan.IP = WorkContext.IP;
//"113.200.29.90";
string addre = objScan.IPLocation();
int IndexofA = addre.IndexOf("省") + 1;
var ct = addre.Substring(0,IndexofA);
var sourceaddr = addre;
var citys= bll.GetCitys();
if (citys.FirstOrDefault(s => s.CityName == ct) == null)
{
ct = "重庆市";
}
model.SourceCity = sourceaddr;
model.City = ct;
model.FromUser = WorkContext.Uid;
model.IsVip = Convert.ToByte(Guid.Empty.Equals(WorkContext.Uid) ? 0 : 1);
model.SumbitTime = DateTime.Now;
model.State = 1;//-1为删除状态，1表示正常
if (bll.Insert(model, null))
{
return AjaxResult("ok", "发送成功！", false);
}
else
{
return AjaxResult("err", "发送失败！", false);
}
}
catch (Exception ex)
{
return AjaxResult("err", "发送失败！" + ex.ToString(), false);
throw;
}
}
/// <summary>
/// 实体Reader
/// </summary>
/// <returns>实体对象</returns>
protected static SpeechInfoEntity GetBindTData(SqlDataReader dataReader)
{
SpeechInfoEntity speechInfoEntity = null;
while (dataReader.Read())
{
speechInfoEntity = new SpeechInfoEntity();
if (dataReader["Id"] != DBNull.Value)
{
speechInfoEntity.Id = new Guid(dataReader["Id"].ToString());
}
if (dataReader["FromUser"] != DBNull.Value)
{
speechInfoEntity.FromUser = new Guid(dataReader["FromUser"].ToString());
}
if (dataReader["SpeachContent"] != DBNull.Value)
{
speechInfoEntity.SpeachContent = Convert.ToString(dataReader["SpeachContent"]);
}
if (dataReader["SpeechImage"] != DBNull.Value)
{
speechInfoEntity.SpeechImage = Convert.ToString(dataReader["SpeechImage"]);
}
if (dataReader["IsVip"] != DBNull.Value)
{
speechInfoEntity.IsVip = Convert.ToByte(dataReader["IsVip"]);
}
if (dataReader["State"] != DBNull.Value)
{
speechInfoEntity.State = Convert.ToByte(dataReader["State"]);
}
if (dataReader["SumbitTime"] != DBNull.Value)
{
speechInfoEntity.SumbitTime = Convert.ToDateTime(dataReader["SumbitTime"]);
}
}
dataReader.Close();
dataReader.Dispose();
return speechInfoEntity;
}
/// <summary>
/// 实体集合Reader
/// </summary>
/// <returns>实体集合</returns>
protected static List<SpeechInfoEntity> GetBindTDataList(SqlDataReader dataReader)
{
List< SpeechInfoEntity> speechInfoList = new List< SpeechInfoEntity>();
while (dataReader.Read())
{
SpeechInfoEntity speechInfoEntity = new SpeechInfoEntity();
if (dataReader["Id"] != DBNull.Value)
{
speechInfoEntity.Id = new Guid(dataReader["Id"].ToString());
}
if (dataReader["FromUser"] != DBNull.Value)
{
speechInfoEntity.FromUser = new Guid(dataReader["FromUser"].ToString());
}
if (dataReader["SpeachContent"] != DBNull.Value)
{
speechInfoEntity.SpeachContent = Convert.ToString(dataReader["SpeachContent"]);
}
if (dataReader["SpeechImage"] != DBNull.Value)
{
speechInfoEntity.SpeechImage = Convert.ToString(dataReader["SpeechImage"]);
}
if (dataReader["IsVip"] != DBNull.Value)
{
speechInfoEntity.IsVip = Convert.ToByte(dataReader["IsVip"]);
}
if (dataReader["State"] != DBNull.Value)
{
speechInfoEntity.State = Convert.ToByte(dataReader["State"]);
}
if (dataReader["SumbitTime"] != DBNull.Value)
{
speechInfoEntity.SumbitTime = Convert.ToDateTime(dataReader["SumbitTime"]);
}
if (dataReader["cityname"] != DBNull.Value)
{
speechInfoEntity.City = Convert.ToString(dataReader["cityname"]);
}
speechInfoList.Add(speechInfoEntity);
}
dataReader.Close();
dataReader.Dispose();
return speechInfoList;
}
/// <summary>
/// 创建
/// </summary>
/// <param name="speechInfoEntity">实体</param>
/// <param name="tran">事务</param>
/// <returns>是否成功</returns>
public static Guid InsertReturnID( 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));
Guid result = Guid.Empty;
if (tran == null)
{
Guid.TryParse(SqlServerHelper.ExecuteScalar(CommandType.Text, SqlInsertReturnID, parameters.ToArray()).ToString(), out result);
}
else
{
Guid.TryParse(SqlServerHelper.ExecuteScalar(tran, CommandType.Text, SqlInsertReturnID, parameters.ToArray()).ToString(), out result);
}
return result;
}
/// <summary>
/// 更新
/// </summary>
/// <param name="speechInfoEntity">实体</param>
/// <param name="tran">事务</param>
/// <returns>是否成功</returns>
public static bool Update( SpeechInfoEntity speechInfoEntity , SqlTransaction tran)
{
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(SqlServerHelper.CreateInputParameter("@Id", SqlDbType.UniqueIdentifier, speechInfoEntity.Id));
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));
if (tran == null)
{
SqlServerHelper.ExecuteNonQuery(CommandType.Text, SqlUpdate, parameters.ToArray());
return true;
}
SqlServerHelper.ExecuteNonQuery(tran, CommandType.Text, SqlUpdate, parameters.ToArray());
return true;
}
/// <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>
/// 更新
/// </summary>
/// <param name=" speechInfoEntity">实体</param>
/// <param name="tran">事务</param>
/// <returns>是否成功</returns>
public bool Update( SpeechInfoEntity speechInfoEntity , SqlTransaction tran)
{
return SpeechInfoDAL.Update(speechInfoEntity, tran);
}
/// <summary>
/// 创建
/// </summary>
/// <param name=" speechInfoEntity">实体</param>
/// <param name="tran">事务</param>
/// <returns>是否成功</returns>
public Guid InsertReturnID( SpeechInfoEntity speechInfoEntity , SqlTransaction tran)
{
return SpeechInfoDAL.InsertReturnID(speechInfoEntity, tran);
}
/// <summary>
/// 创建
/// </summary>
/// <param name=" speechInfoEntity">实体</param>
/// <param name="tran">事务</param>
/// <returns>是否成功</returns>
public bool Insert( SpeechInfoEntity speechInfoEntity , SqlTransaction tran)
{
return SpeechInfoDAL.Insert(speechInfoEntity, tran);
}
public ActionResult Save(SpeechInfoEntity model)
{
try
{
var city = "";
//统计当前发言人的发言次数
//if (Session["User"] != null)
//{
// UsersEntity user = Session["User"] as UsersEntity;
// //获取当前这个人的这个小时发言的数量
string uid = string.Empty;
if (Session["User"] != null)
{
UsersEntity user = Session["User"] as UsersEntity;
uid = user.Id.ToString();
}
else
{
uid = ShopUtils.GetBSPCookie("bsp");
if (string.IsNullOrEmpty(uid.ToString()))
{
uid = Guid.NewGuid().ToString();
ShopUtils.SetBSPCookie("bsp", uid);
}
}
SpeechInfoBLL bll = new SpeechInfoBLL();
IPScaner objScan = new IPScaner();
string ip = Request.UserHostAddress.ToString();
objScan.DataPath = Server.MapPath("/App_data/qqwry.Dat");
objScan.IP = WorkContext.IP;
//"113.200.29.90";
string addre = objScan.IPLocation();
int IndexofA = addre.IndexOf("省") + 1;
var ct = addre.Substring(0,IndexofA);
var sourceaddr = addre;
var citys = bll.GetCitys();
if (citys.FirstOrDefault(s => s.CityName == ct) == null)
{
ct = "重庆市";
}
SpeechInfoBLL bill = new SpeechInfoBLL();
if (!string.IsNullOrEmpty(uid))
{
int num = bill.GetSpeechCount(new Guid(uid));
if (num >= 3)
{
return AjaxResult("err", "发送失败一小时内最多能发3条！", false);
}
}
model.SourceCity = sourceaddr;
model.FromUser = new Guid(uid);
model.IsVip = Convert.ToByte(Guid.Empty.Equals(new Guid(uid)) ? 0 : 1);
model.SumbitTime = DateTime.Now;
model.State = 1; //-1为删除状态，1表示正常
model.City = ct;
// SpeechInfoBLL bll = new SpeechInfoBLL();
if (bll.Insert(model, null))
{
return AjaxResult("ok", "发送成功！", false);
}
else
{
return AjaxResult("ok", "发送失败！", false);
}
//}
//return AjaxResult("err", "请登陆后发信息！", false);
}
catch (Exception ex)
{
//return AjaxResult("err", "发送失败！" + ex.ToString(), false);
throw;
}
}
