public void Delete1(string id) { string sql = "delete from T_PaperByManualSelection where paperID=@paperID"; SqlParameter[] parms = { new SqlParameter("@paperID", id) }; DBHelperCommomSql.Delete(sql, parms); }
public void Insert1(Users obj) { string sql = "insert into T_PaperByManualSelection(paperName,deptID,paperType,creator,createdTime) values(@paperName,@deptID,@paperType,@creator,@createdTime); select @@identity"; SqlParameter[] parms = { new SqlParameter("@paperName", obj.Name), new SqlParameter("@deptID", obj.Name), new SqlParameter("@paperType", obj.Name), new SqlParameter("@createdTime", obj.Name) }; SqlConnection conn = new SqlConnection(DBHelperCommomSql.connStr); SqlTransaction trans = null; try { conn.Open(); trans = conn.BeginTransaction("TInsertPaperByManualSelection"); using (SqlDataReader dr = DBHelperCommomSql.Select(trans, sql, parms)) { if (dr.Read()) { int id = Convert.ToInt32(dr[0]); dr.Close(); sql = "insert into T_PaperByManualSelection_Subject(paperID,subjectType,subjectID) values(@paperID,@subjectType,@subjectID)"; //1:填空题,2:判断题,3:单选题,4:多选题,5:简答题 //if (obj.FillBlankList != null) // foreach (SubjectOfFillBlank subject in obj.FillBlankList) // { // SqlParameter[] parms2 ={ // new SqlParameter("@paperID",id), // new SqlParameter("@subjectType",1), // new SqlParameter("@subjectID",subject.Id) // }; // DBHelperCommomSql.Insert(trans, sql, parms2); // } } } trans.Commit(); } catch { trans.Rollback(); } finally { trans.Dispose(); conn.Close(); } }
public Users SelectByID1(string id) { Users paper = new Users(); string sql = "select * from T_PaperByManualSelection where paperID=@paperID"; SqlParameter[] parms = { new SqlParameter("@paperID", id) }; using (SqlDataReader dr = DBHelperCommomSql.Select(sql, parms)) { if (dr.Read()) { paper.Name = dr["paperName"].ToString(); dr.Close(); } //填空题 sql = "select t1.* from T_SubjectOfFillBlank t1 inner join T_PaperByManualSelection_Subject t2 on t1.id=t2.subjectID where t2.paperID=@paperID and t2.subjectType=1"; using (SqlDataReader dr2 = DBHelperCommomSql.Select(sql, parms)) { List <Users> list = new List <Users>(); while (dr2.Read()) { Users subject = new Users(); subject.Name = dr2["question"].ToString(); list.Add(subject); } } } return(paper); }