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);
}
