Ejemplo n.º 1
0
        public static bool AddWord(Model.Book book)
        {
            string sql = "insert into U_Word(U_Word,U_Chinese,U_Pronounce,U_Note) values(@U_Word,@U_Chinese,@U_Pronounce,@U_Note)";

            /*构建sql参数*/
            SqlParameter[] parm = new SqlParameter[] {
                new SqlParameter("@U_Word", SqlDbType.VarChar),
                new SqlParameter("@U_Chinese", SqlDbType.VarChar),
                new SqlParameter("@U_Pronounce", SqlDbType.VarChar),
                new SqlParameter("@U_Note", SqlDbType.VarChar)
            };
            /*给参数赋值*/
            parm[0].Value = book.bookName;
            parm[1].Value = book.Name;
            parm[2].Value = book.move;
            parm[3].Value = book.address;
            /*执行sql进行添加*/
            return((DBHelp.ExecuteNonQuery(sql, parm) > 0) ? true : false);
        }
Ejemplo n.º 2
0
        public static Model.Book getSomeFile(string barcode, string Sqlname)
        {
            /*构建查询sql*/
            string        sql      = "select * from  " + Sqlname + " where U_id='" + barcode + "'";
            SqlDataReader DataRead = DBHelp.ExecuteReader(sql, null);

            Model.Book book = new Model.Book();
            /*如果查询存在记录,就包装到对象中返回*/
            if (DataRead.Read())
            {
                book.barcode     = Convert.ToInt32(DataRead["U_Id"]);
                book.bookName    = DataRead["U_Name"].ToString();
                book.bookType    = Convert.ToInt32(DataRead["U_PsdType"]);
                book.note        = DataRead["U_Note"].ToString();
                book.bookPhoto   = (byte[])DataRead["U_Image"];
                book.publishDate = Convert.ToDateTime(DataRead["U_LoginTime"].ToString());
            }
            DataRead.Close();
            return(book);
        }
Ejemplo n.º 3
0
        public static bool AddFile(Model.Book book, string Sqlname)
        {
            string sql = "insert into " + Sqlname + "(U_Name,U_PsdType,U_Note,U_Image,U_LoginTime) values(@U_Name,@U_PsdType,@U_Note,@U_Image,@U_LoginTime)";

            /*构建sql参数*/
            SqlParameter[] parm = new SqlParameter[] {
                new SqlParameter("@U_Name", SqlDbType.VarChar),
                new SqlParameter("@U_PsdType", SqlDbType.Int),
                new SqlParameter("@U_Note", SqlDbType.VarChar),
                new SqlParameter("@U_Image", SqlDbType.Image),
                new SqlParameter("@U_LoginTime", SqlDbType.DateTime)
            };
            /*给参数赋值*/
            parm[0].Value = book.bookName;
            parm[1].Value = book.bookType;
            parm[2].Value = book.note;
            parm[3].Value = book.bookPhoto;
            parm[4].Value = book.publishDate;
            /*执行sql进行添加*/
            return((DBHelp.ExecuteNonQuery(sql, parm) > 0) ? true : false);
        }
Ejemplo n.º 4
0
        /*更新图书实现*/
        public static bool EditWord(Model.Book book)
        {
            string sql = "update U_Word set U_Word=@U_Word,U_Chinese=@U_Chinese,U_Pronounce=@U_Pronounce,U_Note=@U_Note where U_Id=@U_Id";

            /*构建sql参数信息*/
            SqlParameter[] parm = new SqlParameter[] {
                new SqlParameter("@U_Id", SqlDbType.Int),
                new SqlParameter("@U_Word", SqlDbType.VarChar),
                new SqlParameter("@U_Chinese", SqlDbType.Int),
                new SqlParameter("@U_Pronounce", SqlDbType.VarChar),
                new SqlParameter("@U_Note", SqlDbType.Image)
            };
            /*为参数赋值*/
            parm[0].Value = book.barcode;
            parm[1].Value = book.bookName;
            parm[2].Value = book.Name;
            parm[3].Value = book.move;
            parm[4].Value = book.address;

            /*执行更新*/
            return((DBHelp.ExecuteNonQuery(sql, parm) > 0) ? true : false);
        }
Ejemplo n.º 5
0
        /*更新图书实现*/
        public static bool EditFile(Model.Book book, string Sqlname)
        {
            string sql = "update " + Sqlname + " set U_Name=@U_Name,U_PsdType=@U_PsdType,U_Note=@U_Note,U_Image=@U_Image,U_LoginTime=@U_LoginTime where U_Id=@U_Id";

            /*构建sql参数信息*/
            SqlParameter[] parm = new SqlParameter[] {
                new SqlParameter("@U_Id", SqlDbType.Int),
                new SqlParameter("@U_Name", SqlDbType.VarChar),
                new SqlParameter("@U_PsdType", SqlDbType.Int),
                new SqlParameter("@U_Note", SqlDbType.VarChar),
                new SqlParameter("@U_Image", SqlDbType.Image),
                new SqlParameter("@U_LoginTime", SqlDbType.DateTime)
            };
            /*为参数赋值*/
            parm[0].Value = book.barcode;
            parm[1].Value = book.bookName;
            parm[2].Value = book.bookType;
            parm[3].Value = book.note;
            parm[4].Value = book.bookPhoto;
            parm[5].Value = book.publishDate;
            /*执行更新*/
            return((DBHelp.ExecuteNonQuery(sql, parm) > 0) ? true : false);
        }
Ejemplo n.º 6
0
        public static List <Model.Book> GetBImage(int pagenum, int pageindex, out int pageCount)
        {
            List <Model.Book> books = new List <Model.Book>();

            SqlParameter[] P =
            {
                new SqlParameter("@pageIndex",      pageindex),
                new SqlParameter("@pageCount",      pagenum),
                new SqlParameter("@pageTotalCount", SqlDbType.Int),
            };
            P[2].Direction = ParameterDirection.Output;
            DataSet ds = DbHepler.GetDataSet("WY", System.Data.CommandType.StoredProcedure, P);

            pageCount = Convert.ToInt32(P[2].Value);
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                Model.Book book = new Model.Book();
                book.Author        = dr["Author"].ToString();
                book.AuthorDesc    = dr["AuthorDesc"].ToString();
                book.CategoryID    = (int)dr["CategoryID"];
                book.Clicks        = (int)dr["Clicks"];
                book.ContentDesc   = dr["ContentDesc"].ToString();
                book.EditorComment = dr["EditorComment"].ToString();
                book.ID            = dr["ID"].ToString();
                book.ISBN          = dr["ISBN"].ToString();
                book.Price         = (decimal)dr["Price"];
                book.PublishDate   = (DateTime)dr["PublishDate"];
                book.PublisherID   = (int)dr["PublisherID"];
                book.State         = (int)dr["State"];
                book.Title         = dr["Title"].ToString();
                book.TOC           = dr["TOC"].ToString();
                book.WordsCount    = (int)dr["WordsCount"];
                books.Add(book);
            }
            return(books);
        }
        //更新一本书

        //0:更新失败
        //1:更新成功
        //2:连接出错,更新失败
        //3:图片为空,更新失败
        //4:ID为空,更新失败
        //
        public int update(Model.Book book)
        {
            string id        = book.Id;
            string name      = book.Name;
            string author    = book.Author;
            string publisher = book.Publisher;


            string pubtime = book.Pubtime;
            string pritime = book.Pritime;

            string edition    = book.Edition;
            string impression = book.Impression;

            string pages = book.Pages;
            string words = book.Words;

            string format    = book.Format;
            string paper     = book.Paper;
            string packaging = book.Packaging;

            string isbn = book.Isbn;

            byte[] picture   = book.Picture;
            string price     = book.Price;
            string sort      = book.Sort;
            string inventory = book.Inventory;


            //判断连接
            if (DbHelper.checkConnection() == false)
            {
                return(2);
            }

            if (picture == null)
            {
                return(3);
            }

            if (id == null || id == "")
            {
                return(4);
            }

            string cmdText = "update book set b_name='" + name + "',b_author='" + author + "',b_publisher='" + publisher + "',b_pubtime='" + pubtime + "',b_pritime='" + pritime + "',b_edition='" + edition + "',b_impression='" + impression + "',b_pages='" + pages + "',b_words='" + words + "',b_format='" + format + "',b_paper='" + paper + "',b_packaging='" + packaging + "',b_isbn='" + isbn + "',b_picture=@picture,b_price='" + price + "',b_sort='" + sort + "',b_inventory='" + inventory + "' where b_id='" + id + "'";

            SqlParameter[] parameters = { new SqlParameter("@picture", SqlDbType.Binary) };
            parameters[0].Value = picture;

            int i = DbHelper.ExecuteNonQuery(cmdText, parameters);

            if (i == 1)
            {
                return(1);
            }
            else
            {
                Console.WriteLine("更新失败");
                return(0);
            }
        }
Ejemplo n.º 8
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Model.Book GetModel(int Id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 Id,Title,Author,PublisherId,PublishDate,ISBN,WordsCount,UnitPrice,ContentDescription,AurhorDescription,EditorComment,TOC,CategoryId,Clicks from Books ");
            strSql.Append(" where Id=@Id ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@Id", SqlDbType.Int, 4)
            };
            parameters[0].Value = Id;

            Model.Book model = new Model.Book();
            DataSet    ds    = DbHelperSQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
                {
                    model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
                }
                model.Title  = ds.Tables[0].Rows[0]["Title"].ToString();
                model.Author = ds.Tables[0].Rows[0]["Author"].ToString();
                if (ds.Tables[0].Rows[0]["PublisherId"].ToString() != "")
                {
                    //  model.PublisherId = int.Parse(ds.Tables[0].Rows[0]["PublisherId"].ToString());
                    int PublisherId = int.Parse(ds.Tables[0].Rows[0]["PublisherId"].ToString());
                    model.Publisher = publisherServices.GetModel(PublisherId);
                }
                if (ds.Tables[0].Rows[0]["PublishDate"].ToString() != "")
                {
                    model.PublishDate = DateTime.Parse(ds.Tables[0].Rows[0]["PublishDate"].ToString());
                }
                model.ISBN = ds.Tables[0].Rows[0]["ISBN"].ToString();
                if (ds.Tables[0].Rows[0]["WordsCount"].ToString() != "")
                {
                    model.WordsCount = int.Parse(ds.Tables[0].Rows[0]["WordsCount"].ToString());
                }
                if (ds.Tables[0].Rows[0]["UnitPrice"].ToString() != "")
                {
                    model.UnitPrice = decimal.Parse(ds.Tables[0].Rows[0]["UnitPrice"].ToString());
                }
                model.ContentDescription = ds.Tables[0].Rows[0]["ContentDescription"].ToString();
                model.AurhorDescription  = ds.Tables[0].Rows[0]["AurhorDescription"].ToString();
                model.EditorComment      = ds.Tables[0].Rows[0]["EditorComment"].ToString();
                model.TOC = ds.Tables[0].Rows[0]["TOC"].ToString();
                if (ds.Tables[0].Rows[0]["CategoryId"].ToString() != "")
                {
                    int CategoryId = int.Parse(ds.Tables[0].Rows[0]["CategoryId"].ToString());
                    model.Category = categoryServices.GetModel(CategoryId);
                }
                if (ds.Tables[0].Rows[0]["Clicks"].ToString() != "")
                {
                    model.Clicks = int.Parse(ds.Tables[0].Rows[0]["Clicks"].ToString());
                }
                return(model);
            }
            else
            {
                return(null);
            }
        }