/// <summary> /// 更新一条数据 /// </summary> public bool Update(BCW.HP3.Model.HP3BuySY model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_HP3BuySY set "); strSql.Append("BuyID=@BuyID,"); strSql.Append("BuyDate=@BuyDate,"); strSql.Append("BuyType=@BuyType,"); strSql.Append("BuyNum=@BuyNum,"); strSql.Append("BuyMoney=@BuyMoney"); strSql.Append("BuyZhu=@BuyZhu"); strSql.Append("BuyTime=@BuyTime"); strSql.Append("Odds=@Odds"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@BuyID", SqlDbType.Int, 4), new SqlParameter("@BuyDate", SqlDbType.NChar, 10), new SqlParameter("@BuyType", SqlDbType.Int, 4), new SqlParameter("@BuyNum", SqlDbType.NVarChar, -1), new SqlParameter("@BuyMoney", SqlDbType.BigInt, 8), new SqlParameter("@BuyZhu", SqlDbType.Int, 4), new SqlParameter("@BuyTime", SqlDbType.DateTime), new SqlParameter("@Odds", SqlDbType.Decimal, 9), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.BuyID; parameters[1].Value = model.BuyDate; parameters[2].Value = model.BuyType; parameters[3].Value = model.BuyNum; parameters[4].Value = model.BuyMoney; parameters[5].Value = model.BuyZhu; parameters[6].Value = model.BuyTime; parameters[7].Value = model.Odds; parameters[8].Value = model.ID; int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public BCW.HP3.Model.HP3BuySY DataRowToModel(DataRow row) { BCW.HP3.Model.HP3BuySY model = new BCW.HP3.Model.HP3BuySY(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["BuyID"] != null && row["BuyID"].ToString() != "") { model.BuyID = int.Parse(row["BuyID"].ToString()); } if (row["BuyDate"] != null) { model.BuyDate = row["BuyDate"].ToString(); } if (row["BuyType"] != null && row["BuyType"].ToString() != "") { model.BuyType = int.Parse(row["BuyType"].ToString()); } if (row["BuyNum"] != null) { model.BuyNum = row["BuyNum"].ToString(); } if (row["BuyMoney"] != null && row["BuyMoney"].ToString() != "") { model.BuyMoney = long.Parse(row["BuyMoney"].ToString()); } if (row["BuyZhu"] != null && row["BuyZhu"].ToString() != "") { model.BuyZhu = int.Parse(row["BuyZhu"].ToString()); } if (row["BuyTime"] != null && row["BuyTime"].ToString() != "") { model.BuyTime = DateTime.Parse(row["BuyTime"].ToString()); } } return(model); }
//增加一条HP3购彩记录 public int Add(BCW.HP3.Model.HP3BuySY model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_HP3BuySY("); strSql.Append("BuyID,BuyDate,BuyType,BuyNum,BuyMoney,BuyZhu,BuyTime,Odds)"); strSql.Append("values("); strSql.Append("@BuyID,@BuyDate,@BuyType,@BuyNum,@BuyMoney,@BuyZhu,@BuyTime,@Odds)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@BuyID", SqlDbType.Int, 4), new SqlParameter("@BuyDate", SqlDbType.NChar, 10), new SqlParameter("@BuyType", SqlDbType.Int, 4), new SqlParameter("@BuyNum", SqlDbType.NVarChar, -1), new SqlParameter("@BuyMoney", SqlDbType.BigInt, 8), new SqlParameter("@BuyZhu", SqlDbType.Int, 4), new SqlParameter("@BuyTime", SqlDbType.DateTime), new SqlParameter("@Odds", SqlDbType.Decimal, 9) }; parameters[0].Value = model.BuyID; parameters[1].Value = model.BuyDate; parameters[2].Value = model.BuyType; parameters[3].Value = model.BuyNum; parameters[4].Value = model.BuyMoney; parameters[5].Value = model.BuyZhu; parameters[6].Value = model.BuyTime; parameters[7].Value = model.Odds; object obj = SqlHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 取得每页记录 /// </summary> /// <param name="p_pageIndex">当前页</param> /// <param name="p_pageSize">分页大小</param> /// <param name="p_recordCount">返回总记录数</param> /// <param name="strWhere">查询条件</param> /// <returns>IList Brag</returns> public IList <BCW.HP3.Model.HP3BuySY> GetHP3ListByPage(int p_pageIndex, int p_pageSize, string strWhere, out int p_recordCount) { IList <BCW.HP3.Model.HP3BuySY> model = new List <BCW.HP3.Model.HP3BuySY>(); string sTable = "tb_HP3BuySY"; string sPkey = "id"; string sField = "ID,BuyID,BuyDate,BuyType,BuyNum,BuyMoney,BuyZhu,BuyTime"; string sCondition = strWhere; string sOrder = "ID Desc"; 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(model); } while (reader.Read()) { BCW.HP3.Model.HP3BuySY objHP3 = new BCW.HP3.Model.HP3BuySY(); objHP3.ID = reader.GetInt32(0); objHP3.BuyID = reader.GetInt32(1); objHP3.BuyDate = reader.GetString(2); objHP3.BuyType = reader.GetInt32(3); objHP3.BuyNum = reader.GetString(4); objHP3.BuyMoney = reader.GetInt64(5); objHP3.BuyZhu = reader.GetInt32(6); objHP3.BuyTime = reader.GetDateTime(7); model.Add(objHP3); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public BCW.HP3.Model.HP3BuySY GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,BuyID,BuyDate,BuyType,BuyNum,BuyMoney,BuyZhu,BuyTime from tb_HP3BuySY "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; BCW.HP3.Model.HP3BuySY model = new BCW.HP3.Model.HP3BuySY(); DataSet ds = SqlHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }