Beispiel #1
0
        public int GetInsert(M_Examination examination)
        {
            string sqlStr = "INSERT INTO [dbo].[ZL_Examination] ([StuUserName],[Stuid],[Generate],[Starttime],[Endtime],[Qlist],[Total],[Score],[Reviews],[Examiners],[RoomID]) VALUES (@StuUserName,@Stuid,@Generate,@Starttime,@Endtime,@Qlist,@Total,@Score,@Reviews,@Examiners,@RoomID),SET @ExaID = SCOPE_IDENTITY()";

            SqlParameter[] cmdParams = initmod.GetParameters();
            return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sqlStr, cmdParams)));
        }
Beispiel #2
0
 public int insert(M_Examination model)
 {
     return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
 }
Beispiel #3
0
 public bool GetUpdate(M_Examination model)
 {
     return(Sql.UpdateByIDs(strTableName, PK, model.ExaID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters()));
 }