public int AddExamInform(ExamInform examInform) { string sql = "insert into ExamInform(title,informText,creatTime,creatId,source) values(@title,@informText,@creatTime,@creatId,@source)"; SqlParameter[] pars = { //new SqlParameter("@name", userInfo.UserName), new SqlParameter("@title", SqlDbType.VarChar, 200), new SqlParameter("@informText", SqlDbType.Text), new SqlParameter("@creatTime", SqlDbType.DateTime), new SqlParameter("@creatId", SqlDbType.VarChar, 20), new SqlParameter("@source", SqlDbType.VarChar, 200), }; pars[0].Value = examInform.title; pars[1].Value = examInform.informText; pars[2].Value = examInform.creatTime; pars[3].Value = examInform.creatId; pars[4].Value = examInform.source; return(SqlHelper.GetExecuteNonQuery(sql, CommandType.Text, pars)); }
public void GetExamInformList(ExamInform examInform) { }