protected void Vote(int voteID)
{
string content = "ok";
if ((ShopConfig.ReadConfigInfo().AllowAnonymousVote == 0) && (base.UserID == 0))
{
content = "»¹Î´µÇ¼";
}
else
{
string str2 = CookiesHelper.ReadCookieValue("VoteCookies" + voteID.ToString());
if ((ShopConfig.ReadConfigInfo().VoteRestrictTime > 0) && (str2 != string.Empty))
{
content = "Ç벻ҪƵ·±Ìá½»";
}
else
{
VoteRecordInfo voteRecord = new VoteRecordInfo();
voteRecord.VoteID = voteID;
voteRecord.ItemID = StringHelper.AddSafe(RequestHelper.GetQueryString <string>("ItemID"));
voteRecord.AddDate = RequestHelper.DateNow;
voteRecord.UserIP = ClientHelper.IP;
voteRecord.UserID = base.UserID;
voteRecord.UserName = base.UserName;
VoteRecordBLL.AddVoteRecord(voteRecord);
if (ShopConfig.ReadConfigInfo().VoteRestrictTime > 0)
{
CookiesHelper.AddCookie("VoteCookies" + voteID.ToString(), "VoteCookies" + voteID.ToString(), ShopConfig.ReadConfigInfo().VoteRestrictTime, TimeType.Second);
}
}
}
ResponseHelper.Write(content);
ResponseHelper.End();
}
/// <summary>
/// 投票
/// </summary>
/// <param name="voteID"></param>
protected void Vote(int voteID)
{
string result = "ok";
if (ShopConfig.ReadConfigInfo().AllowAnonymousVote == (int)BoolType.False && base.UserID == 0)
{
result = "还未登录";
}
else
{
string voteCookies = CookiesHelper.ReadCookieValue("VoteCookies" + voteID.ToString());
if (ShopConfig.ReadConfigInfo().VoteRestrictTime > 0 && voteCookies != string.Empty)
{
result = "请不要频繁提交";
}
else
{
VoteRecordInfo voteRecord = new VoteRecordInfo();
voteRecord.VoteID = voteID;
voteRecord.ItemID = StringHelper.AddSafe(RequestHelper.GetQueryString <string>("ItemID"));
voteRecord.AddDate = RequestHelper.DateNow;
voteRecord.UserIP = ClientHelper.IP;
voteRecord.UserID = base.UserID;
voteRecord.UserName = base.UserName;
VoteRecordBLL.AddVoteRecord(voteRecord);
if (ShopConfig.ReadConfigInfo().VoteRestrictTime > 0)
{
CookiesHelper.AddCookie("VoteCookies" + voteID.ToString(), "VoteCookies" + voteID.ToString(), ShopConfig.ReadConfigInfo().VoteRestrictTime, TimeType.Second);
}
}
}
ResponseHelper.Write(result);
ResponseHelper.End();
}
/// <summary>
///
/// </summary>
/// <param name="voteRecord"></param>
public VoteRecordInfo ReadVoteHistoryRecord(int voteID, string ip, string itemID)
{
SqlParameter[] parameters =
{
new SqlParameter("@voteID", SqlDbType.NVarChar),
new SqlParameter("@ip", SqlDbType.NVarChar),
new SqlParameter("@itemID", SqlDbType.NVarChar)
};
parameters[0].Value = voteID;
parameters[1].Value = ip;
parameters[2].Value = itemID;
VoteRecordInfo voteRecord = new VoteRecordInfo();
using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadVoteHistoryRecord", parameters))
{
if (dr.Read())
{
voteRecord.ID = dr.GetInt32(0);
voteRecord.VoteID = dr[1].ToString();
voteRecord.ItemID = dr[2].ToString();
voteRecord.UserIP = dr[3].ToString();
voteRecord.AddDate = dr.GetDateTime(4);
voteRecord.UserID = dr.GetInt32(5);
voteRecord.UserName = dr[6].ToString();
}
}
return(voteRecord);
}
/// <summary>
/// 增加一条投票记录数据
/// </summary>
/// <param name="voteRecord">投票记录模型变量</param>
public int AddVoteRecord(VoteRecordInfo entity)
{
using (var conn = new SqlConnection(connectString))
{
string sql = @"INSERT INTO [VoteRecord]([VoteID],[ItemID],[UserIP],[AddDate],[UserID],[UserName]) VALUES(@VoteID,@ItemID,@UserIP,@AddDate,@UserID,@UserName);
select SCOPE_IDENTITY()";
return(conn.Query <int>(sql, entity).Single());
}
}
public int AddVoteRecord(VoteRecordInfo voteRecord)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@voteID", SqlDbType.Int), new SqlParameter("@itemID", SqlDbType.NVarChar), new SqlParameter("@userIP", SqlDbType.NVarChar), new SqlParameter("@addDate", SqlDbType.DateTime), new SqlParameter("@userID", SqlDbType.Int), new SqlParameter("@userName", SqlDbType.NVarChar) };
pt[0].Value = voteRecord.VoteID;
pt[1].Value = voteRecord.ItemID;
pt[2].Value = voteRecord.UserIP;
pt[3].Value = voteRecord.AddDate;
pt[4].Value = voteRecord.UserID;
pt[5].Value = voteRecord.UserName;
return(Convert.ToInt32(ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "AddVoteRecord", pt)));
}
public void PrepareVoteRecordModel(SqlDataReader dr, List <VoteRecordInfo> voteRecordList)
{
while (dr.Read())
{
VoteRecordInfo item = new VoteRecordInfo();
item.ID = dr.GetInt32(0);
item.VoteID = dr.GetInt32(1);
item.ItemID = dr[2].ToString();
item.UserIP = dr[3].ToString();
item.AddDate = dr.GetDateTime(4);
item.UserID = dr.GetInt32(5);
item.UserName = dr[6].ToString();
voteRecordList.Add(item);
}
}
public VoteRecordInfo ReadVoteRecord(int id)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@id", SqlDbType.NVarChar) };
pt[0].Value = id;
VoteRecordInfo info = new VoteRecordInfo();
using (SqlDataReader reader = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadVoteRecord", pt))
{
if (reader.Read())
{
info.ID = reader.GetInt32(0);
info.VoteID = reader.GetInt32(1);
info.ItemID = reader[2].ToString();
info.UserIP = reader[3].ToString();
info.AddDate = reader.GetDateTime(4);
info.UserID = reader.GetInt32(5);
info.UserName = reader[6].ToString();
}
}
return(info);
}
/// <summary>
/// 增加一条投票记录数据
/// </summary>
/// <param name="voteRecord">投票记录模型变量</param>
public static int AddVoteRecord(VoteRecordInfo voteRecord)
{
voteRecord.ID = dal.AddVoteRecord(voteRecord);
VoteItemBLL.ChangeVoteItemCount(voteRecord.ItemID, ChangeAction.Plus);
return(voteRecord.ID);
}
