/// <summary> /// 增加一条数据 /// </summary> public bool Add(TSIMSServer.Model.v_course_textbook_info model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into v_course_textbook_info("); strSql.Append("course_name,need_book,isbn,book_name,price,user_num)"); strSql.Append(" values ("); strSql.Append("@course_name,@need_book,@isbn,@book_name,@price,@user_num)"); MySqlParameter[] parameters = { new MySqlParameter("@course_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("@user_num", MySqlDbType.VarChar, 50) }; parameters[0].Value = model.course_name; parameters[1].Value = model.need_book; parameters[2].Value = model.isbn; parameters[3].Value = model.book_name; parameters[4].Value = model.price; parameters[5].Value = model.user_num; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public TSIMSServer.Model.v_course_textbook_info DataRowToModel(DataRow row) { TSIMSServer.Model.v_course_textbook_info model = new TSIMSServer.Model.v_course_textbook_info(); if (row != null) { if (row["course_name"] != null) { model.course_name = row["course_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["user_num"] != null) { model.user_num = row["user_num"].ToString(); } } return(model); }
public HttpResponseMessage GetTextBookInfo(string user_num) { //string user_num = userNo.user_num; //List<Model.t_user> userList = BLL_User.GetModelList("1=1"); if (user_num != null) { TSIMSServer.BLL.v_course_textbook_info VCTI_BLL = new BLL.v_course_textbook_info(); string sql = "select a.course_name, a.need_book,c.isbn," + "d.book_name,d.price,e.user_num from t_teaching as a " + "join t_user as b on b.user_num = '" + user_num + "' and a.class_num = b.class_num left join " + "t_teaching_book as c on a.id = c.teaching_id left join t_book d on d.isbn = c.isbn left join " + "t_book_order as e on e.user_num = b.user_num and e.isbn = c.isbn"; List <TSIMSServer.Model.v_course_textbook_info> VCTIList = VCTI_BLL.GetModelListByUser(sql); string jsonResult = "{\"code\": 1,\"data\": ["; for (int i = 0; i < VCTIList.Count; i++) { TSIMSServer.Model.v_course_textbook_info VCTI = VCTIList[i]; string json = ""; if (i != 0) { json = json + ","; } json = json + "{\"courseName\": \"" + VCTI.course_name; json = json + "\",\"needBook\": \"" + VCTI.need_book; json = json + "\",\"isbn\": \"" + VCTI.isbn; json = json + "\",\"bookName\": \"" + VCTI.book_name; json = json + "\",\"price\": \"" + VCTI.price; if (VCTI.user_num.Equals(user_num)) { json = json + "\",\"isSelect\": \"" + 1; } else { json = json + "\",\"isSelect\": \"" + 0; } json = json + "\"}"; jsonResult += json; } jsonResult += "]}"; //string json = "{\"user_num\":" + user_num + "}"; return(new HttpResponseMessage { Content = new StringContent(jsonResult, System.Text.Encoding.UTF8, "application/json") }); } else { string json = "{\"code\":" + 0 + ", \"data\":" + "\"获取失败\"" + "}"; return(new HttpResponseMessage { Content = new StringContent(json, System.Text.Encoding.UTF8, "application/json") }); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TSIMSServer.Model.v_course_textbook_info model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update v_course_textbook_info set "); strSql.Append("course_name=@course_name,"); strSql.Append("need_book=@need_book,"); strSql.Append("isbn=@isbn,"); strSql.Append("book_name=@book_name,"); strSql.Append("price=@price,"); strSql.Append("user_num=@user_num"); strSql.Append(" where "); MySqlParameter[] parameters = { new MySqlParameter("@course_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("@user_num", MySqlDbType.VarChar, 50) }; parameters[0].Value = model.course_name; parameters[1].Value = model.need_book; parameters[2].Value = model.isbn; parameters[3].Value = model.book_name; parameters[4].Value = model.price; parameters[5].Value = model.user_num; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public TSIMSServer.Model.v_course_textbook_info GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select course_name,need_book,isbn,book_name,price,user_num from v_course_textbook_info "); strSql.Append(" where "); MySqlParameter[] parameters = { }; TSIMSServer.Model.v_course_textbook_info model = new TSIMSServer.Model.v_course_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); } }