Beispiel #1
0
        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));
        }
Beispiel #2
0
 public void  GetExamInformList(ExamInform examInform)
 {
 }