/// <summary> /// 更新一条数据 /// </summary> public void Update(BCW.SFC.Model.SfPay model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_SfPay set "); strSql.Append("CID=@CID,"); strSql.Append("usID=@usID,"); strSql.Append("Vote=@Vote,"); strSql.Append("VoteNum=@VoteNum,"); strSql.Append("OverRide=@OverRide,"); strSql.Append("PayCent=@PayCent,"); strSql.Append("PayCents=@PayCents,"); strSql.Append("State=@State,"); strSql.Append("WinCent=@WinCent,"); strSql.Append("AddTime=@AddTime,"); strSql.Append("IsPrize=@IsPrize,"); strSql.Append("IsSpier=@IsSpier,"); strSql.Append("change=@change,"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@CID", SqlDbType.Int, 4), new SqlParameter("@usID", SqlDbType.Int, 4), new SqlParameter("@Vote", SqlDbType.NVarChar), new SqlParameter("@VoteNum", SqlDbType.Int, 4), new SqlParameter("@OverRide", SqlDbType.Int, 4), new SqlParameter("@PayCent", SqlDbType.Int, 4), new SqlParameter("@PayCents", SqlDbType.BigInt, 8), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@WinCent", SqlDbType.BigInt, 8), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@IsPrize", SqlDbType.Int, 4), new SqlParameter("@IsSpier", SqlDbType.Int, 4), new SqlParameter("@change", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.id; parameters[1].Value = model.CID; parameters[2].Value = model.usID; parameters[3].Value = model.Vote; parameters[4].Value = model.VoteNum; parameters[5].Value = model.OverRide; parameters[6].Value = model.PayCent; parameters[7].Value = model.PayCents; parameters[8].Value = model.State; parameters[9].Value = model.WinCent; parameters[10].Value = model.AddTime; parameters[11].Value = model.IsPrize; parameters[12].Value = model.IsSpier; parameters[13].Value = model.change; SqlHelper.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 取得排行记录 /// </summary> /// <param name="p_pageIndex">当前页</param> /// <param name="p_pageSize">分页大小</param> /// <param name="p_recordCount">返回总记录数</param> /// <param name="strWhere">查询条件</param> /// <returns>IList HcPay</returns> public IList <BCW.SFC.Model.SfPay> GetSFPaysTop(int p_pageIndex, int p_pageSize, string strWhere, out int p_recordCount) { IList <BCW.SFC.Model.SfPay> listSFPayTop = new List <BCW.SFC.Model.SfPay>(); // 计算记录数 string countString = "SELECT COUNT(DISTINCT usID) FROM tb_SFPay where " + strWhere + ""; p_recordCount = Convert.ToInt32(SqlHelper.GetSingle(countString)); if (p_recordCount > 50) { p_recordCount = 50; } if (p_recordCount > 0) { int pageCount = BasePage.CalcPageCount(p_recordCount, p_pageSize, ref p_pageIndex); } else { return(listSFPayTop); } // 取出相关记录 string queryString = ""; queryString = "SELECT Top 50 usID,sum(WinCent-PayCents) as WinCents FROM tb_SFPay where " + strWhere + " group by usID Order by sum(WinCent-PayCents) desc"; using (SqlDataReader reader = SqlHelper.ExecuteReader(queryString)) { int stratIndex = (p_pageIndex - 1) * p_pageSize; int endIndex = p_pageIndex * p_pageSize; int k = 0; while (reader.Read()) { if (k >= stratIndex && k < endIndex) { BCW.SFC.Model.SfPay objHcPay = new BCW.SFC.Model.SfPay(); objHcPay.usID = reader.GetInt32(0); objHcPay.WinCent = reader.GetInt64(1); listSFPayTop.Add(objHcPay); } if (k == endIndex) { break; } k++; } } return(listSFPayTop); }
/// <summary> /// 取得每页记录 /// </summary> /// <param name="p_pageIndex">当前页</param> /// <param name="p_pageSize">分页大小</param> /// <param name="p_recordCount">返回总记录数</param> /// <param name="strWhere">查询条件</param> /// <returns>IList SfPay</returns> public IList <BCW.SFC.Model.SfPay> GetSfPays1(int p_pageIndex, int p_pageSize, string strWhere, string strOrder, out int p_recordCount) { IList <BCW.SFC.Model.SfPay> listSfPays = new List <BCW.SFC.Model.SfPay>(); string sTable = "tb_SfPay"; string sPkey = "id"; string sField = "id,CID,usID,Vote,VoteNum,OverRide,PayCent,PayCents,State,WinCent,AddTime,IsPrize,IsSpier,change"; string sCondition = strWhere; string sOrder = strOrder; int iSCounts = 0; using (SqlDataReader reader = SqlHelper.RunProcedureMe(sTable, sPkey, sField, p_pageIndex, p_pageSize, sCondition, sOrder, iSCounts, out p_recordCount)) { //计算总页数 if (p_recordCount > 0) { int pageCount = BasePage.CalcPageCount(p_recordCount, p_pageSize, ref p_pageIndex); } else { return(listSfPays); } while (reader.Read()) { BCW.SFC.Model.SfPay objSfPay = new BCW.SFC.Model.SfPay(); objSfPay.id = reader.GetInt32(0); objSfPay.CID = reader.GetInt32(1); objSfPay.usID = reader.GetInt32(2); objSfPay.Vote = reader.GetString(3); objSfPay.VoteNum = reader.GetInt32(4); objSfPay.OverRide = reader.GetInt32(5); objSfPay.PayCent = reader.GetInt32(6); objSfPay.PayCents = reader.GetInt64(7); objSfPay.State = reader.GetInt32(8); objSfPay.WinCent = reader.GetInt64(9); objSfPay.AddTime = reader.GetDateTime(10); objSfPay.IsPrize = reader.GetInt32(11); objSfPay.IsSpier = reader.GetInt32(12); objSfPay.change = reader.GetString(13); listSfPays.Add(objSfPay); } } return(listSfPays); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(BCW.SFC.Model.SfPay model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_SfPay("); strSql.Append("CID,usID,Vote,VoteNum,OverRide,PayCent,PayCents,State,WinCent,AddTime,IsPrize,IsSpier,change)"); strSql.Append(" values ("); strSql.Append("@CID,@usID,@Vote,@VoteNum,@OverRide,@PayCent,@PayCents,@State,@WinCent,@AddTime,@IsPrize,@IsSpier,@change)"); SqlParameter[] parameters = { new SqlParameter("@CID", SqlDbType.Int, 4), new SqlParameter("@usID", SqlDbType.Int, 4), new SqlParameter("@Vote", SqlDbType.NVarChar), new SqlParameter("@VoteNum", SqlDbType.Int, 4), new SqlParameter("@OverRide", SqlDbType.Int, 4), new SqlParameter("@PayCent", SqlDbType.Int, 4), new SqlParameter("@PayCents", SqlDbType.BigInt, 8), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@WinCent", SqlDbType.BigInt, 8), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@IsPrize", SqlDbType.Int, 4), new SqlParameter("@IsSpier", SqlDbType.Int, 4), new SqlParameter("@change", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.CID; parameters[1].Value = model.usID; parameters[2].Value = model.Vote; parameters[3].Value = model.VoteNum; parameters[4].Value = model.OverRide; parameters[5].Value = model.PayCent; parameters[6].Value = model.PayCents; parameters[7].Value = model.State; parameters[8].Value = model.WinCent; parameters[9].Value = model.AddTime; parameters[10].Value = model.IsPrize; parameters[11].Value = model.IsSpier; parameters[12].Value = model.change; SqlHelper.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public BCW.SFC.Model.SfPay GetSfPay(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,CID,usID,Vote,VoteNum,OverRide,PayCent,PayCents,State,WinCent,AddTime,IsPrize,IsSpier from tb_SfPay "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; BCW.SFC.Model.SfPay model = new BCW.SFC.Model.SfPay(); using (SqlDataReader reader = SqlHelper.ExecuteReader(strSql.ToString(), parameters)) { if (reader.HasRows) { reader.Read(); model.id = reader.GetInt32(0); model.CID = reader.GetInt32(1); model.usID = reader.GetInt32(2); model.Vote = reader.GetString(3); model.VoteNum = reader.GetInt32(4); model.OverRide = reader.GetInt32(5); model.PayCent = reader.GetInt32(6); model.PayCents = reader.GetInt64(7); model.State = reader.GetInt32(8); model.WinCent = reader.GetInt64(9); model.AddTime = reader.GetDateTime(10); model.IsPrize = reader.GetInt32(11); model.IsSpier = reader.GetInt32(12); return(model); } else { return(null); } } }