Exemplo n.º 1
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(TSIMS.Model.v_student_textbook_info model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update v_student_textbook_info set ");
            strSql.Append("course_name=@course_name,");
            strSql.Append("course_type=@course_type,");
            strSql.Append("user_name=@user_name,");
            strSql.Append("need_book=@need_book,");
            strSql.Append("isbn=@isbn,");
            strSql.Append("book_name=@book_name,");
            strSql.Append("price=@price,");
            strSql.Append("author=@author,");
            strSql.Append("publisher=@publisher,");
            strSql.Append("edition=@edition,");
            strSql.Append("remark=@remark,");
            strSql.Append("user_num=@user_num,");
            strSql.Append("id=@id");
            strSql.Append(" where ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@course_name", MySqlDbType.VarChar, 100),
                new MySqlParameter("@course_type", MySqlDbType.Int32,    11),
                new MySqlParameter("@user_name",   MySqlDbType.VarChar, 100),
                new MySqlParameter("@need_book",   MySqlDbType.Int32,    11),
                new MySqlParameter("@isbn",        MySqlDbType.VarChar,  50),
                new MySqlParameter("@book_name",   MySqlDbType.VarChar, 100),
                new MySqlParameter("@price",       MySqlDbType.Decimal,  10),
                new MySqlParameter("@author",      MySqlDbType.VarChar, 100),
                new MySqlParameter("@publisher",   MySqlDbType.VarChar, 100),
                new MySqlParameter("@edition",     MySqlDbType.VarChar, 100),
                new MySqlParameter("@remark",      MySqlDbType.VarChar, 100),
                new MySqlParameter("@user_num",    MySqlDbType.VarChar,  50),
                new MySqlParameter("@id",          MySqlDbType.Int32, 11)
            };
            parameters[0].Value  = model.course_name;
            parameters[1].Value  = model.course_type;
            parameters[2].Value  = model.user_name;
            parameters[3].Value  = model.need_book;
            parameters[4].Value  = model.isbn;
            parameters[5].Value  = model.book_name;
            parameters[6].Value  = model.price;
            parameters[7].Value  = model.author;
            parameters[8].Value  = model.publisher;
            parameters[9].Value  = model.edition;
            parameters[10].Value = model.remark;
            parameters[11].Value = model.user_num;
            parameters[12].Value = model.id;

            int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Exemplo n.º 2
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public TSIMS.Model.v_student_textbook_info DataRowToModel(DataRow row)
 {
     TSIMS.Model.v_student_textbook_info model = new TSIMS.Model.v_student_textbook_info();
     if (row != null)
     {
         if (row["course_name"] != null)
         {
             model.course_name = row["course_name"].ToString();
         }
         if (row["course_type"] != null && row["course_type"].ToString() != "")
         {
             model.course_type = int.Parse(row["course_type"].ToString());
         }
         if (row["user_name"] != null)
         {
             model.user_name = row["user_name"].ToString();
         }
         if (row["need_book"] != null && row["need_book"].ToString() != "")
         {
             model.need_book = int.Parse(row["need_book"].ToString());
         }
         if (row["isbn"] != null)
         {
             model.isbn = row["isbn"].ToString();
         }
         if (row["book_name"] != null)
         {
             model.book_name = row["book_name"].ToString();
         }
         if (row["price"] != null && row["price"].ToString() != "")
         {
             model.price = decimal.Parse(row["price"].ToString());
         }
         if (row["author"] != null)
         {
             model.author = row["author"].ToString();
         }
         if (row["publisher"] != null)
         {
             model.publisher = row["publisher"].ToString();
         }
         if (row["edition"] != null)
         {
             model.edition = row["edition"].ToString();
         }
         if (row["remark"] != null)
         {
             model.remark = row["remark"].ToString();
         }
         if (row["user_num"] != null)
         {
             model.user_num = row["user_num"].ToString();
         }
         if (row["id"] != null && row["id"].ToString() != "")
         {
             model.id = int.Parse(row["id"].ToString());
         }
     }
     return(model);
 }
Exemplo n.º 3
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(TSIMS.Model.v_student_textbook_info model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into v_student_textbook_info(");
            strSql.Append("course_name,course_type,user_name,need_book,isbn,book_name,price,author,publisher,edition,remark,user_num,id)");
            strSql.Append(" values (");
            strSql.Append("@course_name,@course_type,@user_name,@need_book,@isbn,@book_name,@price,@author,@publisher,@edition,@remark,@user_num,@id)");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@course_name", MySqlDbType.VarChar, 100),
                new MySqlParameter("@course_type", MySqlDbType.Int32,    11),
                new MySqlParameter("@user_name",   MySqlDbType.VarChar, 100),
                new MySqlParameter("@need_book",   MySqlDbType.Int32,    11),
                new MySqlParameter("@isbn",        MySqlDbType.VarChar,  50),
                new MySqlParameter("@book_name",   MySqlDbType.VarChar, 100),
                new MySqlParameter("@price",       MySqlDbType.Decimal,  10),
                new MySqlParameter("@author",      MySqlDbType.VarChar, 100),
                new MySqlParameter("@publisher",   MySqlDbType.VarChar, 100),
                new MySqlParameter("@edition",     MySqlDbType.VarChar, 100),
                new MySqlParameter("@remark",      MySqlDbType.VarChar, 100),
                new MySqlParameter("@user_num",    MySqlDbType.VarChar,  50),
                new MySqlParameter("@id",          MySqlDbType.Int32, 11)
            };
            parameters[0].Value  = model.course_name;
            parameters[1].Value  = model.course_type;
            parameters[2].Value  = model.user_name;
            parameters[3].Value  = model.need_book;
            parameters[4].Value  = model.isbn;
            parameters[5].Value  = model.book_name;
            parameters[6].Value  = model.price;
            parameters[7].Value  = model.author;
            parameters[8].Value  = model.publisher;
            parameters[9].Value  = model.edition;
            parameters[10].Value = model.remark;
            parameters[11].Value = model.user_num;
            parameters[12].Value = model.id;

            int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Exemplo n.º 4
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public TSIMS.Model.v_student_textbook_info GetModel()
        {
            //该表无主键信息,请自定义主键/条件字段
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select course_name,course_type,user_name,need_book,isbn,book_name,price,author,publisher,edition,remark,user_num,id from v_student_textbook_info ");
            strSql.Append(" where ");
            MySqlParameter[] parameters =
            {
            };

            TSIMS.Model.v_student_textbook_info model = new TSIMS.Model.v_student_textbook_info();
            DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }