/// <summary> /// 得到一个对象实体 /// </summary> public OnLineTest.Model.Chapter DataRowToModel(DataRow row) { OnLineTest.Model.Chapter model = new OnLineTest.Model.Chapter(); if (row != null) { if (row["ChapterId"] != null && row["ChapterId"].ToString() != "") { model.ChapterId = int.Parse(row["ChapterId"].ToString()); } if (row["TextBookId"] != null && row["TextBookId"].ToString() != "") { model.TextBookId = int.Parse(row["TextBookId"].ToString()); } if (row["ChapterName"] != null) { model.ChapterName = row["ChapterName"].ToString(); } if (row["ChapterParentNo"] != null && row["ChapterParentNo"].ToString() != "") { model.ChapterParentNo = int.Parse(row["ChapterParentNo"].ToString()); } if (row["ChapterDeep"] != null && row["ChapterDeep"].ToString() != "") { model.ChapterDeep = int.Parse(row["ChapterDeep"].ToString()); } if (row["ChapterRemark"] != null) { model.ChapterRemark = row["ChapterRemark"].ToString(); } if (row["IsVerified"] != null && row["IsVerified"].ToString() != "") { if ((row["IsVerified"].ToString() == "1") || (row["IsVerified"].ToString().ToLower() == "true")) { model.IsVerified = true; } else { model.IsVerified = false; } } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(OnLineTest.Model.Chapter model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Chapter set "); strSql.Append("TextBookId=@TextBookId,"); strSql.Append("ChapterName=@ChapterName,"); strSql.Append("ChapterParentNo=@ChapterParentNo,"); strSql.Append("ChapterDeep=@ChapterDeep,"); strSql.Append("ChapterRemark=@ChapterRemark,"); strSql.Append("IsVerified=@IsVerified"); strSql.Append(" where ChapterId=@ChapterId"); SqlParameter[] parameters = { new SqlParameter("@TextBookId", SqlDbType.Int, 4), new SqlParameter("@ChapterName", SqlDbType.NVarChar, 200), new SqlParameter("@ChapterParentNo", SqlDbType.Int, 4), new SqlParameter("@ChapterDeep", SqlDbType.Int, 4), new SqlParameter("@ChapterRemark", SqlDbType.Text), new SqlParameter("@IsVerified", SqlDbType.Bit, 1), new SqlParameter("@ChapterId", SqlDbType.Int, 4) }; parameters[0].Value = model.TextBookId; parameters[1].Value = model.ChapterName; parameters[2].Value = model.ChapterParentNo; parameters[3].Value = model.ChapterDeep; parameters[4].Value = model.ChapterRemark; parameters[5].Value = model.IsVerified; parameters[6].Value = model.ChapterId; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(OnLineTest.Model.Chapter model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Chapter("); strSql.Append("TextBookId,ChapterName,ChapterParentNo,ChapterDeep,ChapterRemark,IsVerified)"); strSql.Append(" values ("); strSql.Append("@TextBookId,@ChapterName,@ChapterParentNo,@ChapterDeep,@ChapterRemark,@IsVerified)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@TextBookId", SqlDbType.Int, 4), new SqlParameter("@ChapterName", SqlDbType.NVarChar, 200), new SqlParameter("@ChapterParentNo", SqlDbType.Int, 4), new SqlParameter("@ChapterDeep", SqlDbType.Int, 4), new SqlParameter("@ChapterRemark", SqlDbType.Text), new SqlParameter("@IsVerified", SqlDbType.Bit, 1) }; parameters[0].Value = model.TextBookId; parameters[1].Value = model.ChapterName; parameters[2].Value = model.ChapterParentNo; parameters[3].Value = model.ChapterDeep; parameters[4].Value = model.ChapterRemark; parameters[5].Value = model.IsVerified; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public OnLineTest.Model.Chapter GetModel(int ChapterId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ChapterId,TextBookId,ChapterName,ChapterParentNo,ChapterDeep,ChapterRemark,IsVerified from Chapter "); strSql.Append(" where ChapterId=@ChapterId"); SqlParameter[] parameters = { new SqlParameter("@ChapterId", SqlDbType.Int, 4) }; parameters[0].Value = ChapterId; OnLineTest.Model.Chapter model = new OnLineTest.Model.Chapter(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }