/// <summary> /// 取得每页记录 /// </summary> /// <param name="p_pageIndex">当前页</param> /// <param name="p_pageSize">分页大小</param> /// <param name="p_recordCount">返回总记录数</param> /// <param name="strWhere">查询条件</param> /// <returns>IList DrawBox</returns> public IList <BCW.Draw.Model.DrawBox> GetDrawBoxs(int p_pageIndex, int p_pageSize, string strWhere, string strOrder, out int p_recordCount) { IList <BCW.Draw.Model.DrawBox> listDrawBoxs = new List <BCW.Draw.Model.DrawBox>(); string sTable = "tb_DrawBox"; string sPkey = "id"; string sField = "ID,GoodsName,Explain,GoodsImg,GoodsType,GoodsValue,GoodsNum,AddTime,OverTime,ReceiveTime,GoodsCounts,Statue,beizhu,rank,points,AllNum,lun"; 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(listDrawBoxs); } while (reader.Read()) { BCW.Draw.Model.DrawBox objDrawBox = new BCW.Draw.Model.DrawBox(); objDrawBox.ID = reader.GetInt32(0); objDrawBox.GoodsName = reader.GetString(1); objDrawBox.Explain = reader.GetString(2); objDrawBox.GoodsImg = reader.GetString(3); objDrawBox.GoodsType = reader.GetInt32(4); objDrawBox.GoodsValue = reader.GetInt32(5); objDrawBox.GoodsNum = reader.GetInt32(6); objDrawBox.AddTime = reader.GetDateTime(7); objDrawBox.OverTime = reader.GetDateTime(8); objDrawBox.ReceiveTime = reader.GetDateTime(9); objDrawBox.GoodsCounts = reader.GetInt32(10); objDrawBox.Statue = reader.GetInt32(11); objDrawBox.beizhu = reader.GetString(12); objDrawBox.rank = reader.GetInt32(13); objDrawBox.points = reader.GetInt32(14); objDrawBox.AllNum = reader.GetInt32(15); objDrawBox.AllNum = reader.GetInt32(16); listDrawBoxs.Add(objDrawBox); } } return(listDrawBoxs); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(BCW.Draw.Model.DrawBox model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_DrawBox("); strSql.Append("GoodsName,Explain,GoodsImg,GoodsType,GoodsValue,GoodsNum,AddTime,OverTime,ReceiveTime,GoodsCounts,Statue,beizhu,Rank,Points,AllNum,lun)"); strSql.Append(" values ("); strSql.Append("@GoodsName,@Explain,@GoodsImg,@GoodsType,@GoodsValue,@GoodsNum,@AddTime,@OverTime,@ReceiveTime,@GoodsCounts,@Statue,@beizhu,@Rank,@Points,@AllNum,@lun)"); SqlParameter[] parameters = { new SqlParameter("@GoodsName", SqlDbType.NVarChar, 50), new SqlParameter("@Explain", SqlDbType.NVarChar), new SqlParameter("@GoodsImg", SqlDbType.NVarChar), new SqlParameter("@GoodsType", SqlDbType.Int, 4), new SqlParameter("@GoodsValue", SqlDbType.Int, 4), new SqlParameter("@GoodsNum", SqlDbType.Int, 4), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@OverTime", SqlDbType.DateTime), new SqlParameter("@ReceiveTime", SqlDbType.DateTime), new SqlParameter("@GoodsCounts", SqlDbType.Int, 4), new SqlParameter("@Statue", SqlDbType.Int, 4), new SqlParameter("@beizhu", SqlDbType.NVarChar, 50), new SqlParameter("@rank", SqlDbType.Int, 4), new SqlParameter("@Points", SqlDbType.Int, 4), new SqlParameter("@AllNum", SqlDbType.Int, 4), new SqlParameter("@lun", SqlDbType.Int, 4) }; parameters[0].Value = model.GoodsName; parameters[1].Value = model.Explain; parameters[2].Value = model.GoodsImg; parameters[3].Value = model.GoodsType; parameters[4].Value = model.GoodsValue; parameters[5].Value = model.GoodsNum; parameters[6].Value = model.AddTime; parameters[7].Value = model.OverTime; parameters[8].Value = model.ReceiveTime; parameters[9].Value = model.GoodsCounts; parameters[10].Value = model.Statue; parameters[11].Value = model.beizhu; parameters[12].Value = model.rank; parameters[13].Value = model.points; parameters[14].Value = model.AllNum; parameters[15].Value = model.lun; SqlHelper.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public BCW.Draw.Model.DrawBox GetDrawBoxbyC(int GoodsCounts) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,GoodsName,Explain,GoodsImg,GoodsType,GoodsValue,GoodsNum,AddTime,OverTime,ReceiveTime,GoodsCounts,Statue,beizhu,rank,points,AllNum,lun from tb_DrawBox "); strSql.Append(" where GoodsCounts=@GoodsCounts "); SqlParameter[] parameters = { new SqlParameter("@GoodsCounts", SqlDbType.Int, 4) }; parameters[0].Value = GoodsCounts; BCW.Draw.Model.DrawBox model = new BCW.Draw.Model.DrawBox(); using (SqlDataReader reader = SqlHelper.ExecuteReader(strSql.ToString(), parameters)) { if (reader.HasRows) { reader.Read(); model.ID = reader.GetInt32(0); model.GoodsName = reader.GetString(1); model.Explain = reader.GetString(2); model.GoodsImg = reader.GetString(3); model.GoodsType = reader.GetInt32(4); model.GoodsValue = reader.GetInt32(5); model.GoodsNum = reader.GetInt32(6); model.AddTime = reader.GetDateTime(7); model.OverTime = reader.GetDateTime(8); model.ReceiveTime = reader.GetDateTime(9); model.GoodsCounts = reader.GetInt32(10); model.Statue = reader.GetInt32(11); model.beizhu = reader.GetString(12); model.rank = reader.GetInt32(13); model.points = reader.GetInt32(14); model.AllNum = reader.GetInt32(15); model.lun = reader.GetInt32(16); return(model); } else { return(null); } } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(BCW.Draw.Model.DrawBox model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_DrawBox set "); strSql.Append("GoodsName=@GoodsName,"); strSql.Append("Explain=@Explain,"); strSql.Append("GoodsImg=@GoodsImg,"); strSql.Append("GoodsType=@GoodsType,"); strSql.Append("GoodsValue=@GoodsValue,"); strSql.Append("GoodsNum=@GoodsNum,"); strSql.Append("AddTime=@AddTime,"); strSql.Append("OverTime=@OverTime,"); strSql.Append("ReceiveTime=@ReceiveTime,"); strSql.Append("GoodsCounts=@GoodsCounts,"); strSql.Append("Statue=@Statue,"); strSql.Append("beizhu=@beizhu,"); strSql.Append("rank=@rank,"); strSql.Append("points=@points, "); strSql.Append("AllNum=@AllNum, "); strSql.Append("lun=@lun "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@GoodsName", SqlDbType.NVarChar, 50), new SqlParameter("@Explain", SqlDbType.NVarChar), new SqlParameter("@GoodsImg", SqlDbType.NVarChar), new SqlParameter("@GoodsType", SqlDbType.Int, 4), new SqlParameter("@GoodsValue", SqlDbType.Int, 4), new SqlParameter("@GoodsNum", SqlDbType.Int, 4), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@OverTime", SqlDbType.DateTime), new SqlParameter("@ReceiveTime", SqlDbType.DateTime), new SqlParameter("@GoodsCounts", SqlDbType.Int, 4), new SqlParameter("@Statue", SqlDbType.Int, 4), new SqlParameter("@beizhu", SqlDbType.NVarChar, 50), new SqlParameter("@rank", SqlDbType.Int, 4), new SqlParameter("@points", SqlDbType.Int, 4), new SqlParameter("@AllNum", SqlDbType.Int, 4), new SqlParameter("@lun", SqlDbType.Int, 4) }; parameters[0].Value = model.ID; parameters[1].Value = model.GoodsName; parameters[2].Value = model.Explain; parameters[3].Value = model.GoodsImg; parameters[4].Value = model.GoodsType; parameters[5].Value = model.GoodsValue; parameters[6].Value = model.GoodsNum; parameters[7].Value = model.AddTime; parameters[8].Value = model.OverTime; parameters[9].Value = model.ReceiveTime; parameters[10].Value = model.GoodsCounts; parameters[11].Value = model.Statue; parameters[12].Value = model.beizhu; parameters[13].Value = model.rank; parameters[14].Value = model.points; parameters[15].Value = model.AllNum; parameters[16].Value = model.lun; SqlHelper.ExecuteSql(strSql.ToString(), parameters); }