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))); }
public int insert(M_Examination model) { return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model))); }
public bool GetUpdate(M_Examination model) { return(Sql.UpdateByIDs(strTableName, PK, model.ExaID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters())); }