public ActionResult AddPraise(int weaponID)
{
Avatar avatar = Session[SessionKey.AvatarKey] as Avatar;
PraiseLog pralog = new PraiseLog();
pralog.PraiseIP = Request.UserHostAddress;
pralog.WeaponID = weaponID;
pralog.PraiseNumber = 1;
pralog.Source = 0;
pralog.CreateTS = DateTime.Now;
pralog.AreaID = avatar.GameAreaID;
pralog.AvatarID = avatar.AvatarID;
pralog.UserID = avatar.UserID;
int result = WeapDesignBll.AddPraiseLog(pralog);
if (result > 0 || result == -3)
{
return(Jsonp(ErrorCode.Succuess, result));
}
else if (result == -2)
{
return(Jsonp(ErrorCode.RepeatPraise, null));
}
else
{
return(Jsonp(ErrorCode.PraiseFailed, null));
}
}
public PortalResult PraiseQuestion(User user, Question exist)
{
var old = GetPraiseLog(user.Id, exist.Id);
using (var db = new PortalDb())
{
//如果可以取消
if (old == null)
{
exist.PraisesNum = exist.PraisesNum + 1;
var p = new PraiseLog()
{
UserId = user.Id, RelateId = exist.Id, PraiseType = PraiseType.Question
};
db.Praises.Add(p);
db.SaveChanges();
return(new PortalResult(true)
{
Num = exist.PraisesNum
});
}
if (!PortalConfig.CanCancelPraise)
{
return(getaPortalResult(false, "你已经赞过啦", exist.PraisesNum));
}
db.Praises.Remove(old);
exist.PraisesNum = exist.PraisesNum - 1;
db.SaveChanges();
}
return(new PortalResult(true)
{
Num = exist.PraisesNum
});
}
public ActionResult AddPraiseLog(PraiseLog praiseLog)
{
PraiseLog pLog = new PraiseLog();
pLog.WeaponID = praiseLog.WeaponID;
pLog.CreateTS = DateTime.Now;
pLog.PraiseNumber = praiseLog.PraiseNumber;
pLog.Source = 1;
pLog.PraiseIP = "admin";
pLog.AreaID = -1;
pLog.UserID = -1;
pLog.AvatarID = -1;
int rs = _adminBLL.AddPraiseLog(pLog);
//记录日志
Log(string.Format("新增PraiseLog 数据:{0}", pLog.ToString()));
if (rs == -1)
{
return(UnSuccessful("新增赞数失败", "AddPraiseLog"));
}
else
{
return(Success("PraiseLogList"));
}
}
/// <summary>
/// 列表
/// </summary>
/// <param name="searchSort">用来搜索的实例</param>
/// <returns></returns>
public ActionResult PraiseLogList(DataPage dp, PraiseLog model)
{
List <PraiseLog> lists = new List <PraiseLog>();
if (Request["btnExportExcel"] == null)//导出Excel
{
lists = _adminBLL.GetPraiseLogList(ref dp, model);
GetDataPage(dp);
}
else
{
dp.PageSize = 0;
lists = _adminBLL.GetPraiseLogList(ref dp, model);
string fileName = "nothing";
if (lists.Count() > 0)
{
fileName = "PraiseLogList" + lists.Count() + "_Item";
}
Dictionary <string, Func <PraiseLog, string> > showFields = new Dictionary <string, Func <PraiseLog, string> >();
showFields.Add(PraiseLog.WeaponIDField, z => "'" + z.WeaponID.ToString());
showFields.Add(PraiseLog.PraiseNumberField, z => "'" + z.PraiseNumber.ToString());
showFields.Add(PraiseLog.PraiseIPField, z => "'" + z.PraiseIP.ToString());
showFields.Add(PraiseLog.CreateTSField, z => "'" + z.CreateTS.ToString());
showFields.Add(PraiseLog.SourceField, z => "'" + z.Source.ToString());
showFields.Add(PraiseLog.UserIDField, z => "'" + z.UserID.ToString());
showFields.Add(PraiseLog.AreaNameField, z => "'" + z.AreaName.ToString());
showFields.Add(PraiseLog.AvatarIDField, z => "'" + z.AvatarID.ToString());
ObjectUtil.Common.ExcelHelper2 <PraiseLog> elh = new ObjectUtil.Common.ExcelHelper2 <PraiseLog>(lists, null, showFields);
elh.FileWebSaveAs(Response, fileName);
}
//记录日志
Log(string.Format("查看[PraiseLog]列表页面 搜索数据:{0}", model.ToString()));
return(View(lists));
}
public static int AddPraiseLog(PraiseLog pralog)
{
lock (locker)
{
return(client.AddPraiseLog(pralog));
}
}
/// <summary>
/// 增加
/// </summary>
/// <returns></returns>
public ActionResult AddPraiseLog(int?WeaponID)
{
PraiseLog praiseLog = new PraiseLog();
praiseLog.WeaponID = Convert.ToInt32(WeaponID);
//记录日志
Log(string.Format("查看[PraiseLog]新增页面"));
return(View(praiseLog));
}
/// <summary>
/// 获取 PraiseLog 翻页列表
/// </summary>
/// Create By zhouqi
/// 2015/12/7 17:29:03
/// <param name="dp">翻页类 如果PageSize = 0 则不翻页</param>
/// <param name="searchPraiseLog">PraiseLog 查询实体</param>
/// <returns></returns>
public List <PraiseLog> GetPraiseLogList(ref DataPage dp, PraiseLog searchPraiseLog)
{
DbCommand cmd = DB.GetStoredProcCommand("PraiseLog_GetList");
//翻页参数
DB.AddInParameter(cmd, DataPage.PageSizeField, DbType.Int32, dp.PageSize);
DB.AddInParameter(cmd, DataPage.PageIndexField, DbType.Int32, dp.PageIndex);
DB.AddParameter(cmd, DataPage.RowCountField, DbType.Int64, ParameterDirection.InputOutput, String.Empty, DataRowVersion.Default, dp.RowCount);
DB.AddInParameter(cmd, PraiseLog.WeaponIDField, DbType.Int32, searchPraiseLog.WeaponID);
DB.AddInParameter(cmd, PraiseLog.PraiseIPField, DbType.String, searchPraiseLog.PraiseIP);
List <PraiseLog> praiseLogList = new List <PraiseLog>();
using (IDataReader dr = DB.ExecuteReader(cmd))
{
if (dr.FieldCount > 0)
{
int coPraiseID = dr.GetOrdinal(PraiseLog.PraiseIDField);
int coWeaponID = dr.GetOrdinal(PraiseLog.WeaponIDField);
int coPraiseIP = dr.GetOrdinal(PraiseLog.PraiseIPField);
int coCreateTS = dr.GetOrdinal(PraiseLog.CreateTSField);
int coPraiseNumber = dr.GetOrdinal(PraiseLog.PraiseNumberField);
int coSource = dr.GetOrdinal(PraiseLog.SourceField);
int coAvatarID = dr.GetOrdinal(PraiseLog.AvatarIDField);
int coAreaID = dr.GetOrdinal(PraiseLog.AreaIDField);
int coUserID = dr.GetOrdinal(PraiseLog.UserIDField);
int coAreaName = dr.GetOrdinal(PraiseLog.AreaNameField);
while (dr.Read())
{
PraiseLog praiseLog = new PraiseLog();
praiseLog.PraiseID = dr.IsDBNull(coPraiseID) ? (int)0 : dr.GetInt32(coPraiseID);
praiseLog.WeaponID = dr.IsDBNull(coWeaponID) ? (int)0 : dr.GetInt32(coWeaponID);
praiseLog.PraiseIP = dr.IsDBNull(coPraiseIP) ? string.Empty : dr.GetString(coPraiseIP);
praiseLog.CreateTS = dr.IsDBNull(coCreateTS) ? (DateTime)SqlDateTime.Null : dr.GetDateTime(coCreateTS);
praiseLog.PraiseNumber = dr.IsDBNull(coPraiseNumber) ? (int)0 : dr.GetInt32(coPraiseNumber);
praiseLog.Source = dr.IsDBNull(coSource) ? (int)0 : dr.GetInt32(coSource);
praiseLog.AvatarID = dr.IsDBNull(coAvatarID) ? (long)0 : dr.GetInt64(coAvatarID);
praiseLog.AreaID = dr.IsDBNull(coAreaID) ? (int)0 : dr.GetInt32(coAreaID);
praiseLog.UserID = dr.IsDBNull(coUserID) ? (long)0 : dr.GetInt64(coUserID);
praiseLog.AreaName = dr.IsDBNull(coAreaName) ? string.Empty : dr.GetString(coAreaName);
praiseLogList.Add(praiseLog);
}
}
}
//获取翻页
dp.RowCount = Convert.ToInt64(DB.GetParameterValue(cmd, DataPage.RowCountField));
return(praiseLogList);
}
private PortalResult CreatePraise(int userid, int rid, int num, PraiseType type = PraiseType.Question)
{
var p = new PraiseLog()
{
UserId = userid, RelateId = rid, PraiseType = type
};
_praiseRepository.Insert(p);
return(new PortalResult(true)
{
Num = num
});
}
public int AddPraiseLog(PraiseLog praiseLog)
{
_admin = new WeaponDesignAdminService.WeaponDesignAdminServiceClient();
try
{
int rs = _admin.AddPraiseLog(praiseLog);
_admin.Close();
return(rs);
}
catch (Exception ex)
{
_admin.CloseCatch(ex, "AddPraiseLog 增加赞数失败");
return(0);
}
}
public int AddPraiseLog(PraiseLog praiseLog)
{
_client = new WeaponDesignService.WeaponDesignServiceClient();
try
{
int rs = _client.AddPraiseLog(praiseLog);
_client.Close();
return(rs);
}
catch (Exception ex)
{
_client.CloseCatch(ex, "AddPraiseLog 点赞失败");
return(0);
}
}
private PortalResult CreatePraise(int userid, int rid, int num, PraiseType type = PraiseType.Question)
{
using (var db = new PortalDb())
{
var p = new PraiseLog()
{
UserId = userid, RelateId = rid, PraiseType = type
};
db.Praises.Add(p);
db.SaveChanges();
return(new PortalResult(true)
{
Num = num
});
}
}
public List <PraiseLog> GetPraiseLogList(ref DataPage dp, PraiseLog searchPraiseLog)
{
_admin = new WeaponDesignAdminService.WeaponDesignAdminServiceClient();
List <PraiseLog> lists = new List <PraiseLog>();
try
{
lists = _admin.GetPraiseLogList(ref dp, searchPraiseLog);
_admin.Close();
return(lists);
}
catch (Exception ex)
{
_admin.CloseCatch(ex, "GetPraiseLogList 获取点赞失败");
return(lists);
}
}
///// <summary>
///// 每人每活动一票，可换作品
///// </summary>
///// Create By zhouqi
///// 2015/12/3 17:17:27
///// <param name="praiseLog">PraiseLog 实体</param>
///// <returns></returns>
//public Int32 ChangePraiseLog(PraiseLog praiseLog)
//{
// DbCommand cmd = DB.GetStoredProcCommand("PraiseLog_Change");
// DB.AddParameter(cmd, PraiseLog.WeaponIDoldField, DbType.Int32, ParameterDirection.InputOutput, PraiseLog.WeaponIDoldField, DataRowVersion.Current, praiseLog.WeaponIDold);
// DB.AddInParameter(cmd, PraiseLog.WeaponIDField, DbType.Int32, praiseLog.WeaponID);
// DB.AddInParameter(cmd, PraiseLog.PraiseIPField, DbType.String, praiseLog.PraiseIP);
// DB.AddInParameter(cmd, PraiseLog.PraiseNumberField, DbType.Int32, praiseLog.PraiseNumber);
// DB.AddInParameter(cmd, PraiseLog.SourceField, DbType.Int32, praiseLog.Source);
// DB.AddInParameter(cmd, PraiseLog.AvatarIDField, DbType.Int64, praiseLog.AvatarID);
// DB.AddInParameter(cmd, PraiseLog.AreaIDField, DbType.Int32, praiseLog.AreaID);
// DB.AddInParameter(cmd, PraiseLog.UserIDField, DbType.Int64, praiseLog.UserID);
// //增加返回参数
// DB.AddParameter(cmd, ConstUtil.ReturnValue, DbType.Int32, ParameterDirection.ReturnValue,
// string.Empty, DataRowVersion.Default, (int)ReturnState.UnSuccessful);
// DB.ExecuteNonQuery(cmd);
// Int32 rs = Convert.ToInt32(DB.GetParameterValue(cmd, "WeaponIDold"));
// return rs;
//}
/// <summary>
/// 每人每天一票，只增不减
/// </summary>
/// Create By zhouqi
/// 2015/12/3 17:17:27
/// <param name="praiseLog">PraiseLog 实体</param>
/// <returns></returns>
public Int32 AddPraiseLog(PraiseLog praiseLog)
{
DbCommand cmd = DB.GetStoredProcCommand("PraiseLog_Add");
DB.AddParameter(cmd, PraiseLog.PraiseIDField, DbType.Int32, ParameterDirection.InputOutput, PraiseLog.PraiseIDField, DataRowVersion.Current, praiseLog.PraiseID);
DB.AddInParameter(cmd, PraiseLog.WeaponIDField, DbType.Int32, praiseLog.WeaponID);
DB.AddInParameter(cmd, PraiseLog.PraiseIPField, DbType.String, praiseLog.PraiseIP);
DB.AddInParameter(cmd, PraiseLog.CreateTSField, DbType.DateTime, praiseLog.CreateTS);
DB.AddInParameter(cmd, PraiseLog.PraiseNumberField, DbType.Int32, praiseLog.PraiseNumber);
DB.AddInParameter(cmd, PraiseLog.SourceField, DbType.Int32, praiseLog.Source);
DB.AddInParameter(cmd, PraiseLog.AvatarIDField, DbType.Int64, praiseLog.AvatarID);
DB.AddInParameter(cmd, PraiseLog.AreaIDField, DbType.Int32, praiseLog.AreaID);
DB.AddInParameter(cmd, PraiseLog.UserIDField, DbType.Int64, praiseLog.UserID);
//增加返回参数
DB.AddParameter(cmd, ConstUtil.ReturnValue, DbType.Int32, ParameterDirection.ReturnValue,
string.Empty, DataRowVersion.Default, (int)ReturnState.UnSuccessful);
DB.ExecuteNonQuery(cmd);
Int32 rs = Convert.ToInt32(DB.GetParameterValue(cmd, ConstUtil.ReturnValue));
return(rs);
}
public List <PraiseLog> GetPraiseLogList(ref DataPage dp, PraiseLog searchPraiseLog)
{
return(_dal.GetPraiseLogList(ref dp, searchPraiseLog));
}
public Int32 AddPraiseLog(PraiseLog praiseLog)
{
return(_dal.AddPraiseLog(praiseLog));
}
